PowerPivot exercises on POWERPIVOT DATA MODELS

This page lists the 7 exercises about PowerPivot data models in PowerPivot on our website:

Software: PowerPivot
Version: Excel 2013 and later
Topic: PowerPivot data models
Level: Relatively easy
Course: PowerPivot / Excel Power BI
Exercise: From the MAM database, import 6 tables and use them to show quantity sold by town.

Go to exercise ...

Software: PowerPivot
Version: Excel 2010 and later
Topic: PowerPivot data models
Level: Relatively easy
Course: PowerPivot / Excel Power BI
Exercise: Create a pivot table of average prices for transactions.

Go to exercise ...

Software: PowerPivot
Version: Excel 2016 and later
Topic: PowerPivot data models
Level: Relatively easy
Course: PowerPivot / Excel Power BI
Exercise: Import tables from the Make-a-Mammal database, then hide tables and columns to create a clean data model.

Go to exercise ...

Software: PowerPivot
Version: Excel 2016 and later
Topic: PowerPivot data models
Level: Average difficulty
Course: PowerPivot / Excel Power BI
Exercise: Import tables into PowerPivot, hide tables and columns and create a pivot table and slicer.

Go to exercise ...

Software: PowerPivot
Version: Excel 2010 and later
Topic: PowerPivot data models
Level: Average difficulty
Course: PowerPivot / Excel Power BI
Exercise: Import a table then amend it and import others to create data model.

Go to exercise ...

Software: PowerPivot
Version: Excel 2010 and later
Topic: PowerPivot data models
Level: Harder than average
Course: PowerPivot / Excel Power BI
Exercise: Create a pivot table with slicer based on ten different tables.

Go to exercise ...

Software: PowerPivot
Version: Excel 2016 and later
Topic: PowerPivot data models
Level: Harder than average
Course: PowerPivot / Excel Power BI
Exercise: Create two pivot tables, and two timelines which control both of the pivot tables.

Go to exercise ...

You can search our full list of Power BI exercises here, or why not have a look at our other Power BI training resources?

This page has 0 threads Add post