Data Warehouse Application $(60$ Points$)$

I. Data Warehouse definition and characteristics

II$.$ Dimensional tables and fact tables

III. Explain Slowly Changing dimensions $.$ Explain with examples

IV$.$ What are the key columns in Fact and dimension tables?

V$.$ Star Schema vs Snow Flake schema

VI$.$ Surrogate key

VII. Explain ETL process

VIII.OLAP vs OLTP Differences

Use the "ContosoSales" Access database file to answer the following questions in this

assignment

DATABASE

What type of database is the ContosoSales database? Explain.

POWERPIVOT $-$ WRITE QUERIES AND TEST THEM ON POWERPIVOT

Write a SQL statement to extract Product Name and Product Description from the

database. What tables $($or table$)$ should you use in your query?

Write a SQL statement to extract Sales Quantity for all products with class id equal to $1.$

You, a manager with Contoso Corporation, would like to analyze Sales done by various

distribution channel. You know you have to write a query to extract this knowledge.

a$.$ What tables are involved in the query?

b$.$ What fields do you need from these tables?

c$.$ What should you add to the query to only see the sales through catalog order?