Data Warehouse Presentation

50 %
50 %
Information about Data Warehouse Presentation

Published on February 16, 2014

Author: gourav5660


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

SSAS report

Thank You

Add a comment

Related presentations

Related pages

Data Warehouse Presentation - PRINCIPLE PARTNERS

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 ...
Read more

Data Warehouse Presentation - Forsiden - Universitetet i Oslo

1 Data Warehouse Presentation November 10th 2004 VPROCs Amps VPROCs Amps VPROCs Amps VPROCs Amps A LARGE Data Warehouse 30,000 ...
Read more

Data Warehouse | PresentationLoad

Data Warehouse - Das Data Warehouse verstehen: PowerPoint-Set zur Darstellung der technischen Funktionalität, des wirtschaftlichen Nutzens, und der ...
Read more

DATA WAREHOUSE PowerPoint PPT Presentations

View Data Warehouse presentations online, safely and virus-free! Many are downloadable. Learn new things quickly. Get ideas for your own presentations.
Read more

PPT – What is Data Warehouse PowerPoint presentation ...

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
Read more

Entscheidungsunterstützende Systeme (Data Warehouse)

... HTWK Leipzig Data Warehouse & Data Marts Data Warehouse - Datenbank für Analysezwecke; orientiert sich in Struktur an Analysebedürfnissen ...
Read more