← All work
BUSINESS INTELLIGENCE / EGYPTIAN RETAIL SCENARIO

B2B Retail Analytics & Churn Diagnostic

A Power BI portfolio exploring retailer lifecycle, delivery performance, sales changes, and category mix in a B2B grocery-distribution scenario.

THE PROJECT / FOLLOW THE THREAD

A question. A process.
Work you can explore.

Follow the decisions behind the implementation, then inspect the original work.

01 / WHY THIS WORK EXISTS

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.

ProjectB2B Retail Analytics & Churn Diagnostic
Available evidence7 linked files · visual preview
ExplorePublic interactive report
02 / THE CHOICES & CONNECTIONS

Follow the implementation.

  1. 01

    Use a star schema to organize the analytical entities and facts.

  2. 02

    Build DAX measures for performance and period comparisons.

  3. 03

    Explore delivery SLA, cohort retention, activation, and sales-drop decomposition.

  4. 04

    Organize the reporting experience into executive, operations, retention, and commercial views.

Power BISQLDAXSQL ServerPower Query
Read the implementation notes
03 / OPEN THE WORK

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.

FMCG Sales & Retailer Lifecycle — published Power BI home viewEnlarge preview
Published Power BI home view
Explore Power BI interactions View the original source
04 / THE WORK BEHIND THE CLAIM

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

DOCREADME.mdPBIXMaxab Retail Performance & Churn Analytics Dashboard.pbixDOCdesign/maxab-dashboard-wireframe.htmlPBIPMaxab Retail Performance & Churn Analytics Dashboard.pbipJSONthemes/maxab-theme.jsonJSONthemes/Power BI Theme by BIBB.jsonJSONsrc/Maxab Retail Performance & Churn Analytics Dashboard.SemanticModel/diagramLayout.json
Open the documentation Explore the repository
LATEST FROM GITHUB

The source
keeps moving.

Source updated

Real-time insights into retailer behavior, operational performance, and customer lifecycle across the Maxab distribution network in Egypt.

Current README excerpt

Real-time insights into retailer behavior, operational performance, and customer lifecycle across the Maxab distribution network in Egypt.

A source excerpt, not an independently verified outcome.

A different question.
A connected skill.

Power Query · SQL · Power BI

Accounts Receivable Analytics

An accounts-receivable analytics scenario connecting synthetic transactions, Power Query transformations, and a star schema.

Follow this project
Power BI · SQL · DAX

Apple Stock Market Analysis

An end-to-end data engineering and analytics project analyzing historical Apple Inc. (AAPL) stock market data up to the present day, to extract actionable business insights and…

Follow this project
Power BI · SQL · SQL Server

Data Engineering Learning Roadmap

A practical, self-paced roadmap for SQL, Python, analytics engineering, data pipelines, big data, and portfolio projects.

Follow this project
A QUESTION WORTH EXPLORING?

Let’s make something useful.

Start a conversation

Project preview

Find a project

↑ ↓ to navigate · Enter to open · Esc to closeBrowse all work ↗