Data Courses
Learn hands-on, job-ready skills to build your data career.
Data Warehousing Course – Fundamentals and Foundations
This free course introduces fundamental concepts of data warehousing. It covers several topics, explains key concepts, provides insight into experience-based best practices, provides real-life examples, and provides practical hands-on exercises.
- What is a Data Warehouse?
- Why do you need a Data Warehouse?
- Gathering Requirements and high-level design
- Data Warehouse modelling and Star Schemas
- ETL (Extract, Transform, Load) design patterns.
- Semantic layer and OLAP concepts.
Data Warehouse Bus Matrix Excel Template
Use the Data Warehouse Bus Matrix spreadsheet to document your Data Warehouse design, estimate your project, and communicate the plan and progress to stakeholders.
“I’ve used this Bus Matrix spreadsheet on all my projects to help design, plan and estimate data warehouses and communicate the scope and progress to stakeholders.”
Recent Posts
Avoid Hash Surrogate Keys in Data Warehouse Dimensions
Background Traditionally, the Kimball methodology for data warehousing has advocated using integer surrogate keys to uniquely identify dimension records. This approach has been widely adopted due to its storage, indexing, and query performance efficiency. However, with the advent of Data Vault modeling, the use of hash keys as surrogate identifiers became popular. The rationale behind…
Data Warehouse Architecture
What is Data Warehouse Architecture Before you build a data warehouse, you must define some standards for how you and your team will design and structure your data warehouse system. A Data Warehouse Architecture describes how data is sourced, stored, processed, and accessed. The architecture can vary depending on the specific needs and scale of…
What is a Star Schema (and why it’s important)
A Star Schema is a data modelling technique used to model the presentation layer of a Data Warehouse. It refers to the way Facts and Dimensions in the model are related. A Star Schema is organized around a central fact table that is related to its Dimension tables using foreign keys in the Fact table….