Data Warehouse Lifecycle: The Kimball Approach
description.
Building a data warehouse is complex and challenging. This course prepares you to successfully implement your data warehouse/business intelligence program by presenting the essential elements of the popular Kimball Approach as described in the bestselling book, The Data Warehouse Lifecycle Toolkit (Second Edition).
The 1-day course is packed with techniques, guidance, and advice from planning, requirements, and design through architecture, ETL, and operations. The breadth of content covered in this course necessitates a lecture format.
Important topics include:
- The Kimball Approach to data warehouse project planning and requirements gathering
- A brief introduction to dimensional modeling
- A framework for creating your technical architecture
- Physical system design
- Overview of the ETL system
- And much more!
Why attend
You will learn:
- Understand why data warehouse modernization is needed to help improve decision-making and competitiveness
- Have the ingredients to know how to modernize your data warehouse to improve agility, reduce the cost of ownership, facilitate easy maintenance
- Understand modern data modeling techniques and how to reduce the number of data stores in a data warehouse without losing information
- Understand how to exploit cloud computing at a lower cost and how to migrate to the cloud
- Understand how to reduce data latency in your data warehouse
- Understand how to integrate your data warehouse with data stored in cloud storage data lakes
- Know how to migrate from a waterfall-based data warehouse and data marts to a lean, modern logical data warehouse with virtual data marts that integrate easily with cloud storage and other analytical systems
- Know how to use data virtualization to simplify access to a more comprehensive set of insights available on multiple analytical platforms running analytics on different types of data for precise evidence-based decision making
- Understand the role of a modern data warehouse in a data-driven enterprise
Who should attend
This course is designed for all major roles on a data warehouse project, including project managers, business analysts, data modelers, architects, and ETL or BI application designers and developers. It is valuable both for team members engaged in their first data warehouse/business intelligence project, as well as for those who have several projects under their belts and want to align their experience with the proven Kimball techniques.
Prerequisites
Students should be:
- Able to name and describe in a few words the main operational systems of his or her organization
- Able to name and describe in a few words the main business concerns of the end-users in his or her organization
- Somewhat familiar with basic data modeling concepts such as referential integrity
However, the absence of these abilities and familiarity will not keep you from profiting from the course. There is no need for any kind of preparatory data warehouse/business intelligence course prior to this course.
outline.
Kimball Approach Overview
- Introduction to the Kimball Approach
- Focus on the business
- The Kimball Lifecycle
Gather Business Requirements
- Program planning and management
- Gather requirements from the user community
- Gain consensus on priorities
- Document the business requirements
Dimensional Modeling Fundamentals
- The dimensional modeling process: the Kimball Approach
- A brief introduction to dimensional modeling: dimensions and facts
- Conformed dimensions
Create the Technical Architecture
- Alternative technical architectures
- The Kimball architecture
- Implications of cloud architecture
- The role of Big Data
Develop the DW Database
- Develop the physical model
- Plan the storage
- Keys and when to declare them
- Performance aggregations and OLAP
Create the ETL System
- Overview
- Plan
- Extract
- Clean and conform the data
- Deliver dimension and fact tables
- Manage the ETL process
Build the BI Applications
- BI applications are the face of the data warehouse
- Types of BI applications
Deploy, Operate and Grow
- Technical deployment
- Get ready for release: documentation, training and user acceptance
- Plan for automated operations
instructor.
Joy Mundy
This course gives you the opportunity to learn directly from Joy Mundy. She co-authored, with Ralph Kimball and other members of Kimball Group, many of the popular “Toolkit” books including The Data Warehouse Lifecycle Toolkit (Second Edition), The Microsoft Data Warehouse Toolkit, and The Kimball Group Reader (Second Edition). Joy teaches the full course portfolio, previously taught by Kimball University for one simple reason: the methodology proves its value over and over in practice.
Joy Mundy has worked with business managers and IT professionals to prioritize, justify and implement large-scale business intelligence and data warehousing systems since 1992. She leverages these consulting experiences when teaching DW/BI courses.
Joy began her career as a financial analyst, but soon decided that she enjoyed working with a wide variety of data. She learned the fundamentals of data warehousing by building a system at Stanford University, and then started a data warehouse consultancy in 1994. She worked at WebTV and Microsoft’s SQL Server product development team for a few years before returning to consulting with Kimball Group in 2004, until Kimball Group’s dissolution in 2016. Joy is now semi-retired, but loves teaching and the occasional consulting engagement. She graduated from Tufts University with a BS in Economics, and from Stanford University with an MS in Engineering-Economic Systems.
dates & price.
This course is offered exclusively as Customer Specific Training, whereby we can deliver private courses - on-site or virtually - at a time that works best for you, with content tailored to your team’s specific learning needs.
Need more information?
Simply leave your details in our contact form, and a member of our team will be in touch shortly to discuss your requirements.
Related Content
Dimensional Modeling: The Kimball Approach
Don't miss the opportunity to learn directly from Joy Mundy, co-author with Ralph Kimball and other members of Kimball Group, of many of the popular “Toolkit” books. Learn techniques for developing your dimensional model, from the basics to the most advanced practices.
