Skip to content
Mohsen Fazeli

Applications

Solutions

This page describes analytical tools I have built. You will find data systems, forecasting models, and dashboards developed for passenger transportation regulation and education planning.

  1. Automated Assessment Report Generator

    BC Passenger Transportation Board

    Developed an automated reporting system that produces comprehensive, approximately 30-page assessment reports for passenger transportation licence applications. The tool generates market indicators, visualizations, and written interpretations tailored to each application's proposed operating area, providing decision-makers with a consistent, evidence-based assessment of regional transportation conditions, market demand, and existing service capacity.

    • R
    • Shiny
    • Quarto
    • Excel
    • Git

    View repository (opens in a new tab)

  2. Transportation DataHub

    BC Passenger Transportation Board

    Developed an automated data integration and processing system that consolidates information from multiple government, industry, and public sources into a standardized transportation dataset. The system validates incoming information, identifies data-quality issues, and calculates consistent industry indicators, producing analysis-ready datasets that support regulatory assessments, economic monitoring, and research across British Columbia.

    • R
    • SQL
    • SQL Server
    • Excel
    • Python
    • Quarto
    • Git

    View repository (opens in a new tab)

  3. Transportation Dashboard

    BC Passenger Transportation Board

    Developed and published an interactive dashboard providing a comprehensive overview of British Columbia's taxi and ride-hailing industries, including passenger demand, industry activity, fares, service availability, and market trends. The dashboard improves public access to industry information, helps transportation businesses understand the economic evidence considered in regulatory decisions, and supports greater transparency in the Board's oversight of the industry.

    • R
    • Shiny
    • Power BI
    • SQL Server
    • Git

    View repository (opens in a new tab)

  4. BC Pickup Density Heatmap

    BC Passenger Transportation Board

    Developed an interactive geographic visualization of passenger pickup activity across British Columbia, identifying areas of concentrated transportation demand and variations in service usage. The tool supports geographic service coverage assessments, congestion studies, and the identification of high-demand locations, providing evidence to inform traffic management, fleet capacity planning, and transportation licensing decisions.

    • Power BI
  5. Trip Demand Forecasting Model

    BC Passenger Transportation Board

    Developed a forecasting tool to estimate changes in passenger transportation demand across British Columbia over a five-year horizon, accounting for historical travel activity and regional market developments. The model provides forward-looking estimates to support fleet capacity assessments, transportation service planning, and regulatory decisions concerning future vehicle requirements.

    • R
    • SQL Server
    • Git

    View repository (opens in a new tab)

  6. BC Teacher Supply-Demand Model

    BC Ministry of Education and Child Care

    Developed an analytical planning tool to assess teacher supply and demand across British Columbia's school districts, using Python web scraping to collect teaching job postings as an indicator of labour demand and newly issued teacher certifications as an indicator of workforce supply, then bringing these sources together in Power BI. The tool identifies regional workforce imbalances, monitors emerging teacher shortages, and supports provincial education workforce planning and resource allocation decisions.

    • Python
    • Power BI
  7. Student Enrolment Forecast Model

    BC Ministry of Education and Child Care

    Developed a Python forecasting model that produces annual student enrolment projections for individual school districts across British Columbia, incorporating historical enrolment patterns, demographic developments, and federal government permit targets to account for changes in immigration-related student populations. The projections support provincial education planning by anticipating shifts in student demand, informing future school capacity and staffing requirements, and supporting evidence-based school district funding allocations.

    • Python