Courses for careers in Data

Learn hands-on, job-ready skills to build your data career.


Data Warehousing – Fundamentals and Foundations Course

This free course is an introduction to Data Warehouse concepts. It consists of several Data Warehouse topics, explanations of key concepts, insight into experience-based best practices, real-life examples, and 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.

Data Warehouse Bus Matrix Template

Free Data Warehouse Matrix Excel Template
Data Warehouse Bus Matrix Excel template

Recent Posts

What is a Fact table (and why you need them)

In the context of a data warehouse, a fact table represents a business process/event and contains the measures and metrics you want to analyze for that business process/event. There are three types of facts corresponding to three kinds of business events. A Fact doesn’t exist in isolation. It is related to a set of Dimensions….

What is Dimensional Modeling (introduction)

Dimensional modeling is a data modeling technique used to model the presentation layer of a data warehouse. It focuses on delivering simplicity and query performance for the end user. It allows users to easily understand and navigate the data available for reporting and ad hoc analysis. A dimensional model supports high-performance aggregated queries and performs…

What is a Data Warehouse (and why you need one)

A Data Warehouse is a database that supports enterprise reporting and analysis. A well-designed data warehouse uses accepted data modelling and management techniques to provide an integrated data source that makes it easy to build reports and analyses. A data warehouse should exhibit the following four characteristics: At the heart of a data warehouse is…