Decided to turn a recent post into a YouTube video. --- A data warehouse acts as the main hub for most data teams, yet it often becomes a mess. While there are many different strategies to handle this, in this video I want to share the approach I follow. It's based around a simple 3-layered design to take raw source data into meaningful data marts ready for analytics. Enjoy!

Do you think its worth it to create templates like with cookie cutter in order to automate the create of basic modules, project structure etc? One issue with this approach in my opinion is that almost every project is different and many times even small differences in the user-case requirements may require big differences in the overall data workflow.