Skip to Main Content
Getting Great Results with Excel Pivot Tables, PowerQuery and PowerPivot
book

Getting Great Results with Excel Pivot Tables, PowerQuery and PowerPivot

by Thomas Fragale
May 2024
Beginner to intermediate content levelBeginner to intermediate
304 pages
7h 43m
English
Wiley
Content preview from Getting Great Results with Excel Pivot Tables, PowerQuery and PowerPivot

CHAPTER 8Improving a Pivot Table with Power Pivot

In the previous chapter, you learned to make pivot tables from more than one table using the data model. There's a lot more you can do with the data model. In this chapter, we will go further with the data model using Power Pivot.

Power Pivot is a set of tools designed to take your pivot tables and your data to the next level. With Power Pivot, you can create formulas in the powerful Data Analysis Expressions (DAX) language to further support and analyze the tables within the data model. Power Pivot can also create pivot tables from very large databases, much larger than what a regular Excel spreadsheet can handle. Power Pivot will allow you to pull data from multiple sources into the data model and then join the tables from different sources together to make pivot tables and pivot charts. Power Pivot also has a feature called a key performance indicator (KPI), which adds a visual element to a pivot table. Power Pivot can analyze your data in many more ways, but, for the purpose of this book, I will show how Power Pivot can be used to support pivot tables. This chapter will show you how to activate the Power Pivot add‐in and how to use some of the Power Pivot features.

A picture depicts Q R code.
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Microsoft Excel Pivot Table Data Crunching Including Dynamic Arrays, Power Query, and Copilot

Microsoft Excel Pivot Table Data Crunching Including Dynamic Arrays, Power Query, and Copilot

Bill Jelen

Publisher Resources

ISBN: 9781394243051Purchase Link