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
Repository link: Customer Data
Customer Data Dashboard [Tableau]
Skills Used: Tableau
Features:
- This project mirrors the dashboard above in Tableau.
- Dataset used: Online Shop Customer Sales Data from Kaggle
- Tableau Public link: Customer Data Dashboard
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
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