Subscription

Explore Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Learning Hub

Conferences

Free Learning

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

Section 1: Introduction to DAX for the BI Pro

This section covers the basics of DAX, along with the importance of good data models and how to write efficient DAX formulas by using variables and good formatting. You will understand how DAX queries work using an example-based approach. You will also learn how to optimize the BI workflow by writing efficient and powerful DAX queries with easy-to-follow explanations and examples:

Chapter 1, What Is DAX?
Chapter 2, Using DAX Variables and Formatting
Chapter 3, Building Data Models
Chapter 4, Working with DAX in Power BI, Excel, and SSAS
Chapter 5, Getting It into Context

The rest of the chapter is locked

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 R$50/month. Cancel anytime

Authors (1)

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