Power Pivot and Power BI : the Excel user's guide to DAX Power Query, Power BI & Power Pivot in Excel 2010-2016 / by Rob Collie & Avi Singh.

Format:

Book

Author/Creator:

Collie, Rob, author.

Singh, Avi, author.

Language:

English

Subjects (All):

Microsoft Excel (Computer file).

Microsoft PowerPivot (Computer file).

Business intelligence--Computer programs.

Business intelligence.

Information visualization--Computer programs.

Information visualization.

Business--Data processing.

Business.

Visual analytics.

Physical Description:

1 online resource (334 p.)

Edition:

2nd ed.

Place of Publication:

Merritt Island, FL : Holy Macro! Books, [2016]

Summary:

Unlock the power of data analysis with Excel Power Pivot and Power BI.This guide provides Excel users with step-by-step instructions for leveraging DAX, Power Query, and Power BI to produce reports and analyses previously impossible.Learn to transform data into actionable insights, creating solutions in hours that once took weeks.

Contents:

Front Cover; Back Cover; Preface/Forward/Intro; Dedications; Supporting Workbooks and Data Sets; Errata and Book Support; A Note on Hyperlinks; Foreword and Forward; Introduction - Our Two Goals for this Book; 1 - A Revolution Built On YOU; 2 - Power Pivot and the Power BI Family: Making Sense of the Various Versions; 4 - Loading Data Into Power Pivot; 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 Powers12 - 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 - Multiple Data Tables - Differing Granularity; 19 - Performance: Keep Things Running Fast; 20 - Power Query to the Rescue; 21 - Power BI Desktop; 22 - "Complicated" Relationships; 23 - Row and Filter Context Demystified; 24 - CALCULATE and FILTER - More Nuances

Foreword and Forward"State of the Union" November 2015 - What's Changed?; What Has Changed at Microsoft? Virtually Everything.; What's Changed in My Corner of the World? Also Everything.; Introduction - Our Two Goals for this Book; 1 - A Revolution Built On YOU; Does This Sound Familiar?; Excel Pros: The World Is Changing in Your Favor; Our Importance Today; Excel at the Core; Three Ingredients of Revolution; Ingredient One: Explosion of Data; Ingredient Two: Economic Pressure; Ingredient Three: Dramatically Better Tools

2 - Power Pivot and the Power BI Family: Making Sense of the Various VersionsIt's a Family of Products Built on Shared Engines; Power Query is a Close Second in Importance; Visuals: The Crucial "Last Mile"; Power BI Desktop: Two Tools for the (Learning) Price of One!; Same Engines, Just Different Visuals; What do we mean by the "tough" or "valuable" stuff?; Power Pivot (in Excel) Versions; Power Pivot for Excel 2010; Power Pivot for Excel 2013 - Only Available in "Pro Plus" Excel; Differences in User Interface: 2010, 2013, 2016; When We Said "Cosmetic" We Meant "Awkward"; 32-bit or 64-bit?

Office 2010 or Newer is Required

Notes:

Includes index.

Description based on online resource; title from PDF title page (ebrary, viewed January 13, 2016).

Description based on publisher supplied metadata and other sources.

ISBN:

1-61547-226-6

OCLC:

935256098