Seminar Overview

This practical seminar provides you with an in-depth understanding of data warehousing and its application to business intelligence. You will learn the concepts and skills necessary to build a successful data warehouse to implement your business intelligence program on the first implementation. Real-world case studies of business intelligence and data warehousing implementations to leverage the lessons learned on these projects. Through team interaction attendees will be provided with a full life cycle strategy and methodology for defining system requirements, capturing/integrating source data, and accessing the information in the data warehouse.

Benefits of Attending

• Learn a full life-cycle methodology for implementing a business intelligence system using data warehouse technology.
• Understand how to define requirements that yield positive ROI.
• Identify the challenges of implementing a data warehouse.
• Understand how to build a data warehouse that is flexible to the changing technical marketplace.

Who Should Attend & What You Will Learn

CIOs and Executive Management will learn how to:

• Cost justify and build a business intelligence system using data warehouse technology for a competitive advantage in the marketplace.
• Understand how to manage risk and anticipate the stumbling blocks before they occur.

Project Managers and DSS Architects will learn to:

• Organize and manage their teams.
• How to create accurate project plans.
• Learn to define requirements that prevent scope creep.
• How to build an architecture that is extendible, robust, and flexible over time.

Database Designers will learn to:

• Identify the key business data necessary to store in the physical data models in order for the data warehouse to provide value to its end users.

Lead Designers and Business Analysts will learn how to:

• Design attainable requirements for the data warehouse.

Seminar Outline

1. Understanding Data Warehousing
   • Analyze the current state of the data warehousing industry
   • Data warehousing fundamentals including active data warehousing
2. Challenges in the Data Warehouse Industry
   • Selling the concept of building a data warehouse to management (ROI)
   • Cutting through the vendor hype
   • Dealing with large volumes of data warehouse data
3. How to Implement an Integrated Data Warehouse Solution
   • Keys to a Sound Architecture
   • Defining System Requirements
   • Integrating Legacy System Sources
   • Accessing Data Warehouse
   • Approaches to Data Warehouse Development
4. The Data Warehouse Team
   • Creating the Data Warehouse Team
   • Data Warehouse Team Role Walkthroughs
   • Creating the Data Warehouse Project Plan
   • Data Warehouse ROI Definition
   • Constructing the Data Warehouse Scope Document
   • Create a Data Integration Strategy for your Company
5. Understanding the Key Business Intelligence Vendors
   • Evaluating Business Intelligence Tools, including ETL (extract, transform, & load), OLAP (online analytical processing), and portals
   • Real-world analysis of tool vendors
6. Understand the Trends in Business Intelligence

About The Instructor:

Mike Reed