The Basics of a Good Analytics Data Warehouse

By Medium - 2021-03-17

Description

An analytics data warehouse stores essentially the same data generated by transactional databases — nothing more, nothing less. But whereas a transactional database may be designed to be as fast as…

Summary

  • Properly Layering your Data into L1, L2 and L3 Layers An analytics data warehouse stores essentially the same data generated by transactional databases — nothing more, nothing less.
  • The goal of the analytics data warehouse is to enable a data scientist (or interchangeably analyst) to rapidly mix data to answer complex questions and discover useful information that is not obvious.
  • Another example is “How many orders did we have by business segment”?
  • If it takes the analyst more than 2 minutes to quickly review the papers on the wall and write out the basic pseudo-code (or if you know the pseudo-code is wrong because the documentation is out of date) then you don’t have a good data model or proper documentation.

 

Topics

  1. Backend (0.33)
  2. Database (0.21)
  3. UX (0.14)

Similar Articles

15 Essential Steps To Build Reliable Data Pipelines

By Medium - 2020-12-01

If I learned anything from working as a data engineer, it is that practically any data pipeline fails at some point. Broken connection, broken dependencies, data arriving too late, or some external…