logo

Data Warehouse Design : Case Study

16 Pages1486 Words61 Views
   

Added on  2021-06-17

Data Warehouse Design : Case Study

   Added on 2021-06-17

ShareRelated Documents
Running head: DATA WAREHOUSE DESIGNData Warehouse Design: A Case Study of CarHireOZName of the StudentName of the University
Data Warehouse Design : Case Study_1
DATA WAREHOUSE DESIGN2Table of Contents1. Introduction:................................................................................................................................32. Data Warehouse Bus Matrix:.......................................................................................................33. Star Schema for the Data Marts:..................................................................................................43.1 Rental and Sales:........................................................................................................................43.2 Advertisement/commercials:.....................................................................................................54. Fact Table, Granularity and Justification against Granularity:....................................................65. Justification and Attribute Hierarchy of the Dimension Tables:.................................................86. Data Warehouse Design Features:.............................................................................................127. Identification of Fields:..............................................................................................................138. Conclusion:................................................................................................................................15Bibliography:.................................................................................................................................16
Data Warehouse Design : Case Study_2
DATA WAREHOUSE DESIGN31. Introduction:The data warehousing is used for supporting the decision making process of anorganization by integrated, non-volatile, subject-oriented and time variant data collectionprocesses. The bus-matrix is used for aligning the dimensions with the business processes.Through the star schema, it is possible to represent the design of the data warehouse.The report is focused on the bus-matrix start schema, using granularity to justify the facttables and using the data to support business queries. The data warehouse of CarHireOZ isdesigned for supporting the business objectives of the enterprise. 2. Data Warehouse Bus Matrix:BusinessprocessesDimensionsVEHICLETYPEVEHICLECUSTOMERSMEMBERCLASSBOOKINGDRIVERSCONTRACTRETURNPROTOCOLDATEPROMOTIONITEMITEMSALESTOREMEDIACOMPANYRental andSalesXXXXXXXXXXXXAdvertisement/commercialsXXXXXXXX
Data Warehouse Design : Case Study_3
DATA WAREHOUSE DESIGN43. Star Schema for the Data Marts:3.1 Rental and Sales:
Data Warehouse Design : Case Study_4

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Data Warehouse Design and Implementation
|17
|1547
|286

Data Warehouse Design: A Case Study of CarHireOZ
|14
|1757
|178

Data Warehouse Design Assignment
|18
|1608
|190

Data Warehouse Design - PDF
|16
|1079
|172

Data Warehouse Design Assignment
|18
|1319
|45

Data Warehouse Design: A Case Study of Chemist Warehouse
|19
|2762
|58