Explore Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Learning Hub

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

Who this book is for

This book is for data analysts, business analysts, BI developers, or any SQL users who want to get the best out of DAX in the BI and data analytics domain using an example-rich guide. You will learn how to use DAX queries in Power BI, Excel, and SQL Server to carry out efficient analysis. Some understanding of BI concepts is mandatory.

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 $19.99/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