Abigael Cherotich

Research and BI/Data Analyst | Driving Insights Through Data & Scalable Systems

Abigael Cherotich

I am a senior research and BI/data analyst , with over five years of experience working in leading consultancy firms , where I have supported corporates, businesses, and international NGOs in conducting A/B testing, market research, social research, and product analysis.

With expertise in SQL, Python, R, cloud platforms, and BI tools , I design scalable analytics solutions such as real-time dashboards, automated reporting workflows, and data-driven presentations that enable organizations to make smarter decisions, optimize revenue, and improve efficiency.

Download CV

0

Years Experience

0

Dashboards Built

0

Projects Completed

Toolset

Statistical & Programming

SPSS | Python | RStudio | STATA | SQL | RShiny

BI & Visualization

Power BI | RShiny | Tableau | Looker | Looker Studio | Excel

Cloud Platforms

Snowflake | AWS (Redshift, S3) | Google Cloud (BigQuery)

Data Engineering Tools

Apache Airflow | Apache Kafka | Git

Projects

Retail Sales Dashboard

Power BISQLForecasting

Interactive retail dashboard tracking KPIs, regional drilldowns, and short-term forecasts.

Retail Sales Dashboard
Code View Dashboard

Customer Segmentation & ETL

dbtAirflowSQL

Automated ETL pipeline with optimized queries for customer segmentation and churn analysis.

Customer Segmentation
Code Docs

Impact of Mobile Money

ImpactRStata

DiD/PSM study on mobile money's role in financial inclusion using World Bank Findex data.

Impact of Mobile Money
Code Read Report

Customer Churn Prediction

PythonXGBoostML

End-to-end ML model with feature importance, evaluation metrics, and deployable scoring script.

Customer Churn Prediction
Code Notebook

Contact

Email LinkedIn