Designed and implemented a retail OLAP data warehouse using SQL and Python to support analytical reporting and business intelligence. The project involved extracting transactional retail data from a flat file, transforming the data into a dimensional model, and loading it into a star-schema warehouse for querying and analysis.
- Create a realistic retail analytics warehouse
- Implement dimensional modelling
- Separate transactional and analytical structures
- Improve query performance using indexing
- Enable analytical reporting and future dashboard integration
For GDPR purposes, this project does not feature real life data - all data is synthetic.
The intial data state is a flat file containing all business transactions for a retail business.
DBDiagram.io - Create inital ERD mock up
SQL - Database manipulation