TC Data Consultants

My work

Projects & case studies

Products I've built and problems I've solved for clients, from a nationwide transport data API to the dashboard that runs a local salon.

Featured

Products & brands

Product ยท Data API

TransCAPI

A Great Britain transport data API: every stop, every timetable, one API key. Bus, tram and rail across England, Scotland and Wales, with live train and bus positions, disruptions matched to your route, journey planning, reachability maps and measured punctuality, all built from official open data and served as plain JSON.

  • API design
  • Data pipelines
  • Live data
  • Geospatial
Visit transcapi.com

Client project

SEP Brands

Case study coming soon.

    Client case studies

    Real problems, measurable results

    Hair & beauty

    Data dashboard for a hair and beauty salon

    A custom dashboard giving the salon owner real-time insight into the numbers that matter, built on data imported from their Fresha booking system.

    • Daily and monthly revenue tracking to monitor performance
    • Appointment analysis to spot peak times and plan staffing
    • Customer retention insights to support loyalty strategies
    • Product sales reporting to highlight best-sellers and stock trends

    Result: Hours saved every week and clearer, data-driven decisions that improved profitability.

    Logistics

    Lead generation for a London last-mile delivery service

    A targeted lead list built from Companies House data to find the businesses most likely to need last-mile delivery.

    • Extracted active companies in relevant industries from Companies House
    • Filtered by location to London-based businesses only
    • Enriched with extra sources to gauge delivery needs and business size
    • Scored every lead by its likelihood to convert

    Result: A structured, highly targeted list that powered effective outreach and won new business.

    Sales & CRM

    Data cleansing and consolidation for a CRM

    Multiple overlapping spreadsheets merged into a single, trustworthy CRM database.

    • Merged customer records from several sources
    • Deduplicated entries to remove redundancy
    • Standardised addresses, phone numbers and company names
    • Corrected errors, gaps and outdated information

    Result: A clean, reliable CRM the client could use with confidence for sales and targeted marketing.

    Have a project in mind?

    Let's talk about what you'd like to build and how data can get you there.

    Start a conversation