How to Work on Assignments in Data Modeling (Relationships + Measures)

After cleaning your data in Power Query, the next step is Data Modeling.

Data Modeling decides how your tables connect and how your calculations work.

This step ensures your dashboards show correct and meaningful results.

1. Open the Data Model View

In Power BI:

1. Click the Model view (the icon looks like a table with relationships)

2. You will see all your tables displayed as boxes

This view shows how your data is structured.

2. Identify Fact and Dimension Tables

A good model usually has:

• 1 Fact Table

• Several Dimension Tables

This makes reporting accurate and easy.

 3. Create Relationships Between Tables

To connect tables:

• Drag the matching field from one table to the other
  (e.g., DepartmentID → DepartmentID)

This creates a relationship.

Important:
One side must be unique (Dimension).
The other side can repeat (Fact).

This is called a One-to-Many Relationship — the correct method in Power BI modeling.

4. Create Measures for Calculations

Measures are used for Totals, Averages, Counts, and Performance KPIs.

Examples:

• Total Sales

• Total Employees

• Average Rating

• Total Hours

• Total Cost

Measures are created in the Report View or Model View, not Power Query.

Rule of Thumb:

• Columns are used for filtering

• Measures are used for calculations

5. Name Your Fields Clearly

Good naming makes your dashboard easier to use.

Examples:

• “EmpName” → “Employee Name”

• “Dept_ID” → “Department ID”

• “Rev_Tot” → “Total Revenue”

Clear fields = clear dashboards.

6. Keep Only What You Need

If a column is not needed in reporting:

• Right-click → Hide in Report View

This makes your Fields panel much easier to work with.

7. Expected Output After Data Modeling

Your model should now have:

Once the model is correct, you are ready for dashboard building.