From the course: Excel Business Intelligence: Data Modeling 101

Unlock this course with a free trial

Join today to access over 22,600 courses taught by industry experts.

Data model best practices

Data model best practices - Microsoft Excel Tutorial

From the course: Excel Business Intelligence: Data Modeling 101

Start my 1-month free trial Buy for my team

Data model best practices

“

- [Instructor] Alright, so you've officially made it to the end of the data modeling 101 section, nice work, congratulations, we are just starting to cruise now and the best is yet to come. So stay tuned. Now as usual, let's finish this section with my favorite best practices. Number one, always normalize your data model before you do anything else, that means that you should have each table with a single, distinct purpose, you should have foreign keys in your data table, primary keys in your lookup tables, and more importantly, you should know this data model like the back of your hand, that's going to be really important once you start to actually analyze that data with Power Pivot and DAX. Also try to use relationships as much as possible, versus merged tables, generally speaking long and narrow tables are better than short, wide merged tables. Next best practice, organize your lookup tables above the data tables in the diagram view. Now functionally speaking, this doesn't really…

Contents