Data Analyst · Nairobi, Kenya

Benard
Mwinzi

Turning raw data into real decisions

Python · SQL · Tableau · Excel — 4+ years delivering analytical insights for international clients across HR, finance, and operations.

See my projects Get in touch
4+Years freelancing
8Client projects
5Analysts mentored
6Portfolio projects
Work

Selected projects

Six end-to-end analyses spanning payments, hospitality, housing, and sales — real data, real tools, real findings.

01
PythonTableauEDAFeature Engineering
Kenya Payment Systems Analysis
End-to-end analysis of Kenya's digital payments ecosystem (2007–2026) using Central Bank data. Mobile Money grew 500x, POS rose 4→42%, card usage fell post-COVID. Insights guide banks and fintech on trends, opportunities, and strategy.
→
02
PythonPandasSeabornGeoMap
Hotel Booking Analytics: Revenue Drivers & Customer Behaviour
Exploratory analysis of 66,541 hotel bookings (2010–2019). Thailand, Malaysia & Singapore lead bookings; 46–60 age group spends most; discounts above 15% erode margins; bookings grew YoY with dips in Feb, Jun & Nov.
→
03
SQLMySQLPandasData Cleaning
Nashville Housing — SQL Data Cleaning & Analysis
End-to-end SQL data cleaning pipeline for 56,477 Nashville housing records. Techniques: self-join imputation, substring parsing, conditional normalisation, and date formatting to prepare data for reliable insights.
→
04
ExcelDAXPower PivotMacros
Adventure Works MS-Excel Dashboard
Interactive Excel dashboards with Power Pivot, DAX, macros, and pivot tables. Revealed $307M revenue, 41% margin, Q2 peak performance, and 50+ age group driving 39% profit to inform sales strategy and targeting.
→
05
PythonEDAA/B TestingData Viz
Cyclistic Bike-share Data Analysis
Google Data Analytics capstone project. Analysed bike-share usage patterns to help the marketing team design campaigns converting casual riders into annual members.
→
06
TableauDashboardDescriptive Stats
Splendor Hotel Group: Cancellation & Revenue Loss Analysis
Analysed SHG booking data in Tableau, uncovering $13.1M revenue loss from 44,224 cancellations. Transient guests drove 88% of cancellations, OTAs 72%. Insights target deposit policy reform and OTA dependency reduction.
→
About me

Analyst.
Problem Solver.

Benard Mwinzi
Benard Mwinzi Data Analyst · Nairobi, Kenya

I am a data analyst based in Nairobi, Kenya, with a BA in Economics and Mathematics from Machakos University and a Google Data Analytics Certificate. I specialise in transforming raw data into clear, actionable insights.

Over 4+ years of freelance work on Upwork, I have delivered dashboards, benchmarking reports, and data visualisations for international clients across HR, operations, and business analytics.

Beyond analysis, I served as a Data Analytics Mentor at Blossom Academy in Ghana, guiding five graduates into their first freelance data careers — a role that sharpened both my communication and my understanding of what makes data work meaningful.

I am currently seeking a full-time data analyst role where I can apply these skills to drive real business decisions.

PythonSQLTableau ExcelMySQL Power PivotDAXEDA A/B TestingData Storytelling
📊

Data-driven storytelling

Translating complex datasets into clear narratives that non-technical stakeholders can act on.

🌍

Local domain expertise

Deep knowledge of African markets — from Kenya's digital payments ecosystem to regional economics.

🎓

Teaching & mentorship

Guided 5 junior analysts into paid freelance careers through structured coaching and proposal writing.

🤝

Client-focused delivery

8 completed Upwork projects for US and European clients with a focus on clarity and timely communication.

Capabilities

Skills & tools

A full-stack analytical toolkit built across 4+ years of real client work.

Languages

Python
SQL

Visualisation

Tableau
Matplotlib
Seaborn

Tools

MS Excel
Power Pivot
MySQL

Analytical

EDA
A/B Testing
Storytelling
Background

Experience &
education

Work experience
Feb 2025 – Jun 2025
Data Analytics Mentor
Blossom Academy · Ghana
Mentored five analytics graduates into their first freelance careers. Guided profile building, proposal writing, and landing first gigs through a structured programme.
Oct 2023 – Jan 2024
Data Analyst
Knoetic, Inc. · United States
Analysed employee attrition data from 630 startup respondents across the US and Europe. Delivered a benchmarking report with 19 visualisations covering attrition by company size, remote status, and demographics.
Jan 2021 – Present
Data Analyst (Freelance)
Upwork ↗
8 diverse data analysis projects for international clients — dashboards, benchmarking reports, ER diagrams, and data visualisations across HR, operations, and business analytics.
Education
May 2022 – Jan 2023
Google Data Analytics Certificate
Google / Coursera
Professional certification covering spreadsheets, SQL, and Tableau. Completed all eight courses including the Cyclistic capstone project.
View credential
Sep 2015 – Apr 2021
BA Economics and Mathematics
Machakos University · Kenya
Interdisciplinary degree combining economic theory with statistical and mathematical techniques. Minor in Statistics and Sociology.
Get in touch

Let's work
together

I'm open to full-time data analyst roles and interesting freelance projects. Reach out via any channel below or send a message directly.

@
Emailbenardmwinzi73@gmail.com
☎
Phone+254 728 900 958
in
LinkedInbenard-musyoka1234
GH
GitHubgithub.com/BenaData
Up
UpworkView Upwork profile
K
Kagglekaggle.com/benardmwinzi

Opening your email client…