Emmizee-dataanalyst/chicken_republic_sales_dashboard

The Chicken Republic Lagos Sales Dataset captures real-world retail transaction data from Chicken Republic outlets in Lagos, Nigeria. It provides insights into sales performance across different product categories, including revenue, quantity sold, and profit. # 🐔 Chicken Republic Sales Dashboard ## 📌 About the Dataset The **Chicken Republic Lagos Sales Dataset** captures real-world retail transaction data from Chicken Republic outlets in Lagos, Nigeria. It provides insights into sales performance across different product categories, including revenue, quantity sold, and profit. ### **Key Columns** - **Date**: Transaction date - **Location**: Outlet/branch where the sale occurred - **Product Category**: Category of the product sold (e.g., Meals, Drinks, Snacks) - **Product**: Name of the specific product - **Quantity Sold**: Number of units sold - **Unit Price (NGN)**: Price per unit - **Total Sales (NGN)**: Quantity × Unit Price - **Profit (NGN)**: Estimated profit from the sale ## 🔍 Exploratory Data Analysis (EDA) Questions 1. **What is the total revenue contribution of each product category?** 2. **How many units were sold in each product category, and which category leads in volume?** 3. **Which products generate the highest profit margins for the company?** 4. **How do monthly sales trends compare across the reporting period? Are there noticeable seasonal patterns?** 5. **Which locations deliver the highest profitability, and where are the underperforming regions?** 6. **Which individual products contribute the most to overall sales revenue?** --- ## ✅ Findings 1. **Top Products by Sales & Profit** - Ice Cream, Cake, and Sausage Roll were the top-performing products. 2. **Top Location by Profit** - Victoria Island recorded the highest profit. 3. **Best Performing Months** - April, May, and March were the top three months with the highest sales. 4. **Category Performance** - Dessert had the highest overall sales. - Meals had the highest number of units sold. 5. **Product Performance in Victoria Island** - Cake Slice was the top product in Victoria Island, with April being its peak month. --- ## 🛠 Recommendations Based on these insights, the following strategies are suggested: 1. **Capitalize on High …