Skip to content
Horse Before the Cart - Start With the Reporting Need episode artwork

Sep 1, 2022 9 min

Horse Before the Cart - Start With the Reporting Need

from The Dashboard Effect Hosted by 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

Episode details come from the podcast's RSS feed.

Embed this episode

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...

Ready to play

Horse Before the Cart - Start With the Reporting Need

0:00 9:42

No transcript yet.

Requests help us decide what to transcribe next.

Frequently asked questions

How long is this episode of The Dashboard Effect?

This episode is 9 minutes long.

When was this The Dashboard Effect episode published?

This episode was published on September 1, 2022.

Is there a transcript available for this episode?

Yes, a full transcript is available for this episode. You can read the complete transcript on the episode page.

Can I download this The Dashboard Effect episode?

Yes. Use the download control on the episode player to save the publisher-provided media file.