Sales Optimization Dashboard
Embedded Files
Project Description:
As a Data Analyst for WixSin Company, I was tasked with leveraging the sales dataset to build an interactive dashboard using Microsoft Excel. The primary objective was to answer key business questions related to revenue growth, revenue patterns, category proportions, state contributions, segment performance, and top-selling products. The ultimate goal was to provide actionable recommendations to the Management for sustaining or increasing revenue.
Project Objectives:
Project Objectives:
Monthly Revenue Growth:
To analyze the sales dataset to determine if revenue is growing on a monthly basis.
Revenue by Days of the Week:
To identify the days of the week when the company makes the most revenue.
Category Proportion to Total Revenue:
To calculate the proportion of each category to the total revenue.
State Contributions to Total Revenue:
To assess the contribution of each state to the total revenue of the company.
Segment Revenue Analysis:
To determine which segment has the highest amount of revenue.
Top 5 Best-Selling Products:
To identify and present the top 5 best-selling products.
Project Tasks:
Project Tasks:
Monthly Revenue Growth:
Analyzed sales data to track and visualize monthly revenue trends.
Revenue by Days of the Week:
Created visualizations showcasing revenue patterns across different days of the week.
Category Proportion to Total Revenue:
Calculated and visualized the proportion of each category relative to the total revenue.
State Contributions to Total Revenue:
Conducted an analysis to determine the contribution of each state to the company's total revenue.
Segment Revenue Analysis:
Evaluated and visualized the revenue performance of different segments.
Top 5 Best-Selling Products:
Identified and presented the top 5 best-selling products based on sales data.
Project Dashboard/Visualization
My Achievements:
My Achievements:
Insightful Monthly Revenue Trends:
I analyzed and visualized monthly revenue trends, providing insights into growth patterns.
Optimal Revenue Days Identified:
I identified the specific days of the week when the company generates the most revenue.
Category Proportion Analysis:
I calculated and visually represented the proportion of each category to total revenue.
State-wise Revenue Contribution:
I assessed the contribution of each state to the total revenue, offering insights for targeted strategies.
Segment Performance Insight:
I determined the segment with the highest revenue, guiding strategic focus.
Top 5 Best-Selling Products:
I identified the top 5 best-selling products, offering a focus on marketing and inventory management.
Recommendations to Management:
Focus on High-Revenue Days:
Allocate marketing efforts or promotions on days identified as high revenue-generating days.
Category-Specific Marketing Strategies:
Tailor marketing strategies for categories with high proportions to maximize revenue.
State-Specific Targeting:
Implement targeted strategies in states contributing significantly to revenue for potential growth.
Segment Optimization:
Invest resources in optimizing the segment identified with the highest revenue for continued success.
Product-Specific Promotions:
Design promotions or campaigns around the top 5 best-selling products to further boost sales.
Page updated
Google Sites
Report abuse