FMCG Sales & Retailer Lifecycle
An Egyptian B2B portfolio scenario exploring sales, churn, delivery, and commercial metrics.
A question. A process.
Work you can explore.
Follow the decisions behind the implementation, then inspect the original work.
Chapter 1 of 4 · The question
The question behind the build.
A sales drop can have several causes. Retention, delivery performance, and commercial mix need separate definitions and a shared reporting model.
Follow the implementation.
- 01
Use a star schema to organize the analytical entities and facts.
- 02
Build DAX measures for performance and period comparisons.
- 03
Explore delivery SLA, cohort retention, activation, and sales-drop decomposition.
- 04
Organize the reporting experience into executive, operations, retention, and commercial views.
See the work. Inspect the details.
Look at the model, DAX library, and reporting pages to understand how the business questions are decomposed. The repository connects customer lifecycle questions to operational context.
Published Power BI home view · Captured from the published Power BI report. Select to enlarge.
Go beyond
the screenshot.
Load the public Power BI report to explore its pages and filters. The interactive view connects to Microsoft Power BI when you choose to load it.
Choose where to look deeper.
Search the linked source inventory or narrow it to the kind of artifact you want to inspect. Files open at their original source.
7 linked source files
No linked files match this view.