Term Project — Dimensional Modeling

Designed a data warehouse in Access and created queries for meaningful insights.

Date: 17 April 2025
Tools: Access, Excel
Skills: Dimensional Modeling
Domain: Education

Overview

This project focused on creating a dimensional data warehouse using Access, with fact and dimension tables connected through primary keys.
Excel was used to validate outputs via pivot tables.

📂 Deliverables

📊 Excel Workbook
📁 Access Database

🔍 Key Learnings

Built star schema relationships with referential integrity
Applied ETL principles for data transformation and validation