Data Model Best Practices
The data model that is created in Power Pivot or a Tabular solution is the foundation of any Microsoft business intelligence solution.
The data model consists of the data structure (including tables and their relationships, columns in the tables, and all measures created), the data itself (actual content in the table rows), and the metadata (the table/column/measure descriptions, formatting, security, etc.).
- User Friendly Data Models
- Normalization vs. Denormalization
- Data Acquisition and Visibility
- Relationships or Joins
- Data Cardinality
- One to Many Relationships
- Pivot vs Unpivot
- Many to Many Relationships
- Time Intelligence
We will modify this posting as we add new content. We will add links to the new postings and very possibly add new topics as we go. We have so much information already that we could at least put an outline around the majority of it. We look forward to sharing this information with you and helping grow the Power Pivot and tabular community. Check back often or sign up for a subscription so you don’t miss new information!