Pizza King – End-to-End Data Analytics Project

Project Overview

This project aims to analyze restaurant sales data for Pizza King across multiple locations in Egypt, transforming raw data into meaningful business insights and interactive dashboards.

The project covers the complete data analytics workflow, from data cleaning and preprocessing to exploratory data analysis, SQL querying, and interactive business intelligence reporting.

Tools & Technologies

- Microsoft Excel: Advanced Data Cleaning, Pivot Tables, Advanced Formulas, and Interactive Dashboards.

- Python: Pandas, NumPy, Matplotlib, Seaborn, and Exploratory Data Analysis (EDA).

- SQL: Data Extraction, Joins, CTEs, Subqueries, Window Functions, and Business Analysis.

- Power BI: Data Modeling, DAX Measures, Interactive Dashboards, KPIs, and Geographic Sales Analysis.

Key Business Objectives

- Analyze total revenue and sales performance.

- Identify the best-performing branches across Egypt.

- Analyze customer purchasing behavior.

- Discover top-selling and low-performing products.

- Evaluate monthly and seasonal sales trends.

- Compare branch performance geographically using an Egypt map.

- Generate actionable business recommendations.

Expected Deliverables

- Advanced Excel Dashboard.

- Python Exploratory Data Analysis Notebook.

- SQL Business Analysis Queries.

- Interactive Power BI Dashboard.

- Business Insights & Final Recommendations.

Note: This is a portfolio simulation project using a practice dataset, not official Pizza King business data.