How to architect the perfect Data Warehouse

Key warehousing techniques made simple

Data Warehousing: Simplified

Preprocessing

Unfortunately, not all data is created equally, but it’s data nonetheless and therefore carries value.

Staging

Photo by Hannes Egler on Unsplash

The staging area should also be seen as transient.

Master

Photo by Drew Beamer on Unsplash

You have data that is clean and appropriately named to match the business language, modelled correctly ready for any exploration or calculations to be done downstream.

Reporting

Photo by Micheile Henderson on Unsplash
“Charts with statistics on the screen of a laptop on a glossy surface” by Carlos Muza on Unsplash

All of this from one place, with no joins and most of the heavy lifting done as it should be done, using the power of the data warehouse.

In Summary

Data and Productivity Writer — Data Architect at easyfundraising.org.uk

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store