Data Warehousing & 2008 Business Intelligence
on 7 CD-ROMs
Featuring Analysis Services 2008




Advance Your Career
Learn Business Intelligence from a top industry expert. Multi-Dimensional Microsoft Business Intelligence is now available on full-motion screencast 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 screencast 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 21 Hours of Instruction
The instructor is Kalman Toth MCDBA, MCITP, 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 Designer 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 screencast and rich audio make the subject matter understandable, and reusable as reference material.

Complete SQL Server 2008 Analysis Services video course for DW/BI architects, administrators and developers; 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 OLAP and data mining data sources in enterprise environment.

Data Warehouse/Business Intelligence architecture students must have a solid working knowledge of the Windows environment. SQL Server 2008 and programming experience in at least one computer language are helpful. This is the very best and most intensive Data Warehouse and Business Intelligence multimedia screencast 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 hierarchies, 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 AdventureWorksDW2008 sample data warehouse. 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 data mining model 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 a brief 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, MCITP, is an IT professional with over 17 years of database administration and development experience with SQL server 4.2, 6.5, 7.0, 2000 2005, and 2008. 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 screencast 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: Microsoft SQL Server 2008 Analysis Services Unleashed
Microsoft SQL Server 2008 Analysis Services Unleashed (888 pages) is the ultimate guide for anyone who is planning to use the latest version of Analysis Services. It gives readers insight into the way Analysis Services functions, and explains practical methods for designing and creating multidimensional objects. It also provides valuable insight into the reasons behind the design decisions taken by the product development team. The authors have been involved with Analysis Services from its earliest days at Microsoft. They have documented in detail the internal features of Analysis Services 2008, explaining server architecture, main data structures, data processing, and query resolution algorithms. Discover the new functionality introduced in Analysis Services 2008 including MDX enhancements and new DMV (dynamic memory views) Work with the Business Intelligence Development Studio, the new Dimension Editor, and Aggregation Designer interfaces. Enjoy complete coverage of new Shared Scalable Databases scale-out infrastructure Learn the key concepts of multidimensional modeling. Explore the multidimensional object model and its definition language Integrate multidimensional and relational databases. Build client applications to access data in Analysis Services. Unravel the inner workings of the server architecture, including main data structures, data processing, and query resolution algorithms. Learn the main concepts of the MDX language and gain an in-depth understanding of advanced MDX concepts. Gain a deeper understanding of the internal and external protocols for data transfer, including the XML/A protocol. Discover how Analysis Services manages memory. Explore the security model, including role-based security, code-access security, and data security.

Multidimensional Data Warehousing & 2008 Business Intelligence on 7 full-motion screen image video and rich audio CD-ROMs $645.


Data Warehousing & 2008 Business Intelligence on 7 CD-ROMs

CD-ROM 1 - BUSINESS INTELLIGENCE (2 hours 53 minutes)
1. Enter the Golden Age of Business Intelligence
2. Comprehensive & Scalable Persuasive BI Platform
3. BI Initiative. How to Justify, Sell & Architect
4. Installing AdventureWorks2008 DW & SSAS Project
5. Tour of Business Intelligence Development Studio
6. Data Warehousing & Data Mining Review
7. Multi-Level Dimension & Multi-Dimensional Cube
8. OLAP Cube: Millions of Pre-Calculated Answers
9. Easy Drilldown OLAP Reports with Report Builder
10. The Power of BI with Dashboard Reporting
11. Creating Interactive Analytical Matrix Reports
12. Exploring Online Data Analysis with OLAP Cubes
13. Review of Integration and Reporting Services
14. Performance Management with Balanced Scorecard
15. SQL Server 2008 - Integrated BI Delivery Platform
16. Business Intelligence to Machine Intelligence

CD-ROM 2 - DW/BI BASICS (3 hours 8 minutes)
1. Overview of Data Warehousing & OLAP Technology
2. Modern Data Warehouse & Data Mart Structure
3. Tour of SQL Server 2008 Analysis Services
4. SSAS Administration - DB Backup & Restore
5. AdventureWorksDW2008 Sample DW Database
6. OLTP Transactional Systems - AdventureWorks2008
7. Pre-BI Approach - GROUP BY & Aggregate Queries
8. OLAP: Interactive Online Analytical Processing
9. Browsing OLAP Cubes & Mining Models in SSMS
10. Slicing & Dicing SSAS Cubes in Excel 2007
11. Selecting Data from SSAS Cube in Report Wizard
12. Multi-Dimensional Model Architecture & Design
13. Exploring Enterprise Requirements Gathering
14. Data Source Analysis and SSIS Data Profiling
15. Convincing Management & Executive Perspective
16. Composition & Dynamics of DW/BI Project Team

