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
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 ...
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 - Das Data Warehouse verstehen: PowerPoint-Set zur Darstellung der technischen Funktionalität, des wirtschaftlichen Nutzens, und der ...
View Data Warehouse presentations online, safely and virus-free! Many are downloadable. Learn new things quickly. Get ideas for your own presentations.
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
... HTWK Leipzig Data Warehouse & Data Marts Data Warehouse - Datenbank für Analysezwecke; orientiert sich in Struktur an Analysebedürfnissen ...