PowerPivot exercises on TRANSFORMING DATA (POWER QUERY)

This page lists the 7 exercises about Transforming data (Power Query) in PowerPivot on our website:

Software: PowerPivot
Version: Excel 2013 and later
Topic: Transforming data (Power Query)
Level: Relatively easy
Course: PowerPivot / Excel Power BI
Exercise: For a table of populations, change data types and make other changes in Power Query.

Go to exercise ...

Software: PowerPivot
Version: Excel 2016 and later
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 ...

Software: PowerPivot
Version: Excel 2016 and later
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 ...

Software: PowerPivot
Version: Excel 2016 and later
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 ...

Software: PowerPivot
Version: Excel 2013 and later
Topic: Transforming data (Power Query)
Level: Average difficulty
Course: PowerPivot / Excel Power BI
Exercise: Divide exchange rate and investment symbols into more parts by splitting and removing columns.

Go to exercise ...

Software: PowerPivot
Version: Excel 2016 and later
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 ...

Software: PowerPivot
Version: Excel 2013 and later
Topic: Transforming data (Power Query)
Level: Harder than average
Course: PowerPivot / Excel Power BI
Exercise: For a table of skyscrapers, perform lots of query transforms and then pivot the results.

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