Wrap-up

Các khái niệm về Kho dữ liệu (Data Warehouse)

Aaren Stubberfield

Data Scientist

What we covered - Chapter 1

Data Warehouse Basics

  • What is a data warehouse?
  • Data warehouse life-cycle
  • Comparing to data lakes and marts

an image of the number one on an orange background

Các khái niệm về Kho dữ liệu (Data Warehouse)

What we covered - Chapter 2

Warehouse architectures and properties

  • Warehouse layers
  • Inmon vs Kimball designs
  • OLAP and OLTP systems

an image of the number two on a brown background

Các khái niệm về Kho dữ liệu (Data Warehouse)

What we covered - Chapter 3

Data warehouse data modeling

  • Fact and dimension tables
  • Slowly changing dimensions
  • Row / column store
  • Kimball's four-step process

image of the number three on a black background

Các khái niệm về Kho dữ liệu (Data Warehouse)

What we covered - Chapter 4

Data cleaning and other considerations

  • ETL / ELT processes
  • Data cleaning
  • On-premises / in the cloud implementations

image of a four on a green background

Các khái niệm về Kho dữ liệu (Data Warehouse)

Things we didn't cover

  • SQL fundamentals
  • Building data pipelines
  • Analyzing warehouse data
Các khái niệm về Kho dữ liệu (Data Warehouse)

Learning more

Books:

  • The Data Warehouse Toolkit, Third Edition: The Definitive Guide to Dimensional Modeling (by Kimball)
  • Building the Data Warehouse (by Inmon)
  • DAMA - Data Management Body of Knowledge (by DAMA International)

DataCamp courses:

  • Understanding Data Engineering
  • Introduction to Power BI
  • Intermediate SQL Server
Các khái niệm về Kho dữ liệu (Data Warehouse)

Good bye and thank you!

Các khái niệm về Kho dữ liệu (Data Warehouse)

Preparing Video For Download...