Business Skills Ser.: Definitive Guide to DAX : Business Intelligence for Microsoft Power BI, SQL Server Analysis Services, and Excel by Marco Russo and Alberto Ferrari (2019, Trade Paperback)

TextbooksXpress (3666)
98.6% positive feedback
Price:
US $39.80
(inclusive of GST)
ApproximatelyS$ 51.78
+ $8.71 shipping
Estimated delivery Thu, 12 Jun - Thu, 10 Jul
Returns:
30 days return. Buyer pays for return shipping. If you use an eBay shipping label, it will be deducted from your refund amount.
Condition:
Brand New

About this product

Product Identifiers

PublisherPearson Education
ISBN-101509306978
ISBN-139781509306978
eBay Product ID (ePID)242666824

Product Key Features

Number of Pages768 Pages
Publication NameDefinitive Guide to DAX : Business Intelligence for Microsoft Power BI, SQL Server Analysis Services, and Excel
LanguageEnglish
Publication Year2019
SubjectEnterprise Applications / Business Intelligence Tools, Programming Languages / Sql, Desktop Applications / Spreadsheets, Databases / General
TypeTextbook
AuthorMarco Russo, Alberto Ferrari
Subject AreaComputers
SeriesBusiness Skills Ser.
FormatTrade Paperback

Dimensions

Item Height1.5 in
Item Weight42.1 Oz
Item Length9.1 in
Item Width7.4 in

Additional Product Features

Edition Number2
Intended AudienceScholarly & Professional
LCCN2019-930884
TitleLeadingThe
IllustratedYes
Table Of ContentIntroduction 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
SynopsisThis comprehensive and authoritative guide will teach students the DAX language for business intelligence, data modeling, and analytics. Leading Microsoft BI consultants Marco Russo and Alberto Ferrari help students master everything from table functions through advanced code and model optimization. They'll 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 DAX's 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, Now expanded and updated with modern best practices, this is the most complete guide to Microsoft's 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. You'll 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 DAX's 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 · Master core DAX concepts, including calculated columns, measures, and calculation groups · Work efficiently with basic and advanced table functions · Understand evaluation contexts and the CALCULATE and CALCULATETABLE functions · Perform time-based calculations · Use calculation groups and calculation items · Use syntax of variables (VAR) to write more readable, maintainable code · Express diverse and unusual relationships with DAX, including many-to-many relationships and bidirectional filters · Master advanced optimization techniques, and improve performance in aggregations · Optimize data models to achieve better compression · Measure DAX query performance with DAX Studio and learn how to optimize your DAX, Now expanded and updated with modern best practices, this is the most complete guide to Microsoft's 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. You'll 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 DAX's 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 - Master core DAX concepts, including calculated columns, measures, and calculation groups - Work efficiently with basic and advanced table functions - Understand evaluation contexts and the CALCULATE and CALCULATETABLE functions - Perform time-based calculations - Use calculation groups and calculation items - Use syntax of variables (VAR) to write more readable, maintainable code - Express diverse and unusual relationships with DAX, including many-to-many relationships and bidirectional filters - Master advanced optimization techniques, and improve performance in aggregations - Optimize data models to achieve better compression - Measure DAX query performance with DAX Studio and learn how to optimize your DAX, 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 optimization. You'll 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 DAX's 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

All listings for this product

Buy It Now
Any Condition
New
Pre-owned
No ratings or reviews yet
Be the first to write a review