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

Routledge Marketing Analytics Dashboard Preview

Routledge: Marketing Analytics and FY2026 Budget

End-to-end marketing analytics for a publisher's direct book sales across three years of data: a full data audit, a reconciliation of what Google and Meta claim against real orders, attribution under four rules, customer value and payback by channel, affiliate commission terms and an FY2026 paid media budget. Built using BigQuery SQL, Python and Power BI.

Visit Project Read Report
Blinkit AWS Sales Pipeline Preview

Blinkit: AWS End-to-End Sales Pipeline

End-to-end cloud data pipeline and sales analytics project built entirely on AWS, analysing Blinkit grocery sales data across multiple item categories and outlet types. Covers automated file ingestion via a scheduled SageMaker notebook, serverless querying through Athena, and a live Power BI dashboard connected via ODBC.

Visit Project View Dashboard
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.

Visit Project Read Report
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.

Visit Project Read Report
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.

Visit Project View Dashboard

Technical Skillset

Data Visualisation

Power BI DAX Measures Matplotlib Seaborn

Data Analysis

Python (Pandas, NumPy) SQL BigQuery Excel Statistical Testing AI (Claude & Codex)

Data Modeling and ETL

Star Schema Design ETL Pipelines Power Query (M)

Cloud and Data Engineering

AWS S3 AWS SageMaker AWS Athena AWS Redshift ODBC

Send me a message

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