Esther Njuguna | Product Analyst at Buspatrol

Esther Njuguna

Product Analyst at Buspatrol

Based in Nairobi, Kenya

About

Esther is a data analyst at BusPatrol, specializing in data visualization, SQL, and business intelligence. I am passionate about bringing data to life and creating meaning in numbers. I aspire to be a mentor also to others. Before BusPatrol, she worked as a clinician at Equity Afya. They have also contributed to research on public health interventions using geospatial analytics and worked in telehealth, where she ran a clinic from its launch to now, seeing 10 patients a day. She has also volunteered as a mentor in two different communities.

Skills

Projects

Kenya HealthCare

This project explores health-seeking behavior among Kenyan individuals using survey data. The aim is to analyze how demographic factors (age, gender, income, etc.) influence access to healthcare, health insurance coverage, hospital visits, and preventive health practices like routine checkup

Udemy Course completion rate

As part of the Onyx DataDNA January 2024 Challenge, I analyzed a real-world dataset from Udemy, one of the world’s largest online learning platforms. The goal was to uncover insights into online course trends, pricing strategies, user engagement, and instructor dynamics using effective data storytel

Nairobi County Facilities Distribution

A comprehensive overview of healthcare facilities in Nairobi County, offering insights into their operational status, distribution, facility types, and management. It serves as a data-driven tool for policymakers, healthcare providers, and researchers.

Medical Residency Program Dashboard

Medical residency programs, focusing on resident distribution, sponsorship status, employer types, and study programs. It offers valuable data for policymakers, medical institutions, and healthcare stakeholders to assess trends in medical training and employment.

Governance

Hakitrack is a governance-focused project developed as part of the ALX program, aimed at improving transparency and accountability in public sector operations. The platform allows users to track and report issues related to governance, such as corruption, service delivery gaps, and public resources.

USA hospital data

Experience

2024 - Present

Product Analyst at Buspatrol

Validating and cleaning datasets to ensure accuracy and consistency in traffic violation reports. Conducting quality assurance (QA) checks on data processing workflows to maintain high standards. Analyzing trends in stop-arm violations and preparing reports for stakeholders. Collaborating with teams to optimize data workflows and improve reporting efficiency.

Education

2014-2019

Bachelor in Clinical Medicine and Community Health

2022

Certificate in Data Analytics

Learned how to clean, organize, and analyze data using tools such as Excel, SQL, Tableau, PowerBI, Python, and R. Additionally, gained expertise in using Google Sheets for data analysis and visualization, as well as techniques for creating interactive dashboards.