Selected Analytics Projects

Examples of forecasting systems, dashboards, and reporting workflows built to support better business decisions.

Stock Forecasting and Investment Decision Support System

A web-based investment decision-support platform combining machine-learning forecasting with portfolio optimisation.

  • Built and compared ElasticNet, LightGBM, and LSTM forecasting models
  • Created an ensemble forecasting framework
  • Used Modern Portfolio Theory for portfolio optimisation
  • Applied Ledoit-Wolf covariance estimation
  • Evaluated models using RMSE, MAE, MASE, and directional accuracy
  • Used walk-forward backtesting to reduce look-ahead bias
PythonPandasNumPyScikit-LearnTensorFlowLightGBMReact

Marketing Performance Dashboard

A central dashboard designed to help a digital marketing team monitor campaign performance and make faster optimisation decisions.

  • Combined multiple campaign metrics
  • Tracked weekly performance
  • Monitored more than five key metrics in one view
  • Highlighted trends and optimisation opportunities
  • Supported better budget allocation decisions
ExcelPythonPandasData Visualisation

Automated Business Reporting Pipeline

A Python and SQL reporting workflow that cleans, validates, transforms, and prepares business data for analysis.

  • SQL queries using joins, CTEs, aggregations, and window functions
  • Automated data-processing scripts
  • Data validation and cleaning
  • Exploratory analysis
  • Stakeholder-ready reports and visualisations
PythonSQLPandasNumPyExcel

Have a Similar Project in Mind?

Tell me about your reporting or analytics challenge, and we can discuss how a similar approach could work for your business.

No technical knowledge is required. Explain the problem in simple words, and we can identify the right solution together.