 |
 |
 |
 |
 |
 |
 |
 |
||
 |
||
 |
||
 |
||
 |
||
 |
||
 |
||
 |
||
 |
||
 |
Special limited time offer for Microsoft referrals: $100 off!*
To get $100 off the prices listed below, enter the following Promotion Code at the bottom of the Registration page: KU87MDWD
*Offer good only for the Microsoft Data Warehouse in Depth class. Offer ends December 12, 2005.
|
NEW! Microsoft Data Warehouse in Depth |
October 4-6, 2005 Chicago, IL DoubleTree Guest Suites Chicago Downtown |
Price: $1,995.00 Special, extended date: Early Bird price by October 3: $1,795.00  |
|
|
|
| December 12-14, 2005 San Diego, CA Hilton San Diego Gaslamp Quarter |
Price: $1,995.00 Early Bird price by Oct. 28: $1,795.00 |
|
|
|
Microsoft Data Warehouse in Depth Course Description
With SQL Server 2005, Microsoft provides a complete suite of tools for you to build data warehouse and business intelligence systems using software from a single vendor. This course prepares you to deal with the many facets of developing, deploying, operating, and growing your Microsoft data warehouse system.
What you’ll learn
This three-day lecture and demo course, based on The Microsoft Data Warehouse Toolkit (John Wiley & Sons; late 2005), will provide you a detailed technical introduction to building a Microsoft data warehouse system that meets the needs of your business users. The class will provide Microsoft-specific detailed guidance for working through the data warehouse lifecycle, from requirements gathering and design through the ETL system, relational data warehouse, OLAP and data mining applications, to reporting and ad hoc query systems. We’ll discuss issues around deploying, operating, and securing the Microsoft data warehouse system. This course covers a lot of material in a short time.
The focus of the course is architectural—how should you design the components of the system. We expect our attendees to be able to read documentation and follow Microsoft’s generally straightforward user interfaces. Our goal is to teach you the hard stuff: not which button to push, but why. The pace of the course permits only demos by the instructor; do not expect hands on tutorials during class time.
Who should attend
This course is designed for data warehouse architects and implementers, who are responsible for building the data warehouse environment. This would include data warehouse team managers, system architects, ETL system architects and developers, data warehouse operational staff, and BI application designers and developers.
Prerequisites
Attendees must be familiar with and understand dimensional modeling. If you have attended one of the Kimball Group public or onsite courses, you qualify. If you have thoroughly read and understood the Data Warehouse Toolkit, Second Edition (John Wiley & Sons, 2002), you qualify. This course supplements, rather than replaces, the material in our other courses. Whether or not you’ve attended one of our courses, be sure to review the key dimensional design concepts. For example, you must readily grasp the concept of a Type 2 Slowly Changing Dimension without explanation during the class. Please note that dimensional modeling is not taught during this course. It is your responsibility to come prepared.
COURSE OUTLINE
Getting Started the Right Way
• Project planning
• Business requirements
• Dimensional modeling
• Understanding the Microsoft product architecture and toolset
Developing the Microsoft Data Warehouse / BI System
• Installation, setup and configuration
• Relational data warehouse physical design
• Designing the ETL system for SQL Server Integration Services
• Developing the ETL system in Integration Services
• Developing the Analysis Services OLAP database
• Designing BI applications
• Implementing Reporting Services
• Developing the Data Mining applications
Running the Microsoft Data Warehouse / BI System
• Implementing security
• Testing and deploying the system
• Operations and maintenance
• Growing and modifying the system
• Metadata
• Real time business intelligence
Home | Kimball University | Consulting | Events | Books | Articles | Design Tips | Commentary | About Us | Contact Us | Site Map