Data-Warehouse-and-OLAP-for-Healthcare-Analytics

This project investigates the development of a data warehousing and Online Analytical Processing (OLAP) framework for improved healthcare data analysis.

• Anonymized data from the SeriousMD platform is utilized.
• A star-schema data warehouse is designed for efficient data storage and retrieval.
• A comprehensive Extract, Transform, Load (ETL) process ensures data integrity.
• An OLAP application enables advanced analytical queries using functionalities like roll-up, drill-down, slice, and dice.
• Rigorous query processing and optimization techniques significantly improve performance.

Paper:

This project is further detailed in the following paper: STADVDB MCO1 Technical Paper

OLAP Application

To test out the application, visit the Tableau Public App