Book Image

Hands-On Business Intelligence with DAX

By : Horne
Book Image

Hands-On Business Intelligence with DAX

By: Horne

Overview of this book

Data Analysis Expressions (DAX) is known for its ability to increase efficiency by extracting new information from data that is already present in your model. With this book, you’ll learn to use DAX’s functionality and flexibility in the BI and data analytics domains. You’ll start by learning the basics of DAX, along with understanding the importance of good data models, and how to write efficient DAX formulas by using variables and formatting styles. You’ll then explore how DAX queries work with the help of examples. The book will guide you through optimizing the BI workflow by writing powerful DAX queries. Next, you’ll learn to manipulate and load data of varying complexity within Microsoft products such as Power BI, SQL Server, and Excel Power Pivot. You’ll then discover how to build and extend your data models to gain additional insights, before covering progressive DAX syntax and functions to understand complex relationships in DAX. Later, you’ll focus on important DAX functions, specifically those related to tables, date and time, filtering, and statistics. Finally, you’ll delve into advanced topics such as how the formula and storage engines work to optimize queries. By the end of this book, you’ll have gained hands-on experience in employing DAX to enhance your data models by extracting new information and gaining deeper insights.

Related Content you might be interested in

Current Title:

Small book image
Hands-On Business Intelligence with DAX
Horne
Jan, 2020 | 402 pages
Small book image
Supercharge Power BI
Bill Jelen | Matt Allington
Sep, 2024 | 292 pages
Small book image
Tabular Modeling with SQL Server 2016 Analysis Services Cookbook
Derek Wilson
Jan, 2017 | 372 pages
Small book image
Supercharge Excel
Bill Jelen | Matt Allington
Sep, 2024 | 219 pages
Table of Contents (18 chapters)
Preface
Preface
Who this book is for
What this book covers
To get the most out of this book
Get in touch
1
Section 1: Introduction to DAX for the BI Pro
Section 1: Introduction to DAX for the BI Pro
Free Chapter
2
What is DAX?
What is DAX?
Introducing DAX
Working with data types and operators
Working with calculated columns and measures
Evaluation contexts – part 1
Using the CALCULATE function
Summary
3
Using DAX Variables and Formatting
Using DAX Variables and Formatting
Getting started with DAX variables
Formatting your DAX code
Debugging errors in your DAX code
Summary
4
Building Data Models
Building Data Models
Introduction to data modeling
Data modeling concepts in DAX
Getting data into your data model
Extending your data model
It's a date
Summary
5
Working with DAX in Power BI, Excel, and SSAS
Working with DAX in Power BI, Excel, and SSAS
Working with DAX in Power BI Desktop
Working with DAX in Excel Power Pivot
Working with DAX in SSAS Tabular
Summary
6
Getting It into Context
Getting It into Context
Introducing evaluation contexts – part 2
Deep diving into row context
Deep diving into filter context
Changing context using DAX functions
Summary
7
Section 2: Understanding DAX Functions and Syntax
Section 2: Understanding DAX Functions and Syntax
8
Progressive DAX Syntax and Functions
Progressive DAX Syntax and Functions
Breaking down DAX syntax
Dealing with relationships
Looking at DAX functions
Introduction to aggregation functions
Functions for parent-child hierarchies
Summary
9
Table Functions
Table Functions
Introducing table functions
Looking at table manipulation functions
Working with table functions
Summary
10
Date, Time, and Time Intelligence Functions
Date, Time, and Time Intelligence Functions
Introduction to date and time functions
Working with date and time functions
Looking at time intelligence functions
Making your data more intelligent over time
Summary
11
Filter Functions
Filter Functions
Introduction to filter functions
Filtering your data with filter functions
Summary
12
Statistical Functions
Statistical Functions
Introducing statistical functions
Calculating averages
Working with percentiles
Ranking your data
Calculating standard deviation and variance
Summary
13
Working with DAX Patterns
Working with DAX Patterns
Introducing Power BI Quick Measures
Calculating cumulative totals
Binning data using segmentation
Comparing equivalent periods
Working with mathematical patterns
Summary
14
Section 3: Taking DAX to the Next Level
Section 3: Taking DAX to the Next Level
15
Optimizing Your Data Model
Optimizing Your Data Model
Introducing the VertiPaq engine
Understanding your data model
Simplifying your data model
Creating summary tables
Summary
16
Optimizing Your DAX Queries
Optimizing Your DAX Queries
Introduction to the DAX calculation engines
Monitoring performance with DAX Studio
Using SQL Server Profiler
Using Power BI Performance Analyzer
Summary
17
Other Books You May Enjoy
Other Books You May Enjoy
Leave a review - let other readers know what you think

Using Power BI Performance Analyzer

For the last section in this chapter, we are going to look at the Performance Analyzer feature in Power BI Desktop. This feature gives information on how elements of a report, such as visuals and DAX queries, are performing.

To display the Performance Analyzer pane, click on the Performance Analyzer checkbox on the Show section of the View ribbon, as shown in Figure 13-16:

Figure 13-16: Enabling the performance analyzer feature in Power BI Desktop

Once checked, the Performance Analyzer pane will be displayed to the right of the report desktop. From here, you can start recording data and see information on the processing times required to update report elements when a user interacts with a report. For example, if you alter a slicer, click on a visual, or adjust a filter, then it will send a query to the data model. Information on the action...

Previous Section
End of Section 5
Next Section