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 Tables11 - "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 NuancesForeword 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 Tools2 - 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