For this assignment, you will use the Global Super Store dataset Download Global Super Store dataset. You will create a report on Power BI and submit your $.$pbix file on canvas. Please follow the following instructions to complete the assignment.

Data Transformation

Check the column headers in each query. Make sure that the column headers are properly used as column headers.

Relationships

Create a relationship between the Orders, People, and Returns tables. $($You will decide which fields to use as the key field in each table$)$

Report

You will create a report comprising five visuals for orders given in $2011$ and $2012.$

In the first visual, you will create a car chart to show each category's sales and profit performance. When you drill down into a category, the visual will provide the sales and profit performance of the subcategory.

In the second visual, create a pie chart to display the returned sales in each market. When you click on a category of the pie chart, it will filter the bar chart and show returned sales and profit in each category.

Third visual: Create a table with four columns: $1)$ Region, $2)$ the VP of Sales in that region $($the person field in the People query$),3)$ the sales amount by each person and $4)$ the percentage of the grand total sum of sales. The table will only display the VPs in the top six regarding sales.

Fourth visual: Create a tree map that displays the total profit in each country. The treemap will serve as a filter for all the visuals, including the table.

Fifth visual: Create a fifth visual to display essential metrics about this dataset. You can create any visual that displays sales$/$profit $/$ etc. performance of any relevant field. Be creative.

Create a slicer using the market field. The slicer will be in tile format and will serve as a filter for all the visuals.