Data Warehouse Architecture with
OLAP Cubes
on 5 Full-Motion Video & Audio CD-ROMs

 TEST DRIVE
 BUY ONLINE
 REFERENCE
 CONTACT US
 LINKS

Testimonials

"'I appreciated the one-on-one aspect of cd-rom video training in data warehouse development. It really strengthened my knowledge in data warehousing. I have really learned a lot from this course and have been enlightened on important topics. "
Dick Bilder

"The Data Warehouse Architecture an excellent course in designing, developing, and project managing our datawarehouse. The expertise in the cd-rom instruction set helped get us moving with data warehouse implementation, and helped us get the OLAP cubes done on a timely basis, and on budget. I plan to use other video training products from SQLUSA in the future."
Denise Brown

"Thanks to the excellent sqlusa multimedia training course in data warehousing, in less than three months after building 15 OLAP cubes, I was able to change the way we do day-to-day management of the business data at my company, with unprecedented ability to quickly pin-point issues needing mangement attention and then to equally quickly get detailed information on them. Our new business intelligence systems will actually influence the management culture of the company, with line managers having information readily available in the form they need. Our new Analysis Services Data Warehouse allows data to be viewed from many different points. Referred to as 'multi-dimensional analysis', we are able to view all operational areas without sorting through hundreds and thousands of pages of reports just by slicing and dicing the cubes. This contrasts with the traditional operational OLTP databases, which are ideal for producing paychecks, financial statements, and other reports, but which are usually poor at giving quick answers to the simple questions needed to run complex businesses. SQLUSA multimedia is the best way to quickly learn the art of data warehouse construction."
Sean McKinley

"I have been on several business intelligence live courses. SQLUSA's CD-ROM training course beats them all. It is the best. I am applying what I learned on all of my data warehousing / data marts projects."
Charles Baumann

"I am writing to thank you for the excellent multimedia course. Your data warehouse architecture instruction is excellent, and has given us a good understanding of OLAP cube design and creation. The trainer is a good presenter and teacher and is able to make many very subtle concepts seem clear, simple and logical. We have now tried out our first data warehousing model we built with our data and I must say I am impressed and delighted with it."
Stuart Wilkinson

"SQLUSA's excellent Business Intelligence training has enabled our company to develop a wealth of intelligence in the financial services industry and to become knowledge experts in a number of areas. Many BI projects were developed based on OLAP cubes, including an analysis of how online market data delivery over the internet is impacting financial services, customer service and satisfaction surveys, competitive interstate commerce issues and the latest trends in outsourcing to Asian countries."
Don Wiley

 

 

BI TRIO 2005
Multi-Dimensional Business Intelligence
Data Warehousing with OLAP Cubes
SQL Server 2005 Training  
SQL Server 2000 Training  

Invest in Your Career
Learn Business Intelligence from a top industry expert. Data Warehouse Architecture with Microsoft OLAP Cubes 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 Data Warehouse Architecture with this easy-to-follow CD-ROM collection from Silico-Magnetic Intelligence. Whether you are learning Data Warehousing 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.

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

Audience
Software engineers, systems analysts, IT managers and project managers who design, develop, implement and manage Microsoft SQL Server 2000 Analysis Services based applications. MCSE & MCDBA candidates, VB, Java, C++, ASP.NET and database developers who need to know more about applying OLAP cubes in business environment.

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

Objectives
The CD-ROM based course will teach students to define requirements for Data Warehouse, 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 OLAP cubes, maintain and optimize cubes. (See full list below). Most of the topics in MCDBA certification exam 70–019,"Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0" are covered in the multimedia course.

About the Trainer
Kalman Toth, MCDBA, is an IT professional with over 14 years of database administration and development experience with SQL server 4.2, 6.5, 7.0 and 2000. Kalman Toth was a developer on IBM's marketing Data Warehouse project operated by Dun-Bradstreet. He has designed OLAP datawarehouses 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 an 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 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.

