All in the name of

When you’re building out your data models, take some time on naming your tables and columns. Names are important. Sometimes names have different meanings to different people across your organization.

Names of tables and columns should be in the format of simple, easy-to-understand, English names and how they’re referred to by your business users. The casing should not be all lower or all upper unless it’s an acronym.

The further back in the data stack we can set the proper naming the better off we are. It makes it easier to use the data model in multiple tools (PowerBI, Excel, etc). Doing it up front makes everything smoother, as changing names later requires re-work in multiple areas. One of those pay me now or pay me later situations. What standards do you normally follow when it comes to naming?

A Daily Email From Me

Give me a couple minutes of your day and I promise to provide thought-provoking messages to help you level up your BI knowledge and run more successful data projects.

A Daily Email From Me

Subscribe to get daily tips/ideas for how to best run a data project.

    We won't send you spam. Unsubscribe at any time.