www.biam300rank.com
In this activity, you will discuss the differences between a relational
database and an OLAP cube.
===================================================
BIAM 300 Week 5 Homework Assignment
FOR MORE CLASSES VISIT
www.biam300rank.com
Answer the following essay questions in your own words.
What are dimensions and how can you use them? Provide examples.
What are metrics and facts? Provide examples.
Why have a metadata repository?
What does an ETL job do? Provide examples.
What is an OLAP cube?
What is a data mart?
It is often said in data warehouse projects that you should ”think big,
start small, and deliver fast.” Why is that?
What is SQL and how can you use it?