Demos of Data Warehousing with Microsoft SQL Server 2008

 

1. Creating Data Marts

 

1.1 Create data mart with BIDS 834

1.2 Add in more attributes to the database 542

1.3 Cube Deployment 311

 

2. ETL

 

2.1 Exercise 4: Load MaxMinManufacturing DM dimension tables

2.1.1 Prepare for starting 245

2.1.2 Stage 1 Easy dimension loading 824

2.1.3 Stage 2 Loading with extra efforts (DimPlant, DimMaterilal) 804

2.1.4 Stage 2 Loading with extra efforts (DimMachinetzype, DimMachine) 928

2.2 Exercise 5: Load fact tables

2.2.1 Preparation 313

2.2.2 Load DimBatch table 945

2.2.3 Load Manufacturing fact table 540

2.2.4 Load Inventory fact table 146

 

3. Cubism

 

3.1 Getting started with cubism

3.1.1 No time dimension - a simple cube 724

3.1.2 Create time dimension tables 924

3.1.3 Create time dimension from an existing table 232

3.1.4 Configure a cube for MaxMinManufacturing data mart 1040

 

3.2 Exercise 6: Create an OLAP cube

3.2.1 Add new items into fact tables and define a hierarchical time dimension from a fact tables 954

3.2.2 Measure configuring and formatting 430

3.2.3 Create calculated measures 308

3.2.4 Define hierarchies of Material and Product dimensions 238

3.2.5 Deploy a comprehensive OLAP cube 333

 

3.3 Exercise 7: Customize a cube 653