Power Pivot Archives - TheSmartMethod.com

Publishers of the world’s most comprehensive and up-to-date Excel tutorials

Excel tutorials

The only Excel books you will ever need

The only constantly updated Excel 365 titles more…
Thoroughly covers Power Pivot and Power Query more…
Covers business intelligence and OLAP features more…
Simple, easy, understandable, 2-page lessons more…
Available as both printed books and e-Books more…
Used by schools, colleges and universities more…
Available for 365, 2021, 2019, 2016 and Mac versions more…

Category: Power Pivot

Search again:

Power Pivot - 2 Minute Executive Overview

Excel Power Pivot – 2 minute overview

Power Pivot causes great confusion. This simple 2-minute overview completely de-mystifies Power Pivot and its associated technologies.

Excel 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.

Excel OLAP pivot tables

This article explains the difference between a regular Excel pivot table and the new OLAP pivot table used by Power Pivot.

Excel Power Pivot window

This lesson discusses the Power Pivot window and how it differs from the regular Excel window. A sample file is included.

Excel data model 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.

Picture of man holding key over his head

Primary and Foreign Keys simply explained

Tables are related to each other using primary and foreign keys. This article explains how Excel uses them in Power Pivot and Get & Transform.

Excel CUBEVALUE function

This lesson shows how to use the CUBEVALUE function to make an OLAP pivot table directly access the data model. Includes sample file.

Excel 3D Maps 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.

Excel tutorials

Category: Power Pivot

Excel Power Pivot – 2 minute overview

Excel modern data analysis

Excel OLAP pivot tables

Excel Power Pivot window

Excel data model Design

Understand OLTP database design

Primary and Foreign Keys simply explained

Excel CUBEVALUE function

Excel 3D Maps data model

Categories

Recently added articles

Excel protected view warning

VLOOKUP inexact match

VLOOKUP exact match

Microsoft Office update channels

Every lesson is presented on two facing pages

Excel linear and exponential series

Excel Tutorials

Articles

Downloads

Policies

About

Which tutorial do you need?

Which Excel Essential Skills version do you need to learn?

Excel 365 for Windows

Excel 2021 for Windows

Excel 2019 for Windows

Excel 2019 for Mac

Excel 2016 for Windows

Excel 2016 for Mac