CD-ROM 3 - DATA WAREHOUSE DESIGN (2 hours 58 minutes)
1. Enterprise Data Warehouse Architecture
2. Dimensional Modelling Star Schema Diagram
3. Understanding Fact Table vs. Dimension Table
4. Fact Table Measures & Calculated Measures
5. Defining Dimension Attributes & Hierarchies
6. Populating & Refreshing the Data Warehouse
7. Extract, Transform and Load (ETL) Processes
8. T-SQL Commands & Utilities for Importing Data
9. Data Transfer with SSIS Import/Export Wizard
10. Exploring Advanced SQL Server 2008 SSIS
11. Complex Data Warehouse Population with SSIS
12. Data Warehouse DB Maintenance & Optimization
13. Slowly Changing Dimensions and SCD Wizard
14. Business Intelligence Wizard & Time Dimension
15. Pros & Cons of Normalized Snowflake Schema
16. Reviewing Data Warehouse Security Concepts

CD-ROM 4 - OLAP CUBES (3 hours 1 minute)
1. Creating an Analysis Services Database
2. Adding Simple OLAP Cubes to an SSAS Database
3. Migrating from SSAS 2000 to SSAS 2008
4. Migrating SSAS 2005 Database to SSAS 2008
5. Analysis Services 2008 Architecture
6. OLAP Concepts: Measures & Dimensions
7. Organizing Measures, Dimensions & Hierarchies
8. Aggregations Concepts - GROUP BY Queries
9. The AdventureWorksDW2008 Data Warehouse
10. Managing AS 2008 from Management Studio
11. Designing with the Dimension Wizard
12. Learning the Attribute Relationship Designer
13. Exploring the Aggregation Design Wizard
14. Working with the Cube Wizard
15. Exploring the New Streamlined Cube Designer
16. Processing Dimensions and Cubes

CD-ROM 5 - COMPLEX CUBES (3 hours 2 minutes)
1. Adding Measures & Measure Groups to a Cube
2. Calculated Member, Named Set & Script Command
3. Editing Dimensions and Cubes in the Designers
4. Slicing & Dicing, Drilling a Cube in the Browser
5. Understanding the Schema Generation Wizard
6. MOLAP, ROLAP, HOLAP & Other Storage Models
7. Aggregation & Usage-Based Cube Optimization
8. Deployment Wizard & Synchronize DB Wizard
9. Automating Cube Processing with SSIS
10. Drillthroughs, Actions and Perspectives
11. Natural, Navigation & Parent-Child Hierarchies
12. Calculation Tools - Metadata, Functions & Templates
13. Linked Object Wizard, Translations & Currency
14. Referenced & Many-to-Many Dimension Relationships
15. OLAP Cube, Dimension & Cell Level Security
16. Partition Management, DB Processing & Writeback

CD-ROM 6 - DELIVERY & PM (3 hours 8 minutes)
1. Delivery to BI Consumers & Project Management
2. Exploring MDX Concepts - Overview and Examples
3. MDX Syntax Elements - Expressions & Queries
4. Working with SSMS MDX Template Explorer
5. Discovering SSRS Visual MDX Query Builder
6. Capturing MDX Queries with SQL Server Profiler
7. OLAP Client - Excel 2007 Pivot Tables & Charts
8. Excel 2007 - Saving & Loading .cub Local Cubes
9. Interactive Drilldown SSRS OLAP Matrix Reports
10. Key Performance Indicator (KPI) Reports
11. The XMLA Language - Capture with SQL Profiler
12. Reviewing DW/BI Project Deliverables
13. Recognizing Moribund DW/BI Projects
14. Understanding Successful DW/BI Projects
15. Choosing the Right BI Presentation Layer
16. Success Secrets to DW/BI Project Management

CD-ROM 7 - DATA MINING (2 hours 50 minutes)
1. Reviewing the Data Mining Business Process
2. Extracting Gold from the Mine of Customer Data
3. The DMX Language - Capture with SQL Profiler
4. DM Algorithms – Predicting, Clustering or Both
5. Decision Trees - Classification & Regression
6. Naive Bayes – Classification for Prediction
7. Time Series - Regression of Continuous Values
8. Clustering - Segmentation for Grouping
9. Sequence Clustering for Paths Grouping
10. Association for Recommendation Engines
11. Neural Networks to Calculate Possibilities
12. Linear and Logistic Regression for Prediction
13. Data Mining Wizard to Create Mining Structures
14. Exploring the Data Mining Ribbon in Excel 2007
15. Discovering Data Analysis for DM in Excel 2007
16. Mined Customers Cube - Combining DM with OLAP

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


The future is just a click away! Your future!
The Best Data Warehouse & Business Intelligence
Training in the World

  Copyright 2009, SMI Corp. All Rights Reserved.  
  Microsoft is a trademark of Microsoft Corporation.
SQL Server 2008 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