Project 2 Milestone 3: DW Reporting and Visualization
8) Write the SQL that get be needed to solution the three most relevant investigations using your basis depot. This requires adaptation 3 SQL statements. (10 points)
9) Create a visualization for your earliest address investigation. (Note: Figures P13.3.2G (page 615) and P13.3 (page 616) semblance solitary certainty tables delay multiple compass.
11) Create a visualization for your promote address investigation. (Note: it must be contrariant than the earliest and ideally use contrariant certainty or size tables).
12) Create a third visualization, it must be contrariant than the earliest two and should use contrariant certainty or size tables
Assessment Your surrender instrument get be checked for faultlessness and rectitude. Connecting Assignments This milestone takes the industrious basisbase for the DW from milestone 2 and uses it to profit reports and visualizations that solution the investigations from Milestone 1. It is the developed tread that demonstrates the appraise of implementing a DW.
Onces we pluck bid , we are going present milestones solutions for M1 and M2 . So that it get manageable to do M3.