What do you get with eBook?

Instant access to your Digital eBook purchase

Download this book in EPUB and PDF formats

Access this title in our online reader with advanced features

DRM FREE - Read whenever, wherever and however you want

AI Assistant (beta) to help accelerate your learning

Key benefits

Understand the ins and outs of DAX expressions and querying functions with the help of easy-to-follow examples

Manipulate data of varying complexity and optimize BI workflows to extract key insights

Create, monitor, and improve the performance of models by writing clean and robust DAX queries

Description

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.

What you will learn

Understand DAX, from the basics through to advanced topics, and learn to build effective data models

Write and use DAX functions and expressions with the help of hands-on examples

Discover how to handle errors in your DAX code, and avoid unwanted results

Load data into a data model using Power BI, Excel Power Pivot, and SSAS Tabular

Cover DAX functions such as date, time, and time intelligence using code examples

Gain insights into data by using DAX to create new information

Understand the DAX VertiPaq engine and how it can help you optimize data models

What do you get with eBook?

Instant access to your Digital eBook purchase

Download this book in EPUB and PDF formats

Access this title in our online reader with advanced features

DRM FREE - Read whenever, wherever and however you want

AI Assistant (beta) to help accelerate your learning

Frequently bought together

$48.99

$48.99

$38.99

Total $ 136.97

FAQs

How do I buy and download an eBook?

Where there is an eBook version of a title available, you can buy it from the book details for that title. Add either the standalone eBook or the eBook and print book bundle to your shopping cart. Your eBook will show in your cart as a product on its own. After completing checkout and payment in the normal way, you will receive your receipt on the screen containing a link to a personalised PDF download file. This link will remain active for 30 days. You can download backup copies of the file by logging in to your account at any time.

If you already have Adobe reader installed, then clicking on the link will download and open the PDF file directly. If you don't, then save the PDF file on your machine and download the Reader to view it.

Please Note: Packt eBooks are non-returnable and non-refundable.

Packt eBook and Licensing When you buy an eBook from Packt Publishing, completing your purchase means you accept the terms of our licence agreement. Please read the full text of the agreement. In it we have tried to balance the need for the ebook to be usable for you the reader with our needs to protect the rights of us as Publishers and of our authors. In summary, the agreement says:

You may make copies of your eBook for your own use onto any machine
You may not pass copies of the eBook on to anyone else

How can I make a purchase on your website?

If you want to purchase a video course, eBook or Bundle (Print+eBook) please follow below steps:

Register on our website using your email address and the password.
Search for the title by name or ISBN using the search option.
Select the title you want to purchase.
Choose the format you wish to purchase the title in; if you order the Print Book, you get a free eBook copy of the same title.
Proceed with the checkout process (payment to be made using Credit Card, Debit Cart, or PayPal)

Where can I access support around an eBook?

If you experience a problem with using or installing Adobe Reader, the contact Adobe directly.
To view the errata for the book, see www.packtpub.com/support and view the pages for the title you have.
To view your account details or to download a new copy of the book go to www.packtpub.com/account
To contact us directly if a problem is not resolved, use www.packtpub.com/contact-us

What eBook formats do Packt support?

Our eBooks are currently available in a variety of formats such as PDF and ePubs. In the future, this may well change with trends and development in technology, but please note that our PDFs are not Adobe eBook Reader format, which has greater restrictions on security.

You will need to use Adobe Reader v9 or later in order to read Packt's PDF eBooks.

What are the benefits of eBooks?

You can get the information you need immediately
You can easily take them with you on a laptop
You can download them an unlimited number of times
You can print them out
They are copy-paste enabled
They are searchable
There is no password protection
They are lower price than print
They save resources and space

What is an eBook?

Packt eBooks are a complete electronic version of the print edition, available in PDF and ePub formats. Every piece of content down to the page numbering is the same. Because we save the costs of printing and shipping the book to you, we are able to offer eBooks at a lower cost than print editions.

When you have purchased an eBook, simply login to your account and click on the link in Your Download Area. We recommend you saving the file to your hard drive before opening it.

For optimal viewing of our eBooks, we recommend you download and install the free Adobe Reader version 9.

D. Lamarche Sep 05, 2020

Nice book and clear to understand.Looking forward to dig deeper into it.Thanks Ian.

Amazon Verified review

Ron101voa Sep 29, 2020

Disclaimer: I am a BI developer and have been using PowerBi for reports, dashboards, and custom visuals development for the last 2 years. I received a review copy of this book from the publisher. I will do my best to share my opinions as objectively as possible.I think this is a helpful book and a good reference guide for the Business Intelligence community. It can be a great resource whether you are transitioning from Excel to PowerBi, or a seasoned BI developer working with SSAS or other platforms. The book is divided into three parts, that build the learners' skillset progressively.In the first part of the book (Chapter 1 through 5), I enjoyed how the author balanced explaining simple DAX concepts and applying the concepts to write DAX scripts. Let me give you a simple example: The author walks you through the similarities and the differences between ‘Measures’ and ‘Calculated column’ and explained clearly when to use each toolset. Even though it may sound like a simple item, but it can be a complicated concept for someone who is just starting out to learn Power Bi/DAX. I also considered the author did a great job showing us how to write DAX codes using variables, variables nesting, and other techniques. In real life, the data source and the models built from these sources might have limitations, thus developing the skillset to write complex DAX scripts is extremely important and necessary to develop proper visuals and reports. The author transitioned well between different platforms such as PowerBi, Excel and SSAS to teach DAX without overwhelming the audience. For e.g. the author took the time to explain the concept of the Data model, discussed best practices of developing a well-defined data model, and then provided examples of how to execute it.The second part of the book (Chapter 6 through 11) really gets into the detail of deriving value from DAX scripts. I personally found the chapter on Date, Time, and Time Intelligence of great benefit. And finally, the third part of the book is more targeted for advanced users. In my opinion, there is some room for improvement in this part. I would like to see more details around Data model optimization to execute DAX queries efficiently.DAX and Power Bi is evolving continuously with new updates and releases. Getting this book & reviewing it really helped me take my Power Bi skills to the next level. I strongly recommend this book.

Administration Team (GRAAY) Mar 30, 2020

This technical manual is written with a very easy to follow style and its nice to know that the author is actually in a role that defines his credentials to write a book of this type. I very much look forward to the follow up.

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

What do you get with eBook?