EPISODE · Sep 1, 2022 · 9 MIN
Horse Before the Cart - Start With the Reporting Need
from The Dashboard Effect · host Brick Thompson, Jon Thompson, Caleb Ochs
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
What this episode covers
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 dashboard...
NOW PLAYING
Horse Before the Cart - Start With the Reporting Need
No transcript for this episode yet
Similar Episodes
No similar episodes found.
Similar Podcasts
No similar podcasts found.