How to architect the perfect Data Warehouse

Key warehousing techniques made simple

Image for post
Image for post
Data Warehousing: Simplified

Preprocessing

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

Staging

Image for post
Image for post
Photo by Hannes Egler on Unsplash

The staging area should also be seen as transient.

Master

Image for post
Image for post
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

Image for post
Image for post
Photo by Micheile Henderson on Unsplash
Image for post
Image for post
“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

Written by

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