Answered step by step
Verified Expert Solution
Link Copied!

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)

  1. What type of data is on the "Data" worksheet?
  2. Identify dimensions and their characteristics
  3. Identify Key Figures (facts or measures)
  4. Draw a data warehouse which corresponds to the data on the "Data" worksheet.
image

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Analyzing Data And Making Decisions Statistics For Business Microsoft Excel 2010 Updated

Authors: Judith Skuce

2nd Edition

9780132844727, 013292496X, 132844729, 978-0132924962

More Books

Students also viewed these Databases questions

Question

What is a role model? (p. 8)

Answered: 1 week ago