I'm a Data Analyst & Business Analyst with a background in software engineering, currently working at Centrika Ltd in Kigali, Rwanda. I specialize in turning complex operational data into clear, actionable business insights — using SQL, Python, Power BI, and Excel.
Before moving into data, I worked as a frontend developer and team lead at Rwanda TVET Board, where I built data-integrated web systems and led engineering teams. That background gives me a rare ability to understand both the data infrastructure and the business questions it needs to answer.
I care deeply about using data to improve public services, healthcare systems, and operational performance across Africa. Every dashboard I build, every report I automate, every query I write — it's all in service of helping organizations make better decisions faster.
📍 Location → Kigali, Rwanda
💼 Current Role → Data Analyst @ Centrika Ltd
🎯 Focus → Data Analysis · Business Intelligence · Reporting Automation
🌱 Learning → Power BI Advanced · Machine Learning · TensorFlow.js
🗣️ Languages → English (Fluent) · Kinyarwanda (Native)
📫 Email → lidvinelouange@gmail.com
| Role | What I Deliver | |
|---|---|---|
| 📊 | Data Analysis | SQL queries, KPI tracking, trend analysis, business reporting |
| 📈 | Business Intelligence | Power BI & Streamlit dashboards that stakeholders actually use |
| ⚙️ | Python Automation | Scripts that replace hours of manual reporting work |
| 🌐 | Frontend Development | Fast, accessible web apps with React, Next.js & TypeScript |
End-to-end projects demonstrating SQL, Python, Excel automation, and interactive BI dashboards
| 🔗 Project | 📋 What It Does | 🛠️ Stack |
|---|---|---|
| 📊 Sales SQL Analysis | Advanced business intelligence with CTEs, window functions (RANK OVER PARTITION BY), YoY growth analysis, regional revenue ranking, and discount impact reporting across 2,000+ transactions |
SQLite · Python · Pandas |
| 🔎 Retail EDA Analysis | Full exploratory data analysis pipeline — data quality audit, statistical profiling, customer Pareto analysis, correlation analysis (discount vs profit margin), and 6 publication-ready charts | Python · Pandas · Seaborn · Matplotlib |
| 📁 Automated Excel Report | Python script that auto-generates a formatted 3-sheet Excel workbook with KPI cards, embedded charts, conditional formatting, and auto-filters — eliminating hours of manual work | Python · openpyxl · Excel |
| 📈 BI Dashboard | Interactive business intelligence dashboard with real-time filters (region, year, segment, category), 6 KPI cards, dual-axis trend charts, scatter with OLS trendline, and quarterly breakdowns | Streamlit · Plotly · Python |
Data Analyst / Data Systems Engineer — Centrika Ltd, Kigali 2025 – Present
Designing SQL analysis workflows · Building Power BI dashboards · Automating reporting pipelines with Python · Investigating data quality issues · Building the Centrika Reconciliation System
Team Lead — Software Dev & Data Systems — Rwanda TVET Board, Kigali 2023 – 2024
Led development team · Built SQL-integrated backend systems · Designed monitoring dashboards · Integrated real-time data visualization for national education stakeholders
Education — Rwanda Coding Academy
Diploma in Software Programming & Embedded Systems
Louange Lidvine Bizimana · Kigali, Rwanda 🇷🇼