2 of 10

INTRODUCTION

Burger Hub encountered challenges in leveraging its sales data to make informed business decisions. and without proper analysis of sales trends and ordering patterns, the business struggle to optimize operations, improve customer satisfaction, and increase profitability.

This analysis aims to address the root-causes of concerns by examining key performance metrics and providing actionable insights to help Burger Hub make data-driven decisions that support long-term growth.

3 of 10

Overview of Dashboard

4 of 10

��Objectives��…Analyze Sales Trends and ordering patterns to improve operational efficiency.��..Utilize Data Insights to enhance customer satisfaction and boost profitability.� ��

MY PROJECT GOAL & OBJECTIVES

Goal

..Make better business decisions using sales data at Burger Hub.

5 of 10

APPROACH DEPLOYED��Adopted the root cause analysis technique to examine and identify the problems affecting the business. This helped us uncover key inefficiencies, and challenges that were slowing down operations, limiting sales, and affecting customer satisfaction.��From findings, I suggested practical solutions to improve efficiency, streamline processes, and reduce order delays or cancellations, as well as provide a clear action plan, to make smarter decisions that support long-term growth and success.�

6 of 10

HIGHLIGHTS SALES PERFORMANCE

This is a summary of metric analysis on Overall Sales Performance.

Total Revenue (N21,712): Total amount generated from burger sales.
Average Revenue (N43.40): The average amount spent per order.
Quantity of Orders (500): Total number of orders placed and processed.

Key Insights:

Thus, this analysis shows that customers usually spend N43.40 per order, meaning they often buy more than just one burger on every visit to the Hub.

7 of 10

The chart illustrates customers' burger preferences across other brands, which shows Veggie Burger as the most popular, with the highest number of orders at slightly above 105, making it the top choice among customers.

Order preference efforts can be optimized by:

Stock high demand orders- Prepare more Veggie Burgers in advance and prioritize inventory planning around this popular burger brand.
Promote lower selling orders, through discounts and improved recipes.
Increase workforce to speed up service.

8 of 10

The chart shows more canceled (181) and pending (150) orders than completed (169) burger orders, indicating likely operational inefficiencies that may need addressing to improve order fulfillment and customer satisfaction.

Key Insights for Operational Improvement:

Prevent Cancellations: Maintain proper stock levels to ensure all orders can be fulfilled.
Improve Efficiency: Reduce delays by optimizing kitchen workflow and staff coordination.
Enhance Customer Experience: Keep customers informed about their order status and resolve issues promptly.

9 of 10

Outcome of the chart shows the trend of burger orders over four sales quarters as follows:

Q1 had the highest orders (above 500), but they dropped significantly in Q2.
Q3 saw a further decrease, reaching just below 300.
Q4 had the lowest orders, with only a slight decline from Q3.

From above decline performance, sales can be increased with effective marketing to enhance operational efforts.

10 of 10

END NOTE

This analytic initiative, reveals several insights for Burger Hub's business improvement and opportunity to address sales challenges in other to enhance customer satisfaction, reduce order cancellations and delays, and ultimately drive sustainable business growth.

1 of 10