You'll learn how to approach requirements gathering, data source analysis, management buying, multi-dimensional modeling and data warehouse/business intelligence project life cycle. Explore data warehouse architecture and Analysis Services cube design. And discover the MOLAP, ROLAP and HOLAP storage models for Analysis Services cubes.

This course introduces you to analysis services cubes by using the MDX multi-dimensional query language. And you’ll get acquainted with the guidelines for successful DW/BI projects. Explore previous and all new data mining algorithms. Discover cube browsing and data mining from Excel 2007.

And you’ll learn best practices on usage of Microsoft DW/BI tools: Management Studio, Business Intelligence Development Studio. You’ll get an overview of Integration Services (input tool for data warehouse/ OLAP cubes) and Reporting Services (output/interactive analysis tool for OLAP reporting).

This seven CD-ROM based course teaches you how to:
· Define requirements for data warehouse/Business Intelligence
· Identify facts, measures, and dimensions
· Define the ETL processes
· Design and populate fact and dimension tables
· Install and configure analysis services
· Create dimensions, create multi-dimensional OLAP cubes, maintain and optimize cubes

CD-ROM 1 - BUSINESS INTELLIGENCE
1. Business Intelligence Overview
2. The New BI Platform: SQL Server 2005
3. Mission of Business Intelligence
4. Financial Justification for Business Intelligence
5. Tour of Business Intelligence Development Studio
6. Data Warehousing and Mining Review
7. Multi-Dimensional OLAP Cubes
8. Dashboard Reports
9. Standard Production and Ad Hoc Reports
10. Multi-Dimensional Analytical Reports
11. Online Data Analysis with OLAP Cubes
12. Review of Integration and Reporting Services
13. Building Business Intelligence Solutions
14. Corporate Performance Management with Scorecards
15. Multi-Dimensional BI Delivery Platforms
16. Magic of Business Intelligence

CD-ROM 2 - DW/BI ARCHITECTURE
1. Data Warehouse Overview
2. Data Warehouse & Data Mart Structure
3. Tour of SQL Server 2005 Analysis Services
4. SSAS Administration
5. Review of AdventureWorksDW
6. OLTP Transactional Systems
7. Traditional Database Reporting
8. OLAP: Online Analytical Processing
9. Browsing OLAP Cubes in Management Studio
10. Entity-Relationship Modeling
11. Multi-Dimensional Modeling
12. Multi-Dimensional Model Architecture
13. Enterprise Requirements Gathering
14. Data Source Analysis
15. Management Buyin, Executive Perspective
16. DW/BI Project Team

CD-ROM 3 - DW/BI DESIGN
1. Enterprise Data Warehouse Design
2. The Fact Table
3. Identifying Measures, Calculated Measures
4. Designing Dimension Tables
5. Architecting a Hierarchy
6. Populating the Data Warehouse
7. ETL: Extract, Transform, Load
8. Stored Procedures for Importing Data
9. Using Microsoft SSIS for Data Transfer
10. Advanced SSIS
11. Efficient Data Warehouse Population with SSIS
12. Data Warehouse Maintenance and Optimization
13. Analysis Services DB Backup and Restore
14. Changing Measures and Dimensions
15. Business Intelligence Wizard for Smart Dimensions
16. Data Warehouse Security

CD-ROM 4 - OLAP CUBES
1. OLAP Concepts and Database Setup
2. Design of Fact and Dimension Tables
3. Analysis Services 2005 Architecture
4. The Foodmart 2005 Sample Data Warehouse
5. Populating Fact and Dimension Tables
6. Cube Measures, Dimensions & Hierarchies
7. Aggregations, the GROUP BY Query
8. The AdventureWorksDW Sample Data Warehouse
9. Managing AS 2005 from Management Studio
10. The Dimension Wizard
11. Creating Parent-Child Dimensions
12. The Cube Wizard
13. Designing Cubes in BI Development Studio
14. Creating a Cube with Star Schema
15. Snow Flake Schema
16. Processing Dimensions and Cubes

CD-ROM 5 - COMPLEX CUBES
1. Adding Measure Groups & Calculated Measures
2. Editing Dimensions in the Dimension Designer
3. Editing a Cube in the Cube Designer
4. Slicing & Dicing, Drilling a Cube in the Browser
5. Schema Generation Wizard
6. MOLAP, ROLAP, HOLAP & Other Storage Models
7. Aggregation Design Wizard for Optimization
8. Usage-Based Optimization Wizard
9. Deployment Wizard & Synchronize DB Wizard
10. Automating Cube Processing with SSIS
11. Drillthroughs, Actions, Perspectives and Translations
12. Account Dimensions & Key Performance Indicators
13. Linked Dimensions & User Hierarchies
14. Writeback: Write-Enabling a Dimension
15. Cube, Dimension & Cell Level Security
16. Partition Management & AS DB Processing

CD-ROM 6 - UI & DW/BI PM
1. Overview of User Interfaces
2. MDX Concepts Overview and Examples
3. MDX Syntax Elements: Expressions
4. Creating MDX Queries in Management Studio
5. Advanced MDX Query Examples
6. Using Excel as a Cube Client
7. Pivot Tables and Pivot Charts
8. Cognos PowerPlay and Reportnet
9. Introduction to Cognos PowerPlay
10. Cube Browser in BI Development Studio
11. DW/BI Project Deliverables
12. Moribund DW/BI Projects
13. Successful DW/BI Projects
14. Choosing the Right User Interface
15. Migrating SQL 2000 DW to SQL 2005
16. Success Secrets to DW/BI Project Management

CD-ROM 7 - DATA MINING
1. Data Mining in the Enterprise
2. Terminology, Roles and Responsibilities
3. SQL 2005 Data Mining Architecture
4. Design, Build, Deploy and Process
5. Overview of SSAS Data Mining Algorithms
6. Decision Trees
7. Naive Bayes
8. Clustering
9. Sequence Clustering
10. Time Series
11. Association
12. Neural Networks
13. Linear and Logistic Regression
14. Data Mining Wizard
15. The Data Mining Business Process
16. Data Mining is Mining Gold: Case Studies