This pragmatic seminar provides the student with a comprehensive understanding of data warehousing fundamentals and principles. You will learn the best practices and processes necessary to architect, design and build a successful data warehouse – or resurrect one.
Practical field examples of data warehousing implementations permeate the presentation. The class covers justification and requirements activities, project planning, data modeling and data access as well as topics like data quality, maturing warehouses and market landscape issues that are needed for success.
This class is for anyone involved in a data warehouse/business intelligence initiative. The class establishes the terminology foundation and exposes each participant to the larger picture and roles of the other team members, thereby creating a more efficient and successful team.
Chief Information Officers
Information Technology Leadership
Project and Program Managers
Definitions and Justification
Data Warehouse Program
Data Warehouse Justification
Data Warehouse Architecture
Inmon-oriented Enterprise Data Warehouse Approaches
Kimball-oriented Data Mart Oriented Approaches
Federating the Data Warehouse across the Enterprise
Data Access Tool Categories
The Agile Approach
Roles and Responsibilities – Technical
Roles and Responsibilities – Business (including data stewards)
Design and Implementation Deliverables
Aspects of Architecture and Methodology that each organization needs a decisiveness direction on
Data Warehouse Modeling
Conceptual and Logical
Steps to create a dimensional data model
Dimensional – Star
Dimensional – Snowflake
The Data Warehouse Landscape – What’s Going on?
BI Program Environment Landscape