Data Analyst · Nairobi, Kenya

Mary
Wachira

BSc. Economics & Statistics · Second Class Honours (Upper)

I transform messy datasets into clear, actionable insights. Using SQL, Power BI, Excel, and R — I build dashboards and analyses that help businesses make faster, smarter decisions.

✉ waitheramary7532@gmail.com ☎ +254 748 198 559 💼 linkedin.com/in/mary-wachira-09885127b 🖥 github.com/Mary7532
View My Work Get In Touch
5+
Projects Completed
50K+
Records Processed
3
Industry Internships
// 01 — Skills & Tools

My Toolkit

Core technical skills and the tools I use daily to transform raw data into decisions.

📊
Microsoft Excel
Advanced
Pivot TablesPower QueryVLOOKUPVBADashboards
📈
Power BI
Intermediate–Advanced
DAXData ModellingCustom VisualsSlicers
🗄
SQL
Intermediate
MySQLJoinsWindow FunctionsQuery Optimization
📉
R Programming
Intermediate
ggplot2dplyrStatistical ModellingSPSS
🔍
Statistics & Analytics
Advanced
Hypothesis TestingRegressionForecastingEconometrics
🗺
Tableau
Intermediate
Calculated FieldsStory PointsFilters
// 02 — Featured Projects

Real Data. Real Impact.

Each project was built from scratch using actual datasets — structured as business case studies following the 7-step methodology: Problem → Objective → Approach → Tools → Insights → Recommendations → Dashboard.

Income and Expenditure Dashboard
Excel · Financial Analysis
Project 01

Personal Finance & Cash Flow Dashboard

Analysed 621 mobile money transactions spanning Aug–Nov 2025 across 8 spending categories. Built a structured data model, pivot summaries, and interactive KPI dashboard with month and category slicers.

📋 Case Study
Business ProblemHow can an individual understand spending patterns to improve savings rates?
ApproachCleaned M-Pesa statements, classified 8 expense categories, built pivot model with slicers
Key Finding64% of spending concentrated in debt repayment; savings rate at 19.78%
RecommendationReallocate entertainment budget to increase monthly savings by ~3%
Total income tracked: KES 318,565 | Withdrawn: KES 311,945
Net flow: +KES 6,620 | Income-to-Expense Ratio: 1.02
8 spend categories classified and prioritised
Monthly trend visualisation with anomaly detection
ExcelPivot TablesKPI DesignData Cleaning
Request Full Analysis →
Revenue Dashboard on Sales
Excel · Global Sales Intelligence
Project 02

7-Year Global Sales Performance Dashboard

Processed 1,000 orders across 8 global regions (2014–2020) covering 10 product categories. Designed pivot-driven dashboards tracking revenue, profit margins, regional performance, and customer segment trends.

📋 Case Study
Business ProblemWhich regions and product categories drive the most profitable growth?
ApproachPivot analysis with region/segment/priority slicers, YoY trend lines, country ranking
Key FindingMexico and Japan lead country performance; Corporate segment most profitable
RecommendationIncrease Corporate segment outreach in Asia-Pacific high-performing markets
Total revenue analysed: $5.69M | Total profit captured: $1.35M
8 global regions compared side-by-side
YoY growth tracked across 3 customer segments
Revenue breakdown by order priority and product category
ExcelRevenue AnalysisRegional ComparisonYoY Trends
Request Full Analysis →
Outreach Performance Dashboard
Excel · Outreach Analytics
Project 03

University Admissions Outreach Analysis

Cleaned and analysed 37,881 outreach call records to measure conversion funnels, caller performance, and campaign effectiveness. Dashboard includes quarterly and caller-level slicers for granular insight.

📋 Case Study
Business ProblemWhich callers and campaigns convert prospects to enrolled students most efficiently?
ApproachFunnel analysis across 10+ call outcomes; caller comparison charts; campaign timeline
Key FindingFA24IP campaign yielded highest conversion; "Not Connected" rate at 64.67%
RecommendationShift calling hours to improve connection rate; replicate FA24IP follow-up scripts
37,881 call records processed and cleaned
Conversion rate: 2.15% | Response rate: 17.79%
Escalation rate isolated at 1.14%
Outcome distribution across 10+ call result types
ExcelFunnel AnalysisPivot TablesLarge Dataset
Request Full Analysis →
// 03 — Professional Experience

Where I've Worked

Hands-on internships delivering measurable impact across FMCG, EdTech, and public sector environments.

Dec 2025 – Jan 2026
Data Analysis & Visualization Intern — Team Project Lead
Excelerate · Remote
  • Led 4-person international team analysing 50,000+ record sales dataset, delivering weekly cross-timezone insights
  • Cleaned and validated e-commerce data using SQL; built 4 Power BI dashboards tracking customer acquisition, revenue trends, and product performance
  • Produced data quality audit report identifying 5 key anomalies, informing improved data collection practices
Jan 2025 – Mar 2025
Data Analyst Intern — Commercial Sales Department
East African Breweries Ltd (EABL) · Nairobi
  • Optimised SQL queries for sales reporting, cutting execution time from 3–5 minutes to under 60 seconds
  • Delivered 5 executive business decks analysing sales trends across 10 regions, informing Q1 2025 distribution strategy
  • Redesigned stock reconciliation template for 25+ distributors, reducing monthly discrepancy variance from 5% to under 3%
Aug 2023 – Nov 2023
Attaché — Quality Assurance & Risk Department
National Construction Authority · Nairobi
  • Compiled 40+ page 2023 Strategic Plan Implementation Progress Report, delivered 2 weeks ahead of deadline
  • Standardised quarterly data submission templates across 6 departments, improving consistency scores from 80% to 89%
  • Supported ISO 9001:2015 compliance audit, flagging 10+ reporting gaps and contributing to retained certification
// 04 — About Me

The Person Behind the Data

I'm a data analyst based in Nairobi with a BSc. in Economics & Statistics (Second Class Honours, Upper Division) from the University of Nairobi. I'm drawn to the moment when a messy dataset becomes a clear story — when numbers stop being noise and start being answers.

I believe great analysis isn't just technically correct — it has to be understood and acted upon. That's why I focus as much on how insights are communicated (dashboards, decks, narratives) as on the underlying methodology.

Outside of work, I enjoy thinking about macroeconomics, watching how data shapes policy, and helping organisations discover what's hiding in their numbers. I'm open to junior analyst roles, freelance data work, and data-driven collaborations in Kenya and beyond.

🎓
Education
BSc. Economics & Statistics — University of Nairobi (2020–2024) · Second Class Honours, Upper Division
📍
Location
Nairobi, Kenya — Open to Remote & Hybrid
☎
Phone
+254 748 198 559
🛠
Primary Tools
Excel · Power BI · SQL · R · Tableau · SPSS · Python
🔍
Domain Interests
FMCG analytics · macroeconomics · public sector data · EdTech · financial services
🏅
Certifications
SQL for Data Science (Simplilearn) · Advanced Excel (Coursera) · Data Analytics — Deloitte Australia (Forage) · Business Analytics: Excel, SQL, Power BI, Tableau (Denaco Analytics)
🌍
Languages
English (Fluent) · Kiswahili (Fluent)
// 05 — Contact

Let's Work Together

I'm actively looking for data analyst opportunities in Kenya and remote roles. Whether you have a project in mind, a job opening, or just want to talk about data — my inbox is always open.

✉️ waitheramary7532@gmail.com 📞 +254 748 198 559 💼 linkedin.com/in/mary-wachira-09885127b 🖥 github.com/Mary7532