The Location Table That Had Nowhere to Go
As part of my Subscription Churn project for StaffWise, I decided to use simulated data to practice creating a clean […]
The Location Table That Had Nowhere to Go Read More »
June 2025
Why Is It So Hard to Make SQL Shine in a Portfolio?
If you’re on the journey to becoming a data analyst (or already in the field), you’ve probably heard this a
Why Is It So Hard to Make SQL Shine in a Portfolio? Read More »
Data Cleaning Progress Update
Clean data isn’t just about tidy spreadsheets; it’s what ensures that insights are reliable and decisions are well-informed. This stage
Data Cleaning Progress Update Read More »
Free vs Paid Tools: How Far Can You Really Go When Building Your Portfolio?
You’ve probably heard it before – maybe from mentors, online forums, or blogs: “You don’t need to spend a cent
Free vs Paid Tools: How Far Can You Really Go When Building Your Portfolio? Read More »
Top 6 Tips for Simulating Realistic Data with ChatGPT and Python
I recently set out to create a mock dataset for a BI Sprint Series project I’m working on. I figured
Top 6 Tips for Simulating Realistic Data with ChatGPT and Python Read More »
What Happened to My Location Table?
I asked Python to create random cities, states, and countries – and it did, separately. Now I’ve got Nairobi in
What Happened to My Location Table? Read More »
Simulating Realistic Subscription Data for Business Intelligence
One of the biggest hurdles in building a business intelligence (BI) pipeline is… well, getting the data. But what happens
Simulating Realistic Subscription Data for Business Intelligence Read More »
Identifying Key Data Points for Analysis
To fix a problem, you first have to measure it correctly. For StaffWise, a subscription-based HR and workforce management platform,
Identifying Key Data Points for Analysis Read More »
Problem Statement
StaffWise, a subscription-based HR and workforce management platform tailored for the hospitality industry, has seen a troubling pattern emerge: revenue