Data Warehouses in Service of BI
summary
Overview of how Business Intelligence teams support decision-making by building data stores and analytical layers, covering techniques like data stream joins, creating data marts (витрины), and data research methods. Discusses practical approaches for combining and curating operational data to enable reliable BI reports and analyses.
AI-written summary · about
chapters (16)
- 0:00BI and data warehouses
- 1:51What is ETL and why
- 3:20ETL data formats
- 7:12Simple ETL example
- 10:23Parallel data loading
- 15:44ETL in distributed systems
- 17:54Event streams and BI
- 21:06Event formalization
- 23:13Hadoop data storage
- 26:50Replication to analytics DB
- 29:00Distributed DB integration
- 33:15ClickHouse and Hadoop
- 36:45ClickHouse and analytics DB
- 39:19Choosing storage solutions
- 42:37Report automation
- 50:23Q&A
related talks
43mBig Data: A tour of the Modern Data Warehouse
31mData Warehouses Meet Data Lakes
01h 01mModern Data Warehousing Strategy
05mThe Future of Data Warehousing
25mFrom Data Warehouse To Self-service BI: Our Journey To Data Mesh
01h 00mBuilding an Effective Data Warehouse Architecture
24mData Pipelines to Dashboards
32mHow to Build a Data Warehouse?