Data Analysis Project using Microsoft Excel

By Hansen Winarto

🎯 Project Objective

Analyze pizza sales data from a fictional restaurant to uncover insights related to top-performing products, order patterns over time, and revenue trends. The goal is to provide actionable business recommendations to increase sales and optimize the menu.

📦 Dataset Info

• Source: Provided CSV/Excel file (fictional data)
• Time Period: January – December 2015
• Total Records: ~48,000 order lines
• Columns: Date, Pizza Name, Size, Quantity, Total Price, etc.

📊 Tools Used

• Microsoft Excel
  • Pivot Tables
  • Charts (Bar, Line, Pie)
  • Conditional Formatting
• PowerPoint / Canva (for visual polish, optional)

🧠 Key Insights

Top Pizza by Quantity Classic Deluxe is the most ordered pizza with 2,453 orders, but it ranks 4th in revenue.

Top Pizza by Revenue Barbecue Chicken pizza generates the highest revenue (~Rp42 million).

Peak Time Diner time (6 PM – 11:59 PM) accounts for 39% of total orders.

Seasonal Drop Sales noticeably dip in September and October, possibly due to lack of promotions or seasonal behavior.

Low Performers The Brie Carre Pizza are the lowest ordered pizzas (under 500 orders).

💡 Recommendations

→ Upsell High-Volume Items