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.
Recent Posts
Dimension Tables – An Introduction
A Dimension table is one of the 3 key elements of dimensional modeling used to build a Data Warehouse. This article will give you an in-depth understanding of various Dimension table concepts. What is a Dimension Table? Conceptually, Dimension tables are database tables modelled to represent the business entities involved in business processes and events….
What is a Fact table? (and why you need them)
In the context of a data warehouse, a fact table represents a business process or event and contains the measures and metrics you want to analyze for that process or 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…
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…