The Five Laws of Data Warehousing

My sincere apologies to Issac Asimov.

  1. Software is automation. Data warehouses are software. Your data warehouse should be a robot, programmed and tuned to provide the right data to the right people at the right time, while constantly checking itself for errors and inconsistencies.

  2. Model your business, not your source systems. Your competitive advantage is your unique perspective of your market. Build that into your data models.

  3. Never scale your team to keep up with the day-to-day, you should only grow your team because you have harder engineering problems to solve.

  4. “Big data is what happened when the cost of storing information became less than the cost of making the decision to throw it away.” (George Dyson via Tim O’Reilly)

  5. As far as your business is concerned, the reports are the warehouse. Everything between the report and the source systems is overhead.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s