Portfolio projects

Customer Data Dashboard [Microsoft Excel]

Skills used: Excel, PowerQuery.

Features:

  • Every data point & graph in the dashboard is dynamic, and would update if the dataset evolved over time.
  • Exportable to a PDF one-pager, no formatting issues.
  • Dataset used: Online Shop Customer Sales Data from Kaggle

Portfolio image

Repository link: Customer Data

Customer Data Dashboard [Tableau]

Skills Used: Tableau

Features:

Portfolio image

Repository link: Customer Data

Top 14 Standings | 2005 - 2022 [Tableau]

Skills used: Tableau

Features:

  • The workbook contains two dashboards: one that provides general statistics on title wins, playoff apperances, number of seasons in the Top 14 and win/loss rates. The other allows the user to compare any two seasons by looking at the full standings.
  • Dataset compiled by myself using Data from Wikipedia & The Ligue Nationale de Rugby website.
  • Tableau Public link: Rugby Top 14 2005-2022

Portfolio image

Formula 1 Queries [SQL]

Skills used:

  • Intermediate SQL
  • Database creation
  • Data cleaning

In this project, I answer a range of different questions about Formula 1 racing statistics and history by querying a motor racing dataset. This is primarily used as a way to practice and identify learning opportunities in SQL. Please note this project is dynamic and additional questions will be added as I continue to learn more SQL concepts.

Repository link: Formula 1 SQL Project

Formula 1 Queries - Visualisation [Tableau]

Skills used:

  • Tableau

In this spin off project, I take some of the data from the queries above and create a small visualisation that allows people to compare major statistics across the decades in F1 (winners, racers, race numbers, points scorers, standings & points progression throughout individual seasons).

You can find the visualisation here: F1 Through The Decades