skip to main content
Language:
Search Limited to: Search Limited to: Resource type Show Results with: Show Results with: Index

Power Pivot and Power BI : the Excel user's guide to DAX Power Query, Power BI & Power Pivot in Excel 2010-2016

Rob Collie author. Avi Singh author.

2nd ed.. 2016

Online access

  • Title:
    Power Pivot and Power BI : the Excel user's guide to DAX Power Query, Power BI & Power Pivot in Excel 2010-2016
  • Author: Rob Collie author.
  • Avi Singh author.
  • Description: 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
  • Publication Date: 2016
  • Publisher: Merritt Island, FL : Holy Macro! Books
  • Format: 1 online resource (334 p.).
  • Identifier: ISBN 1-61547-226-6
  • Subjects: Business intelligence -- Computer programs; Information visualization -- Computer programs; Business -- Data processing; Visual analytics; Microsoft Excel (Computer file); Microsoft PowerPivot (Computer file); Electronic books
  • Language: English
  • Source: 01DAL UDM ALMA

Searching Remote Databases, Please Wait