Utkarsh Pandey

Data Analyst | Marketing Analyst | Product Analyst

About Me

Utkarsh Pandey

I am a data analyst specialising in transforming complex datasets into clear, commercially actionable insights. I work across the full analytics stack, from data engineering and modelling in SQL, through statistical analysis and insight generation in Python, to interactive dashboards and data-driven narratives that help organisations make informed decisions.

With experience across multiple industries including SaaS Fintech, E-commerce, Ed-Tech, and Publishing, I have delivered analytics work spanning debt collections optimisation, marketing performance analysis, ROI audit, and product analytics.

My Projects

DebtStream Digital Collections Analysis Preview

DebtStream: Digital Collections Analysis

End-to-end analytics project for a B2B fintech platform analysing 10,000 customer accounts to optimise a digital collections funnel, evaluate an SMS A/B test, and identify recovery risk segments. Built using BigQuery SQL, Python and Power BI.

Documentation View Dashboard
Argos E-Commerce Marketing Analysis Preview

Argos: E-Commerce Marketing Analysis

Complete end-to-end e-commerce marketing analysis for a UK-based retailer covering 4.5 years of data across funnel and conversion analysis, cohort retention and RFM customer segmentation. Built using MySQL, Python and Power BI.

Documentation View Dashboard
Taylor and Francis Marketing ROI Audit Preview

Taylor and Francis: Marketing ROI Audit

End-to-end marketing ROI audit for a global academic publishing firm implementing a last-touch attribution model to evaluate a £650,000 marketing investment across four channels, with K-Means clustering for audience segmentation. Built using MySQL, Python and Power BI.

Documentation View Dashboard
Uber Trip Analysis Power BI Dashboard Preview

Uber: Trip Analysis Dashboard

End-to-end Power BI dashboard analysing 103,728 Uber trips across New York City in June 2024. Covers booking trends, revenue and surge analysis, vehicle and payment type breakdowns, location intelligence, and time-based demand patterns using DAX measures and a dynamic field parameter slicer.

Documentation View Dashboard

Technical Skillset

Data Visualisation

  • Power BI
  • Matplotlib
  • Seaborn
  • DAX Measures

Data Analysis

  • BigQuery SQL
  • MySQL
  • Python (Pandas, NumPy)
  • Statistical Testing
  • AI - Claude Code & Codex

Data Modeling and ETL

  • Power Query (M)
  • Star Schema Design
  • ETL Pipelines
  • Google BigQuery

Send me a message

Interested in collaborating or have questions about my work? I would love to hear from you.