Dashboard Dataset for Excel

Dataset for Excel Dashboard   -- Click Here to Download


Assignment Brief: Excel Dashboard Creation

Objective: Develop an interactive Excel dashboard to provide comprehensive insights into sales performance. The dashboard should allow users to analyze various aspects of sales data to make informed business decisions.

Analysis Requirements:

  1. Product Category Performance:

    • Examine the performance of different product categories across various cities.

  2. Sales Trends Over Time:

    • Analyze how sales have changed over different periods (e.g., monthly, quarterly).

  3. Customer Age Group Distribution:

    • Understand the distribution of sales across different customer age groups.

  4. Product Performance:

    • Identify the best and worst-performing products.

  5. Payment Methods Analysis:

    • Analyze the preferred payment methods of customers.

  6. State-Wise Sales Performance:

    • Evaluate sales performance across different states.

  7. Top Customers:

    • Calculate the average sales amount per customer, focusing on the top 10 customers.

Dashboard Features:

  • Slicers:

    • Category Slicer: Allows users to filter data by product category.

    • Year/State Slicer: Provides the option to filter data by year or state.

Deliverables:

  • An Excel dashboard that includes all the analysis requirements.

  • Clear and visually appealing charts and graphs to represent the data.

  • Interactive elements, such as slicers, to facilitate dynamic data exploration.

Comments

Post a Comment

Popular posts from this blog

Power BI Practice

❓ Power BI Practice Data https://docs.google.com/spreadsheets/d/1qQ90Fru5QbNK8QjgPSVOSIlLcHFa2hXO/edit?usp=sharing&ouid=105173447805752617719&rtpof=true&sd=true Scenario: Retail Sales Performance Analysis Business Context: You are a Business Analyst at a retail chain called TrendZone . The company operates across multiple cities and sells four product categories: Electronics, Apparel, Home Decor, and Sports Equipment. Management wants to understand sales performance, profitability, and customer purchasing behavior. ❓ Power BI Practice Questions 🔹 Level 1: Basic Reporting Create a bar chart showing total sales by ProductCategory . Show a table with CustomerName, City, and their TotalSales . Use a slicer to filter data by Region and see how total profit changes. What is the average discount given per product category ? 🔹 Level 2: Intermediate DAX & Modeling Create a new calculated column: NetSales = TotalSales - Discount . Create a measure for ...
Read more

TIME SERIES ANAYSIS DATASET

 https://docs.google.com/spreadsheets/d/1Ans3hkk0RuC9tMLq8X83bFYA_6Zux8K6/edit?usp=sharing&ouid=105173447805752617719&rtpof=true&sd=true basic practice data above.. ------------------------------------------------------------------------------ ☕ Scenario: Coffee Shop Monthly Sales (Excel Practice) Context: You are analyzing monthly sales data for a chain of 5 coffee shops (Central, North, South, East, West) from January 2022 to December 2024 . 📊 Practice Tasks (for Excel) Line Chart: Plot monthly sales trend for each branch. Moving Average: Calculate 3-month and 6-month moving averages. Growth Rate: Compute month-over-month and year-over-year growth. Seasonality Check: Identify months with consistently higher or lower sales. Branch Comparison: Create a line chart comparing all 5 branches. Forecasting (Basic): Use Excel’s trendline feature to project next 6 months. Practice Dataset https://docs.google.com/spreadsheets/d/1JKiaBWRzur3E_ySpfdMOZ...
Read more