Project 2 Milestone 3: DW Reporting and Visualization
8) Write the SQL that succeed be needed to solution the three most expressive scrutinys using your postulates magazine. This requires adaptation 3 SQL statements. (10 points)
9) Create a visualization for your primary skill scrutiny. (Note: Figures P13.3.2G (page 615) and P13.3 (page 616) pomp individual occurrence tables after a while multiple body.
11) Create a visualization for your promote skill scrutiny. (Note: it must be contrariant than the primary and ideally use contrariant occurrence or configuration tables).
12) Create a third visualization, it must be contrariant than the primary two and should use contrariant occurrence or configuration tables
Assessment Your acquiescence instrument succeed be checked for foresight and entireness. Connecting Assignments This milestone takes the filled postulatesbase for the DW from milestone 2 and uses it to result reports and visualizations that solution the scrutinys from Milestone 1. It is the conclusive march that demonstrates the appreciate of implementing a DW.
Onces we gather bid , we are going yield milestones solutions for M1 and M2 . So that it succeed not-difficult to do M3.