Microsoft® SQL Server® 2012 Bible

1307 Chapter 58: Creating and Deploying BI Semantic Models 58 Figure 58-8 shows the fi ltered list of products. FIGURE 58-8 Filt ...

1308 Part IX: Business Intelligence Creating KPIs in PowerPivot KPIs provide a quick and effective way to evaluate success of an ...

1309 Chapter 58: Creating and Deploying BI Semantic Models 58 Make sure that the fi rst color band displaying the Green-Yellow- ...

1310 Part IX: Business Intelligence FIGURE 58-10 Key Peformance Indicator (KPI) window. The KPI you just created can now be disp ...

1311 Chapter 58: Creating and Deploying BI Semantic Models 58 Expand the Sum of Reseller Sales Gross Profi t KPI. You will noti ...

1312 Part IX: Business Intelligence This means that there are three tables, DimProduct, DimProductSubCategory, and DimProductCat ...

1313 Chapter 58: Creating and Deploying BI Semantic Models 58 Scroll all the way to the right until you see a blank column with ...

1314 Part IX: Business Intelligence Locate and right-click the ProductSubCategory attribute of the DimProduct table. Select Add ...

1315 Chapter 58: Creating and Deploying BI Semantic Models 58 FIGURE 58-15 Product Drilldown hierarchy. Creating Perspectives in ...

1316 Part IX: Business Intelligence Click the Offi ce Ribbon options on the top left and select Switch to Advanced Mode. The Ad ...

1317 Chapter 58: Creating and Deploying BI Semantic Models 58 Click OK. Click on the PivotTable option in the Offi ce Ribbon. S ...

1318 Part IX: Business Intelligence ■ (^) The workbook’s content is static unless the data is refreshed from the underlying data ...

1319 Chapter 58: Creating and Deploying BI Semantic Models 58 To schedule automatic data refresh of a PowerPivot workbook follow ...

1320 Part IX: Business Intelligence The Table Import Wizard window opens. Select the Microsoft SQL Server option, as shown in F ...

1321 Chapter 58: Creating and Deploying BI Semantic Models 58 Click Next. The Choose How To Import Data dialog window opens. Yo ...

1322 Part IX: Business Intelligence Click the column header titled SalesAmount. The entire column is highlighted. Click the Col ...

1323 Chapter 58: Creating and Deploying BI Semantic Models 58 In the Row Filters section, click inside the DAX fi lter textbox ...

1324 Part IX: Business Intelligence Select the BicycleProductManagers role from the roles drop down list and click OK. An Excel ...

1325 Chapter 58: Creating and Deploying BI Semantic Models 58 or no processing when the project is deployed. The default option ...

1326 Part IX: Business Intelligence Summary BI Semantic Models is a rich, scalable, and fl exible model that can be deployed as ...