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.