Portfolio

Data Analyst — Python, SQL, Power BI — end-to-end projects from raw data to insight

B.Sc. Computing Systems at Ulster University (predicted First Class), based in London. I like problems where the messy bit is not the model, but the join: calendars, hubs, duplicates, and definitions that change depending who is asking.

Portrait of Doniyor Mekhmonov

About

I did not come to data because spreadsheets sounded easy — I came because I enjoy turning vague questions into something testable. A number on its own is rarely interesting; what hooks me is the chain from definition → query → chart → decision. That is why my public work spans three different shapes of data: public mobility (Santander Cycles in R), structured sport results (Premier League in Python), and transactional retail (Apple global sales in MySQL with views and stored procedures).

Practically, that means I am comfortable owning a slice end-to-end: load and clean, document assumptions, explore, visualise, and (where SQL allows) leave the next analyst a procedure instead of a one-off SELECT. My GitHub is the proof surface — notebooks, R Markdown, and ordered SQL files you can open without my narration.

I work part-time on the floor at Aqua Shard while studying full-time, which sharpened pace, accuracy, and communication under pressure — the same habits I bring when presenting findings. I am looking for a Data Analyst internship (consulting-flavoured teams especially) where I can support client delivery with rigorous SQL/Python and clear reporting — including Power BI as I grow that stack (see upcoming work below).

Technical skills

Levels are honest signals, not decoration — tied to what I have actually shipped in repos and coursework.

Strong / shipped in projects

  • Python Advanced Used end-to-end in Premier League analysis (Pandas, Jupyter, 15+ charts).
  • SQL (MySQL) Intermediate Apple SQL project: schema, load, 30 business questions, CTEs, windows, views, stored procedures.

Core + growing

  • R Intermediate London bike analysis in R Markdown / ggplot2-style workflow.
  • Power BI Intermediate Dashboard coursework + upcoming public dashboard project (see below).
  • Excel · Jupyter · Git · VS Code / RStudio Daily tools Versioned work, reproducible notebooks, collaborative norms.

Competencies

  • Data cleaning & wrangling
  • Exploratory data analysis
  • Visualisation & reporting
  • Dashboard design (in progress)

Projects

Click a card to open the full write-up, charts where relevant, and the GitHub repository.

Upcoming

Power BI — public dashboard

Starting next

A publishable Power BI report (theme, drill-through, and DAX measures documented) on a dataset I can redistribute — aimed at hiring managers who want “click the .pbix” proof, not screenshots only.

Python — portfolio “signature” notebook

Pipeline + narrative

One tightly edited notebook that reads top-to-bottom: question → data checks → transformation → model-free insight → limitations. Same bar as my football work, different domain.

Work experience

Floor staff — Aqua Shard, London

Jun 2025 – Present | Part-time (~20 hrs/week)

  • High-standard guest service in a fine-dining, high-expectation environment.
  • Balanced with full-time study while maintaining a First Class average.
  • Composure, precision, and clear communication under pressure.

Education & awards

Ulster University — B.Sc. Computing Systems

Sep 2024 – May 2027 | London, England

Predicted classification: First Class | Year 1 average: 75%+

Key modules: Databases, Statistics, Machine Learning, Algorithms, Software Engineering

Dean's List

Academic excellence, Ulster University (2024–2025).

Contact me

Send a message — I usually reply within a day or two.