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.