Buy Definitive Guide to DAX, The by Marco Russo at Bookstore UAE
close menu
Bookswagon
search
My Account
Book 1
Book 2
Book 3
Book 1
Book 2
Book 3
Book 1
Book 2
Book 3
Book 1
Book 2
Book 3
Home > Computing and Information Technology > Databases > Database software > Definitive Guide to DAX, The: Business intelligence with Microsoft Excel, SQL Server Analysis Services, and Power BI(Business Skills)
Definitive Guide to DAX, The: Business intelligence with Microsoft Excel, SQL Server Analysis Services, and Power BI(Business Skills)

Definitive Guide to DAX, The: Business intelligence with Microsoft Excel, SQL Server Analysis Services, and Power BI(Business Skills)


     0     
5
4
3
2
1



Out of Stock


Notify me when this book is in stock
X
About the Book

The Definitive Guide to DAX is the most comprehensive and authoritative guide to Microsoft's DAX language for business intelligence and analytics. While other books cover only the basics, this guide offers expert guidance on everything intermediate-to-advanced Excel users and BI professionals need to know, from the basics to innovative high-performance techniques.

Table of Contents:
Foreword xvii Introduction xix Chapter 1: What is DAX? 1 Understanding the data model 1 Understanding the direction of a relationship 3 DAX for Excel users 5 Cells versus tables 5 Excel and DAX: Two functional languages 8 Using iterators 8 DAX requires some theory 8 DAX for SQL developers 9 Understanding relationship handling 9 DAX is a functional language 10 DAX as a programming and querying language 11 Subqueries and conditions in DAX and SQL 12 DAX for MDX developers 13 Multidimensional vs. Tabular 13 DAX as a programming and querying language 13 Hierarchies 14 Leaf-level calculations 15 Chapter 2: Introducing DAX 17 Understanding DAX calculations 17 DAX data types 18 DAX operators 21 Understanding calculated columns and measures 22 Calculated columns 22 Measures 23 Variables 26 Handling errors in DAX expressions 26 Conversion errors 26 Arithmetical operations errors 27 Intercepting errors 30 Formatting DAX code 32 Common DAX functions 35 Aggregate functions 35 Logical functions 37 Information functions 39 Mathematical functions 39 Trigonometric functions 40 Text functions 40 Conversion functions 41 Date and time functions 42 Relational functions 42 Chapter 3: Using basic table functions 45 Introducing table functions 45 EVALUATE syntax 47 Using table expressions 50 Understanding FILTER 51 Understanding ALL, ALLEXCEPT, and ALLNOBLANKROW 54 Understanding VALUES and DISTINCT 58 Using VALUES as a scalar value 59 Chapter 4: Understanding evaluation contexts 61 Introduction to evaluation contexts 62 Understanding the row context 66 Testing your evaluation context understanding 67 Using SUM in a calculated column 67 Using columns in a measure 68 Creating a row context with iterators 69 Using the EARLIER function 70 Understanding FILTER, ALL, and context interactions 74 Working with many tables 77 Row contexts and relationships 78 Filter context and relationships 80 Introducing VALUES 84 Introducing ISFILTERED, ISCROSSFILTERED 85 Evaluation contexts recap 88 Creating a parameter table 89 Chapter 5: Understanding CALCULATE and CALCULATETABLE 93 Understanding CALCULATE 93 Understanding the filter context 95 Introducing CALCULATE 98 CALCULATE examples 101 Filtering a single column 101 Filtering with complex conditions 106 Using CALCULATETABLE 109 Understanding context transition 111 Understanding context transition with measures 114 How many rows are visible after context transition? 116 Understanding evaluation order of context transition 117 Variables and evaluation contexts 118 Understanding circular dependencies 119 CALCULATE rules 122 Introducing ALLSELECTED 123 Understanding USERELATIONSHIP 125 Chapter 6: DAX examples 129 Computing ratios and percentages 129 Computing cumulative totals 132 Using ABC (Pareto) classification 136 Computing sales per day and working day 143 Computing differences in working days 150 Computing static moving averages 151 Chapter 7: Time intelligence calculations 155 Introduction to time intelligence 155 Building a Date table 156 Using CALENDAR and CALENDARAUTO 157 Working with multiple dates 160 Handling multiple relationships to the Date table 161 Handling multiple Date tables 162 Introduction to time intelligence 164 Using Mark as Date Table 166 Aggregating and comparing over time 168 Year-to-date, quarter-to-date, month-to-date 168 Computing periods from prior periods 171 Computing difference over previous periods 174 Computing the moving annual total 175 Closing balance over time 178 Semi-additive measures 178 OPENINGBALANCE and CLOSINGBALANCE functions 184 Advanced time intelligence 188 Understanding periods to date 189 Understanding DATEADD 191 Understanding FIRSTDATE and LASTDATE 196 Understanding FIRSTNONBLANK and LASTNONBLANK 199 Using drillthrough with time intelligence 200 Custom calendars 200 Working with weeks 201 Custom year-to-date, quarter-to-date, month-to-date 204 Computing over noncontiguous periods 206 Custom comparison between periods 210 Chapter 8: Statistical functions 213 Using RANKX 213 Common pitfalls using RANKX 216 Using RANK.EQ 219 Computing average and moving average 220 Computing variance and standard deviation 222 Computing median and percentiles 223 Computing interests 225 Alternative implementation of PRODUCT and GEOMEAN 226 Using internal rate of return (XIRR) 227 Using net present value (XNPV) 228 Using Excel statistical functions 229 Sampling by using the SAMPLE function 230 Chapter 9: Advanced table functions 233 Understanding EVALUATE 233 Using VAR in EVALUATE 235 Understanding filter functions 236 Using CALCULATETABLE 236 Using TOPN 239 Understanding projection functions 241 Using ADDCOLUMNS 241 Using SELECTCOLUMNS 244 Using ROW 247 Understanding lineage and relationships 248 Understanding grouping/joining functions 250 Using SUMMARIZE 250 Using SUMMARIZECOLUMNS 255 Using GROUPBY 261 Using ADDMISSINGITEMS 262 Using NATURALINNERJOIN 265 Using NATURALLEFTOUTERJOIN 266 Understanding set functions 267 Using CROSSJOIN 267 Using UNION 269 Using INTERSECT 272 Using EXCEPT 274 Using GENERATE, GENERATEALL 275 Understanding utility functions 278 Using CONTAINS 278 Using LOOKUPVALUE 280 Using SUBSTITUTEWITHINDEX 283 Using ISONORAFTER 284 Chapter 10: Advanced evaluation context 285 Understanding ALLSELECTED 285 Understanding KEEPFILTERS 294 Understanding AutoExists 304 Understanding expanded tables 307 Difference between table expansion and filtering 315 Redefining the filter context 316 Understanding filter context intersection 318 Understanding filter context overwrite 320 Understanding arbitrarily shaped filters 321 Understanding the ALL function 326 Understanding lineage 329 Using advanced SetFilter 331 Learning and mastering evaluation contexts 338 Chapter 11: Handling hierarchies 339 Computing percentages over hierarchies 339 Handling parent-child hierarchies 346 Handling unary operators 358 Implementing unary operators by using DAX 359 Chapter 12: Advanced relationships 367 Using calculated physical relationships 367 Computing multiple-column relationships 367 Computing static segmentation 369 Using virtual relationships 371 Using dynamic segmentation 371 Many-to-many relationships 373 Using relationships with different granularities 378 Differences between physical and virtual relationships 381 Finding missing relationships 382 Computing number of products not sold 383 Computing new and returning customers 384 Examples of complex relationships 386 Performing currency conversion 386 Frequent itemset search 392 Chapter 13: The VertiPaq engine 399 Understanding database processing 400 Introduction to columnar databases 400 Understanding VertiPaq compression 403 Understanding value encoding 404 Understanding dictionary encoding 405 Understanding Run Length Encoding (RLE) 406 Understanding re-encoding 409 Finding the best sort order 409 Understanding hierarchies and relationships 410 Understanding segmentation and partitioning 412 Using Dynamic Management Views 413 Using DISCOVER_OBJECT_MEMORY_USAGE 414 Using DISCOVER_STORAGE_TABLES 414 Using DISCOVER_STORAGE_TABLE_COLUMNS 415 Using DISCOVER_STORAGE_TABLE_COLUMN_SEGMENTS 416 Understanding materialization 417 Choosing hardware for VertiPaq 421 Can you choose hardware? 421 Set hardware priorities 421 CPU model 422 Memory speed 423 Number of cores 423 Memory size 424 Disk I/O and paging 424 Conclusions 424 Chapter 14: Optimizing data models 425 Gathering information about the data model 425 Denormalization 434 Columns cardinality 442 Handling date and time 443 Calculated columns 447 Optimizing complex filters with Boolean calculated columns 450 Choosing the right columns to store 451 Optimizing column storage 453 Column split optimization 453 Optimizing high cardinality columns 454 Optimizing drill-through attributes 455 Chapter 15: Analyzing DAX query plans 457 Introducing the DAX query engine 457 Understanding the formula engine 458 Understanding the storage engine (VertiPaq) 459 Introducing DAX query plans 459 Logical query plan 460 Physical query plan 461 Storage engine query 462 Capturing profiling information 463 Using the SQL Server Profiler 463 Using DAX Studio 467 Reading storage engine queries 470 Introducing xmSQL syntax 470 Understanding scan time 477 Understanding DISTINCTCOUNT internals 479 Understanding parallelism and datacache 480 Understanding the VertiPaq cache 481 Understanding CallbackDataID 483 Reading query plans 488 Chapter 16: Optimizing DAX 495 Defining optimization strategy 496 Identifying a single DAX expression to optimize 496 Creating a reproduction query 499 Analyzing server timings and query plan information 500 Identifying bottlenecks in the storage engine or formula engine 503 Optimizing bottlenecks in the storage engine 504 Choosing ADDCOLUMNS vs. SUMMARIZE 505 Reducing CallbackDataID impact 509 Optimizing filter conditions 512 Optimizing IF conditions 513 Optimizing cardinality 515 Optimizing nested iterators 517 Optimizing bottlenecks in the formula engine 522 Creating repro in MDX 527 Reducing materialization 528 Optimizing complex bottlenecks 532 Index 537

