1. The Extraction, Transformation, Loading processes

Use data files (with different formatting or different type of files (e.g. Excle files, flat files, html

files, etc.) to load the data warehouse, as explained in the attached note regarding ETL.

Provide analytical operations that can be performed on data warehouse, such as: Roll up, Drill down, Slice and Dice (Pivoting), Rotation (View data from a new perspective), provide one or two example(s) for each of the above operations.

Consider that the attributes for a record will change over the time and you need to update your data warehouse, apply the Slowly Changing Dimension Concepts (Type SCD1, SDC2, and SCD3) as explained in the class notes and attached note to reflect the change of the attributes that you were selecting in your data warehouse. To show that change, you can query the data warehouse for those attributes before applying the SCD1, SDC2, and SCD3 and after.

Provide query examples using the fact tables and dimensional tables by applying dimensional query (Aggregation, Specific, and Inside out) as explained in the attached note, provide one or two example(s) for each of the above operations.

(Optional, extra points) Develop a GUI user interface to allow the users to query your data warehouse. The first screen allows the users to login to the data warehouse system. Then the system can provide a number of options that the users can click and the required information can be shown (using forms and reports similar to usage in database course project).

1