Data Warehouse Presentation

50 %
50 %
Information about Data Warehouse Presentation
Education

Published on February 16, 2014

Author: gourav5660

Source: slideshare.net

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 – Wikipedia

Ein Data-Warehouse (abgekürzt DW oder DWH) oder Datenlager ist eine für Analysezwecke optimierte zentrale Datenbank, die Daten aus mehreren, ...
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

PowerPoint Presentation

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

Data Warehouse PowerPoint Template - PresentationLoad

Data Warehouse - Understanding the Data Warehouse: this PowerPoint template set serves to illustrate technical functionality, economic profitability and ...
Read more

Data Warehouse Presentation - Forsiden

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

PPT – Warehouse Operations PowerPoint presentation | free ...

Data Warehouse Models and OLAP Operations - Pilot, Arbor Essbase ... The PowerPoint PPT presentation: "Warehouse Operations" is the property of its ...
Read more

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

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

DATAWAREHOUSE_PPT - scribd.com

Introduction to Data Warehousing. Pragim Technologies Roadmap • • • • • • • • • Introduction to Data Warehousing OLTP Vs OLAP
Read more