Question-4 Marks [10]

You have to create a Sales dashboard (1 pager snapshot graphical report) with Power BI from the data provided to you in the 5 Excel files.

1. Customer
2. Order
3. Product
4. Region
5. Sales

The dashboard must contain the following components:

1. Total Sales
2. Gross Profit
3. Product Category Wise Sales, Quantity, Gross Profit
4. Sales by State and Country
5. Sales and Gross Profit by Year
6. Sales by Month
7. Units sold by State
8. Sub-Category of Products

The solution will be evaluated based on appropriate visualizations used, the design and organization of the dashboard components.