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.

  • European Sales Tableau Dashboard

    Built an interactive Tableau dashboard to track sales, profit, customer count, monthly trends, product performance, and country-level variations across the EU Superstore dataset. Performed data cleaning, validation, and EDA to identify demand patterns, loss-making products, and regional 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

  • Sales Insights Power BI Project

    Built a one-page Power BI dashboard to convert sales and finance data into KPI scorecards, trend views, and guided business insights for review meetings. Applied Power Query ETL, star-schema modelling, and DAX calculations (MoM/QoQ), improving data consistency and reporting reliability through reconciliation checks.

  • 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