Market & Competitor Analysis — Sample Case Study I transformed complex market information into a clear, decision-ready research brief: market trends, competitor positioning, key opportunities, and actionable recommendations.

This sample demonstrates how I use AI-assisted research and structured analysis to turn scattered information into concise insights that help businesses make faster, better-informed decisions.

Excel PivotTable — Sales Summary

Client had raw sales data (14 rows across UK/USA, split by quarter) and needed it turned into something actually usable. I cleaned it up and built a PivotTable that breaks total sales down by rep and country, with grand totals for both.

What I did:

Structured the raw data into a proper table (consistent headers, currency formatting)

Built a PivotTable summarizing Sum of Sales by Last Name and Country

Used SUMIFS so the totals update automatically if the source data changes — nothing hardcoded

Checked every formula for errors before delivery

Delivered as a working .xlsx file, ready to plug into a bigger report or dashboard.

If you've got messy sales/ops data sitting in a spreadsheet and need it turned into something you can actually read at a glance, this is exactly the kind of thing I can help with.