Case study · 01
Football Transfers Analysis
Key insights
- Insight 1. Lead with a number (e.g. fees for 21–24 year-olds rose X% vs. Y%).
- Insight 2
- Insight 3 (optional)
- GitHub link
- Workbook link
Antony N. Kinuthia · Data Analyst · Software Engineering background
I clean, query and model data in Python, SQL and Excel, then turn it into charts and recommendations people can act on. My engineering background means the analysis ships, not just the slide deck.
Fig. 01 — About
I'm a Data Analyst with a Computer Science degree from Daystar University and hands-on experience building business solutions on clients' operational and financial data.
As a Software Engineering Intern at Premier Analytics I worked with Microsoft Power Platform and Dynamics 365 Business Central, where I saw how much value sits in data that companies already collect. Now I focus on the analysis: cleaning messy datasets, asking the right questions with SQL and pandas, and presenting answers clearly.
Since 2023 I've also done freelance AI data work: transcribing and labelling speech data in English and Swahili, masking personal information to GDPR/HIPAA standards, and scoring LLM responses against quality rubrics. It taught me that the quality of an analysis depends on the data underneath it.
Outside of client work I build products (Nestly) and automation (VideoToClips), and I run two YouTube channels.
describe(antony)
Fig. 02 — Skills
Python, SQL and Excel do the heavy lifting. Statistics and clear visuals turn the output into something a business can use.
| skill | type | group |
|---|---|---|
| Python | language | core |
| pandas | library | core |
| NumPy | library | core |
| SQL | language | core |
| Excel | tool | core |
| SQLite | database | core |
| Statistics | method | analysis |
| Data Cleaning | method | analysis |
| Data Visualization | method | analysis |
| Business Analytics | domain | analysis |
| Data Validation & QA | method | analysis |
| Power Platform | platform | platform |
| Dataverse | database | platform |
13 rows in set
Fig. 03 — Projects
Each one starts with a business question and ends with findings someone could act on.
Case study · 01
Case study · 02
Property websites for short-stays
A platform that gives short-stay hosts their own property website. one line on scale/impact (e.g. number of properties, bookings).
Automated long-form → shorts pipeline
Python pipelines that transcribe long-form video with OpenAI Whisper, align segments to the millisecond, and cut shorts with FFmpeg. Jobs are tracked in SQLite with error logging and recovery, so interrupted batches lose no data.
Fig. 04 — Experience
–
Premier Analytics
– Present
Upwork (freelance)
–
Small business clients
–
Daystar University
Fig. 05 — Certifications
365 Data Science
365 Data Science
DeepLearning.AI · Stanford
issuer
StudySection
Fig. 06 — Content
I also run two YouTube channels, which is where my automation work gets tested in production.
@RawAnatomy_1
Anatomy and fitness shorts. confirm or refine this line.
Watch on YouTube: Raw Anatomy (opens in a new tab)@ascend_daily_elevate
One-line description of the channel.
Watch on YouTube: Ascend Daily Elevate (opens in a new tab)Fig. 07 — Contact
I'm open to Data Analyst roles and freelance analysis work. Email is the fastest way to reach me.
antony@nestlyafrica.cloud