Best Practices for Power BI modelling

Ok, time for another Power Bi video and this time we are going to talk about Power BI naming conventions and other power bi modelling tips.
First we will talk about what to remove or hide from your model like:
Do not expose in a view a column that is not necessary in the Power BI data model.
TIP: use radacad power bi helper to find out which things are not being used in the model:radacad.com/power-bi-helper
More info about naming conventions here:
docs.microsoft.com/en-us/sql/...
And about vertipaq: • What is Vertipaq and h...
Now for the best practices here are some:
Use names that are well-known for the business
It is a best practice to rename all the columns in the views, using exactly the names you will expose in the user interface of Power BI.
You should avoid renaming tables and columns in a Power BI data model.
Try to use single word names on tables if possible.
And when it comes to naming conventions, take these into account:
Avoid all caps (SALESTERRITORY)
Pascal casing (SalesTerritory)
Camel casing (salesTerritory)
Use words separated by space (Sales Territory)
You should remove any prefix and any suffix you might use in table names.
Avoid acronyms
Avoid abbreviations, use complete name when possible. If acronyms/abbreviations are used, they are always used in the same way.
What are your best Power BI modelling tips? Let us know in the comments box!
Looking for a download file? Go to our Download Center: curbal.com/donwload-center
SUBSCRIBE to learn more about Power and Excel BI!
/ @curbalen
Our PLAYLISTS:
- Join our DAX Fridays! Series: goo.gl/FtUWUX
- Power BI dashboards for beginners: goo.gl/9YzyDP
- Power BI Tips & Tricks: goo.gl/H6kUbP
- Power Bi and Google Analytics: goo.gl/ZNsY8l
ABOUT CURBAL:
Website: www.curbal.com
Contact us: www.curbal.com/contact
************
************
QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
► Linkedin: goo.gl/3VW6Ky
► Twitter: @curbalen, @ruthpozuelo
► Google +: goo.gl/rvIBDP
► Facebook: goo.gl/bME2sB
#POWERBITIPS #CURBAL #POWERBI #MVP