Microsoft Power BI - Excel 2016 training exercises | Transforming data (Power Query)

Showing exercises 1-4 (out of 4)

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: How to unpivot data in Power Query, then use this as a basis for a pivot table.

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 ...

This page has 0 threads Add post