Data analytics projects and solutions I've built to solve real-world problems.
I've worked on various data analytics projects that combine technical skills with practical applications. These projects demonstrate my expertise in SQL, Python, R, MongoDB, and data visualization tools like Tableau and Power BI.
Public Healthcare Dashboard
Built comprehensive Tableau dashboards to track KPI trends, deviations, and quality indicators. Performed data cleaning, validation, and EDA to identify performance bottlenecks and service-level deviations. Applied analytical techniques from MSc modules including relational modelling and statistical trend identification.
Tableau Project
Car Price Forecasting
Applied regression models using R programming to detect trends and patterns in car pricing data. Conducted EDA, feature engineering, and distribution checks. Used statistical tests and model diagnostics (RMSE, residual analysis) to validate assumptions and compared multiple regression techniques.
R Project
MongoDB Aggregation Framework
Designed aggregation pipelines to analyze activity patterns and inconsistencies across media channel reporters. Built data models with grouping, filtering, and join operations. Conducted anomaly detection using statistical thresholds and performed data profiling for scalable reporting.
MongoDB Project
PII Encryption Tool
Developed a Python-based tool to detect and encrypt PII, strengthening compliance and reducing manual errors. Automated QA workflows with exception logs and error detection. Applied statistical checks to ensure encrypted outputs matched expected distribution patterns.
Python Project
Optical Stegnography for security enhancement
Developed an optical steganography tool using Python to embed secret messages in images. Implemented encryption and decryption algorithms to ensure secure communication. Conducted performance analysis and compared different steganography methods for optimal results.
Python Project