Free Bonus from Microsoft Press:
SQL Server 2000 Analysis Services Step by Step

This excellent book shows Microsoft Excel and Access experts, IS managers, and database developers how to build applications that take advantage of the powerful data-analysis services in Microsoft SQL Server 2000. You’ll discover why these services make it easier to analyze huge amounts of data quickly, and you’ll learn how to develop a wide range of advanced dimensional-data applications—from enterprise reporting tools to advanced decision-support systems. The book’s easy-to-follow lessons begin with clear objectives and include real-world business examples, with a companion CD full of sample files that support each lesson.

 
 
Multimedia Data Warehouse Architecture with OLAP Cubes on 5 full-motion screen image video and rich audio CD-ROMs $395.

Enlarge

Data Warehouse Architecture with Microsoft OLAP Cubes on 5 CD-ROMs


CD-ROM 1 - DW Architecture (131 min)
1. Introduction and Welcome Notes
2. Data Warehouse Overview
3. Data Warehouse Structure
4. Data Marts
5. Business Intelligence (BI)
6. OLTP Transactional Systems
7. Traditional Database Reporting
8. OLAP: Online Analytical Processing
9. Data Mining
10. Entity-Relationship Modeling
11. Dimensional Modeling
12. Multidimensional Model Architecture
13. Enterprise Requirements
14. Data Source Analysis
15. Management Buyin, Executive Perspective
16. Data Warehousing Project Team

CD-ROM 2 - DW Design (160 min)
1. 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 DTS for Data Transfer
10. Advanced DTS
11. Population Strategies
12. Data Warehouse Maintenance
13. DW Backup and Restoration
14. Changing Measures and Dimensions
15. Non-standard and Parent-Child Dimensions
16. Datawarehouse Security

CD-ROM 3- OLAP Cubes (147 min)
1. OLAP Concepts and Database Setup
2. Design of Fact and Dimension Tables
3. Analysis Services Architecture
4. The Foodmart 2000 Sample Data Warehouse
5. Populating Fact and Dimension Tables
6. Cube Measures, Dimensions & Hierarchies
7. Aggregations, the GROUP BY Query
8. Using the Analysis Manager
9. Creating the Data Source
10. The Dimension Wizard
11. Creating Shared Dimensions
12. Creating Time Dimension
13. The Cube Wizard
14. Creating a Cube with Star Schema
15. Snow Flake Schema
16. Processing Dimensions and Cubes

 

CD-ROM 4. Complex Cubes (141 min)
1. Creating Calculated Measures
2. Editing Star Schema Dimension
3. Editing Snow Flake Schema Dimension
4. Editing Parent-Child Dimension
5. Editing a Cube
6. The Cube Browser
7. Optimizing Aggregations with Storage Models
8. Usage-Based Optimizations
9. OLAP Processing, Incremental Updates
10. Automating Cube Processing with DTS
11. Drillthroughs and Actions
12. Creating Virtual Dimensions
13. Creating Securirty Roles for Cube Access
14. Creating Virtual Cubes
15. Data Mining Models
16. Data Warehouse Application Architecture

CD-ROM 5. - UI & DW PM (136 min)
1. Overview of User Interfaces
2. MDX Concepts Overview and Examples
3. Creating MDX Expressions
4. Creating MDX Queries
5. Retrieving Cell Values
6. Using Excel as a Cube Client
7. Pivot Tables
8. Crystal Reports
9. Cognos PowerPlay and Reportnet
10. Introduction to Cognos PowerPlay
11. Advanced PowerPlay
12. DW Project Deliverables
13. Moribound DW Projects
14. Successful DW Projects
15. Choosing the Right User Interface
16. Success Secrets to DW Project Management


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

 
 

The future is just a click away! Your future!

 
 
     
  Copyright 2004, SMI Corp. All Rights Reserved.  
     
  Microsoft is a trademark of Microsoft Corporation.
SQL Server 2000 is a program product of Microsoft Corporation.
Analysis Services is a program product of Microsoft Corporation.