YouTube Analytics Pipeline
6 channels
Scraped, modelled and compared through the YouTube API, and refreshing on its own in Microsoft Fabric.
Data engineering, 2025. Python, YouTube Data API, MySQL, Microsoft Fabric.
Read the case studyProjects
Data pipelines, financial analysis, risk models and reports. Open any project for the full case study, with the live dashboard where one is published.
Novacore Financial Report
+1,269%
The month-on-month jump in expenses in July 2022, the month a profitable company made its first loss.
Financial analysis, 2025. Power BI, DAX, Power Query, Excel.
Read the case study
Mortgage Portfolio Risk
18 of 19
High-risk loans in the portfolio that were written by one office, Newark.
Risk analytics, 2025. Power BI, DAX, Power Query, Excel.
Read the case study
Forggith Pharmaceuticals
20+ measures
DAX measures behind revenue, targets, year to date and same period last year, sliced by team, product and place.
BI development, 2023. Power BI, DAX, Power Query.
Read the case study
RFM Customer Segmentation
11 segments
Every customer scored 1 to 5 on recency, frequency and money, then placed in one of eleven segments, from Champions to Lost.
Customer analytics, 2025. Power BI, DAX.
Read the case study
Top Zenith Student Performance
62.55%
The school’s average pass rate, tracked alongside a predicted third-term score for every student.
Education analytics, 2024. Power BI, DAX, Power Query.
Read the case study
Cyclistic Bike-Share
5.67M rides
Every trip from twelve monthly files of 2022 Divvy data, cleaned in pandas before any chart was drawn.
Exploratory analysis, 2024. Python, pandas, Matplotlib, Seaborn.
Read the case study