Opening book details…
Can I read Power Pivot and Power BI: The Excel User's Guide to the Data Revolution on EtoBox?
Power Pivot and Power BI: The Excel User's Guide to the Data Revolution by Rob Collie, Avichal Singh, Avichal Singh is a nonfiction available to read on EtoBox.
What is Power Pivot and Power BI: The Excel User's Guide to the Data Revolution about?
Power Pivot for Excel and its close cousin Power BI Desktop are Microsoft's tightly-related pair of revolutionary analytical tools - tools that are fundamentally changing the way organizations work with data. Covers Power Query, Power BI Desktop, PowerBI.com, Power Pivot, Excel 2016, Excel 2013, Excel 2010 Front Cover 1 Back Cover 334 Preface/Forward/Intro 16 Dedications 16 Supporting Workbooks and Data Sets 16 Errata and Book Support 16 A Note on Hyperlinks 16 Foreword and Forward 17 Introduction - Our Two Goals for this Book 19 1 - A Revolution Built On YOU 20 2 - Power Pivot and the Power BI Family: Making Sense of the Various Versions 24 4 - Loading Data Into Power Pivot 35 5 - Intro to Calculated Columns 43 6 - Introduction to DAX Measures 48 7 - The “Golden Rules” of DAX Measures 66 8 - CALCULATE() – Your New Favorite Function 76 9 - ALL() – The “Remove a Filter” Function 83 10 - Thinking in Multiple Tables 89 11 - “Intermission” – Taking Stock of Your New Powers 100 12 - Disconnected Tables 101 13 - Introducing the FILTER() Function, and Disconnected Tables Continued 110 14 - Introduction to Time Intelligence 120 15 - IF(), SWITCH(), BLANK(), and Other Conditional Fun 139 16
Who reads Power Pivot and Power BI: The Excel User's Guide to the Data Revolution?
It is typically read by self-directed learners exploring a subject in depth.
Common subject areas: history, science, philosophy, social sciences.
- Author
- Rob Collie, Avichal Singh, Avichal Singh
- Publisher
- Holy Macro! Books [Imprint] Tickling Keys, Incorporated Independent Publishers Group [distributor
- Published
- 2015
- Language
- EN
- ISBN
- 9781615470396
- Category
- nonfiction
- Subjects
- Science, Business, Management
- Rating
- 4.7 / 5 (46 ratings)
- Updated
- 2026-03-14
Other editions & translations
- Power Pivot and Power BI : The Excel User's Guide to DAX, Power Query, Power BI & Power Pivot in Excel 2010-2016 (2015)
- Power Pivot and Power BI: The Excel User's Guide to DAX, Power Query, Power BI and Power Pivot in Excel 2010-2016 (2016)
- Power Pivot and Power BI: The Excel User's Guide to the Data Revolution (2016)
- Power Pivot and Power BI : The Excel User's Guide to DAX, Power Query, Power BI & Power Pivot in Excel 2010-2016 (2016)
- Power Pivot and Power BI: The Excel User's Guide to DAX, Power Query, Power BI and Power Pivot in Excel 2010-2016 (2017)
More by Rob Collie, Avichal Singh, Avichal Singh
Browse all works by Rob Collie, Avichal Singh, Avichal Singh
Similar books
- Power Pivot and Power BI : The Excel User's Guide to DAX, Power Query, Power BI & Power Pivot in Excel 2010-2016 — Rob Collie; Avichal Singh (2015)
- Analyzing Data with Power BI and Power Pivot for Excel (Business Skills) — Alberto Ferrari and Marco Russo (2017)
- Beginning Power BI : A Practical Guide to Self-Service Data Analytics with Excel 2016 and Power BI Desktop — Dan Clark (auth.) (2017)
- Learn to Write Dax: A Practical Guide to Learning Power Pivot for Excel and Power Bi : A Practical Guide to Learning Power Pivot for Excel and Power Bi — Matt Allington (2016)
- Dashboarding and Reporting with Power Pivot and Excel : How to Design and Create a Financial Dashboard with Power Pivot - End to End — Kasper de Jonge (2014)
- Excel Pivot Tables: Basic Beginners Guide to Learn Excel Pivot Tables for Data Analysis and Modeling — MARTIN, M G (2021)