Interface overview (Report, Data, Model views) in Power BI - Real Business Scenario

Scenario Mode

👤 Your Role: You are a new Power BI user learning to create reports.

📋 Request: Your manager wants you to understand how to navigate the Power BI interface, especially the Report, Data, and Model views, so you can build reports efficiently.

📊 Data: You have a simple sales dataset with columns: Date, Product, Region, Sales Amount, and Quantity.

🎯 Deliverable: Create a short guide with examples showing how to use the Report view to build visuals, the Data view to inspect data, and the Model view to see relationships.

Sample Data

Date	Product	Region	Sales Amount	Quantity
2024-01-01	Widget A	North	100	5
2024-01-02	Widget B	South	150	3
2024-01-03	Widget A	East	200	7
2024-01-04	Widget C	West	120	4
2024-01-05	Widget B	North	180	6
2024-01-06	Widget C	South	130	5
2024-01-07	Widget A	East	170	8
2024-01-08	Widget B	West	160	4

1

Step 1: Open Power BI Desktop and load the sample sales data.

Use 'Get Data' > 'Excel' or 'CSV' to import the data table.

Expected Result

Data appears in the Data view with all columns visible.

2

Step 2: Switch to the Data view by clicking the Data icon on the left pane.

No formula needed; just click the Data view icon.

Expected Result

You see the table with rows and columns of your sales data.

3

Step 3: Switch to the Model view by clicking the Model icon on the left pane.

No formula needed; just click the Model view icon.

Expected Result

You see the table(s) as boxes and any relationships between them (none yet).

4

Step 4: Switch to the Report view by clicking the Report icon on the left pane.

No formula needed; just click the Report view icon.

Expected Result

You see a blank canvas to create visuals.

5

Step 5: Create a simple bar chart showing total Sales Amount by Region.

In Report view, drag 'Region' to Axis and 'Sales Amount' to Values in the Visualizations pane.

Expected Result

A bar chart appears showing sales totals for North, South, East, and West.

6

Step 6: Use the Data view to check the raw numbers behind the chart.

Switch to Data view and look at the Sales Amount column grouped by Region.

Expected Result

You see the sales amounts for each region matching the bar chart.

7

Step 7: Use the Model view to understand how tables relate (if you had multiple tables).

In Model view, observe table connections or create relationships if needed.

Expected Result

You understand how data tables connect to support your reports.

Final Result

Report View

↓

Data View

↓

Model View

✓Report view is where you build and see visuals like charts.

✓Data view lets you inspect the actual data in tables.

✓Model view shows how tables connect, helping you understand data structure.

Bonus Challenge

Add a new table with product categories and create a relationship to the sales data in Model view. Then update the report to show sales by product category.

Show Hint

Use 'Enter Data' to create a small product category table, then drag to create a relationship in Model view. Use the new category field in your visuals.

Practice

1. Which Power BI view is primarily used to create visuals and reports?

easy

A. Query View

B. Data View

C. Model View

D. Report View

Solution

1. Step 1: Understand the purpose of Report View

   Report View is designed for creating visuals and reports in Power BI.

2. Step 2: Compare with other views

   Data View is for managing data tables, Model View is for managing relationships, and Query View does not exist as a main view.

3. Final Answer:

   Report View -> Option D

4. Quick Check:

   Report View = Create visuals and reports [OK]

Hint: Report View = visuals and reports creation [OK]

Common Mistakes:

• Confusing Data View with Report View
• Thinking Model View is for visuals
• Selecting a non-existent Query View

2. Which of the following is the correct way to switch to Data View in Power BI?

easy

A. Click the table icon on the left pane

B. Click the chart icon on the left pane

C. Click the relationship icon on the left pane

D. Click the gear icon on the top menu

Solution

1. Step 1: Identify the icon for Data View

   Data View is accessed by clicking the table icon on the left pane in Power BI.

2. Step 2: Verify other icons

   The chart icon is for Report View, the relationship icon is for Model View, and the gear icon is for settings, not views.

3. Final Answer:

   Click the table icon on the left pane -> Option A

4. Quick Check:

   Table icon = Data View [OK]

Hint: Table icon = Data View [OK]

Common Mistakes:

• Clicking chart icon instead of table icon
• Confusing relationship icon with Data View
• Looking for Data View in settings

3. In Model View, you create a relationship between two tables. What is the main effect of this action?

medium

A. It allows filtering data across related tables

B. It changes the data values in the tables

C. It creates a new visual report automatically

D. It deletes duplicate rows from tables

Solution

1. Step 1: Understand the purpose of relationships in Model View

   Relationships connect tables to allow data filtering and aggregation across them.

2. Step 2: Eliminate incorrect effects

   Relationships do not change data values, create visuals, or delete rows.

3. Final Answer:

   It allows filtering data across related tables -> Option A

4. Quick Check:

   Relationships enable cross-table filtering [OK]

Hint: Relationships enable filtering between tables [OK]

Common Mistakes:

• Thinking relationships change data values
• Expecting automatic visual creation
• Confusing relationships with data cleaning

4. You tried to create a relationship in Model View but it failed. Which of these is a likely cause?

medium

A. The Data View is empty

B. You are in Report View instead of Model View

C. The tables have no common columns with matching data

D. You have too many visuals on the report page

Solution

1. Step 1: Check relationship requirements

   Relationships require common columns with matching data types and values.

2. Step 2: Evaluate other options

   Being in Report View or having many visuals does not prevent creating relationships; empty Data View means no data but not necessarily failure cause.

3. Final Answer:

   The tables have no common columns with matching data -> Option C

4. Quick Check:

   Common columns needed for relationships [OK]

Hint: Relationships need matching columns in tables [OK]

Common Mistakes:

• Trying to create relationships in wrong view
• Blaming visuals for relationship errors
• Ignoring data type mismatches

5. You want to create a report showing sales by product category and also filter by customer region. Which Power BI views will you use to prepare and build this report?

hard

A. Report View only, because it handles all tasks

B. Data View to check data, Model View to create relationships, Report View to build visuals

C. Model View only, because relationships create visuals

D. Data View only, because it shows all data

Solution

1. Step 1: Prepare data in Data View

   Check and clean data tables for sales, products, and customers in Data View.

2. Step 2: Create relationships in Model View

   Set relationships between product and customer tables to enable filtering by region.

3. Step 3: Build report visuals in Report View

   Use Report View to create charts showing sales by product category and apply filters.

4. Final Answer:

   Data View to check data, Model View to create relationships, Report View to build visuals -> Option B

5. Quick Check:

   Use all three views for data prep, modeling, and reporting [OK]

Hint: Use Data, Model, and Report views together [OK]

Common Mistakes:

• Using only Report View for all tasks
• Ignoring relationships in Model View
• Skipping data checks in Data View