Skip to main content

Projects SQL Workspace Python Lab Leaderboard Community Conference For Companies

Sign in Create account

Home
Projects
Community

Loading…

Practise. Analyse. Build. Showcase.

Master Excel, SQL, Power BI and Python through real-world projects, guided practice, browser-based tools and mentor feedback.

A hands-on learning platform by Data Science East Africa, built to help Africa's data community learn, create and grow with confidence.

Practise

Project library
SQL workspace
Python lab
Excel projects
Power BI projects
Python projects

Progress

Your dashboard
Leaderboard
Portfolios
Pricing
User guide
Account settings

Community

Community board
Conference
For companies
About DSEAfrica
GitHub
LinkedIn
Writing on Medium
YouTube

© 2026 Data Science East Africa. All rights reserved. Logos and icons by Icons8.

Docs
About
@DSEAfrica
Contact

M

Loading projects…

Data Lab/Projects

Project library

Real projects, real business problems

Every brief gives you a client, a role and a decision that depends on your analysis. Pick the tool you are learning, open the case file and work through it milestone by milestone.

Briefs: 14
Industries: 7
Hours of practice: 204

2Excel2PivotTables, lookups, cleaningBrowse
7SQL7Joins, CTEs, window functionsBrowse
3Power BI3Models, DAX, dashboardsBrowse
6Python6pandas, notebooks, EDABrowse

Search projects

Sort by

ToolTool

Excel

SQL

Power BI

Python

LevelLevel

BeginnerIntermediateAdvanced

IndustryIndustry

Finance4Retail3Healthcare1Telecommunications1Logistics1Agriculture2Public Sector2

All briefs

Showing 1–9 of 14 projects

1 learners have taken a brief

Brief 01 · HealthcareAdvanced
East Africa Health Outcomes and Spending Dashboard in Power BI
Build a Power BI report that lets legislators compare health outcomes and health spending across nine East African countries.
Your role: BI Analyst, East Africa Health Policy Forum

Power Query unpivot
Star schema modelling
DAX measures

Power BI

Estimated time: 18h
Participants: 0

Brief 02 · LogisticsIntermediate

Supply Chain and Delivery Performance Analysis in SQL

Join six tables of Kenyan marketplace orders to measure on-time delivery, find the carriers, sellers and routes behind delays, and link lateness to reviews.

Your role: Supply Chain Data Analyst, Kilele Market operations team

Multi-table joins
Date arithmetic
Median and percentiles

Estimated time: 10h
Participants: 0

Brief 03 · TelecommunicationsIntermediate

Telecom Customer Churn Prediction in Python

Find out why customers leave a telecom operator and build a simple model that flags who is likely to leave next.

Your role: Data Scientist, Customer Retention team, Simu Connect

pandas cleaning
Type conversion
groupby and pivot_table

Estimated time: 14h
Participants: 0

Brief 04 · AgricultureBeginner

Kenya Food Market Prices Analysis in Python

Use 14 years of real WFP maize and bean prices to tell Kenyan farmers when to sell and show county officers which markets cost households most.

Your role: Junior Data Analyst, Pamoja Agri-Advisory (fictional NGO)

pandas read_csv
Data types and datetime
Handling missing values

Estimated time: 8h
Participants: 0

Brief 05 · FinanceIntermediate

Financial Performance Dashboard in Power BI

Turn three years of a Kenyan manufacturer's sales into a Power BI report that shows the CFO where profit is made and lost.

Your role: Financial Analyst, FP&A team, Baraka Manufacturing

Power Query
Star schema modelling
Date tables

Estimated time: 12h
Participants: 0

Brief 06 · RetailAdvanced

E-commerce Customer Retention and Cohort Analysis in SQL

Use real online-retail sales to build monthly cohorts, retention rates, RFM scores and a churn flag that show which customers to win back.

Your role: Customer Insights Analyst, online gift wholesaler

Data profiling in SQL
CTEs
Window functions (NTILE, ROW_NUMBER)

Estimated time: 14h
Participants: 0

Brief 07 · FinanceIntermediate

Bank Customer Transactions and Product Usage in SQL

Join seven tables of bank data with SQL to find who transacts most, how cash is giving way to M-Pesa, and who to offer a card or loan.

Your role: Data Analyst, Retail Banking Insights team, Mlima Bank

Relational modelling
INNER and LEFT JOINs
GROUP BY and HAVING

Estimated time: 10h
Participants: 0

Brief 08 · RetailBeginner

Retail Sales and Profitability Analysis in Excel

Clean four years of order lines for a Kenyan office and home retailer, find where profit is made and lost, and build a profit dashboard in Excel.

Your role: Junior Commercial Analyst, Tausi Office & Home

Excel Tables
Data cleaning
Date functions

Estimated time: 8h
Participants: 0

Brief 09 · FinanceBeginner

Kenya Employee Salary Analysis

Answer a CEO's pay questions from a 420-person payroll: who earns what, where the money goes, and which departments are over budget.

Your role: People Analyst, Savanna Tech Group

Filtering and sorting
Aggregation
Subqueries

Estimated time: 6h
Participants: 1