Sabuj Das
$10/hr
Excel Data Specialist | Data Entry, Lead generation, Cleaning, Formatting, Analysis & Visualization
- Reply rate:
- 100.0%
- Availability:
- Hourly ($/hour)
- Age:
- 30 years old
- Location:
- Chandpur, Chittagong, Bangladesh
- Experience:
- 5 years
Superstore sales Dashboard
Project Title: Superstore Annual Sales Dashboard
Objective: Develop an interactive Excel dashboard to analyze and visualize annual sales data for
a superstore, providing insights into sales performance across various dimensions such as
gender, age group, sales channels, and geographic regions.
Key Features:
1. Order vs. Sales Analysis:
o
Visual representation of the total number of orders compared to total sales
revenue over the year.
2. Orders by Demographics:
o
Breakdown of orders by gender and age group to understand customer
demographics.
3. Sales by Channel:
o
Analysis of sales distribution across different sales channels (e.g., online, instore).
4. Top 5 Selling States:
o
Identification of the top 5 states contributing to sales, highlighting regional
performance.
5. Order Status Overview:
o
Visualization of order statuses (e.g., delivered, pending, canceled) to assess order
fulfillment efficiency.
6. Interactive Slicers:
o
Incorporation of slicers for month, product category, and sales channel to allow
users to filter data dynamically.
7. Insights and Recommendations:
o
Provision of actionable insights based on data analysis to inform business
strategies.
Tools and Techniques:
•
Microsoft Excel:
•
o
Utilization of PivotTables and Pivot Charts for data summarization and
visualization.
o
Implementation of slicers for interactive data filtering.
o
Application of conditional formatting to highlight key metrics.
Data Sources:
o
Superstore sales dataset containing information on orders, customers, products,
and sales transactions.
Outcome:
The dashboard provides a comprehensive view of the superstore's annual sales performance,
enabling stakeholders to make informed decisions based on data-driven insights.
Attachments:
