Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Consider the Data_mod.xlsx file (it is posted with this assignment) - (3X2 + 4 = 10 Points) What type of data is on the Data
Consider the "Data_mod.xlsx" file (it is posted with this assignment) - (3X2 + 4 = 10 Points)
- What type of data is on the "Data" worksheet?
- Identify dimensions and their characteristics
- Identify Key Figures (facts or measures)
- Draw a data warehouse which corresponds to the data on the "Data" worksheet.
AutoSave R12 Off H Data_mod.xlsx Protected View File Home Insert Draw Page Layout Formulas Data Review View Automate Help Data Manager PrimaXL Analysis Analysis Design PROTECTED VIEW This file has been verified by Microsoft Defender Advanced Threat Protection and it hasn't detected any threats. If you need to edit this file, click enable editing. Enable Editing : X fx A B 1 Customer - Product 2 Airport Bikes Air Pump 3 Airport Bikesi Air Pump 4 Airport Bikes, Air Pump 5 Airport Bikes Air Pump DistributionCI YEAR 2008 2008 2008 2008 WH WH WH WH D E MONTH 1 2 3 3 DAY 5 29 18 24 F G Date 1/5/2008 2/29/2008 3/18/2008 3/24/2008 Search (Alt+Q) H SalesQuantity UnitOfMeasu Revenue 1 ST 2 ST 4 ST 6 ST K Currency 21.65 EUR 43.3 EUR 86.6 EUR 129.9 EUR L Discount 0.65 1.3 2.6 3.9 M NetSales N Division 21 AS 42 AS 84 AS 126 AS O SALES_ORG Germany South Germany South Germany South Germany South P Country DE DE DE DE
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started