Oussamaseddik/DATA-ANALYSIS-OF-AZIZA-GROCERY

This project involves a comprehensive data analysis of a Tunisian grocery chain, Aziza, using Microsoft Excel. The analysis includes creating an interactive dashboard that provides actionable insights into sales performance, item distribution, and outlet metrics. # DATA-ANALYSIS-OF-AZIZA-GROCERY This project involves a detailed data analysis of the Aziza Supermarket chain in Tunisia. The goal is to provide insights into sales performance, customer satisfaction, and inventory distribution through interactive visualizations and key performance indicators (KPIs). The analysis was performed using Microsoft Excel, leveraging its Pivot Tables, Pivot Charts, and dashboarding features. Business Requirement The analysis aims to: =>Conduct a comprehensive review of Aziza Supermarket's sales data. =>Identify key insights and opportunities for business optimization. =>Visualize key metrics and trends to support data-driven decision-making. KPIs Tracked Total Sales: The overall revenue generated from all items sold. Average Sales: The average revenue per sale. Number of Items: The total count of different items sold. Average Rating: The average customer rating for items sold. Dashboard Features Visualizations Total Sales by Fat Content Objective: Analyze the impact of fat content on total sales. Additional Metrics: Compare KPIs (average sales, number of items, and average rating) across fat content categories. Chart Type: Donut Chart. Total Sales by Item Type Objective: Identify the performance of different item types based on total sales. Additional Metrics: Assess the variation of KPIs by item type. Chart Type: Bar Chart. Fat Content by Outlet for Total Sales Objective: Compare total sales across different outlets segmented by fat content. Additional Metrics: Analyze the distribution of other KPIs by outlet and fat content. Chart Type: Stacked Column Chart. Total Sales by Outlet Establishment Objective: Evaluate how the age or type of outlet establishment impacts total sales. Chart Type: Line Chart. -->Tools Used -Microsoft Excel: Pivot Tables and Charts Conditional Formatting Slicers for interactivity KPIs and Custom Formatting for better visualization and analysis. -->How to Use 1-Download or clone this repository. 2-Ope …