Practice Project — Dimensional Modeling

Designed a data warehouse in Access, developing queries to present analytical insights.

Date: 21 March 2025
Tools: Access
Skills: Dimensional Modeling
Domain: Education

Overview

This project was part of BAN 545 – Dimensional Modeling at Northern Arizona University.
The goal was to design a star schema and create queries to present analytical insights.

📂 Deliverables

📈 Access Database

🔍 Key Learnings

Built and normalized fact/dimension tables with referential integrity
Created queries to present analytical insights