Tag Archives: data model

My Top 10 ETL Best Practices

It’s been over ten years since I coded my first ever ETL routine. Since then I’ve collected together a number of important lessons and best practices, presented here as my very own ‘Ten Commandments’ of ETL. 1. Know your data Whether you’re defining an ETL strategy, designing a set of data flows or writing the code, the single […]

Data on demand: why a good data model matters

 A new colleague joined my project this week. He has never worked with data architects before and was curious about what, exactly, we do. He knew about the end result: typically an analytical report of some kind, measuring key performance indicators or providing answers to common business questions. “Don’t you just need to write a […]