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
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
