Sign In Start Free Trial

Book Overview & Buying
Table Of Contents
Feedback & Rating

Hands-On Business Intelligence with DAX

By : Horne

5 (3)

Hands-On Business Intelligence with DAX

5 (3)

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.

Preface

Preface

Who this book is for

What this book covers

To get the most out of this book

Get in touch

Section 1: Introduction to DAX for the BI Pro

Section 1: Introduction to DAX for the BI Pro

Free Chapter

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

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

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

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

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

Section 2: Understanding DAX Functions and Syntax

Section 2: Understanding DAX Functions and Syntax

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

Table Functions

Table Functions

Introducing table functions

Looking at table manipulation functions

Working with table functions

Summary

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

Filter Functions

Filter Functions

Introduction to filter functions

Filtering your data with filter functions

Summary

Statistical Functions

Statistical Functions

Introducing statistical functions

Calculating averages

Working with percentiles

Ranking your data

Calculating standard deviation and variance

Summary

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

Section 3: Taking DAX to the Next Level

Section 3: Taking DAX to the Next Level

Optimizing Your Data Model

Optimizing Your Data Model

Introducing the VertiPaq engine

Understanding your data model

Simplifying your data model

Creating summary tables

Summary

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

Other Books You May Enjoy

Other Books You May Enjoy

Leave a review - let other readers know what you think

Customer Reviews

5 (3)

5 star

100%

4 star

0

3 star

0

2 star

0

1 star

0

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...

Search

Your notes and bookmarks