Work.

Projects covering reporting, data modelling and analysis. Each case study explains the problem, what I built and how I checked the result.

Open to data and BI roles

Scroll to explore

Retail Reporting & Analysis

Tools
  • SQL Server
  • T-SQL
  • SSMS
Business question

How can a retail-style database be turned into a reusable reporting layer for reliable KPI, customer, product, fulfilment and web analysis?

TypeSQL Reporting & Analysis

Data Professional Salary Survey

Tools
  • Power BI
  • Power Query
  • DAX
  • Excel
Business question

How do reported salaries and career patterns vary across roles, technologies, experience and other respondent characteristics?

TypeBI Dashboard

TV Series Convention Analysis

Tools
  • Excel 365
  • Formulas
  • PivotTables
  • PivotCharts
Business question

How can episode-level convention timing be entered, validated and summarised into reliable series- and episode-level reporting?

TypeExcel Reporting Workbook
MoreWorkThe Python project below is still in development. I'll publish its case study once the analysis and documentation are finished.View project in progressHide project in progress

Python Data Analysis

In progress

Tools
  • Python
  • Pandas
  • Data Visualisation
Business question

To be defined once the dataset and scope are selected.

TypeExploratory Data Analysis

A dashboard or query is easier to trust when its definitions and assumptions are visible. The case studies show those details alongside the final output.

If this is the kind of work you need, let's talk.