Development of a Data Warehousing and OLAP Reporting Dashboard

Data Science — 2025, Undergraduate

This study developed a data warehousing and OLAP reporting dashboard that consolidates multi-source data into dimensional models and supports slice, dice, and drill-down analysis. Users build reports from cubes and export summaries. Adopting a client-server architecture and a survey-based usability evaluation, the system was built using Python, Django, Pandas, and PostgreSQL. The findings showed that the dashboard reduced report turnaround and improved analytical flexibility, while achieving a high System Usability Scale score. The study recommends adoption by institutional planning units.

Homepage screenshot

Report a problem with this project