article thumbnail

How to Build a Performant Data Warehouse in Redshift

Sisense

First, we’ll dive into the two types of databases: OLAP (Online Analytical Processing) and OLTP (Online Transaction Processing). Think of it like something that houses the metrics used to power daily, weekly, or monthly business KPIs. roll-ups of many rows of data). Data architecture.