Summary  
This chapter covers constructing a relational data model by normalizing raw data into separate tables, defining relationships in Power Pivot, and preparing to write DAX measures to drive pivot tables and charts.  

General domain of usage  
Business intelligence for sales analytics

Nordic Bikes is a fictitious company selling bikes and accessories across multiple regions and customer segments. They have data — but no structured way to answer the questions that actually matter to management. That is the problem this course solves.

Business questions to answer:
- Which region and product category leads on revenue?

- Which customer segment places the most orders, and at what average order value?

- Is revenue growing month on month?

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.

The Project Overview