Understanding Tables, Relationships and Data Modeling in Powerpivot

One of the common questions that anyone using Powerpivot has is. How should I model my Data in Powerpivot? and it's not rocket science. it's easy to learn and hopefully you'll understand more about it after you finish reading this post.

If you are new to Powerpivot and new to database modeling then the diagram above makes little to no sense but just think about them as lookup tables that you'll later be doing some VLOOKUPS, MATCH/INDEX and all those formulas that we, as excel users, know about.

Let's learn more about the what you should consider when building your Data Model!