Designing a Data Warehouse

Learn how to design a Data Warehouse with the Kimball Approach

This data warehouse design training course is aimed at data warehouse and business intelligence designers, implementers and managers, but will also serve as a good basis for business and data analysts who will be involved in working with data warehouses and business intelligence deployments. All individuals who will be involved in some element of working with a data warehouse will benefit from gaining an understanding of the Kimball dimension modelling concepts that influence the final design of a data warehouse.

Develop Data Warehouse Design Skills

There are many considerations when undertaking the design of a data warehouse to support your enterprise Business Intelligence solutions and equipping your data warehouse design team with the necessary skills will help to ensure that you architect your Data Warehouse for future growth and scalability, as well as achieving all of your data analytics needs through a robust design and optimal performance.

You will learn to:

• Introduction to Data Warehousing, Business Intelligence & Dimension Modelling

• Basic terminology and concepts of a Kimball based Data Warehouse architecture.

• Kimball Dimensional Modelling Techniques

• Transactional Fact Tables, Factless Fact Tables

• Periodic Snapshot & Accumulating Fact Tables

• Enterprise Bus Architecture & Matrix

• Slowly Changing Dimensions

• Role Play, Junk, Currency & Audit Dimensions

• Chart of Accounts, Calendar & Recursive Hierarchy Dimensions

• Data Warehouse Lifecycle, Modelling Processes & ETL/ELT Techniques

This Designing a Data Warehouse Course is relevant to all Data Warehouse platforms.

Case studies are used throughout to demonstrate the concepts taught and to introduce the need for some of the more advanced modelling techniques such as Factless Tables, Enterprise Data Warehouse Bus Architecture, handling Slowly Changing Dimensions and Snapshots, Bridge Tables, Recursive Hierarchies.

Data Warehouse Design Training, Tailored to Your Needs

This Data Warehouse Design training is offered in a UK based face to face classroom or virtual setting and can be tailored to your needs. Having difficulty with something specific? Let us know and we can focus your training to make sure you learn everything you need to push your Data Warehouse solution forwards.

Follow our Learning Path for Data Warehousing

You may wish to consider some follow-on workshops working in your own environment and looking at how your new skills can be applied with your own challenging data sources. Have a look at our blended learning options.

To complement the Kimball approach to data warehouse design you may also be interested to find out more about a Medallion Architecture approach to managing and storing data from raw source to transformed start schema.

Medallion Architecture Deployment in Microsoft Fabric

To help with gaining an awareness of the importance of data warehouse design across the business you may wish to consider the following course from our "Understanding" series:

Understanding Data Warehouse Design

Delegates should have an understanding of relational database design and be familiar with a database management system such as SQL Server, Azure SQL, Azure Synpase, Oracle, Snowflake.