DAX formulas for PowerPivot : the Excel pro's guide to mastering DAX / Rob Collie.

Format:

Book

Author/Creator:

Collie, Rob.

Language:

English

Subjects (All):

Business intelligence--Computer programs.

Business intelligence.

Microsoft PowerPivot (Computer file).

Microsoft Excel (Computer file).

Physical Description:

1 online resource (255 p.)

Edition:

1st ed.

Place of Publication:

Uniontown, OH : Holy Macro! Books, c2013.

Language Note:

English

Summary:

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 Pivot: 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.

Contents:

Intro

_GoBack

Preface/Forward/Intro

First Chapter

Copyright page

Index

Acknowledgements

Supporting Workbooks and Data Sets

A Note on Hyperlinks

Introduction

1- A Revolution Built on YOU

2- What Version of PowerPivot Should You Use?

3- Learning PowerPivot "The Excel Way"

4- Loading Data Into PowerPivot

5- Intro to Calculated Columns

6- Introduction to DAX Measures

7- The "Golden Rules" of DAX Measures

8- CALCULATE() - Your New Favorite Function

9- ALL() - The "Remove a Filter" Function

10- Thinking in Multiple Tables

11- "Intermission" - Taking Stock of Your New Powers

12- Disconnected Tables

13- Introducing the FILTER() Function, and Disconnected Tables Continued

14- Introduction to Time Intelligence

15- IF(), SWITCH(), BLANK(), and Other Conditional Fun

16- SUMX() and Other X ("Iterator") Functions

17- Multiple Data Tables

18- Time Intelligence with Custom Calendars: Advanced Use of FILTER()

19- Performance: How to keep things running fast.

20- Advanced Calculated Columns

21- The Final Transformation: One Click That Will Change Your Life Forever

A1- Further Proof That the Game is Changing

A2- So Much Power, So Little Space: Further Capabilities

A3- Four Common Error Messages

A4- People: The Most Powerful Feature of PowerPivot

Index.

Notes:

Includes index.

ISBN:

1-61547-112-X

1-61547-212-6

OCLC:

847588649