In this lecture, we explore the foundational concepts of data modelling and database design that underpin Business Intelligence systems.
Topics covered:
• Databases: source systems (Data Lakes, OLTP) vs destination systems (Data Marts, OLAP)
• Data types: structured vs unstructured data
• Data modelling, design patterns, and database schemas
• Dimensional modelling: facts, dimensions, and attributes
• Fact tables and dimension tables
• Star schemas vs snowflake schemas
• Database types: OLTP/OLAP, row-based/columnar, single-homed/distributed
• Data warehouse design — walkthrough using a bookstore case study
