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: MrExcel's Holy Macro! Books, Rob Collie and Avichal Singh

Paid access

|Oct 2024

E-Book €10.99Institutions €105.95

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.

A Revolution Built On YOU
Power Pivot and the Power BI Family: Making Sense of the Various Versions
Learning Power Pivot "The Excel Way"
Loading Data Into Power Pivot
Intro to Calculated Columns
Introduction to DAX Measures
The "Golden Rules" of DAX Measures
CALCULATE() – Your New Favorite Function
ALL() – The "Remove a Filter" Function
Thinking in Multiple Tables
"Intermission" – Taking Stock of Your New Powers
Disconnected Tables
Introducing the FILTER() Function, and Disconnected Tables Continued
Introduction to Time Intelligence
IF(), SWITCH(), BLANK(), and Other Conditional Fun
SUMX() and Other X ("Iterator") Functions
Multiple Data Tables
Multiple Data Tables – Differing Granularity
Performance: Keep Things Running Fast
Power Query to the Rescue
Power BI Desktop
"Complicated" Relationships
Row and Filter Context Demystified
CALCULATE and FILTER – More Nuances
Time Intelligence with Custom Calendars: Greatest Formula in the World
Advanced Calculated Columns
New DAX Functions… and Variables!
"YouTube for Data" – The Importance of a Server

PDF ISBN: 978-1-83664-472-9

Publisher: Packt Publishing Limited

Publication date: 2024

Language: English

Pages: 321

Related subjects:

Computer sciences,

Computer sciences, other

Power Pivot and Power BI

Key Features

Book Description

What you will learn

Who this book is for

Table of Contents

People also read

Publications carousel

Power BI for the Excel Analyst

Supercharge Excel

Master Your Data with Power Query in Excel and Power BI

Instant Creating Data Models with PowerPivot How-to

Supercharge Power BI

Learn Power BI

Mastering Power BI - 2nd Edition

Learn Power BI

Your Excel Survival Kit

Microsoft Power BI Cookbook

Paradigm

My account