Contents
Data Warehouse Concepts and Design 1
Abstract 2
Abbreviations 2
Keywords 3
Introduction 3
Jarir Bookstore – Applying the Kimball Method 3
Summary from the available literature and Follow a Proven Methodology: Lifecycle Steps and Tracks 4
Issues and Process involved in Implementation of DW/BI system 5
Data Model Design 6
Star Schema Model 7
Fact Table 10
Dimension Table: 11
Design Feature: 12
Identifying the fields from facts/dimensions: MS: 12
Advanced business analytics techniques -- optimization, data mining and regression 14
Optimization: Creating Distributed Tables 15
The Data Mining Process 16
Data Mining Tasks 16
Analysis of the given data in the excel 17
a. Optimization 17
b. Data mining 19
C. Regression Analysis: 21
References: 27
1. Degenerate dimension and how is it used. Available from:: http://www.information-management.com/news/7844-1.html 27
7. Role-Playing Dimensions. Available from: http://pic.dhe.MS.com/infocenter/cbi/v10r1m1/index.jsp?topic=%2Fcom.MS.swg.ba.cognos.ug_fm.10.1.1.doc%2Fc_bp-multiplerelationships.html 27
Abstract
This analysis report explains how the Kimball method to architecting and building data warehouses using an Organization’s and how the system works for a real time multinational organization with MS Parallel Data (PDW) Warehouse. This report also shows as to how one would incorporate this MS data warehouse product as a tool for the business analytics and data warehousing solution. The system makes use of the Kimball’s method. Herein, an introductory overview of the method is given and the key principles have been discussed and applied for the organization. Three different dataset are taken and the discussion is based on how a hypothetical organization – a bookstore, for instance would use such data. The case study is presented as to how a hypothetical bookstore will utilize the data warehouse.
The Parallel Data Warehouse (PDW) system architecture has been explored and discussed