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.
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.
Management needs measurable KPIs and performance reports to support data-driven decisions.
The system generates KPIs and reports for customers, subscriptions, revenue, orders, and deliveries.
As a business manager, I want to view KPIs and reports so I can monitor performance and make informed decisions.
Values match source data; filters update dashboard visuals; the reporting output is validated against the defined need.
Nine stakeholder groups were documented with role, business needs, responsibilities, influence, and interest.
Primary relationship chain: Customer → Subscription → Order → Delivery, with Payments linked to Subscription.
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.
This in-page explorer is a lightweight portfolio preview built from the cleaned project data; it is not a Power BI Service embed.
145 customer records - the highest among the eight cities in the cleaned dataset.
Balanced Living has the most subscriptions (143), while Muscle Gain has the highest contract value (31,440 JOD).
Card payments contribute 21,757.50 JOD, the highest paid-revenue amount among payment methods.
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.
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.
Validation rules, duplicate checks, controlled categories, and documented business rules reduce the risk of inconsistent customer, subscription, order, payment, and delivery information.
The dashboard consolidates revenue, subscription, order, and delivery KPIs into a refreshable management view with City and Plan filters.
No percentage time saving, error-elimination rate, or production ROI is claimed because implementation in a real company is outside the project scope.
Problem, objectives, scope, benefits, assumptions, constraints, risks.
Stakeholders, 10 BRs, 16 FRs, 8 NFRs, rules, acceptance criteria, dependencies.
Cross-functional workflow analysis and proposed process redesign.
16 stories with acceptance criteria, priority, related requirement, points, and status.
Role, needs, responsibilities, influence, and interest across 9 stakeholder groups.
Customers, subscriptions, orders, payments, deliveries, and data-quality notes.
11 business analyses including KPIs, plans, cancellations, delivery, payments, geography, and MoM revenue.
Analytical dashboard snapshot from the project dataset.
Final management dashboard with KPIs, six visuals, and City / Plan slicers.