Coffee and Tea Sales Analysis Dashboard

This Excel dashboard provides an overview of sales data for coffee and tea across various states in the U.S. The dashboard is designed to visually represent key metrics and trends to facilitate data-driven decision-making.

Data Source

The data used in this dashboard is sourced from Kaggle.com , which contains information on sales figures for coffee and tea in different states from 2012-15.

Dashboard Components

Overview

• Summary Statistics: Key metrics such as total sales, profit per state, and market-size wise sales.
• Geographical Distribution: Map visualization showing sales distribution across states.

Sales Performance

• Trend Analysis: Line chart displaying yearly profit with respect to the cost of goods.
• Comparison: Combination charts comparing target margin vs. actual margin and target cogs vs. actual cogs.

State-Level Analysis

• State Rankings: Table listing states with area code categorized by market size and type of product sold.
• Detailed Breakdown: Pivot table providing a detailed breakdown of sales by product type and state.

Instructions for Use

1. Data Preparation:

   • Ensure the source data file is updated and accessible.
   • Make sure the data is structured correctly with columns for state, product type (coffee/tea), and sales figures.

2. Opening the Dashboard:

   • Open the Excel file named [excel_data_analysis.xlsx].

3. Refreshing Data (if applicable):

   • If the dashboard contains any linked data or pivot tables, refresh them to reflect the latest data.

4. Interacting with the Dashboard:

   • Use filters or slicers to explore specific states or time periods.
   • Click on different components (charts, tables) to see dynamic interactions.

Author : Jasleen Kaur