Portfolio · Amman, Jordan

Abdullah Derbashi

Junior Business & Data Analyst

I turn scattered business operations into structured requirements, clearer workflows, reliable data, and decision-ready reporting. My work combines business analysis with data analytics so the solution is documented, measurable, and useful to the people who run the business.

LinkedIn ↗ Contact Me
aldrbashe86@gmail.com+962 7 8639 8243Amman, Jordan
10 / 16 / 8Business / Functional / Non-functional requirements
7 · 16 · 14Jira Epics · User Stories · Subtasks
2,500Meal orders analyzed
78,300 JODPaid revenue modeled
Featured Case Study

Meal Subscription Management System

Status: In Progress · Portfolio Case Study

A simulated end-to-end business analysis and data analytics engagement for a meal subscription operation whose customer, subscription, order, payment, and delivery activities were being managed across separate Excel files and WhatsApp conversations.

The case study covers business case development, stakeholder analysis, BRD requirements, As-Is / To-Be process mapping, Agile backlog design in Jira, data cleaning, SQL analysis, KPI definition, Excel reporting, and Power BI dashboarding.

Scope transparency: the project uses simulated data, historical reporting, and solution design. Production software development, real-time Power BI connectivity, bank integrations, GPS tracking, and real-company implementation are outside the documented scope.
Business Problem

Fragmented operations

  • Separate Excel files and WhatsApp threads.
  • Duplicate and incomplete customer records.
  • Difficulty tracking subscription status and payments.
  • Delayed updates across customer service, finance, kitchen, and delivery.
  • No centralized management dashboard.
Proposed Direction

Centralized, traceable workflow

  • Single customer/subscription record with validation.
  • Defined lifecycle statuses and business rules.
  • System-supported order generation and delivery updates.
  • Structured data relationships from customer to delivery.
  • Refreshable KPIs and management reporting.
Process Analysis

As-Is → To-Be workflow redesign

4
As-Is pain points explicitly documented
Duplicates · delays · information risk · no centralized reporting
6
Cross-functional lanes in the process
Customer · CS · System/Finance · Ops/Kitchen · Delivery · Management
Auto
Designed validations and generation
Duplicate check · IDs · dates · orders
Traceable
Status updates through the lifecycle
Subscription · order · payment · delivery
Requirements Engineering

From business need to acceptance criteria

10
Business Requirements
BR-01 to BR-10
16
Functional Requirements
FR-01 to FR-16
8
Non-functional Requirements
Performance · Security · Usability · Reliability · Data Quality
10
Business Rules + 10 Acceptance Criteria
Rules linked to requirements

Traceability example

BR-07

Management needs measurable KPIs and performance reports to support data-driven decisions.

FR-15

The system generates KPIs and reports for customers, subscriptions, revenue, orders, and deliveries.

US-15

As a business manager, I want to view KPIs and reports so I can monitor performance and make informed decisions.

AC / Dashboard

Values match source data; filters update dashboard visuals; the reporting output is validated against the defined need.

Stakeholder register

Nine stakeholder groups were documented with role, business needs, responsibilities, influence, and interest.

High Influence / High Interest

Business OwnerCustomer ServiceOperations ManagerBusiness Analyst

High Influence / Medium Interest

Finance Team

Medium Influence / High Interest

Kitchen TeamDelivery TeamCustomersData Analyst
No stakeholders documented here
Agile Delivery Design

Jira backlog structured for execution

7
Epics
Customer · Subscription · Order · Payment · Delivery · Reporting · Security
16
User Stories
Each linked to an Epic and requirement
14
Subtasks
Execution-level breakdown
83
Story Points across 3 planned sprints
Project status: Planned / In Progress
Data Work

Cleaning, validation, modeling, and SQL analysis

Data-quality evidence

1,050 → 1,019 customer rows31 duplicate customer rows were removed from the working customer dataset.
4 invalid subscription date records → 0End-date validation was applied so end dates no longer precede start dates.
11 missing meal names made explicitMissing values were standardized to an explicit “Unknown Meal” category rather than left blank.
Text and category standardizationCity values and order-status capitalization were normalized to consistent categories.
Validation backlog retainedTransaction-reference uniqueness, negative delivery delays, and failed-delivery completeness were also flagged as quality checks rather than silently ignored.

Logical data model

CustomersPK CustomerID SubscriptionsPK SubscriptionID OrdersPK OrderID PaymentsPK PaymentID DeliveriesPK DeliveryID 1 → * 1 → * 1 → * 1 → *

Primary relationship chain: Customer → Subscription → Order → Delivery, with Payments linked to Subscription.

