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:
And about vertipaq:https://www.youtube.com/watch?v=b8oSgTOeYCE
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 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: https://curbal.com/donwload-center
SUBSCRIBE to learn more about Power and Excel BI!
- Join our DAX Fridays! Series: https://goo.gl/FtUWUX
- Power BI dashboards for beginners: https://goo.gl/9YzyDP
- Power BI Tips & Tricks: https://goo.gl/H6kUbP
- Power Bi and Google Analytics: https://goo.gl/ZNsY8l
Contact us: http://www.curbal.com/contact
If you feel that any of the videos, downloads, blog posts that I have created have been useful to you and you want to help me keep on going, here you can do a small donation to support my work and keep the channel running:
Many thanks in advance!
QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
► Linkedin: https://goo.gl/3VW6Ky
► Twitter: @curbalen, @ruthpozuelo
► Google +: https://goo.gl/rvIBDP
► Facebook: https://goo.gl/bME2sB
#POWERBITIPS #CURBAL #POWERBI #MVP