Microsoft Power BI - Excel 2016 training exercises (page 1 of 2)

Showing exercises 1-20 (out of 23)

Category: Power BI - Excel 2016
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 ...

Category: Power BI - Excel 2016
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 ...

Category: Power BI - Excel 2016
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 ...

Category: Power BI - Excel 2016
Topic: Using Excel tables
Level: Average difficulty
Course: PowerPivot / Excel Power BI
Exercise: Import data from Access, Word and Excel, and link an Excel table, to create a PowerPivot data model.

Go to exercise ...

Category: Power BI - Excel 2016
Topic: Transforming data (Power Query)
Level: Relatively easy
Course: PowerPivot / Excel Power BI
Exercise: Import a population table using Power Query, then tidy up the data.

Go to exercise ...

Category: Power BI - Excel 2016
Topic: Transforming data (Power Query)
Level: Average difficulty
Course: PowerPivot / Excel Power BI
Exercise: Tidy up exchange rate and investment data in Power Query, splitting columns and replacing values.

Go to exercise ...

Category: Power BI - Excel 2016
Topic: Transforming data (Power Query)
Level: Harder than average
Course: PowerPivot / Excel Power BI
Exercise: Create a query to import a table of tall buildings, create new columns and then pivot the data.

Go to exercise ...

Category: Power BI - Excel 2016
Topic: Calculated columns
Level: Relatively easy
Course: PowerPivot / Excel Power BI
Exercise: Create two new calculated columns in a table, using RELATED and CONCATENATE.

Go to exercise ...

Category: Power BI - Excel 2016
Topic: Calculated columns
Level: Average difficulty
Course: PowerPivot / Excel Power BI
Exercise: Divide shopping centres into the circles of hell, using the IF and the SWITCH functions.

Go to exercise ...

Category: Power BI - Excel 2016
Topic: The CALCULATE function
Level: Relatively easy
Course: PowerPivot / Excel Power BI
Exercise: Use the CALCULATE function to show percentages of row and column totals in a pivot table.

Go to exercise ...

Category: Power BI - Excel 2016
Topic: The CALCULATE function
Level: Average difficulty
Course: PowerPivot / Excel Power BI
Exercise: Create a ratio of sales between two different habitats, using the CALCULATE and SUMX functions.

Go to exercise ...

Category: Power BI - Excel 2016
Topic: The CALCULATE function
Level: Average difficulty
Course: PowerPivot / Excel Power BI
Exercise: Use the CALCULATE function to show total sales for Northern powerhouse shopping centres.

Go to exercise ...

Category: Power BI - Excel 2016
Topic: More advanced DAX functions
Level: Average difficulty
Course: PowerPivot / Excel Power BI
Exercise: Exclude a single animal from a pivot table, using CALCULATE combined with the VALUES function.

Go to exercise ...

Category: Power BI - Excel 2016
Topic: More advanced DAX functions
Level: Harder than average
Course: PowerPivot / Excel Power BI
Exercise: Group purchases into shopping centre size bands, using the EARLIER and FILTER functions.

Go to exercise ...

Category: Power BI - Excel 2016
Topic: Date functions
Level: Relatively easy
Course: PowerPivot / Excel Power BI
Exercise: Use the SAMEPERIODLASTYEAR and DATEADD functions to show various statistics for total sales.

Go to exercise ...

Category: Power BI - Excel 2016
Topic: Date functions
Level: Average difficulty
Course: PowerPivot / Excel Power BI
Exercise: Use the TOTALQTD function to accumulate quarter-to-date figures for each environment.

Go to exercise ...

Category: Power BI - Excel 2016
Topic: Date functions
Level: Harder than average
Course: PowerPivot / Excel Power BI
Exercise: Use the PARALLELPERIOD function to show this quarter's total sales divided by the previous quarter's.

Go to exercise ...

Category: Power BI - Excel 2016
Topic: Hierarchies
Level: Average difficulty
Course: PowerPivot / Excel Power BI
Exercise: Create hierarchies using the RELATED function to make a pivot table look neat and tidy.

Go to exercise ...

Category: Power BI - Excel 2016
Topic: KPIs
Level: Average difficulty
Course: PowerPivot / Excel Power BI
Exercise: Create a KPI, showing green if a period's sales are more than 10% of the same period two months previously.

Go to exercise ...

Category: Power BI - Excel 2016
Topic: Power BI Desktop overview
Level: Relatively easy
Course: PowerPivot / Excel Power BI
Exercise: In Power BI Desktop, import some data and create a table visualisation with some formatting.

Go to exercise ...

This page has 0 threads Add post