Data Analyst · Nairobi, Kenya

Turning raw data into
decisions that stick.

Python · SQL · Power BI · End-to-End Pipelines

I build analytics projects from scratch — cleaning messy datasets, designing SQL databases, running exploratory analysis, and publishing dashboards that help businesses act on what the data actually says. Open to roles in Nairobi and remotely.

↓ See my work GitHub ↗ ↓ Download CV Email me
4+
End-to-end projects
10yr
CBK data analysed
7K+
Records processed
47
Kenyan counties mapped
Profile Picture
Peter Ngamau
Data Analyst
📍 Nairobi, Kenya
Python SQL Power BI Tableau
Python
pandas
NumPy
SQL Server
T-SQL
Power BI
DAX
Tableau
matplotlib
seaborn
Excel
EDA
Hypothesis Testing
Star Schema Design
Git & GitHub
Jupyter Notebooks
Python
pandas
NumPy
SQL Server
T-SQL
Power BI
DAX
Tableau
matplotlib
seaborn
Excel
EDA
Hypothesis Testing
Star Schema Design
Git & GitHub
Jupyter Notebooks
What I work with

Skills & Tools

A practical toolkit built through real projects — not just coursework. Every tool below has been applied in a portfolio project with documented results.

🐍

Python Analysis

pandasNumPymatplotlibseabornJupyter
🗄️

SQL & Databases

T-SQLSQL ServerCTEsWindow FunctionsStar Schema
📊

Data Visualisation

Power BIDAXTableauExcel ChartsPivotTables
🔬

Analysis Methods

EDAHypothesis TestingSegmentationKPI TrackingTrend Analysis
🛠️

Data Engineering

ETL PipelinesData CleaningData ValidationSchema Design
💼

Business & Workflow

Stakeholder ReportingGit & GitHubVS CodeGoogle Workspace
Portfolio

End-to-End Projects

Each project runs the full analytics pipeline — raw data in, business insights out. Built independently, documented thoroughly, and available on GitHub.

🇰🇪
Python · SQL Server · Power BI
Featured 10yr Dataset 47 Counties

Kenya Financial Inclusion & Mobile Money Analytics

Analysed 10 years of Central Bank of Kenya data alongside 7 waves of FinAccess Household Survey data to track M-Pesa adoption and financial exclusion gaps across all 47 counties.

Key Findings
  • M-Pesa transaction value grew ~7× over the decade
  • Tana River had the highest exclusion rate at 37.6%
  • People with no formal education were 4.6× more likely to be excluded
View on GitHub →
🛒
Python · SQL Server · Power BI
End-to-End Pipeline 5 Datasets

Retail Sales Analysis — End-to-End Pipeline

Built a complete analytics pipeline from raw CSVs to published Power BI dashboards — cleaning five datasets in Python, designing a SQL Server star schema, and publishing three interactive dashboards.

Key Findings
  • Small store segment drove the majority of total revenue
  • Loyalty members generated measurably higher spend
  • Data integrity validated: zero discrepancies in reported KPIs
View on GitHub →
📉
Python · pandas · seaborn
EDA 7,000 Records 21 Features

Customer Churn Analysis — IBM Telco Dataset

Built a five-task Python EDA pipeline on ~7,000 customer records to identify the key drivers of churn and translate findings into actionable business recommendations.

Key Findings
  • Month-to-month customers churned at significantly higher rates
  • First 12 months of tenure = highest churn risk window
  • Electronic check payment correlated strongly with attrition
View on GitHub →
⚽
Python · pandas · scipy
Statistical Testing Sports Analytics

Hypothesis Testing — Men's vs Women's Football Scores

Cleaned and merged two international match datasets, compared scoring patterns and win rates across both groups, then applied formal hypothesis testing to determine statistical significance.

Approach
  • Exploratory analysis of goal distributions and win rates
  • Statistical hypothesis test on observed score differences
  • Results documented with supporting charts in Jupyter
View on GitHub →
Work History

Professional Experience

Six years of front-line retail experience that grounds every analysis in real business context — understanding not just what data says, but what it means for day-to-day decisions.

📦
Retail Data & Operations Analyst
Sep 2021 – Present
Chandarana Foodplus Supermarket · Nairobi, Kenya
  • Tracked product movement and purchase patterns to guide shelf placement decisions, reducing time-to-find for top-selling SKUs and improving aisle flow.
  • Monitored inventory data daily and flagged demand trends to the purchasing team, reducing both stockout and overstock incidents in high-velocity product lines.
  • Prepared regular management reports on stock levels and product performance — presenting data findings in plain language to non-technical stakeholders including department heads and buyers.
  • Maintained inventory accuracy across thousands of active SKUs in a high-volume retail environment.
🧾
Cashier & Customer Service Associate
2017 – 2020
Tuskys Supermarket · Nairobi, Kenya
  • Handled high daily transaction volumes with consistently low till-reconciliation error rates — an early introduction to the discipline of data accuracy.
  • Managed customer complaints and refund requests, keeping satisfaction scores consistently above store targets.
  • Gained hands-on exposure to point-of-sale transaction reporting and end-of-day reconciliation processes.
Learning

Certifications & Development

Structured learning that directly feeds into my project work — every course applied, not just completed.

🏢

Deloitte Australia — Data Analytics Simulation

Forensic technology simulation involving Tableau dashboard development and Excel-based data classification to support business conclusions in a consulting context.

Forage · April 2026
📚

DataCamp — Data Analyst Track

Structured learning path covering Python (pandas, NumPy), SQL, Power BI, and statistical analysis — directly applied in every portfolio project.

In Progress · 2024–Present
🌍

ALX Africa — Virtual Assistant Certification

Remote collaboration, productivity tools, and project coordination in distributed team environments — skills that directly support remote data roles.

ALX Africa · 2024
Get in Touch

Let's work together.

Open to data analyst roles in Nairobi and remotely. Happy to discuss your project, your team, or just talk data.

✉️
Email ptahmwangi@gmail.com
→
💼
LinkedIn linkedin.com/in/peter-ngamau
→
🐙
GitHub github.com/peter-ngamau
→
Available now

Open to full-time data analyst roles

Based in Nairobi, Kenya. Open to on-site roles locally, hybrid arrangements, and fully remote positions internationally. Quick to respond — usually within 24 hours.

Send me a message →