Back to Portfolio

Haggis Hopper Taxi Business Insights - Case Study

Kin Karta Consulting
United Kingdom
Academic Project (Strathclyde Business School)
Data Analyst/Data Scientist
Interactive Tableau Dashboard for business stakeholders View Analysis Dashboard in Streamlit App View on GitHub

Project Goal

Use Haggis Hopper’s historical trip data to uncover where, when, and how demand fluctuates across Glasgow so the company can allocate its fleet more efficiently, improve passenger experience, and support sustainable growth.

Key Activities

  • Cleaned and prepared multi-source trip data for robust analysis and forecasting.
  • Explored temporal and geospatial demand patterns to identify hotspots and under-served areas.
  • Built Tableau dashboards for business stakeholders to monitor demand, revenue, and fleet performance.
  • Experimented with time-series and machine learning models to forecast short-term taxi demand.
  • Translated findings into concrete recommendations on fleet deployment and service design.

Quantitative Analysis Visuals

Interactive Tableau Highlights

Skills Used

Data Analysis Geospatial Analysis Time Series Analysis Forecasting Machine Learning Dashboard Design

Tech Stack

Programming & Tools
Python SQL Tableau Streamlit
Data & Time Series Analysis
Time Series Analysis Forecasting Outlier Analysis Feature Engineering
Visualization & Dashboards
Interactive Dashboards Data Visualization Stakeholder Reporting