0

Explore Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Free Learning

Hands-On Business Intelligence with DAX

You're reading from Hands-On Business Intelligence with DAX Discover the intricacies of this powerful query language to gain valuable insights from your data

Product type Paperback

Published in Jan 2020

Publisher Packt

ISBN-13 9781838824303

Length 402 pages

Edition 1st Edition

Languages

DAX

Tools

Excel

Concepts

Business Intelligence

Author (1):

Ian Horne

View More author details

Table of Contents (18) Chapters

Preface

1. Section 1: Introduction to DAX for the BI Pro

2. What is DAX? FREE CHAPTER

3. Using DAX Variables and Formatting

4. Building Data Models

5. Working with DAX in Power BI, Excel, and SSAS

6. Getting It into Context

7. Section 2: Understanding DAX Functions and Syntax

8. Progressive DAX Syntax and Functions

9. Table Functions

10. Date, Time, and Time Intelligence Functions

11. Filter Functions

12. Statistical Functions

13. Working with DAX Patterns

14. Section 3: Taking DAX to the Next Level

15. Optimizing Your Data Model

16. Optimizing Your DAX Queries

17. Other Books You May Enjoy

Leave a review - let other readers know what you think

Understanding your data model

There are a few tools available that will help you to understand your data model in more detail. Some of these are third-party tools, but if you are working with a version of Power BI Desktop released after October 2018, then the Power Query Editor comes with excellent data profiling capabilities built in. In this section, we're going to look at these and how they can be used to help you better understand the data that you are working within your data model.

Data profiling with Power BI Desktop

To access the data profiling capabilities in Power BI Desktop, we need to open the Power Query Editor. The easiest way to do this is by clicking on the Edit Queries button in the External data section...

The rest of the chapter is locked

Register for a free Packt account to unlock a world of extra content!

A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.

Unlock this book and the full library FREE for 7 days

Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of

Start free trial

Renews at €18.99/month. Cancel anytime

Authors (1)

Horne

Horne

Ian Horne is head of data services with a global organization. He is a business intelligence (BI) professional with over 30 years of experience and specializes in the design, development, and maintenance of corporate databases, data warehouses, associated ETL processes, and end user reporting. He has extensive knowledge of the Microsoft BI stack, including SQL Server, SSRS, SSAS, Power BI, and, of course, DAX. Ian holds a diploma in computing and a Bachelor of Science degree from the Open University. In his spare time, he creates training videos on Power BI, DAX, and other data-related matters, which he shares through his YouTube channel, Data World TV.

See other products by Horne

Other recommended products

Related to this chapter

Raspberry Pi 3 Projects for Java Programmers

Raspberry Pi 3 Projects for Java Programmers

This book will try to create starting points for Java developers who would like to extend their knowledge on how to interact with hardware on the Raspberry Pi by providing small real world usable projects. After reading this book the reader will be able to build their own real world usable projects not limited to Home Automation, IoT and/or Robotics utilizing logic, user- and web interfaces.

May 2017 9h 32m

Tabular Modeling with SQL Server 2016 Analysis Services Cookbook

Tabular Modeling with SQL Server 2016 Analysis Services Cookbook

Jan 2017 12h 24m

Tabular Modeling with SQL Server 2016 Analysis Services Cookbook

Tabular Modeling with SQL Server 2016 Analysis Services Cookbook

Jan 2017 12h 24m

Tabular Modeling with SQL Server 2016 Analysis Services Cookbook

Tabular Modeling with SQL Server 2016 Analysis Services Cookbook

Jan 2017 12h 24m

Expert Data Modeling with Power BI

Expert Data Modeling with Power BI

This book shows you how to effectively use Power BI, covering everything from Fact tables and Dimension tables to different data modeling techniques. With the help of real-world scenarios, you'll be able to identify when, why, and how to prepare data to support an efficient Star Schema to satisfy business requirements.

Jun 2021 20h 24m

Expert Data Modeling with Power BI

Expert Data Modeling with Power BI

This book shows you how to effectively use Power BI, covering everything from Fact tables and Dimension tables to different data modeling techniques. With the help of real-world scenarios, you'll be able to identify when, why, and how to prepare data to support an efficient Star Schema to satisfy business requirements.

Jun 2021 20h 24m

Expert Data Modeling with Power BI

Expert Data Modeling with Power BI

This book shows you how to effectively use Power BI, covering everything from Fact tables and Dimension tables to different data modeling techniques. With the help of real-world scenarios, you'll be able to identify when, why, and how to prepare data to support an efficient Star Schema to satisfy business requirements.

Jun 2021 20h 24m

Expert Data Modeling with Power BI

Expert Data Modeling with Power BI

This book shows you how to effectively use Power BI, covering everything from Fact tables and Dimension tables to different data modeling techniques. With the help of real-world scenarios, you'll be able to identify when, why, and how to prepare data to support an efficient Star Schema to satisfy business requirements.

Jun 2021 20h 24m

Expert Data Modeling with Power BI

Expert Data Modeling with Power BI

