EXERCISE TOPIC▼
POWER BI EXERCISES▼
POWERPIVOT EXERCISES▼
- PowerPivot data models (7)
- Pivot tables using PowerPivot (2)
- Using Excel tables (3)
- Using other data sources (1)
- Transforming data (Power Query) (7)
- Calculated columns (7)
- Measures (2)
- The CALCULATE function (15)
- More advanced DAX functions (5)
- Calendars (1)
- Date functions (10)
- Hierarchies (2)
- KPIs (5)
- Power View (4)
- Power BI Desktop overview (3)
- Power BI Desktop maps (1)
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: | |
| Exercise: | For a table of populations, change data types and make other changes in Power Query. |
| Software: | PowerPivot |
| Version: | Excel 2016 and later |
| Topic: | Transforming data (Power Query) |
| Level: | Relatively easy |
| Course: | |
| Exercise: | Import a population table using Power Query, then tidy up the data. |
| Software: | PowerPivot |
| Version: | Excel 2016 and later |
| Topic: | Transforming data (Power Query) |
| Level: | Average difficulty |
| Course: | |
| Exercise: | How to unpivot data in Power Query, then use this as a basis for a pivot table. |
| Software: | PowerPivot |
| Version: | Excel 2016 and later |
| Topic: | Transforming data (Power Query) |
| Level: | Average difficulty |
| Course: | |
| Exercise: | Tidy up exchange rate and investment data in Power Query, splitting columns and replacing values. |
| Software: | PowerPivot |
| Version: | Excel 2013 and later |
| Topic: | Transforming data (Power Query) |
| Level: | Average difficulty |
| Course: | |
| Exercise: | Divide exchange rate and investment symbols into more parts by splitting and removing columns. |
| Software: | PowerPivot |
| Version: | Excel 2016 and later |
| Topic: | Transforming data (Power Query) |
| Level: | Harder than average |
| Course: | |
| Exercise: | Create a query to import a table of tall buildings, create new columns and then pivot the data. |
| Software: | PowerPivot |
| Version: | Excel 2013 and later |
| Topic: | Transforming data (Power Query) |
| Level: | Harder than average |
| Course: | |
| Exercise: | For a table of skyscrapers, perform lots of query transforms and then pivot the results. |
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