Naming conventions in Power BI - Real Business Scenario

Scenario Mode

👤 Your Role: You are a business intelligence analyst at a retail company.

📋 Request: Your manager wants you to create a clear and easy-to-understand Power BI report. They ask you to follow good naming conventions for all tables, columns, and measures so that anyone can easily read and maintain the report.

📊 Data: You have sales data with columns for Date, Region, Product, Sales Amount, and Quantity Sold.

🎯 Deliverable: A Power BI report with properly named tables, columns, and measures following best naming conventions.

Sample Data

Date	Region	Product	Sales Amount	Quantity Sold
2024-01-01	North	Apples	100	10
2024-01-02	South	Bananas	150	15
2024-01-03	East	Oranges	120	12
2024-01-04	West	Apples	130	13
2024-01-05	North	Bananas	140	14
2024-01-06	South	Oranges	110	11
2024-01-07	East	Apples	160	16
2024-01-08	West	Bananas	170	17

1

Step 1: Rename the sales data table to a clear and descriptive name.

Rename table to 'SalesData'.

Expected Result

Table name changed to 'SalesData'.

2

Step 2: Rename columns to use PascalCase and clear names without spaces.

Rename columns: Date -> 'SaleDate', Region -> 'Region', Product -> 'ProductName', Sales Amount -> 'SalesAmount', Quantity Sold -> 'QuantitySold'.

Expected Result

Columns renamed to 'SaleDate', 'Region', 'ProductName', 'SalesAmount', 'QuantitySold'.

3

Step 3: Create a measure for total sales amount with a clear and consistent name.

Create measure: TotalSalesAmount = SUM(SalesData[SalesAmount])

Expected Result

Measure 'TotalSalesAmount' created showing sum of sales amounts.

4

Step 4: Create a measure for total quantity sold with a clear and consistent name.

Create measure: TotalQuantitySold = SUM(SalesData[QuantitySold])

Expected Result

Measure 'TotalQuantitySold' created showing sum of quantities sold.

5

Step 5: Use the renamed table, columns, and measures in a simple report visual.

Create a table visual with columns: SalesData[Region], SalesData[ProductName], and measures TotalSalesAmount, TotalQuantitySold.

Expected Result

Report visual shows sales by region and product with total sales and quantity.

Final Result

---------------------------------------------
| Region | ProductName | TotalSalesAmount | TotalQuantitySold |
|--------|-------------|------------------|-------------------|
| North  | Apples      | 100              | 10                |
| North  | Bananas     | 140              | 14                |
| South  | Bananas     | 150              | 15                |
| South  | Oranges     | 110              | 11                |
| East   | Oranges     | 120              | 12                |
| East   | Apples      | 160              | 16                |
| West   | Apples      | 130              | 13                |
| West   | Bananas     | 170              | 17                |
---------------------------------------------

✓Using clear and consistent naming makes the report easy to read and maintain.

✓Total sales and quantity measures provide quick insights into performance by region and product.

✓Renaming columns to PascalCase without spaces helps avoid errors and improves clarity.

Bonus Challenge

Create a naming convention document that explains your naming rules for tables, columns, and measures.

Show Hint

Include rules like using PascalCase, no spaces, descriptive names, and prefixes for measures (e.g., 'Total' for sums).