Design a data warehouse using star schema or snowflake schema that solves a specific business intelligence task
Fantastic news! We've Found the answer you've been seeking!
Question:
Design a data warehouse using star schema or snowflake schema that solves a specific business intelligence task that you come up with. Only one fact table is needed.
You will need to include:
1) a problem statement (i.e. what is the purpose this warehouse is serving)
2) an ER diagram describing the designed schema
3) the justification for your fact table and dimensions.
You can include all components in a word document. Some tasks you can consider: analyzing sales, analyzing hospitalized patients, analyzing student performances, etc.
Related Book For
Decision Systems for Business Intelligence
ISBN: 978-0470433744
2nd edition
Authors: Vicki L. Sauter
Posted Date: