Skip to main content
Have a personal or library account? Click to login
Power Pivot and Power BI Cover

Power Pivot and Power BI

The Excel User's Guide to DAX, Power Query, Power BI & Power Pivot in Excel 2010-2016

Publisher:Packt Publishing Limited
By: ,   and    
Paid access
|Mar 2025
Product purchase options
Description

Unlock the power of data analysis with Power Pivot and Power BI. Master the techniques and tools to transform your data into insightful reports, dashboards, and models.

Key Features

  • Step-by-step guide to mastering Power Pivot and Power BI
  • Practical examples and real-world applications
  • Foundational to advanced techniques for effective data analysis

Book Description

Master Power Pivot and Power BI with this comprehensive guide designed to elevate your data analysis and business intelligence skills. Starting with the essentials of Power Pivot, you'll learn how to load and transform data, create calculated columns, and apply foundational DAX functions. As you advance, the book dives into more complex topics like working with multiple tables, understanding relationships, and mastering advanced DAX functions such as CALCULATE() and FILTER().

You'll also explore the powerful capabilities of Power BI Desktop and learn how to turn your data into compelling visualizations that drive impactful business decisions. With a focus on practical application, the guide includes real-world examples and exercises to reinforce each concept.

By the end of this guide, you'll have the skills to build sophisticated data models, optimize performance, and create dynamic reports and dashboards that effectively communicate insights. This guide is perfect for professionals aiming to harness the full power of Excel and Power BI in their data-driven decision-making processes.

What you will learn

  • Understand the Power Pivot and Power BI ecosystem
  • Load and prepare data effectively
  • Build and manage calculated columns
  • Master DAX measures and functions
  • Optimize data model performance
  • Leverage Power BI Desktop and advanced features

Who this book is for

Ideal for data professionals, Excel users, and business analysts, this book assumes a basic understanding of Excel but no prior knowledge of Power Pivot or Power BI. It is suitable for anyone looking to enhance their data analysis and reporting skills using these tools.

Table of Contents

  1. A Revolution Built On YOU
  2. Power Pivot and the Power BI Family: Making Sense of the Various Versions
  3. Learning Power Pivot "The Excel Way"
  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 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. 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
  25. Time Intelligence with Custom Calendars: Greatest Formula in the World
  26. Advanced Calculated Columns
  27. New DAX Functions… and Variables!
  28. "YouTube for Data" – The Importance of a Server
PDF ISBN: 978-1-83664-472-9
Publisher: Packt Publishing Limited
Copyright owner: © 2024 Packt Publishing Limited
Publication date: 2025
Language: English
Pages: 321
Related subjects:
Computer sciences,
Computer sciences, other

People also read

Book

Power BI for the Excel Analyst

MrExcel's Holy Macro! Books, Wyn Hopkins
Book

Instant Creating Data Models with PowerPivot How-to

Taehyung Lee
Book

Supercharge Excel

MrExcel's Holy Macro! Books, Matt Allington
Book

Master Your Data with Power Query in Excel and Power BI

MrExcel's Holy Macro! Books, Miguel Escobar, Ken Puls
Book

Supercharge Power BI

MrExcel's Holy Macro! Books, Matt Allington
Book

Mastering Microsoft Power BI – Second Edition

Gregory Deckler, Brett Powell, Leon Gordon
Book

Learn Power BI

Greg Deckler
Book

Learn Power BI

Greg Deckler
Book

Microsoft Power BI Quick Start Guide

Devin Knight, Gabriele Iuculano, Bradley Schacht, Bradley Schacht
Book

Data Modeling with Microsoft Excel

Bernard Obeng Boateng, Michael Olafusi, Michael Olafusi