Forum Discussion

Willow0136's avatar
Willow0136
Frequent Visitor
2 years ago
Solved

Column naming conventions for dim tables

Hi everyone,

 

I'm looking to define conventions for our team and this one I'm unsure about and unable to find much info.

Imagine I have the following dim tables in my PBI dataset:

  • Customer
  • Location
  • Device

In each of these tables, there are columns:

  • Code
  • Name
  • Description


Is it generally better to fully define each field name, e.g. `Customer[Customer Code]`, `Location[Location Name]`, or keep them simple and without repetition, e.g. `Customer[Code]`?
My opinion on using longer names:

  • - Introduces repetition
  • + May make it easier to search (if you search for `Customer Code` and the field is `Customer[Code]`, it will currently not show up)

Because of the latter, I'm leaning into longer names at the moment.

1 Reply