This course explores the design and use of data warehouses, lakes, and lakehouses to support business intelligence and decision-making. Students learn modeling, integration, and querying techniques through hands-on labs and projects. Topics include ETL/ELT, OLAP, cloud deployment, and data governance. Emphasis is placed on user needs, system architecture, and analytical performance. The course culminates in a final project where students build and present a complete BI solution.

Course Objectives

• Identify and meet the data needs of different business roles (decision-makers, analysts, engineers).
• Design and implement data warehouse, lake, and lakehouse architectures.
• Apply modeling, integration, and query techniques to support BI.
• Evaluate trade-offs in cloud deployment for data ecosystems.
•  Build and present a full BI project with real-time data and dashboards.