Question: Please design a data warehouse using star schema or snowflake schema that solves a specific business intelligence task that you come up

Please 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) 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.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Data Warehouse Design Using Star Schema1 Problem Statement The goal of this data warehouse is to ana... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Fitness Unlimited is a leading provider of exercise centers with a variety of fitness programs and membership options. Fitness Unlimited maintains a retail database to track sales of services and...

A pharmaceutical retail company possesses various stores and manages its current sales, procurement and materials availability at the stores through Excel sheets. The company executives are now...

Schema Data Mart and Data Warehouses. Reading is below........ 1. Does this schema represent a data mart or data warehouse? Why? 2. There are two predominant schema designs mentioned in the reading...

Please help we with this case duty and answer the questions in dot points with specifics to the notes of each question with references Mini Case: Building Shared Services at RR Communications Vince...

Kindly read instructions carefully cuz I will immediately dislike answers that doesnt follow the instructions. I would like to ask about this case. I want the answer for the first question only...

Inventory Data Warehouse The Inventory Data Warehouse provides data to answer business intelligence questions about inventory transaction cycles. The data warehouse was created by a former database...

PLEASE READ CAREFULLY THE CASE STUDY PROVIDED AND FEEL FREE TO ADD HERE YOUR COMMENTS FOR EXAMPLE LIKES DISLIKES WORDS OR PHRASES YOU DO NOT UNDERSTAND ANY COMMENTS THAT WILL IMPROVE THE DIALOGUE...

answer the question clearly You are building a flight-control system for which a convincing safety case must be made. Would you assign the tasks of safety requirements engineering, test case...

CHOSEN ORGANIZATION : KFC ( KENTUCKY FRIED CHICKEN ) Exercises for Lab 4 In small groups discuss the following questions, you will need to present your solutions to rest of the class.: Question 1 -...

The index of refraction of diamond is 2.42. Construct the graph analogous to Fig. 9.16 for the air/diamond interface. (Assume ?1 = ?2 = ?0.) In particular, calculate (a) The amplitudes at normal...

Create a list of all the things that you think are your strengths when you manage your conflicts with others. What are the conflict management skills that you have? 2. Next, create a list of all the...

2 Explain the following three terms: - worm - ransomware - Trojan horse.

[The following information applies to the questions displayed below company sells 1,150 seeson ticket packages at a price of $260 per package. The first show in the 10- A local theater c of34H Next >