SQL analysis - 11 business questions

01 Executive KPIs
02 Subscription performance by plan
03 Cancellation reasons by plan
04 Order status distribution
05 Top 10 ordered meals
06 Delivery status distribution
07 Delivery performance by time slot
08 Payment status distribution
09 Paid revenue by payment method
10 Geographic performance
11 Monthly revenue + MoM change
-- Example: monthly paid revenue and month-over-month change
WITH MonthlyRevenue AS (...)
SELECT RevenueMonth, PaidRevenueJOD, PreviousMonthRevenue,
  PaidRevenueJOD - PreviousMonthRevenue AS RevenueChangeJOD
FROM RevenueComparison ORDER BY RevenueMonth;
Reporting & Decision Support

Power BI dashboard and KPI layer

Power BI Healthy Food Subscription Dashboard
Power BI output: 7 KPI cards, six analytical visuals, and City / Plan slicers. Historical-data dashboard; interactive Power BI report available on request.
1,019Total customers
650Total subscriptions
2,500Total orders
78,300 JODPaid revenue
16.92%Cancellation rate
81.82%Delivery success rate
37.29 minAverage delivery delay

Interactive Power BI report available on request. The public portfolio uses the dashboard snapshot because Publish to web is disabled on the current university tenant.

Interactive portfolio preview

Filter the modeled subscription data

This in-page explorer is a lightweight portfolio preview built from the cleaned project data; it is not a Power BI Service embed.

650Subscriptions
116,075 JODContract Value
78,300 JODPaid Revenue
2,500Orders
16.92%Cancellation Rate
INSIGHT 01

Salt has the largest customer base

145 customer records - the highest among the eight cities in the cleaned dataset.

INSIGHT 02

Volume and value leaders differ

Balanced Living has the most subscriptions (143), while Muscle Gain has the highest contract value (31,440 JOD).

INSIGHT 03

Card leads paid revenue

Card payments contribute 21,757.50 JOD, the highest paid-revenue amount among payment methods.

INSIGHT 04

Morning delivery slot runs slower

10:00 AM-12:00 PM averages 38.16 minutes delay versus 35.41 minutes for 12:00 PM-2:00 PM, suggesting a capacity review opportunity.

Project Impact & Value Designed

What the solution is designed to improve

Efficiency Gain

The To-Be process removes repeated customer searching, duplicate re-entry, manual daily-order preparation, and disconnected status updates by centralizing records and automating key steps.

Designed impact - not production-measured

Data Accuracy

Validation rules, duplicate checks, controlled categories, and documented business rules reduce the risk of inconsistent customer, subscription, order, payment, and delivery information.

Measured example: 31 duplicate customer rows removed

Management Visibility

The dashboard consolidates revenue, subscription, order, and delivery KPIs into a refreshable management view with City and Plan filters.

Historical dashboard - no real-time connection in current scope

No percentage time saving, error-elimination rate, or production ROI is claimed because implementation in a real company is outside the project scope.

Links & Artifacts

Inspect the actual project outputs

Business Case

Problem, objectives, scope, benefits, assumptions, constraints, risks.

Business Requirements Document

Stakeholders, 10 BRs, 16 FRs, 8 NFRs, rules, acceptance criteria, dependencies.

As-Is / To-Be Process Maps

Cross-functional workflow analysis and proposed process redesign.

Jira Backlog / User Stories

16 stories with acceptance criteria, priority, related requirement, points, and status.

Stakeholder Register

Role, needs, responsibilities, influence, and interest across 9 stakeholder groups.

Clean Project Data

Customers, subscriptions, orders, payments, deliveries, and data-quality notes.

SQL Analysis

11 business analyses including KPIs, plans, cancellations, delivery, payments, geography, and MoM revenue.

Excel Analysis

Analytical dashboard snapshot from the project dataset.

Power BI Dashboard

Final management dashboard with KPIs, six visuals, and City / Plan slicers.

Education & Skills

Business analysis first, data analytics as decision support

Business Analysis

Requirements ElicitationBRD / Business CaseStakeholder AnalysisUser StoriesAcceptance CriteriaBusiness RulesAs-Is / To-Be MappingAgile / ScrumJiradraw.io

Data & Reporting

SQLExcelData CleaningData ModelingKPI DevelopmentPower BIData ValidationBusiness Insights
B.Sc. Computer Information SystemsAl al-Bayt University
Graduated 2023
ECBA (IIBA) preparationEntry Certificate in Business Analysis
In progress
Data Analytics and Visualization with AISuccess Edu Hub
2026