Brick, Blue Margin's founder and CEO, and Sarah Martinez, one of Blue Margin's Lead Data Visualization Consultants, discuss time intelligence in BI. They talk about the importance of constructing and using a date dimension, and some of the tricks to create reports for different time periods (e.g., yesterday, month-to-date, user-defined time period, etc.) without having to write scores of different measure formulas.
Blue Margin helps private equity and mid-market companies organize their data into dashboards, to support strategy execution and create a culture of accountability. We call it The Dashboard Effect, the title of our book and podcast.
Visit Blue Margin's library of additional BI resources here.
For a free, downloadable copy of our book, The Dashboard Effect, click here, or buy a hardcopy or Kindle version on Amazon.
#timeintelligence #businessintelligence #visualization #DAX #calculationgroup #reporting #BI #dashboard #datawarehouse
