Understanding Data ModelsFollowing the Standard Excel MethodDiscovering the PowerPivot WayWhat Is a Data Model?Understanding Physical and Logical Data ModelsNormalization and DenormalizationEmpty ValuesUnderstanding How and When to Denormalize TablesThe PowerPivot Query DesignerWhen to Denormalize TablesComplex RelationshipsUnderstanding OLTP and Data MartsData Marts, Facts, and DimensionsStar SchemasQuerying the Data WarehouseDiscovering Advanced Types of RelationshipsRole-Playing RelationshipsMany-to-Many RelationshipsSummary