What do you think?
Rate this book
DAX Formulas for PowerPivot: A Simple Guide to the Excel Revolution
Microsoft’s Power Pivot is an add-on to Excel that enables you to produce new kinds of reports and analyses that were simply impossible before. This book is the first to tackle DAX formulas, the core capability of Power Pivot, from the perspective of the Excel audience. Written by a leading Power Pivot educator (and former leader on the Power Pivot and Excel teams at Microsoft), the book’s concepts and approach are introduced in a simple, step-by-step manner tailored to the learning style of Excel users everywhere.
The techniques presented allow users to produce, in hours or even minutes, results that formerly would have taken entire teams weeks or months to produce. In this book you will learn how Power
1) Gives you “portable” formulas that can be re-used across multiple different reports with a single click.
2) Removes the need to ever write a VLOOKUP formula again.
3) Allows you to add smart calculations to pivots, such as “Year over Year” and “Moving Averages” which auto-adjust as the pivot changes.
4) Effortlessly merges disjointed sets of data into unified insight.
As a bonus, Power Pivot and DAX formulas are both the heart AND brain of Microsoft’s “Power BI” system, giving us a long-needed bridge between the worlds of Excel and Business Intelligence – a bridge that any Excel PivotTable user can cross with the help of this easy-to-follow book. Your new career – and your organization’s future – starts within these pages
The techniques presented allow users to produce, in hours or even minutes, results that formerly would have taken entire teams weeks or months to produce. In this book you will learn how Power
1) Gives you “portable” formulas that can be re-used across multiple different reports with a single click.
2) Removes the need to ever write a VLOOKUP formula again.
3) Allows you to add smart calculations to pivots, such as “Year over Year” and “Moving Averages” which auto-adjust as the pivot changes.
4) Effortlessly merges disjointed sets of data into unified insight.
As a bonus, Power Pivot and DAX formulas are both the heart AND brain of Microsoft’s “Power BI” system, giving us a long-needed bridge between the worlds of Excel and Business Intelligence – a bridge that any Excel PivotTable user can cross with the help of this easy-to-follow book. Your new career – and your organization’s future – starts within these pages
- GenresAmazon
308 pages, Kindle Edition
First published December 12, 2012
26 people are currently reading
68 people want to read
Ratings & Reviews
Friends & Following
Create a free account to discover what your friends think of this book!
Community Reviews
Displaying 1 - 2 of 2 reviews
January 16, 2022
Excellent Book!!
August 7, 2016
Excelente!
Es muy claro, va directo a lo importante y lo que realmente necesitas saber.
Es lo que necesitas para empezar a usar poder pívot y sacar su mayor provecho.
Es muy claro, va directo a lo importante y lo que realmente necesitas saber.
Es lo que necesitas para empezar a usar poder pívot y sacar su mayor provecho.
Displaying 1 - 2 of 2 reviews