POWERPIVOT 2010 EXERCISES

ALL CATEGORIES

- EXERCISES HOME PAGE (813)
- Access 2010 (66)
- Access VBA Macros (17)
- Advanced VBA (29)
- Excel 2010 (83)
- Excel 2013 (10)
- Excel 2016 (0)
- Excel VBA Macros (37)
- Power BI - Excel 2013 (25)
- Power BI - Excel 2016 (23)
- Power BI Desktop (26)
- PowerPivot 2010 (26)
- Report Builder 3.0 (42)
- SQL (156)
- SSAS - multidimensional (21)
- SSAS - tabular (29)
- SSIS Integration Services (40)
- SSRS Reporting Services (53)
- Visual Basic (45)
- Visual C Sharp (65)
- WPF - Visual C# (20)

# Microsoft PowerPivot 2010 training exercises (page 1 of 2)

Showing exercises 1-20 (out of 26)

Category: | PowerPivot 2010 |

Topic: | Connecting to tables |

Level: | Relatively easy |

Course: | PowerPivot / Excel Power BI |

Exercise: | Create a pivot table of average prices for transactions. |

Category: | PowerPivot 2010 |

Topic: | Creating a data model |

Level: | Average difficulty |

Course: | PowerPivot / Excel Power BI |

Exercise: | Import a table then amend it and import others to create data model. |

Category: | PowerPivot 2010 |

Topic: | Relationships |

Level: | Harder than average |

Course: | PowerPivot / Excel Power BI |

Exercise: | Create a pivot table with slicer based on ten different tables. |

Category: | PowerPivot 2010 |

Topic: | Connecting to Excel |

Level: | Average difficulty |

Course: | PowerPivot / Excel Power BI |

Exercise: | Create a linked Excel workbook in PowerPivot and use it in relationships. |

Category: | PowerPivot 2010 |

Topic: | Connecting to other data |

Level: | Harder than average |

Course: | PowerPivot / Excel Power BI |

Exercise: | Link to two Excel workbooks and one SQL Server table in PowerPivot. |

Category: | PowerPivot 2010 |

Topic: | Calculated columns |

Level: | Relatively easy |

Course: | PowerPivot / Excel Power BI |

Exercise: | Total sales by weekday, using simple two calculated columns. |

Category: | PowerPivot 2010 |

Topic: | Calculated columns |

Level: | Average difficulty |

Course: | PowerPivot / Excel Power BI |

Exercise: | Divide years into bands using SWITCH and calculated columns. |

Category: | PowerPivot 2010 |

Topic: | Calculated columns |

Level: | Harder than average |

Course: | PowerPivot / Excel Power BI |

Exercise: | Summarise sales by status of animal, using calculated columns. |

Category: | PowerPivot 2010 |

Topic: | Measures |

Level: | Average difficulty |

Course: | PowerPivot / Excel Power BI |

Exercise: | Calculate total and average transaction values using measures. |

Category: | PowerPivot 2010 |

Topic: | Measures |

Level: | Harder than average |

Course: | PowerPivot / Excel Power BI |

Exercise: | Calculate ratio of area to units for shopping centres using AVERAGEX. |

Category: | PowerPivot 2010 |

Topic: | FILTER and CALCULATE |

Level: | Relatively easy |

Course: | PowerPivot / Excel Power BI |

Exercise: | Use ALL and CALCULATE to get proportions of totals for regions. |

Category: | PowerPivot 2010 |

Topic: | FILTER and CALCULATE |

Level: | Relatively easy |

Course: | PowerPivot / Excel Power BI |

Exercise: | Divide sales by 4 legs and other for a measure, using the FILTER function. |

Category: | PowerPivot 2010 |

Topic: | FILTER and CALCULATE |

Level: | Average difficulty |

Course: | PowerPivot / Excel Power BI |

Exercise: | Create measure using CALCULATE and ALL to get ratios against total. |

Category: | PowerPivot 2010 |

Topic: | FILTER and CALCULATE |

Level: | Average difficulty |

Course: | PowerPivot / Excel Power BI |

Exercise: | Exclude a month from totals using the VALUES function to retain context. |

Category: | PowerPivot 2010 |

Topic: | FILTER and CALCULATE |

Level: | Average difficulty |

Course: | PowerPivot / Excel Power BI |

Exercise: | Use the RANKX function to order total sales over species. |

Category: | PowerPivot 2010 |

Topic: | FILTER and CALCULATE |

Level: | Average difficulty |

Course: | PowerPivot / Excel Power BI |

Exercise: | Use FILTER and ALL to show sales as a proportion of one region's total. |

Category: | PowerPivot 2010 |

Topic: | FILTER and CALCULATE |

Level: | Harder than average |

Course: | PowerPivot / Excel Power BI |

Exercise: | Create a calculated column using EARLIER to show previous joiner count. |

Category: | PowerPivot 2010 |

Topic: | FILTER and CALCULATE |

Level: | Harder than average |

Course: | PowerPivot / Excel Power BI |

Exercise: | Filter calculated sums to compare two stores' sales figures. |

Category: | PowerPivot 2010 |

Topic: | Creating a calendar |

Level: | Average difficulty |

Course: | PowerPivot / Excel Power BI |

Exercise: | Create and import a calendar in Excel or SQL giving star signs. |

Category: | PowerPivot 2010 |

Topic: | Date calculations |

Level: | Relatively easy |

Course: | PowerPivot / Excel Power BI |

Exercise: | Use the TOTALYTD and TOTALQTD functions to show cumulative totals. |

This page has 0 threads
Add post