Hello, I'm

Nelly Mogere

I build data solutions that drive growth.

As a Data Analyst and BI Specialist, I specialize in transforming complex datasets into clear, actionable insights. Whether it's through interactive dashboards or robust predictive models, I help businesses turn their raw data into their strongest strategic advantage.

View My Work Let's Connect
Data Analytics Business Intelligence Power BI SQL Python Excel
Nelly Mogere Profile

Skills & Technologies

The tools and techniques I use to build data solutions

Programming & Querying

Python SQL DAX M Language

Data Analytics & Engineering

Data Cleaning & Modelling Data Transformation Statistical Analysis ETL

Business Intelligence

Dashboard Development KPI Reporting Business Performance Analysis

Technology Stack

Power BI

Dashboard creation & interactive reporting

SQL Databases

Data extraction & relational querying

MS Excel

Advanced formulas & automated reporting

Python

Statistical analysis & data manipulation

Power Query

Data connection & transformation (ETL)

AWS / Fabric

Cloud data storage & enterprise analytics

Professional Experience

My career journey translating data into business value

Data Analyst

Data Science East Africa

Nairobi, Kenya (Remote)
Jan 2026 – Present

Lead data analyst driving organizational strategy through end-to-end data pipelines, advanced SQL analytics, and automated BI reporting.

Business Value: Enabled leadership to monitor real-time KPIs and make agile decisions by automating complex reporting workflows.
  • Engineered interactive Power BI & Excel dashboards for executive KPI tracking and operational monitoring.
  • Developed robust SQL queries to extract, clean, and model large-scale data from ERPs, APIs, and databases.
  • Conducted trend analysis and revenue forecasting to uncover hidden business opportunities.
Power BI SQL Microsoft Excel Power Query Data Modelling

Data Analyst & STEM Trainer

Women in STEAM Initiative

Thika, Kenya (Hybrid)
Feb 2025 – Jul 2026

Managed program analytics and reporting while empowering individuals through technology education.

Business Value: Improved the organization's ability to measure educational impact by standardizing data collection and visual reporting.
  • Overhauled data collection workflows to improve accuracy and efficiency in tracking program KPIs.
  • Built reporting dashboards that standardized data visualization for evidence-based decision-making.
  • Delivered comprehensive STEM training sessions in programming and robotics.
Power BI Microsoft Excel KPI Tracking Data Validation

Software Engineering Attaché

TechKidz Africa

Mombasa, Kenya
May 2024 – Nov 2024

Supported cross-functional teams in database architecture, software testing, and operational data reporting.

Business Value: Strengthened internal technical capabilities by supporting database design and business process automation.
  • Assisted in the structural design and querying of relational databases for efficient data retrieval.
  • Collaborated on data collection and analysis to support internal business operations.
SQL Database Design System Testing Data Management

Featured Data Projects

GitHub projects showing practical analytics, visualization, and BI skills

Superstore Streamlit Dashboard

Superstore Dashboard

An interactive Streamlit app transforming retail sales data into executive-ready insights with fast filtering and KPI tracking.

Python Streamlit Pandas
Repo Live App
Education Data Analysis

Education Data Analysis

An end-to-end Power BI project analyzing learning data to measure enrolment, performance, and program outcomes.

Power BI Data Modelling KPI Reporting
Repo
Sales Operations Excel Dashboard

Regional Sales Dashboard

A clean Excel dashboard designed to compare multi-regional sales performance, identify gaps, and monitor business trends.

MS Excel Pivot Tables Data Cleaning
Repo
Kenya Femicide Analysis

Kenya Femicide Analysis

An exploratory data analysis project communicating sensitive social impact trends responsibly to support advocacy.

EDA Data Visualization Social Impact
Repo
Rhea Crop Recommendations

Crop Recommendations

A predictive analytics notebook utilizing environmental data to recommend suitable crops for agricultural decision support.

Python Jupyter Predictive Analytics
Repo Live App

Ready to turn your data into a strategic advantage?

I am currently available for new opportunities. Whether you have a question about my portfolio or want to discuss how data can drive your business forward, my inbox is always open.

Email

gesare100@gmail.com

Phone

+254 799 854 104

Location

Mombasa, Kenya

Network

LinkedIn Profile

Let’s connect and build data-driven solutions together.

Send a Message