A full-stack data analytics platform that ingests, stores, and visualises social media engagement metrics — built on MySQL, PHP, and Python.
A normalised MySQL schema stores posts, users, reactions, and time-series engagement data. Queries are optimised with indexing and stored procedures to handle large datasets efficiently.
RESTful endpoints built in PHP expose the database to the frontend, handling authentication, CRUD operations, and data serialisation to JSON for consumption by the dashboard.
Python scripts using Pandas and Matplotlib handle data ingestion, cleaning, and statistical analysis — generating trend reports and exportable visualisations for the final dashboard.
A responsive HTML/CSS/JS interface presents analytics through interactive charts, filterable tables, and summary cards — all served statically via GitHub Pages.