Extreme DAX: Take your Power BI and Microsoft data analytics skills to the next level

Discover the true power of DAX and build advanced DAX solutions for practical business scenariosKey Features: Solve...
HK$900.79
HK$900.79
SKU: 9781801078511
Product Type: Books
Please hurry! Only 231 left in stock
Author: Michiel Rozema
Format: Paperback
Language: English
Subtotal: $900.79
10 customers are viewing this product
Extreme DAX: Take your Power BI and Microsoft data analytics skills to the next level by Rozema, Michiel

Extreme DAX: Take your Power BI and Microsoft data analytics skills to the next level

$900.79

Extreme DAX: Take your Power BI and Microsoft data analytics skills to the next level

$900.79
Author: Michiel Rozema
Format: Paperback
Language: English

Discover the true power of DAX and build advanced DAX solutions for practical business scenarios


Key Features:

  • Solve complex business problems within Microsoft BI tools including Power BI, SQL Server, and Excel
  • Develop a conceptual understanding of critical business data modeling principles
  • Learn the subtleties of Power BI data visualizations, evaluation context, context transition, and filtering


Book Description:

This book helps business analysts generate powerful and sophisticated analyses from their data using DAX and get the most out of Microsoft Business Intelligence tools.


Extreme DAX will first teach you the principles of business intelligence, good model design, and how DAX fits into it all. Then, you'll launch into detailed examples of DAX in real-world business scenarios such as inventory calculations, forecasting, intercompany business, and data security. At each step, senior DAX experts will walk you through the subtleties involved in working with Power BI models and common mistakes to look out for as you build advanced data aggregations.


You'll deepen your understanding of DAX functions, filters, and measures, and how and when they can be used to derive effective insights. You'll also be provided with PBIX files for each chapter, so that you can follow along and explore in your own time.


What You Will Learn:

  • Understand data modeling concepts and structures before you start working with DAX
  • Grasp how relationships in Power BI models are different from those in RDBMSes
  • Secure aggregation levels, attributes, and hierarchies using PATH functions and row-level security
  • Get to grips with the crucial concept of context
  • Apply advanced context and filtering functions including TREATAS, GENERATE, and SUMMARIZE
  • Explore dynamically changing visualizations with helper tables and dynamic labels and axes
  • Work with week-based calendars and understand standard time-intelligence
  • Evaluate investments intelligently with the XNPV and XIRR financial DAX functions


Who this book is for:

Extreme DAX is written for analysts with a working knowledge of DAX in Power BI or other Microsoft analytics tools. It will help you upgrade your knowledge and work with analytical models more effectively, so you'll need practical experience with DAX before you can get started.

Author: Michiel Rozema, Henk Vlootman
Publisher: Packt Publishing
Published: 01/20/2022
Pages: 470
Binding Type: Paperback
Weight: 1.76lbs
Size: 9.25h x 7.50w x 0.95d
ISBN: 9781801078511

This title is not returnable

Returns Policy

You may return most new, unopened items within 30 days of delivery for a full refund. We'll also pay the return shipping costs if the return is a result of our error (you received an incorrect or defective item, etc.).

You should expect to receive your refund within four weeks of giving your package to the return shipper, however, in many cases you will receive a refund more quickly. This time period includes the transit time for us to receive your return from the shipper (5 to 10 business days), the time it takes us to process your return once we receive it (3 to 5 business days), and the time it takes your bank to process our refund request (5 to 10 business days).

If you need to return an item, simply login to your account, view the order using the "Complete Orders" link under the My Account menu and click the Return Item(s) button. We'll notify you via e-mail of your refund once we've received and processed the returned item.

Shipping

We can ship to virtually any address in the world. Note that there are restrictions on some products, and some products cannot be shipped to international destinations.

When you place an order, we will estimate shipping and delivery dates for you based on the availability of your items and the shipping options you choose. Depending on the shipping provider you choose, shipping date estimates may appear on the shipping quotes page.

Please also note that the shipping rates for many items we sell are weight-based. The weight of any such item can be found on its detail page. To reflect the policies of the shipping companies we use, all weights will be rounded up to the next full pound.

Related Products

Recently Viewed Products