Power Pivot related articles
Power Pivot – 2 minute executive overview
Power Pivot causes great confusion. This simple 2-minute overview completely de-mystifies Power Pivot and its associated technologies.
Understand OLAP database design
A Power Pivot data model is an OLAP database. OLAP databases can be modeled as a Snowflake or Star schema. This article explains both designs.
Understand OLTP database design
A Power Pivot data model is an OLAP database. Business databases are OLTP databases. This article discusses how OLTP databases are structured.
Understand Primary and Foreign Keys
Tables are related to each other using primary and foreign keys. This article explains how Excel uses them in Power Pivot and Get & Transform.
Understand modern data analysis
This article describes a new way of working with Excel called “modern data analysis” enabled by the new Get & Transform and Power Pivot tools.
Use the CUBEVALUE function to query a data model
This lesson shows how to use the CUBEVALUE function to make an OLAP pivot table directly access the data model. Includes sample file.
Understand OLAP Pivot Tables
This article explains the difference between a regular Excel pivot table and the new OLAP pivot table used by Power Pivot.
Understand the Power Pivot Window
This lesson discusses the Power Pivot window and how it differs from the regular Excel window. A sample file is included.
Understand how 3D maps use the data model
3D Maps (previously called Power Maps) enables an elegant visualization of data residing in a data model.This article explains how data models are utilized.
Understand Get & Transform and ETL
Get & Transform (or Power Query) is an advanced ETL tool. ETL is an acronym for Extract, Transform and Load. This article simply explains this amazing tool.