PRE$-$REQUISITES FOR THIS APP:

This has to be done in Power BI Service on the web and two artifacts have to be provided:

Publish the Power BI report from your Power BI Service for me to review and grade.

Take screenshots of the various steps needed to complete the dashboard and upload as a PDF file here.

The needed data for this is contained in the Excel file uploaded to the Week $12$ module.

There are $6$ images provided in this question.

INSTRUCTIONS FOR THE APP:

Use the Excel Data file called 'Retail Analysis Sample.xlsx$\text{'}$ uploaded alongside this final in Week $12.$ FOR MAC USERS $-$ use the 'Mac' version of the data file as the hidden data connection in the original file has been fixed for Macs. EVERYONE $-$ fix the workbook with your calculated columns before 'importing' into Power BI service if 'uploading' to Power BI service doesn't work $-$ this is especially true for Mac users. Add either Calculated Columns or Measures $($preferable$)$ as laid out in the first screenshot below to the appropriate sheets in the workbook.

There are also some data formatting and calculations in the various sub$-$items of point $3$ below which should also be added to the workbook.

Once the measures have been added, create a Power BI DASHBOARD in Power BI service using the updated Excel workbook.

Add an 'Attribute Slicer' for Total Sales by Category as shown in the second image. Total Sales is the sum of Regular Sales and Markdown Sales.

Add a Multi$-$row card for Store Details by Category as shown in the third image.

Add a Waterfall chart for Total Unit Price by Month and Category as shown in the fourth image. You may need to format the Month data item. For Total Units This Year, calculate Total Units based on Sales$[$ScenarioID$]=1.$

Add a Bubble chart for Total Sales Variance, Average Price per Unit this year and Current Year Sales by Category as shown in image $5.$

Finally add a line chart for Current Year Sales by District Manager and Category as shown in last image.

Make sure that all $5$ visuals are shown on one dashboard and are well designed. You are allowed to change the color schemes to make them look more appealing.

Remember to take screenshots for intermediary steps and the final dashboard $($similar to the class lecture slides$)$ and save them into a document that can be exported to PDF for upload here.

Refresh this page before uploading the PDF$.$