Sale!

DAX Patterns 2nd Edition by Marco Russo, Alberto Ferrari ISBN 1735365211 9781735365213

Original price was: $50.00.Current price is: $35.00.

DAX Patterns 2nd Edition Russo Digital Instant Download

Author(s): Russo, Marco; Ferrari, Alberto
ISBN(s): 9781735365206, 1735365203
Edition: 2
File Details: PDF, 44.03 MB
Year: 2020
Language: english
SKU: EB-23268220 Category: Tags: , , ,

DAX Patterns 2nd Edition by Marco Russo, Alberto Ferrari – Ebook PDF Instant Download/Delivery: 1735365211, 9781735365213

Full download DAX Patterns 2nd Edition after payment

 

Product details:

ISBN 10: 1735365211

ISBN 13: 9781735365213 

Author: Marco Russo, Alberto Ferrari 

A pattern is a general, reusable solution to a frequent or common challenge. This book is the second edition of the most comprehensive collection of ready-to-use solutions in DAX, that you can use in Microsoft Power BI, Analysis Services Tabular, and Power Pivot for Excel.

The book includes the following patterns: Time-related calculations, Standard time-related calculations, Month-related calculations, Week-related calculations, Custom time-related calculations, Comparing different time periods, Semi-additive calculations, Cumulative total, Parameter table, Static segmentation, Dynamic segmentation, ABC classification, New and returning customers, Related distinct count, Events in progress, Ranking, Hierarchies, Parent-child hierarchies, Like-for-like comparison, Transition matrix, Survey, Basket analysis, Currency conversion, Budget.

Table of contents:

Chapter 1: Time-related calculations

  • Standard time-related calculations

  • Introduction to time intelligence calculations

  • What are standard DAX time intelligence functions

  • Disabling the Auto Date/Time

  • Limitations of standard time intelligence functions

  • Building a Date table

  • Controlling visualization in future dates

  • Naming convention

  • Computing period-to-date totals (Year-to-date, Quarter-to-date, Month-to-date)

  • Computing period-over-period growth (Year-over-year, Quarter-over-quarter, Month-over-month)

  • Computing period-to-date growth

  • Comparing period-to-date with previous full period

  • Using moving annual total calculations and moving averages

Chapter 2: Month-related calculations

  • Introduction to month-related time intelligence calculations

  • Managing years with more than 12 months

  • Similar topics as in Chapter 1 but focused on month granularity

Chapter 3: Week-related calculations

  • Introduction to week-related time intelligence calculations

  • Understanding filter-safe columns

  • Week-to-date total

  • Week-over-week growth

  • Moving average 4 weeks, 1 quarter, 1 year

Chapter 4: Custom time-related calculations

  • Introduction to custom time intelligence calculations

  • Similar calculations as before but customized

Chapter 5: Comparing different time periods

  • Pattern description

Chapter 6: Semi-additive calculations

  • First and last date

  • Opening and closing balance

  • Growth in period

Chapter 7: Cumulative total

  • Basic scenarios

  • Cumulative total on sortable columns

Chapter 8: Parameter table

  • Changing scale of a measure

  • Multiple parameters (independent/dependent)

  • Dynamic top N selections

Chapter 9: Static segmentation

  • Price ranges by category

Chapter 10: Dynamic segmentation

  • Clustering examples

Chapter 11: ABC classification

  • Static, snapshot, dynamic ABC classification

Chapter 12: New and returning customers

  • Patterns and measures for customer lifecycle analysis

Chapter 13: Related distinct count

Chapter 14: Events in progress

  • Open orders and snapshots

Chapter 15: Ranking

  • Static and dynamic ranking examples

Chapter 16: Hierarchies

  • Detecting current level

  • Percentage of parent node

Chapter 17: Parent-child hierarchies

  • Basic patterns

  • Security patterns

Chapter 18: Like-for-like comparison

  • Same store sales analysis

Chapter 19: Transition matrix

  • Static and dynamic matrices

Chapter 20: Survey

  • Pattern description

Chapter 21: Basket analysis

  • Association rules metrics: Support, Confidence, Lift

  • Sample reports

Chapter 22: Currency conversion

  • Multiple source and reporting currencies

Chapter 23: Budget

  • Data model

  • Business choices and forecast allocation

  • Showing actuals and forecasts

People also search for:

z-pattern examples
 
dax metal designs
 
dax martin designs
 
dax patterns marco russo
 
l dax
 
dax k
 
j dax hansen perkins coie
 
j patterns

Tags: Marco Russo, Alberto Ferrari, DAX, Patterns