analyses that would not previously have been possible from a single analytical tool. This is something uniquely available in Microsoft Excel and PowerPivot. Select Chart and Table (Vertical). Now let’s look at the ways Richard can use all this combined data to visualize comparisons that may not have been apparent or easily drawn before. Richard is going to use Excel to organize the data in a chart and table that will make it easier to visualize relationships between all these different sources. Since we’re working in Excel, the functions we use and the actions we take are all familiar. We can create a traditional PivotTable by adding values, rows, and columns. Select Existing Worksheet. Click OK. In the Gemini Task Pane, expand the The difference is that the fields we’re FactSales node. drawing from are coming from the model we just created. Select SalesAmount. We’ll start building this PivotTable by adding Sales Amount.
analyses that would not previously have been possible from a single analytical tool. This is something uniquely available in Microsoft Excel and PowerPivot. Select Chart and Table (Vertical). Now let’s look at the ways Richard can use all this combined data to visualize comparisons that may not have been apparent or easily drawn before. Richard is going to use Excel to organize the data in a chart and table that will make it easier to visualize relationships between all these different sources. Since we’re working in Excel, the functions we use and the actions we take are all familiar. We can create a traditional PivotTable by adding values, rows, and columns. Select Existing Worksheet. Click OK. In the Gemini Task Pane, expand the FactSales node. The difference is that the fields we’re drawing from are coming from the model we just created. Select SalesAmount. We’ll start building this PivotTable by adding Sales Amount.
PowerPivot%20Demo.docx