University competitor research
Compared nearby universities by course offerings and fees, then compiled the findings in Excel to support Aberystwyth University’s internal reporting and evidence-based decisions.
Junior Data Analyst · London, UK
Analysis that makes the next decision clearer.
I turn business questions and complex datasets into structured analysis, clear visuals and practical findings. My portfolio covers Excel, SQL, Power BI, Tableau and Python/Pandas, supported by business intelligence and operational experience.
Level 3
Data Technician practical training completed in July 2026
68%
First-year Economics & Business Management average at 2:1 standard
1st place
Essex Aces at the 2026 NSE Summer Alumni tournament
Profile
Commercial thinking, practical analysis.
I have independently analysed different types of data through professional work, competitive esports and personal projects. I focus on the information that will genuinely improve a decision, then present it in a way the audience can use.
My approach is straightforward: understand the question, structure the data, find the meaningful pattern and communicate it clearly. Alongside technical skills, I bring customer service, teamwork, organisation and experience working accurately in fast-paced environments.
- 01Clarify the business question and the decision the analysis needs to support.
- 02Clean, validate and restructure the data before drawing conclusions.
- 03Prioritise useful measures over collecting information without a clear purpose.
- 04Translate findings into concise reports, dashboards and recommendations.
Applied analysis
Evidence beyond coursework.
These examples show how I have used data in different settings: business research, performance improvement and independent decision-making.
Essex Aces esports
Analysed team and individual performance, recurring mistakes, opponent tendencies and strategic patterns. Presented findings through Excel, Tableau and Power BI so coaches and players could prepare and improve.
Financial and gameplay data
Used company financial statements to support personal investment research and analysed Football Manager performance data, strengthening my ability to define useful measures in unfamiliar datasets.
Portfolio
Current and completed projects.
Projects are framed around the business question, analytical process and result, rather than simply listing the software used.
Household inflation by income
Using Office for National Statistics data to investigate whether lower-income UK households experienced higher inflation than higher-income households between January 2016 and March 2026, and which spending categories explain the difference.
01
RestructureClean and reshape detailed ONS reference tables into an analysis-ready dataset.
02
CompareTrack inflation for lower- and higher-income groups across the ten-year period.
03
ExplainInvestigate which household spending categories drive differences between groups.
04
CommunicateBuild clear charts and a concise methodology for technical and non-technical readers.
Product and sales dashboards
Transformed data with Power Query, defined table relationships and created KPI visuals, slicers and introductory DAX measures to surface product and sales performance.
View portfolio on GitHubNorthwind and World database analysis
Used filtering, aggregation, GROUP BY, INNER and LEFT JOINs in MySQL Workbench to answer business-style questions and practise relational schema design.
View portfolio on GitHubMulti-dataset dashboards
Created dashboards using Spotify, life expectancy and Great Britain employment data, applying maps, line, bar and scatter charts to communicate trends clearly.
View portfolio on GitHubAnalysis and data preparation
Completed Excel analysis using PivotTables, lookups, correlations, t-tests and descriptive statistics, and used Python/Pandas to import, clean, filter and summarise datasets.
View portfolio on GitHubExperience
Where I’ve worked.
A combination of analytical, operational and customer-facing experience has built my attention to detail, reliability and ability to communicate with different audiences.
Aug 2026 – Present
Ocado Logistics
Personal Shopper
- Work accurately and efficiently in a target-led warehouse environment while maintaining quality and safety standards.
- Manage time-critical tasks reliably and contribute to team performance across busy shifts.
Feb 2025 – Oct 2025
Kinect Services
Mobility Support Officer
- Supported children and young adults with disabilities while maintaining safeguarding standards.
- Monitored individual needs, escalated concerns and communicated accurately with parents, carers and transport staff.
Jan 2023 – Oct 2024
The Merchant / Slug and Lettuce
Floor Supervisor / Bartender
- Oversaw opening, closing, stock management, compliance and customer service in a fast-paced environment.
- Trained staff, coordinated activity during high-volume shifts and resolved customer issues professionally.
Jun 2022 – Aug 2022
Aberystwyth University
Business Intelligence Assistant
- Produced competitor and research analysis in Excel to support internal reporting and evidence-based decisions.
- Updated website content through a CMS and coordinated meetings, schedules and minutes using Microsoft Teams.
2018 – 2021
Additional experience
Sales, administration and alumni engagement
- Handled stock, cash reconciliation, invoices, correspondence, client documentation, alumni calls and research tasks using Microsoft Office.
Qualifications
Education and training.
Completed technical training is kept separate from employment, making the distinction between qualifications and workplace experience clear.
Completed July 2026
Level 3 Data Technician Skills Bootcamp
Leep Group
Practical training across Excel, SQL, Python, Power BI, Tableau and Azure fundamentals, including data cleaning, database design, modelling, visualisation, reporting, GDPR and validation.
Completed April 2026
Level 2 Digital Skills Diploma
Digital Skills / Data Technician Training
Covered Excel, SQL, databases, workplace IT, digital project work and presentations, including PivotTables, charts, lookup functions, correlations and statistical outputs.
2021
Economics & Business Management
Aberystwyth University · First year completed
Achieved a 68% average at 2:1 standard and developed foundations in economics, business research and evidence-based decision-making.
2012 – 2019
A Levels and GCSEs
English Literature · History · Drama
11 GCSEs at grades A–C, including Maths and English.
Additional industry exposure: Bright Network Finance & Professional Services Experience; Bright Network Investment Banking Internship Experience; FutureLearn Managing the Household Balance Sheet; Charles Stanley Investment Management Industry Exposure Programme.
Capabilities
Tools and working strengths.
A focused toolkit for collecting, cleaning, analysing and presenting data, combined with the professional skills needed to work effectively with people.
Technical tools
- Excel · PivotTables · lookups
- SQL · MySQL Workbench
- Power BI · Power Query · DAX fundamentals
- Tableau
- Python · Pandas · Jupyter Notebook
- GitHub · Microsoft Office · Azure fundamentals
Data and analysis
- Data cleaning and validation
- Relational databases and JOINs
- Data modelling
- Descriptive statistics and correlation
- T-tests
- Dashboards and reporting
Professional strengths
- Clear communication
- Attention to detail
- Organisation and time management
- Customer service
- Teamwork and safeguarding
- Practical problem-solving
Contact
Looking for a junior analyst who can learn, deliver and communicate?
I’m open to junior data analyst, business intelligence and reporting roles in London and hybrid environments. My GitHub contains the technical work behind this portfolio.