Naming conventions in Power BI - Cheat Sheet & Quick Revision

Recall & Review

beginner

Why are naming conventions important in Power BI?

Naming conventions help keep your reports organized, make it easier to understand what each item does, and help others work with your files without confusion.

beginner

What is a good practice for naming measures in Power BI?

Start measure names with a verb that describes what the measure does, like 'Total Sales' or 'Average Cost'. This makes it clear what the measure calculates.

beginner

How should you name tables in Power BI?

Use clear, simple names that describe the data, like 'Customers', 'Sales', or 'Products'. Avoid spaces or special characters to keep it clean.

intermediate

What naming style helps distinguish calculated columns from regular columns?

Use a prefix like 'Calc_' or suffix like '_Calc' for calculated columns. This helps you quickly see which columns are calculated.

beginner

Why avoid using spaces and special characters in Power BI object names?

Spaces and special characters can cause errors or make formulas harder to write and read. Using underscores or camelCase keeps names safe and easy to use.

Which of these is a good name for a measure that sums sales?

A TotalSales

B sales total

C 123Sales

D Sum-Sales

TotalSales is clear, uses no spaces or special characters, and describes the measure well.

What prefix could you use to identify a calculated column?

A Meas_

B Tbl_

C Calc_

D Dim_

Calc_ is commonly used to mark calculated columns, making them easy to spot.

Why should you avoid spaces in table names?

A They make the table names longer

B They cause errors or make formulas harder

C They look prettier

D They improve performance

Spaces can cause errors or make writing formulas more complicated.

Which naming style is best for Power BI objects?

A Use clear, simple names with no spaces

B Use random letters and numbers

C Use spaces and special characters

D Use very long descriptive sentences

Clear, simple names without spaces or special characters are best for clarity and ease of use.

What is a good way to name a measure that calculates average cost?

A cost average

B CostAvg#

C Avg Cost!

D AverageCost

AverageCost is clear, concise, and avoids spaces or special characters.

Explain why consistent naming conventions are important in Power BI projects.

Think about how clear names help you and others work faster and avoid mistakes.

Describe best practices for naming measures, tables, and calculated columns in Power BI.

Consider how each object type can be named to make its purpose obvious.

Practice

1. Why is it important to use clear and descriptive names for measures and columns in Power BI?

easy

A. It makes reports easier to understand and maintain.

B. It reduces the file size of the Power BI report.

C. It automatically improves the report's performance.

D. It hides sensitive data from users.

Solution

1. Step 1: Understand the role of naming in reports

   Clear and descriptive names help users and developers quickly understand what each measure or column represents.

2. Step 2: Recognize the impact on maintenance

   Consistent naming reduces confusion and makes updating or fixing reports easier over time.

3. Final Answer:

   It makes reports easier to understand and maintain. -> Option A

4. Quick Check:

   Clear naming = easier maintenance [OK]

Hint: Good names = easy reading and fixing [OK]

Common Mistakes:

• Thinking naming affects file size
• Assuming naming improves performance
• Believing naming hides data

2. Which of the following is the correct way to name a measure in Power BI following common naming conventions?

easy

A. TotalSales

B. mTotalSales

C. Measure_TotalSales

D. SalesTotalMeasure

Solution

1. Step 1: Identify common prefixes for measures

   Many teams use a prefix like 'm' to indicate a measure, making it easy to spot in lists.

2. Step 2: Compare options

   mTotalSales uses 'm' prefix with a clear name, which is a common and recommended practice.

3. Final Answer:

   mTotalSales -> Option B

4. Quick Check:

   Prefix 'm' = measure [OK]

Hint: Use 'm' prefix for measures to spot them fast [OK]

Common Mistakes:

• Not using any prefix for measures
• Using long or unclear prefixes
• Mixing measure and column naming styles

3. Given the following naming convention: prefix 'c' for calculated columns and 'm' for measures, what is the correct classification of cProfitMargin?

medium

A. Measure

B. Table Name

C. Calculated Column

D. Filter

Solution

1. Step 1: Analyze the prefix in the name

   The prefix 'c' indicates a calculated column according to the given convention.

2. Step 2: Confirm the rest of the name

   'ProfitMargin' is the descriptive part, so the full name 'cProfitMargin' is a calculated column.

3. Final Answer:

   Calculated Column -> Option C

4. Quick Check:

   Prefix 'c' = calculated column [OK]

Hint: Prefix 'c' means calculated column [OK]

Common Mistakes:

• Confusing 'c' prefix with measure
• Thinking it is a table name
• Assuming it is a filter

4. You see a measure named TotalSales and a calculated column named calcTotalSales. What is the main issue with these names?

medium

A. They are too long and complex.

B. The names are too short and unclear.

C. They use reserved keywords in Power BI.

D. They do not use consistent prefixes to identify their types.

Solution

1. Step 1: Check naming consistency

   The measure has no prefix, while the calculated column uses 'calc' prefix, causing inconsistency.

2. Step 2: Understand impact of inconsistency

   Inconsistent prefixes make it harder to quickly identify item types and maintain the report.

3. Final Answer:

   They do not use consistent prefixes to identify their types. -> Option D

4. Quick Check:

   Consistent prefixes = easier identification [OK]

Hint: Use consistent prefixes for all measures and columns [OK]

Common Mistakes:

• Thinking name length is the main problem
• Assuming reserved keywords are used
• Believing complexity is the issue

5. You want to create a naming convention for a Power BI project that includes tables, calculated columns, and measures. Which of the following naming schemes best follows best practices?

hard

A. tblCustomer, cCustomerAge, mTotalSales

B. CustomerTable, CustomerAgeCalc, TotalSalesMeasure

C. Customer, CustomerAge, TotalSales

D. tCustomer, calcAge, measureSales

Solution

1. Step 1: Identify prefixes for each item type

   Best practice uses clear prefixes: 'tbl' for tables, 'c' for calculated columns, 'm' for measures.

2. Step 2: Evaluate each option

   tblCustomer, cCustomerAge, mTotalSales uses these standard prefixes consistently and clearly, making it easy to identify item types.

3. Final Answer:

   tblCustomer, cCustomerAge, mTotalSales -> Option A

4. Quick Check:

   Standard prefixes = clear naming [OK]

Hint: Use 'tbl', 'c', 'm' prefixes for tables, columns, measures [OK]

Common Mistakes:

• Using inconsistent or unclear prefixes
• Not using any prefixes
• Using overly long or confusing names