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).