(BI) Designing a Data Warehouse Training Course

Main Topics for this Designing a Data Warehouse Training Course

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.

This 3 day 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 dimension modelling concepts that influence the final design of a data warehouse.

Delegates will be introduced to the basic terminology and concepts of a Kimball based Data Warehouse architecture. The course covers Dimension Modelling Techniques introducing the basics of Fact Tables, Dimension Tables, Dimension Hierarchies and more.

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.

This introductory Understanding Data Warehouse Design training course is offered in a face to face classroom or virtual setting and can be tailored to your needs.

You will learn to:

• Introduction to Data Warehousing, Business Intelligence & Dimension Modelling
• 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.

What Next?

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 .