Get startedGet started for free

Load data and promote headers

You were recently hired as a data analyst at Adventure Works Cycles, a manufacturer and retailer of bicycles for the North American and European markets. Check this MSFT Learn article to learn more about shaping data with Power Query.

Your manager provided you with an Excel sheet containing the list of products sold by the company and asked you to help load the data into Power BI so your team can build a report from this data.

Your first task will be to prepare this data for the eventual analysis.

This exercise is part of the course

Data Preparation in Power BI

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise