Definitive Guide to DAX, The: Business intelligence with Microsoft Excel, SQL Se

Description: Definitive Guide to DAX, The by Marco Russo, Alberto Ferrari This comprehensive and authoritative guide will teach you the DAX language for business intelligence, data modeling, and analytics. Leading Microsoft BI consultants Marco Russo and Alberto Ferrari help you master everything from table functions through advanced code and model optimisation. Youll learn exactly what happens under the hood when you run a DAX expression, how DAX behaves differently from other languages, and how to use this knowledge to write fast, robust code. If you want to leverage all of DAXs remarkable power and flexibility, this no-compromise "deep dive" is exactly what you need.Perform powerful data analysis with DAX for Microsoft SQL Server Analysis Services, Excel, and Power BI Master core DAX concepts, including calculated columns, measures, and error handling Understand evaluation contexts and the CALCULATE and CALCULATETABLE functions Perform time-based calculations: YTD, MTD, previous year, working days, and more Work with expanded tables, complex functions, and elaborate DAX expressions Perform calculations over hierarchies, including parent/child hierarchies Use DAX to express diverse and unusual relationships Measure DAX query performance with SQL Server Profiler and DAX Studio FORMAT Paperback LANGUAGE English CONDITION Brand New Notes Trade paperback. The fundamentals of the DAX language required for business intelligence, data modelling and analytics are presented by specialist trainer Ferrari and founder of DevLeap Russo. Author Biography Marco Russo and Alberto Ferrari are the founders of sqlbi.com, where they regularly publish articles about Microsoft Power BI, Power Pivot, DAX, and SQL Server Analysis Services. They have worked with DAX since the fi rst beta version of Power Pivot in 2009 and, during these years, sqlbi.com became one of the major sources for DAX articles and tutorials. Their courses, both in-person and online, are the major source of learning for many DAX enthusiasts. They both provide consultancy and mentoring on business intelligence (BI) using Microsoft technologies. They have written several books and papers about Power BI, DAX, and Analysis Services. They constantly help the community of DAX users providing content for the websites daxpatterns.com, daxformatter.com, and dax.guide. Marco and Alberto are also regular speakers at major international conferences, including Microsoft Ignite, PASS Summit, and SQLBits. Contact Marco at , and contact Alberto at Table of Contents Introduction Chapter 1: What is DAX? Chapter 2: Introducing DAX Chapter 3: Using basic table functions Chapter 4: Understanding evaluation contexts Chapter 5: Understanding CALCULATE and CALCULATETABLE Chapter 6: DAX examples Chapter 7: Time intelligence calculations Chapter 8: Statistical functions Chapter 9: Advanced table functions Chapter 10: Advanced evaluation context Chapter 11: Handling hierarchies Chapter 12: Advanced relationships Chapter 13: The VertiPaq engine Chapter 14: Optimizing data models Chapter 15: Analyzing DAX query plans Chapter 16: Optimizing DAX Index Long Description Now expanded and updated with modern best practices, this is the most complete guide to Microsofts DAX language for business intelligence, data modeling, and analytics. Expert Microsoft BI consultants Marco Russo and Alberto Ferrari help you master everything from table functions through advanced code and model optimization. Youll learn exactly what happens under the hood when you run a DAX expression, and use this knowledge to write fast, robust code. This edition focuses on examples you can build and run with the free Power BI Desktop, and helps you make the most of the powerful syntax of variables (VAR) in Power BI, Excel, or Analysis Services. Want to leverage all of DAXs remarkable capabilities? This no-compromise "deep dive" is exactly what you need. Perform powerful data analysis with DAX for Power BI, SQL Server, and Excel Feature Only advanced DAX book on the market The authors stellar reputation, which is largely based on high-quality books they have already authored The quickly increasing interest in technical content for BI professionals New Feature New examples in Power BI New DAX features (TREATAS, new relationship types) Better guidelines for KEEPFILTERS New explanation of filter context More optimizations using DAX Studio Improved content and examples based of feedback of first edition Update of all new DAX functions and features Details ISBN1509306978 Author Alberto Ferrari Pages 816 Publisher Microsoft Press,U.S. Edition 2nd ISBN-10 1509306978 ISBN-13 9781509306978 Format Paperback Imprint Microsoft Press Subtitle Business intelligence with Microsoft Excel, SQL Server Analysis Services, and Power BI Place of Publication Boston Country of Publication United States Replaces 9780735698352 Media Book DEWEY 658.05 Year 2019 Publication Date 2019-07-20 Short Title The Definitive Guide to DAX Language English Series Business Skills Birth 1964 Affiliation Dean of the College, Woodrow Wilson Professor of Literature, Princeton University Position Dean of the College, Woodrow Wilson Professor of Literature Qualifications PhD, LP AU Release Date 2019-07-27 NZ Release Date 2019-07-27 US Release Date 2019-07-27 UK Release Date 2019-07-27 Edition Description 2nd edition Replaced by 9780138244729 Audience Professional & Vocational We've got this At The Nile, if you're looking for it, we've got it. With fast shipping, low prices, friendly service and well over a million items - you're bound to find what you want, at a price you'll love! TheNile_Item_ID:117935826;

Price: 62.54 AUD

Location: Melbourne

End Time: 2024-11-29T03:39:20.000Z

Shipping Cost: 21.97 AUD