powerbi

Customer Segmentation Report

Use RFM analysis to segment customers and build a churn-risk dashboard with cohort analysis.

deliverables

rubric areas

Advanced

level

7-9 hrs

time

Our context

Local problems

Datasets, projects, and examples stay close to the markets learners know.

Need, not hype

Build what helps

Tools are taught through decisions, systems, and practical output.

Today

Mentor review queue

12 pending

Submissions

Healthy

At risk

Duka SmartKenyan Market

What you learn

Build segmentation logic that supports targeted retention decisions.

Deliverables

RFM modelChurn dashboardRetention action list

Scoring rubric

Segmentation logicDAX depthCohort clarityActionability

Skills practiced

Complex DAXRFM modellingCohort analysisWhat-if parameters

Mentors review the submission for technical accuracy, business reasoning, and manager-ready communication.

How submissions are judged

Data source: Synthetic CRM dataset

Accuracy of the analysis and any calculations.

Whether the recommendation is specific and useful.

How clearly the learner explains the decision.

Whether the output feels ready for a hiring manager.

Score bands

90-100: portfolio-ready

75-89: strong with revisions

60-74: needs coaching

Submit

Send your work for review.

Submit a shareable artifact link so a mentor can review your workbook, dashboard, notebook, or written recommendation.

Related proof

Strong submissions surface here

See the standard learners work toward: clear analysis, practical recommendations, and portfolio-ready delivery.

Product Growth Funnel Analysis

Alice Mwangi

93%

A funnel readout with cohort breakdowns and a practical activation experiment.

See showcase

SME Collections Priority Model

Kevin M.

90%

A prioritized collections list with risk bands and expected cash recovery.

See showcase

Customer Support Quality Scorecard

Naomi A.

88%

A support dashboard that connects response time, quality, and coaching actions.

See showcase

Open showcase