6 May 2026 → 4 June 2026 · One commit every single day · Goal: land a UK Data Analyst job
I'm an MSc Applied CS & AI graduate building job-ready data analytics skills in 30 days. Every day I learn, build something, and push it here. No skipping. Every day counts.
| # | Date | Topic | Tools | Status |
|---|---|---|---|---|
| 01 | 6 May | SQL basics — SELECT, WHERE, ORDER BY, LIMIT | SQLite | ✅ |
| 02 | 7 May | SQL aggregations — COUNT, SUM, GROUP BY, HAVING | SQLite | ✅ |
| 03 | 8 May | SQL JOINs — INNER, LEFT, RIGHT | SQLite | ✅ |
| 04 | 9 May | Subqueries + CTEs | SQLite | ✅ |
| 05 | 10 May | Window functions — RANK, ROW_NUMBER, LAG, LEAD | SQLite | ✅ |
| 06 | 11 May | SQL practice marathon — HackerRank | SQLite | ✅ |
| 07 | 12 May | SQL mini project — UK open dataset | SQLite | ✅ |
| 08 | 13 May | Pandas — data loading and inspection | Python | ✅ |
| 09 | 14 May | Data cleaning — nulls, duplicates, dtypes | Python | ✅ |
| 10 | 15 May | Exploratory data analysis (EDA) | Python | ✅ |
| 11 | 16 May | Statistics for analytics — correlation, distributions | Python | ✅ |
| 12 | 17 May | Matplotlib + Seaborn visualisations | Python | ✅ |
| 13 | 18 May | Full EDA project | Python | ✅ |
| 14 | 19 May | Polish + push EDA project to GitHub | Python | ✅ |
| 15 | 20 May | Power BI — setup + first dashboard | Power BI | ✅ |
| 16 | 21 May | Power BI DAX basics | Power BI | ✅ |
| 17 | 22 May | Power BI portfolio dashboard | Power BI | ✅ |
| 18 | 23 May | Tableau Public — setup + first viz | Tableau | ✅ |
| 19 | 24 May | Tableau — calculated fields + storytelling | Tableau | ✅ |
| 20 | 25 May | Excel — pivot tables + Power Query | Excel | ✅ |
| 21 | 26 May | BI tools review + LinkedIn update | All | ✅ |
| 22 | 27 May | Plan two portfolio projects | All | 📅 |
| 23 | 28 May | Portfolio project 1 — build | Python + SQL | 📅 |
| 24 | 29 May | Portfolio project 1 — finish + publish | Python + SQL | 📅 |
| 25 | 30 May | Portfolio project 2 — build | Power BI / Tableau | 📅 |
| 26 | 31 May | Portfolio project 2 — finish + publish | Power BI / Tableau | 📅 |
| 27 | 1 Jun | CV + LinkedIn optimisation | — | 📅 |
| 28 | 2 Jun | Apply to 10 jobs | — | 📅 |
| 29 | 3 Jun | Interview prep — SQL + case studies | — | 📅 |
| 30 | 4 Jun | Reflect + plan the next 30 days | — | 📅 |
data-analytics-portfolio/ ├── day-01-sql-basics/ │ ├── day01_queries.sql │ └── superstore.db ├── day-02-sql-aggregations/ ├── day-03-sql-joins/ └── ....
SQL Python Pandas Matplotlib Seaborn Power BI Tableau Excel Git
MSc Applied CS & AI Graduate based in the UK. Open to data analyst, junior data scientist, and BI analyst roles.
LinkedIn · Substack · GitHub . HackerRank