![Amazon prime logo](https://m.media-amazon.com/images/G/01/marketing/prime/new_prime_logo_RGB_blue._CB426090081_.png)
Enjoy fast, free delivery, exclusive deals, and award-winning movies & TV shows with Prime
Try Prime
and start saving today with fast, free delivery
Amazon Prime includes:
Fast, FREE Delivery is available to Prime members. To join, select "Try Amazon Prime and start saving today with Fast, FREE Delivery" below the Add to Cart button.
Amazon Prime members enjoy:- Cardmembers earn 5% Back at Amazon.com with a Prime Credit Card.
- Unlimited Free Two-Day Delivery
- Streaming of thousands of movies and TV shows with limited ads on Prime Video.
- A Kindle book to borrow for free each month - with no due dates
- Listen to over 2 million songs and hundreds of playlists
- Unlimited photo storage with anywhere access
Important: Your credit card will NOT be charged when you start your free trial or if you cancel during the trial period. If you're happy with Amazon Prime, do nothing. At the end of the free trial, your membership will automatically upgrade to a monthly membership.
![Kindle app logo image](https://m.media-amazon.com/images/G/01/kindle/app/kindle-app-logo._CB668847749_.png)
Download the free Kindle app and start reading Kindle books instantly on your smartphone, tablet, or computer - no Kindle device required.
Read instantly on your browser with Kindle for Web.
Using your mobile phone camera - scan the code below and download the Kindle app.
Follow the authors
OK
Optimizing DAX: Improving DAX performance in Microsoft Power BI and Analysis Services (color) 2nd ed. Edition
Purchase options and add-ons
This book is the state of the art of optimizing DAX expressions in Power BI and Analysis Services semantic models. Learn how to locate performance bottlenecks, read the query plan and performance metrics, rewrite the slower part of an expression, and measure the performance improvements.
- Use tools like Power BI Desktop Performance Analyzer and DAX Studio
- Understand the DAX formula engine
- Learn characteristics of different storage engines (VertiPaq, DirectQuery over SQL)
- Read DAX query plans
- Optimize common DAX constructs
- Solve security performance issues
- Improve DirectQuery response time
- Control the data placement in composite models to avoid bottlenecks
Prerequisites: proficiency in DAX and SQL (for DirectQuery), understanding of the Tabular engine used by semantic models, and familiarity with DAX Studio.
The hardcover version of this book is in full color, with maximum fidelity of screenshots and different background colors to make code snippets language easy to identify.
- ISBN-101735365246
- ISBN-13978-1735365244
- Edition2nd ed.
- PublisherSqlbi Corp.
- Publication dateApril 30, 2024
- LanguageEnglish
- Dimensions7.5 x 1.69 x 9.25 inches
- Print length818 pages
What do customers buy after viewing this item?
Product details
- Publisher : Sqlbi Corp.; 2nd ed. edition (April 30, 2024)
- Language : English
- Hardcover : 818 pages
- ISBN-10 : 1735365246
- ISBN-13 : 978-1735365244
- Item Weight : 3.53 pounds
- Dimensions : 7.5 x 1.69 x 9.25 inches
- Best Sellers Rank: #3,510,695 in Books (See Top 100 in Books)
- #319 in Desktop Database Books
- #1,333 in Database Storage & Design
- #1,478 in Data Mining (Books)
- Customer Reviews:
About the authors
Alberto started working with SQL Server in 2000 and immediately his interest focused on Business Intelligence. He and Marco Russo created sqlbi.com, where they publish extensive content about Business Intelligence.
Alberto published several books about Analysis Services, Power BI, and Power Pivot. He is a Microsoft MVP and he earned the SSAS Maestro title, the highest level of certification on Microsoft Analysis Services technology.
Today, Alberto's main activities are in the delivery of DAX and data modeling workshops for Power BI and Analysis Services all around the world. Alberto offers consulting services on large and complex data warehouses to provide assessments and validation of project analysis or to perform specific problem-solving activities.
Alberto is a well-known speaker at many international conferences, like PASS Summit, Sqlbits, and Microsoft Ignite. He loves to be on stage both at large events and at smaller user groups meetings, exchanging ideas with other SQL and BI fans. When traveling for work, he likes to engage with local user groups to provide evening sessions about his favorite topics. Thus, you can easily meet Alberto by looking up local Power BI user groups during scheduled courses.
Outside of SQLBI, most of Alberto's personal time is spent practicing video games, in the vain hope of eventually beating his son.
Marco Russo is a business intelligence mentor and consultant in Business Intelligence.
He founded SQLBI, which provides mentoring and consulting on Business Intelligence based on Microsoft technologies. He has particular competence and experience in sectors like financial services, manufacturing, gambling, and commercial distribution.
Marco is a Microsoft MVP and an SSAS Maestro, the highest level of certification in Microsoft Analysis Services. In addition to his BI-related publications, he has authored books about .NET programming.
Today, Marco focuses his time on SQLBI customers, traveling extensively to train and consult on DAX and data modeling for Power BI and Analysis Services. Marco also teaches public classes worldwide.
Marco also speaks at international conferences such as Microsoft Fabric, PASS Summit, and SQLBits.
Customer reviews
- 5 star4 star3 star2 star1 star5 star84%16%0%0%0%84%
- 5 star4 star3 star2 star1 star4 star84%16%0%0%0%16%
- 5 star4 star3 star2 star1 star3 star84%16%0%0%0%0%
- 5 star4 star3 star2 star1 star2 star84%16%0%0%0%0%
- 5 star4 star3 star2 star1 star1 star84%16%0%0%0%0%
Customer Reviews, including Product Star Ratings help customers to learn more about the product and decide whether it is the right product for them.
To calculate the overall star rating and percentage breakdown by star, we don’t use a simple average. Instead, our system considers things like how recent a review is and if the reviewer bought the item on Amazon. It also analyzed reviews to verify trustworthiness.
Learn more how customers reviews work on AmazonTop reviews from the United States
There was a problem filtering reviews right now. Please try again later.
- Reviewed in the United States on May 30, 2024This book is best in enhancing your dax skills and solving comes dax issues I have been following sqlbi.com from my early days and always all of thier products have been so helpful.thankyou
Top reviews from other countries
- nikot.23Reviewed in Italy on August 11, 2024
5.0 out of 5 stars Excellent
Exactly what I expected, sqlbi style and quality.