About the Author :
Marco Russo and Alberto Ferrari cofounded sqlbi.com, where they regularly publish articles about Microsoft PowerPivot, DAX, Power BI, and SQL Server Analysis Services. They also speak regularly at major international conferences, such as TechEd, Ignite, PASS Summit, and SQLBits. Both consult and mentor on business intelligence (BI) and Microsoft BI technologies, having worked with them since 1999. Their books include  Microsoft Excel 2013 Building Data Models with PowerPivot, Microsoft SQL Server 2012 Analysis Services: The BISM Tabular Model, and Microsoft PowerPivot for Excel 2010: Give Your Data Meaning.


Best Sellers


Product Details
  • ISBN-13: 9780735698352
  • Publisher: Microsoft Press
  • Publisher Imprint: Microsoft Press
  • Height: 230 mm
  • No of Pages: 592
  • Series Title: Business Skills
  • Sub Title: Business intelligence with Microsoft Excel, SQL Server Analysis Services, and Power BI
  • Width: 190 mm
  • ISBN-10: 073569835X
  • Publisher Date: 29 Oct 2015
  • Binding: Paperback
  • Language: English
  • Returnable: N
  • Spine Width: 30 mm
  • Weight: 952 gr


Similar Products

Add Photo
Add Photo

Customer Reviews

