Horse Before the Cart - Start With the Reporting Need

Brick and Caleb discuss the best practice of understanding likely reporting needs before architecting a data warehouse, versus just pulling all of the data into the data warehouse. It's OK to have all of the data pulled into a Persisted Staging area, or into a data lake, but overengineering the data warehouse and reporting views and cubes lengthens the time to get to reports and can result in rework.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.#ETL #businessintelligence #datamodeling #reporting #BI #dashboard #datawarehouse