Multi-Dimensional Business Intelligence
on 7 Full-Motion Video & Audio CD-ROMs
Featuring Microsoft Analysis Services 2005



"Your multimedia training really works for Microsoft SQL Server 2005 Analysis Services. OLAP architecture was all I needed to upgrade my skills to meet my current SQL developer job requirements. Learning from CD-s and books, practicing along was easier than attending weeks of courses and seminars. I am so encouraged that I plan to take the MCTIP Business Intelligence exams."
Daniel Hudson


Invest in Your Career
Learn Business Intelligence from a top industry expert. Multi-Dimensional Microsoft Business Intelligence is now available on full-motion CD-ROMs with narration. Learn the fun way! Multimedia training is far more effective than textbooks. It simulates the real-world environment for excellent retention. You can replay the video and audio instructional units as many times as you need to.

Learn Business Intelligence with this easy-to-follow CD-ROM collection from Silico-Magnetic Intelligence. Whether you are learning Data Warehousing/Business Intelligence for the first time or adding to your professional skills set, you will find that SMIís Business Intelligence Training via CD-ROMô contains thorough, outstanding, well-prepared content that is second to none.

7 CD-ROMs with Over 18 Hours of Instruction
The instructor is Kalman Toth,  video MCDBA, Senior SQL Server Database, Data Warehouse and Business Intelligence Architect. By mastering one CD-ROM a day, you can become a Microsoft Data Warehouse/Business Intelligence Analyst in just 7 days. You can also proceed at your own pace. The thorough CD-ROM course is focused on practical solutions to real-world Data Warehouse/Business Intelligence design, building, population, deployment, delivery and maintenance problems. Full-motion screen video and rich audio make the subject matter understandable, and reusable as reference material.

Complete SQL Server 2005 Analysis Services video course for DW/BI analysts, software engineers, DBAs, database architects, systems analysts, and managers who design, develop, implement and manage OLAP applications. MDX, DMX, C#, VB, Java, C++, .NET and database developers who need to apply multi-dimensional analysis and data mining in business environment.

Data Warehouse architecture students must have a solid working knowledge of the Windows environment. SQL Server 2005 and programming experience in at least one computer language are helpful. This is best Data Warehouse and Business Intelligence multimedia training currently available in North America, or anywhere in the World.

The CD-ROM based course will teach students to define requirements for Data Warehouse/Business Intelligence, identify facts, measures and dimensions, define the ETL processes, design fact and dimension tables, populate fact and dimension tables, install and configure analysis services, create dimensions, create multi-dimensional OLAP cubes, maintain and optimize cubes. Discover requirements gathering, data source analysis, management buyin, multi-dimensional modeling and data warehouse/business intelligence project life cycle. Explore data warehouse architecture and Analysis Services cube design. Visualize slicing and dicing OLAP cubes based on the Foodmart 2005 and AdventureWorksDW sample data warehouses. Discover the MOLAP, ROLAP and HOLAP storage models for Analysis Services cubes. Investigate Analysis Services cubes by using the MDX multi-dimensional query language. Get acquainted with the guidelines for a successful DW/BI projects. Explore the previous and new data mining algorithms. Discover cube browsing and data mining from Excel 2007. Student will learn the usage of Microsoft DW/BI tools: Management Studio, Business Intelligence Development Studio. Students will get overview of Integration Services (input tool for data warehouse/ OLAP cubes) and Reporting Services (output/interactive analysis tool for OLAP reporting). (See full list below).

About the Trainer
Kalman Toth, MCDBA, is an IT professional with over 16 years of database administration and development experience with SQL server 4.2, 6.5, 7.0, 2000 and 2005. Kalman Toth was a developer on IBM's marketing Data Warehouse project operated by Dun & Bradstreet. He has designed OLAP data warehouse/business intelligence solutions for major online dating, diet and fitness websites. His clients include: Citibank, Bank of Sweden, Deloitte-Touche, Swiss Bank, Lehman Brothers, Salomon Brothers, Merrill Lynch, and IBM. He holds M.Phil degree in Physics and M.Phil. degree in Computing Science from Columbia University, where he had taught computer science.

CD-ROM Features
SMI's CD-based training is like training one-on-one with an expert -- full motion video allows you to see the steps, hear the explanations, and perform the critical tasks. This is the complete training solution for passing a certification exam, excelling on an interview and performing well in the workplace. It is convenient, giving you the freedom to learn at your own pace, wherever and whenever it suits your schedule. CD-ROM is easy to use, with streamlined interface featuring one-click navigation. 100% guaranteed.

Bonus Book: Practical Business Intelligence with SQL Server 2005
In this book(432 pages), two of Microsoft’s leading consultants illustrate how to use SQL Server 2005 Business Intelligence (BI) technologies to solve real-world problems in markets ranging from retail and finance to healthcare. Drawing on extensive personal experience with Microsoft’s strategic customers, John C. Hancock and Roger Toren offer unprecedented insight into BI systems design and step-by-step best practices for implementation, deployment, and management. Each chapter-length case study begins with the customer’s business goals, and then guides you through detailed data modeling. The case studies show how to avoid the pitfalls that derail many BI projects. You’ll translate each model into a working system and learn how to deploy it into production, maintenance, and efficient operation. Whether you’re a decision-maker, architect, developer, or DBA, this book brings together all the knowledge you’ll need to derive maximum business value from any BI project. Leverage SQL Server 2005 databases, Integration Services, Analysis Services, and Reporting Services; Build data warehouses and extend them to support very large databases; Design effective AS databases;Ensure the superior data quality your BI system needs; Construct advanced enterprise scorecard applications;Use data mining to segment customers, cross-sell, and increase the value of each transaction;Design real-time BI applications;Get hands-on practice with SQL Server 2005’s BI toolset.

Multimedia Multi-Dimensional Business Intelligence on 7 full-motion screen image video and rich audio CD-ROMs $695.


Multi-Dimensional Microsoft Business Intelligence on 7 CD-ROMs

CD-ROM 1 - BUSINESS INTELLIGENCE (2 hours 37 minutes)
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 (2 hours 35 minutes)
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 (3 hours 1 minute)
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 (2 hours 30 minutes)
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 (2 hours 50 minutes)
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 (2 hours 34 minutes)
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 (2 hours 49 minutes)
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

Availability: the product usually ships on the next business day.

  Copyright 2006, SMI Corp. All Rights Reserved.  
  Microsoft is a trademark of Microsoft Corporation.
SQL Server 2005 is a program product of Microsoft Corporation.
SQL Server Analysis Services is a program product of Microsoft Corporation.
Business Intelligence Development Studio is a program product of Microsoft Corporation
SSIS is a program product of Microsoft Corporation
PowerPlay is a program product of Cognos Corporation