Tag Archives: data warehouse
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 […]
BI 101: What is a data warehouse?
It is fair to say that the foundation stone upon which nearly every BI solution is built is the data warehouse. So what is it, and what makes it different from a conventional database? The first thing to stress is that a data warehouse is still a type of database. What makes it different is […]
BI 101: What is Business Intelligence?
For the uninitiated, the term “business intelligence” has the potential to generate quite a lot of questions. When is business ever unintelligent? How is it different from business analysis? What tools and skills does it employ? Why is it important? Would my business benefit from it? This first post in the “BI 101” series begins […]
Busy Intelligence 