REVIEWS      0     
Click Here To Be The First to Review this Product
Definitive Guide to DAX, The: Business intelligence with Microsoft Excel, SQL Server Analysis Services, and Power BI(Business Skills)
Microsoft Press -
Definitive Guide to DAX, The: Business intelligence with Microsoft Excel, SQL Server Analysis Services, and Power BI(Business Skills)
Writing guidlines
We want to publish your review, so please:
  • keep your review on the product. Review's that defame author's character will be rejected.
  • Keep your review focused on the product.
  • Avoid writing about customer service. contact us instead if you have issue requiring immediate attention.
  • Refrain from mentioning competitors or the specific price you paid for the product.
  • Do not include any personally identifiable information, such as full names.

Definitive Guide to DAX, The: Business intelligence with Microsoft Excel, SQL Server Analysis Services, and Power BI(Business Skills)

Required fields are marked with *

Review Title*
Review
    Add Photo Add up to 6 photos
    Would you recommend this product to a friend?
    Tag this Book Read more
    Does your review contain spoilers?
    What type of reader best describes you?
    I agree to the terms & conditions
    You may receive emails regarding this submission. Any emails will include the ability to opt-out of future communications.

    CUSTOMER RATINGS AND REVIEWS AND QUESTIONS AND ANSWERS TERMS OF USE

    These Terms of Use govern your conduct associated with the Customer Ratings and Reviews and/or Questions and Answers service offered by Bookswagon (the "CRR Service").


    By submitting any content to Bookswagon, you guarantee that:
    • You are the sole author and owner of the intellectual property rights in the content;
    • All "moral rights" that you may have in such content have been voluntarily waived by you;
    • All content that you post is accurate;
    • You are at least 13 years old;
    • Use of the content you supply does not violate these Terms of Use and will not cause injury to any person or entity.
    You further agree that you may not submit any content:
    • That is known by you to be false, inaccurate or misleading;
    • That infringes any third party's copyright, patent, trademark, trade secret or other proprietary rights or rights of publicity or privacy;
    • That violates any law, statute, ordinance or regulation (including, but not limited to, those governing, consumer protection, unfair competition, anti-discrimination or false advertising);
    • That is, or may reasonably be considered to be, defamatory, libelous, hateful, racially or religiously biased or offensive, unlawfully threatening or unlawfully harassing to any individual, partnership or corporation;
    • For which you were compensated or granted any consideration by any unapproved third party;
    • That includes any information that references other websites, addresses, email addresses, contact information or phone numbers;
    • That contains any computer viruses, worms or other potentially damaging computer programs or files.
    You agree to indemnify and hold Bookswagon (and its officers, directors, agents, subsidiaries, joint ventures, employees and third-party service providers, including but not limited to Bazaarvoice, Inc.), harmless from all claims, demands, and damages (actual and consequential) of every kind and nature, known and unknown including reasonable attorneys' fees, arising out of a breach of your representations and warranties set forth above, or your violation of any law or the rights of a third party.


    For any content that you submit, you grant Bookswagon a perpetual, irrevocable, royalty-free, transferable right and license to use, copy, modify, delete in its entirety, adapt, publish, translate, create derivative works from and/or sell, transfer, and/or distribute such content and/or incorporate such content into any form, medium or technology throughout the world without compensation to you. Additionally,  Bookswagon may transfer or share any personal information that you submit with its third-party service providers, including but not limited to Bazaarvoice, Inc. in accordance with  Privacy Policy


    All content that you submit may be used at Bookswagon's sole discretion. Bookswagon reserves the right to change, condense, withhold publication, remove or delete any content on Bookswagon's website that Bookswagon deems, in its sole discretion, to violate the content guidelines or any other provision of these Terms of Use.  Bookswagon does not guarantee that you will have any recourse through Bookswagon to edit or delete any content you have submitted. Ratings and written comments are generally posted within two to four business days. However, Bookswagon reserves the right to remove or to refuse to post any submission to the extent authorized by law. You acknowledge that you, not Bookswagon, are responsible for the contents of your submission. None of the content that you submit shall be subject to any obligation of confidence on the part of Bookswagon, its agents, subsidiaries, affiliates, partners or third party service providers (including but not limited to Bazaarvoice, Inc.)and their respective directors, officers and employees.

    Accept


    Inspired by your browsing history


    Your review has been submitted!

    You've already reviewed this product!