QUESTION 1 [25 marks]

1. Using the file

BOC_Store_Database.xlsx,

Desktop which can be published in Power BI Service.

construct a Dashboard in Power BI

Follow the tasks given below in compiling the Dashboard.

a) Using the power query editor in Power BI desktop, clean the data and load it onto

Power BI (1 mark).

b) Construct a data model in Power BI using star schema architecture (2 marks).

c) Using appropriate visualizations, create the Dashboard. The Dashboard should have the

data filtering capability including slicing functions. To effectively design a Power BI

Dashboard, it's important to focus on a specific area to ensure that the Dashboard serves

its intended purpose. (15 marks).

(Submit the Dashboard as a Power BI report file)

2. Interpret the visuals presented in the Dashboard (7 marks) (this can be done in a

Word document).