CSPP 53017: Assignment 6

In the final report, you will put together all the documents you created throughout the quarter and show some sample data from you data warehouse.

Your submission should include:

Revised description of your data warehouse (2-3 paragraphs). Please, note any important changes you made after going through the design and development process.
The current star schema(s) of your data warehouse.
Up to 5 Source-to-Target Data Maps and their SQL implementation. Please, note any other languages used (python, shell scripts, java, etc.)
Six questions about the data in your data warehouse expressed in English including at least 2 reporting-type questions. A simple example of a reporting-type question is "compare the two consecutive monthly sales in terms of total dollars for two product categories".
For each of the 6 questions, show the SQL query or the sequence of SQL queries that gathers that data necessary to answer the question. For some questions, you may find it easier to use other software (e.g. statistical tools such as R, Matlab and Stata) to implement part of the sequence. In such cases, just state what is the input and output for such tools without providing the actual code. You can reuse your work in part 5 of the project.
Show actual data warehouse results for at least one reporting and one other query. Your results should include the query and an excerpt of the resulting relation (up to 20 rows).

You will submit your assignment by emailing a PDF document to the instructor. Please, use the following title for your submission CSPPDW_P6.