QUESTION 3 [20 marks] A company senior executive has been provided with raw data from various divisions within the organization. She seeks guidance on how to extract valuable information from this

data to make well-informed decisions concerning company operations. She has assigned you, a business analyst, a task to provide with her a comprehensive report with some interpretations using a Power BI desktop. Data are given in the following files: XYZ_Company_Database.xlsx and XYZ_Customers.xlsx. She is very keen to get information about customers in addition to other components such as sales, production costs, regions, etc. She is also eager to know the year-to-date sales and production costs in terms of calendar year as well as financial year. Follow the tasks given below in compiling the report. 1. Using the power query editor on the Power BI desktop, clean the data and load it into Power BI (1 mark) 2. Construct a data model in Power BI using star schema architecture (1 mark) 3. Using appropriate visualizations, create the report. The report should have data filtering capability including slicing, drill-down, and drill-through functions. The report can be a maximum of four pages in the Power BI report canvas. (10 marks) 4. Interpret the visuals presented in the report (this can be done in a Word document) (8 marks) Submit the report as a Power BI report file. Interpretation can be done in a Word document.