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
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….
Star Schema vs Snowflake Schema
The Star and Snowflake schemas are two types of Dimensional modelling techniques used in Data Warehousing to organize and structure data for efficient querying and analysis. How do Star and Snowflake schemas differ, and which do we recommend? Read on to find out. Overview Below is the model for a Sales Fact Star Schema vs….