Summary  
This chapter covers relational data modeling patterns—star, snowflake, and spaghetti schemas—emphasizing how clear one-to-many table relationships in a star schema ensure predictable filter flow and reliable measure calculations.  

General domain of usage  
Business intelligence and data warehousing

### Star Schema
One central fact table connected directly to dimension tables. Clear, predictable filter flow. Works reliably with DAX and Power Pivot.

The star schema is not Excel-specific. If you work with a data engineer, a BI developer, or a SQL analyst, this is the structure they will be most familiar with. Building it in Excel puts your model on the same conceptual footing as professional data tools.

Note

### Snowflake Schema
Dimension tables broken into sub-tables forming chains. More normalized but DAX measures do not work reliably in Power Pivot.

A snowflake schema starts with a star schema and then breaks dimension tables down further into sub-tables. For example, instead of a single Customers table containing city and region, the city data lives in a Cities table and region data in a Regions table — forming a chain: Customers → Cities → Regions.

### Spaghetti Model
No clear structure. Tables connected in multiple directions. Filters take ambiguous paths and produce wrong numbers silently.

Tables are connected in multiple directions — dimension tables link to each other, fact tables connect through shared dimension tables, and the diagram view resembles tangled lines rather than a recognisable shape.

Silent wrong numbers are the most dangerous outcome in any model. A visible error prompts investigation. A plausible-looking wrong number may go unnoticed and lead to bad business decisions.

In a star schema, which of the following correctly describes the direction of relationships?

Learn how to turn raw Excel data into a connected data model with Power Pivot, DAX measures, and an interactive dashboard that updates automatically. Starting from a flat table, you will build relationships between multiple tables, write calculated metrics, and deliver a polished, reusable report — all inside Excel.
Suitable for Excel users with basic experience who want to move beyond flat-sheet reporting.

An introduction to what data modeling is, why it matters, and what you will build throughout the course. You will meet the Nordic Bikes project and see the finished dashboard before writing a single formula.

Before building a model, your data needs the right structure. This section covers how to split flat data into clean, purpose-built tables with proper keys, consistent formatting, and clear separation between facts and dimensions.

The core technical section of the course. You will enable Power Pivot, load your tables into the data model, connect them with relationships, and learn how to spot and fix the problems that break a model silently.

Learn to write calculations that go far beyond what Excel formulas can do alone. From basic KPI measures to time intelligence functions, this section builds the analytical layer that powers your reporting.

Turn your model into a finished product. You will build pivot tables that answer real business questions, convert them into charts, and assemble everything into an interactive dashboard controlled by shared slicers.

A structured review of what makes a model reliable, clear, and ready to hand over. The section closes with a capstone project where you apply every skill from the course end to end.

Star Schema Patterns for Excel Users

Star Schema

Snowflake Schema

Spaghetti Model