An Excel-based sales analytics project exploring product and revenue performance across regions, categories, and time periods. Includes data cleaning, KPI tracking, and visual insights to identify top-performing products, high-revenue regions, and customer payment preferences.
This dataset contains the sales details over a period of time across different regions. This is to analyze trends and figure out key insights. The goal of this sales analysis is to understand product and revenue performance across time, regions, and categories.
- Identify high-performing product categories.
- Understand monthly sales trends.
- Recognize top regions and preferred payment methods.
- Make informed decisions about promotions, logistics, and customer preferences.
Before visualization, data cleaning was done using Excel:
- Expanded cells and standardized headers
- Removed blanks and duplicates
- Corrected spelling errors and managed outliers
- Adjusted data types
- Converted the dataset to an Excel Table for easy analysis.
- Ensured consistent formatting for Product Categories and Payment Methods.
- Total Revenue: $80,568
- Total Units Sold: 518
- Top-Selling Product Category: Electronics
- Units Sold by Month (Bar Chart): March recorded the highest number of units sold. Suggests strong demand or effective campaigns during this period.
- Revenue by Month (Line Chart): Revenue follows a monthly trend with visible peaks and dips.
Aids in identifying seasonal or promotional impact on income.
- Revenue by Product Category (Column Chart): Electronics is the top-performing category in terms of revenue.
Other categories like Home appliances, sports and clothing may trail behind.
- Revenue by Region (Pie Chart): North America contributes the largest share of revenue.
Indicates strong market penetration or customer base in that region.
- Revenue by Payment Method (Column Chart): Credit Card is the most used payment method.
Shows customer preference for convenient, possibly online, payments.
- March stands out as the best-performing month in terms of unit sales.
- Electronics dominate the market — possibly due to high unit prices or high demand.
- North America is the strongest region, suggesting it’s a primary market.
- Customers prefer Credit Card payments, aligning with a tech-savvy or online-shopping customer base.
- Units sold (518) vs. revenue ($80K) implies high-value items are a big contributor, especially in the Electronics category.
- Focus more on Electronics by expanding offerings or bundling accessories.
- Investigate why March performs best — repeat successful promotions or campaigns from that month.
- Strengthen logistics and marketing in North America, while exploring strategies to boost performance in weaker regions.
- Promote credit card payment options further, and ensure secure, user-friendly platforms.
- Introduce loyalty or discount programs during slow months to balance revenue.