Question: Based on the data shown in the Detailed Fact Table Example below, if we created an aggregated fact table that contains data about daily Sales

Based on the data shown in the Detailed Fact Table Example below, if we created an aggregated fact table that contains data about daily Sales performance (UnitsSold and DollarsSold) of each store, Q1. such an aggregated table would be connected to how many dimensions and what are they?

Q2. Could you also guess such an aggregated table would have how many records in the fact table?

Please briefly justify your answers to Q1 and Q2.

TID TimeOfDay SALES Fact table Calendar Store Product Customer Key Key Key 1 1 1 1 1 2 2 2 Dollars Sold $100 Units Sold 1 T111 T222 2. 1 $70 $75 2 3 3 1 T333 5 2 3 1 1 T333 1 8:23:59 AM 8:24:30 AM 8:15:08 AM 8:15:08 AM 8:20:33 AM 8:20:33 AM 8:30:00 AM 8:30:00 AM 2 3 4 3 T444 1 2 2 3 T444 2 3 3 2 4 T555 4 $100 $90 $140 $360 $300 $250 $300 $250 2 3 5 T555 2 NNNN 2 3 6 T555 1 2 3 5 T666 8:30:00 AM 9:30:00 AM 9:30:00 AM 2 2 3 6 2 T666 1

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

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!

The following question assumes that a single - source star schema is created. The purpose of this star schema is to analyze quantities of prescribed medications by all dimensions provided by its...

PATIENT PAtientin PatientName PatientWeight PII P22 P33 1608 1258 250b Mary Fred DoctorD DoctorName Specialty D11 D11 D33 S1 S1 S2 SPECIALTY SpecialtylD SpecialtyName S1 S2 Family Medieime treternai...

Based on the data shown in the STATEWIDE HEALTH PRESCRIPTIONS database, if we created an snapshot fact table that contains data about daily prescribed quantities of each medication per each patient,...

E8.1a Using the data in Figure 8.37, illustrate how the tables in the dimensional model shown in Figure 8.38 would be populated. E8.1b Create a dimensional model containing an aggregated fact table,...

Income Statement of an interior design firm, Grand Designs, that makes money by selling hours (fees) and by selling furniture or other items (Sale of Goods). 1) Using the formula for Profit Margin,...

Who is chief knowledge officer? What the primary role? A senior executive in an organization responsible for ensuring that firm fully utilizes the value it gets through knowledge- which is the most...

There are two problems due this week (each worth 35 points) as follows. Problem 1.6 (page 20) In comprehensive paragraphs, answerrequirements a to e. You will have 5 paragraphs total of four to five...

For the exclusive use of M. Xin, 2016. CASE: OIT-71B DATE: 10/15/10 WALMART'S SUSTAINABILITY STRATEGY (B): 2010 UPDATE I don't think there's better money that we're spending anywhere. Fred Krupp,...

INTERNATIONAL REVIEW OF L AW C OMPUTERS & TECHNOLOGY , VOLUME 11, N UMBER 2, P AGES 251-261, 1997 The Data Mart: A New Approach to Data Warehousing PAM ELA PIPE Introduction Vendors have recently...

Read the case Hi Ho Silver at the end of Chapter 4 (I Included the relevant pages to answer this assignment at the bottom) After reviewing the case information, write a 2 to 3-page paper where you...

Dr. Jones' accountant has told him he will need to clear an additional $200,000 of cash flow (above break-even) in order to pay the debt service on the cost of the equipment and yield the required...

Which liquid has the lowest vapor pressure? O acetic acid (Tvap-118C) O acetone (Tvap=56C) O carbon tetrachloride (Tvap=77C) O methanol (Tvap-65C) O toluene (Tvap-111C)

Experts tend to organize their thinking into: A . A list of facts. B . Big ideas or major principles. C . A list of formulas.

atch the compensation objectives with their meanings. Efficiency Efficiency drop zone empty. Fairness Fairness drop zone empty. Compliance Compliance drop zone empty. Improving performance and...