Data Warehouse Full Life-Cycle Implementation
Instructor: David Marco
Duration: 2-day (full course) or 1-day (reduced version)
Seminar Overview
This practical seminar provides you with an in-depth understanding of data warehousing 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, meta data repository fundamentals, and accessing the information in the data warehouse.
Benefits To Your Company
- 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.
Benefits of Attending
- Learn a full life-cycle methodology for implementing a business intelligence system using data warehouse and data mart technology.
- Understand how to define requirements that yield positive ROI.
- Identify the challenges of implementing business intelligence systems.
- 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.
- Understand how to create e-Business solutions that deliver value.
Seminar Outline
- Understanding Data Warehousing
- Analyze the current state of the data warehousing industry
- Data warehousing fundamentals
- Defining meta data and its critical role in data warehousing
- Challenges in the Data Warehouse Industry
- Selling the concept of building a data warehouse to management (ROI)
- Cutting through the vendor hype
- How to Implement a Data Warehouse, Data Mart, and Operational Data Store
- Keys to a Sound Architecture
- Defining System Requirements
- Integrating Legacy System Sources
- Accessing Data Warehouse
- Approaches to Data Warehouse Development
- Data Model Walkthrough (3rd normal and dimensional)
- 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
- Understanding the Key Business Intelligence Vendors
- The Battle for Meta Data Standards (Meta Data Coalition vs. Object Management Group)
- Evaluating Data Warehousing Tools, including ETL (extract, transform, & load), OLAP (online analytical processing), and portals
- Real-world analysis of tool vendors
- Understand the Trends in Business Intelligence
- Data Warehousing Changing Landscape
- Meta Data
- XML
