Analytics Overview for Company — Food Delivery Performance Dashboard

Tools: Tableau, Excel

Skills Demonstrated: Data Visualization, Sales Analysis, Promotional ROI Analysis, KPI Reporting

Situation

The company wanted a clear, data-driven view of its food delivery business performance. Leadership needed to understand the relationship between sales, promotions, and customer ordering patterns across different cuisines and categories to guide marketing spend, product focus, and operational decisions.

Task

Design an interactive dashboard that:

1. Consolidates revenue, promotion cost, discount, and order volume into a single view.
2. Tracks weekly order trends by cuisine to identify demand patterns.
3. Analyzes promotional impact by cuisine and food category.
4. Highlights best-selling and underperforming product categories to inform menu and campaign strategy.

Action

1. Data Preparation: Cleaned and structured raw order and promotion data in Excel, standardizing cuisine and category fields.
2. Dashboard Design in Tableau:
3. Created KPI cards for revenue, promotion cost, orders, and discounts for at-a-glance performance.
4. Built a weekly orders trend chart segmented by cuisine to track seasonal and promotional spikes.
5. Designed a treemap to visualize the distribution of promotions by cuisine and highlight the top beneficiaries.
6. Developed a bar chart for “Food Ordered per Category” to rank products by share of orders.
7. Integrated interactive filters (Region, Cuisine, Category, Week) to allow customized exploration.
8. Analysis: Assessed the contribution of top categories (Beverages, Sandwiches, Pizza) and identified low-performing segments needing marketing intervention.

Result

1. Delivered an interactive analytics dashboard that reduced report preparation time for management by over 50%.
2. Revealed Beverages as the largest revenue driver (40.7% of total orders), validating promotion spend allocation.
3. Identified Italian cuisine as the most responsive to promotions, particularly Italian Sandwiches (25.6% of promotion share).
4. Provided insight into seasonal demand peaks, leading to more targeted promotional timing and improved ROI on marketing spend.
5. Enabled real-time performance tracking, allowing the marketing team to adjust campaigns on the fly.

Portfolio Value: This project demonstrates my ability to transform operational and promotional data into clear, actionable insights using Tableau. The visual storytelling approach made it easier for decision-makers to see performance gaps, capitalize on high-demand categories, and optimize marketing spend for maximum impact.