What Is Data Model in Power BI: Simple Explanation and Example

A data model in Power BI is a structured collection of tables, relationships, and calculations that organize your data for analysis and visualization. It connects different data sources into one place, allowing you to create meaningful reports and dashboards easily.

How It Works

Think of a data model in Power BI like a well-organized filing cabinet. Each drawer is a table holding related information, such as sales, customers, or products. Instead of searching through piles of papers, you connect these drawers with labels called relationships, so you can quickly find how data points relate to each other.

This setup helps Power BI understand how to combine data from different tables when you build charts or reports. It also lets you create new insights by adding calculations, like total sales or average price, that update automatically when you filter or explore your data.

Example

This example shows how to create a simple data model with two tables and a relationship, then calculate total sales.

DAX

Sales = DATATABLE(
  "OrderID", INTEGER, "ProductID", INTEGER, "Quantity", INTEGER, "Price", CURRENCY,
  {
    {1, 101, 2, 10.0},
    {2, 102, 1, 20.0},
    {3, 101, 3, 10.0}
  }
)

Products = DATATABLE(
  "ProductID", INTEGER, "ProductName", STRING,
  {
    {101, "Pen"},
    {102, "Notebook"}
  }
)

// Create relationship: Sales[ProductID] to Products[ProductID]

Total Sales = SUMX(Sales, Sales[Quantity] * Sales[Price])

Output

Total Sales = 70.0

When to Use

Use a data model in Power BI whenever you want to analyze data from multiple sources or tables together. It helps you answer questions like "Which products sell best?" or "How do sales vary by region?" by linking data logically.

Real-world uses include sales reporting, financial analysis, customer insights, and inventory tracking. Building a good data model makes your reports faster, easier to update, and more accurate.

Key Points

• A data model organizes tables and relationships for easy data analysis.
• Relationships connect tables so you can combine data meaningfully.
• Calculated measures add dynamic insights like totals and averages.
• Good data models improve report speed and accuracy.

Key Takeaways

A data model connects tables with relationships to organize data for analysis.

Use calculated measures in the model to create dynamic insights.

Data models help combine data from multiple sources into one report.

Building a clear data model improves report performance and usability.