This book shows you how to effectively use Power BI, covering everything from Fact tables and Dimension tables to different data modeling techniques. With the help of real-world scenarios, you'll be able to identify when, why, and how to prepare data to support an efficient Star Schema to satisfy business requirements.

Jun 2021 20h 24m

Expert Data Modeling with Power BI

Expert Data Modeling with Power BI

This book shows you how to effectively use Power BI, covering everything from Fact tables and Dimension tables to different data modeling techniques. With the help of real-world scenarios, you'll be able to identify when, why, and how to prepare data to support an efficient Star Schema to satisfy business requirements.

Jun 2021 20h 24m

Expert Data Modeling with Power BI

Expert Data Modeling with Power BI

This book shows you how to effectively use Power BI, covering everything from Fact tables and Dimension tables to different data modeling techniques. With the help of real-world scenarios, you'll be able to identify when, why, and how to prepare data to support an efficient Star Schema to satisfy business requirements.

Jun 2021 20h 24m

Expert Data Modeling with Power BI

Expert Data Modeling with Power BI

This book shows you how to effectively use Power BI, covering everything from Fact tables and Dimension tables to different data modeling techniques. With the help of real-world scenarios, you'll be able to identify when, why, and how to prepare data to support an efficient Star Schema to satisfy business requirements.

Jun 2021 20h 24m

Personalised recommendations for you

Based on your interests and search pattern

Modern Computer Vision with PyTorch

Modern Computer Vision with PyTorch

This book provides a hands-on approach to solving over 30 prominent real-world computer vision problems using PyTorch 2.x on actual datasets. Here you'll learn to build a neural network from scratch and optimize hyperparameters, perform image classification, multi-object detection, segmentation, and more. You'll also explore facial expression manipulation and combining CV with NLP and RL techniques, build generative AI applications, and take your model to production on AWS. By the end of this book, you'll master modern NN architectures and confidently solve real-world CV problems.

Jun 2024 24h 52m

Modern Computer Vision with PyTorch

Modern Computer Vision with PyTorch

This book provides a hands-on approach to solving over 30 prominent real-world computer vision problems using PyTorch 2.x on actual datasets. Here you'll learn to build a neural network from scratch and optimize hyperparameters, perform image classification, multi-object detection, segmentation, and more. You'll also explore facial expression manipulation and combining CV with NLP and RL techniques, build generative AI applications, and take your model to production on AWS. By the end of this book, you'll master modern NN architectures and confidently solve real-world CV problems.

Jun 2024 24h 52m

Data Governance Handbook

Data Governance Handbook

This book provides a highly focused view of real business outcomes powered by data governance, that resonate with non-data executives such as CFOs and CEOs. You'll also find useful insights into how to implement data governance initiatives.

May 2024 13h 8m

Data Engineering with Databricks Cookbook

Data Engineering with Databricks Cookbook

This book shows you how to use Apache Spark, Delta Lake, and Databricks to build data pipelines, manage and transform data, optimize performance, and more. Additionally, you'll implement DataOps and DevOps practices, and orchestrate data workflows.

May 2024 14h 36m

Azure Data Engineer Associate Certification Guide

Azure Data Engineer Associate Certification Guide

Unlock the power of Azure data engineering with this certification guide, elevating your skills in data processing, storage, and security with the help of practical insights, hands-on exercises, and the latest advancements.

May 2024 18h 16m

Microsoft Power BI Cookbook

Microsoft Power BI Cookbook

Microsoft Power BI is the most sought-after platform for BI professionals' visualization needs. Explore the latest Power BI features, future AI enhancements, and integration with other Power Platform tools via new recipes in this updated edition.

Jul 2024 19h 56m

Python Data Cleaning Cookbook

Python Data Cleaning Cookbook

The book shows you how to clean, wrangle, and view data from multiple perspectives, including dataset and column attributes. You will cover common and not-so-common challenges that are faced while cleaning messy data for complex situations and learn to manipulate data to get it down to a form that can be useful for making the right decisions.

May 2024 16h 12m

Microsoft Azure AI Fundamentals AI-900 Exam Guide

Microsoft Azure AI Fundamentals AI-900 Exam Guide

This AI-900 study guide will help you prepare and practice for the certification exam. You'll delve into AI workloads, ML principles, computer vision, NLP, knowledge mining, and generative AI using Azure cloud services.

May 2024 9h 36m

Using Stable Diffusion with Python

Using Stable Diffusion with Python

This book shows you how to use Python to control Stable Diffusion and generate high-quality images. In addition to covering the basic usage of the diffusers package, the book provides solutions for extending the package for more advanced purposes.

Jun 2024 11h 44m

Getting Started with DuckDB

Getting Started with DuckDB

This hands-on book teaches you to analyze large datasets with blazing speed and ease. You will learn how to use DuckDB to quickly load, query, transform, analyze, and visualize data effectively through a series of practical examples.

Jun 2024 12h 44m

Databricks Certified Associate Developer for Apache Spark Using Python

Databricks Certified Associate Developer for Apache Spark Using Python

This guide gets you ready for certification with expert-backed content, key exam concepts, and topic reviews. Additionally, you'll be able to make the most of Apache Spark 3.0 to modernize workloads and more using specific tools and techniques.