CSPP 53017: Assignment 5
Due on Friday, March 15, 2013
OLAP queries
The goal of this assignment is to review the OLAP concepts and relate
them to your data warehousing project. First, you will need to
identify 5 queries that would like to run on your data warehouse. You
can use some of the queries, described in earlier assignments but you
should also include some reporting-type queries.
Your submission should include:
- The current star schema(s) of your data warehouse
- Five questions about the data in your data warehouse expressed in English
- For each of the five 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 will submit your assignment by emailing a PDF document to the
instructor. Please, use the following title for your
submission CSPPDW_P5.