Turning raw, messy data into clear stories and actionable insights. I work with SQL, Python, Excel, Power BI & Tableau — passionate about uncovering patterns that drive decisions.
@doreennjagi
Hi, I'm Doreen Njagi — a Data Analyst based in Nairobi, Kenya passionate about transforming raw datasets into meaningful stories that drive real decisions.
Whether it's cleaning messy datasets, building interactive dashboards, writing complex SQL queries, or implementing Odoo ERP systems — I thrive on making data accessible and actionable for businesses and teams.
I'm currently growing my expertise in Data Science & Cloud Engineering with AWS and Azure, always pushing toward the next level of technical mastery. My tagline says it best: "Numbers speak — I just translate."
"Data is the new oil — but only if you know how to refine it. That's where I come in."
— Doreen Njagi · My PhilosophyA comprehensive toolkit for data analysis, visualization, and business intelligence.
A showcase of data analysis projects — from messy data to clear insights.
Predicted customer churn with 92% AUC accuracy across 7,000+ customers. Identified $2.1M in at-risk revenue and built 5 targeted retention strategies with 5–10x ROI projections.
View on GitHub →Exploratory data analysis of New York City traffic collision data — identifying high-risk zones, peak accident times, and contributing factors to support safer urban planning decisions.
View on GitHub →Interactive dashboard analysing workforce metrics including attrition rates, department headcount, salary distributions, and employee satisfaction — built to support HR decision-making.
View on GitHub →Cleaned and standardised a large global tech layoffs dataset using MySQL Workbench. Removed duplicates, handled nulls, and built views for monthly trends, top companies, and regional breakdowns.
View on GitHub →Same layoffs dataset explored using PostgreSQL — demonstrates cross-platform SQL proficiency. Covers advanced window functions, aggregations, and trend analysis across industries and geographies.
View on GitHub →End-to-end Excel project analysing bike sales data — data cleaning, pivot tables, and an interactive dashboard tracking sales by region, demographics, and commute patterns to uncover buyer trends.
View on GitHub →Hands-on Odoo ERP implementation covering sales, inventory, invoicing, and HR modules. Includes custom report configuration, business process mapping, and workflow automation for SME operations.
Coming Soon →Continuous learning fuels everything I do in data analytics.
Intensive program covering data analytics fundamentals, SQL, Python for data science, and business intelligence tools. Hands-on projects with real-world datasets.
Specialized training in Odoo ERP configuration, module implementation, and business process design for SMEs across Kenya.
Building cloud skills for data engineering — focusing on cloud storage, data pipelines, and serverless analytics infrastructure.
Verified learning milestones in data analytics and business intelligence.
Open to junior analyst roles, freelance data projects, and collaborations.
Have a project or opportunity? I'd love to hear from you. I typically respond within 24 hours.