PROG1380 Data Warehousing Design and Implementation Power BI Project A Project Summary This project will give you the opportunity to work through some tutorials on using Power BI to build a dynamic...

Power Bi Assignment, PDF with instructions attached


PROG1380 Data Warehousing Design and Implementation Power BI Project A Project Summary This project will give you the opportunity to work through some tutorials on using Power BI to build a dynamic report dashboard using Power BI Desktop for data housed in a SQL Server Data Warehouse. For this project, the following 2 resources will be helpful: • Robert Sheldon on Power BI: Parts 1, 2, 5 and 7 • Lynda.com Power BI Essential Training by Gini von Courter: most of this tutorial covers Power BI Service, but you can use all the videos that cover Report Visualizations You can complete this project using just the Robert Sheldon tutorials; however, the Lynda.com ones are excellent for going over some of the report features not covered by the Sheldon. Please work through Parts 1, 2, 5 and 7 of the Robert Sheldon Tutorial before completing this project. You will need to install PowerBi Desktop. Project Tasks We will use the Contoso Retail Data Warehouse Database for this project. This database exists on 192.168.40.206. You can download the ContosoRetailDW backup file and restore it in SQL Server if you are working from home on this assignment. Review the fact and dimension tables in this database. You have been bestowed the privilege of creating a Power BI model and dynamic report dashboard for Conteso Retailers (you are officially knighted as Lord or Lady Slayer of Data … Winter is Coming!). Upper management in this firm need to have answers to the following questions: • What are their best-selling products and which ones are laggards? • Which products and channels are most profitable? • What were Conteso’s most profitable years, quarters, or months? Using your newly acquired report modelling and building acumen, you will create reports using Power BI Desktop to answer these questions. You are free to use whatever visualizations and formats that you would like to complete this challenge; moreover, you may choose to spread these visualizations over as many pages as you like within the Power BI Desktop file. If your visuals effectively serve to answer these questions, and your model is efficient in how it exposes data, you can consider yourself successful in achieving the end goal. You may also want to review the rubric for this project as you build your reporting product. Due Date and Rubric Please publish your PowerBi project under the Workspace, YourName_PowerBIAssign. You will need to enroll in the free upgrade trial to do this. Also upload your .pbix file to BlackBoard using the Project link. Your BB upload and report(s) are due to be published Sunday, October 20th at midnight. No late submissions accepted. Grading Targets are based off of Microsoft’s Tips for designing a great Power BI dashboard • Size and positioning are used to highlight the most important information (10 Marks) • Screen real estate is effectively used to convey important information at one glance (10 Marks) • Effective visualizations were chosen to paint an informative picture (20 Marks) • Only the required fields and relationships for the dashboard were used in the project model (10 Marks) https://www.red-gate.com/simple-talk/sql/bi/power-bi-part-1-introduction/ https://www.microsoft.com/en-ca/download/details.aspx?id=18279 https://docs.microsoft.com/en-us/power-bi/service-dashboards-design-tips