Published on February 16, 2014
INFO 637-602 Data Warehousing DFF DW and Analytics Implementation Group-9 Submitted By Shrikant Chaturvedi Sisira Narayana Gourav Nagar
Business Questions • How is the sale of Coke equivalents affected when there is a sale on Pepsi products? How is the effect vice-versa? What is the trend after sale ends? • Which product promotion causes the maximum loss over years? • What is the effect of age demographics on the sales of analgesics? • How is the sale of grooming products effected by the education level of the demographics? • Which of the cities is most/least responsive to holiday seasons than others?
Schema used and ETL Strategies Type Conversation Deleting Junk/Blank Rows Deleting Un-necessary Rows Deriving New Columns using Mathematical Transformation Used Conditional Split Used Regular Expression Load the most granular data Date dimension for every fact Use of surrogate keys Conformed dimensions
List of Reports Report Builder 3.0 SSRS Over SSAS SSRS SSRS
Ein Data-Warehouse (abgekürzt DW oder DWH) oder Datenlager ist eine für Analysezwecke optimierte zentrale Datenbank, die Daten aus mehreren, ...
Data Warehouse - Das Data Warehouse verstehen: PowerPoint-Set zur Darstellung der technischen Funktionalität, des wirtschaftlichen Nutzens, und der ...
So What Is a Data Warehouse? Definition: A single, complete and consistent store of data obtained from a variety of different sources made available to end ...
Data Warehouse - Understanding the Data Warehouse: this PowerPoint template set serves to illustrate technical functionality, economic profitability and ...
1 Data Warehouse Presentation Toto.Horvli@Teradata-NCR.com November 10th 2004 VPROCs Amps VPROCs Amps VPROCs Amps VPROCs Amps A LARGE Data Warehouse 30,000 ...
Data Warehouse Models and OLAP Operations - Pilot, Arbor Essbase ... The PowerPoint PPT presentation: "Warehouse Operations" is the property of its ...
Title: Data Warehouse Presentation Author: Walter Moeller (415) 341-4600 Last modified by: Walter E. Moeller Created Date: 1/23/1997 1:12:45 PM Document ...
Title: What is Data Warehouse 1 What is Data Warehouse? Defined in many different ways, but not rigorously. A decision support database that is maintained
Introduction to Data Warehousing. Pragim Technologies Roadmap • • • • • • • • • Introduction to Data Warehousing OLTP Vs OLAP