Sales_Analytics_Report

This interactive Power BI Report delivers a comprehensive analysis of Sales Analysis of an export and import company. It includes multiple visualizations ranging from donut chart, bar chart, column chart, tree map and line chart, offering insights into sales performance across categories, sub-categories, payment modes, and states.

Summary Page

1. Bar Chart: Sum of Quantity and Sum of Profit by Category Insight: Clothing and Electronics lead in both quantity sold and profit, with Clothing slightly ahead in quantity. Furniture lags behind in both metrics but still contributes significantly. Profit is much lower than quantity across all categories, highlighting possible margin differences.

2. Donut Chart: Sum of Amount by Category Insight: Electronics accounts for the largest share of sales amount (168K, 37.8%). Clothing follows closely (127K, 28.6%). Furniture has the smallest share (144K, 33.97%). The distribution is relatively balanced, but Electronics is the top revenue driver.

3. Pie Chart: Sum of Profit by Category and Sub-Category Insight: Electronics and Clothing dominate the profit share, with several sub-categories contributing to the total. The chart highlights which sub-categories (e.g., specific types of electronics or clothing) are most profitable. Some sub-categories contribute only a small fraction, suggesting potential areas for improvement or reevaluation.

4. Treemap: Sum of Amount by Category and Payment Mode Insight: Electronics and Furniture sales are distributed across various payment modes (EMI, Credit Card, UPI, COD). Clothing shows a strong presence in COD and Credit Card payments. The treemap reveals customer payment preferences by category, which can inform marketing or payment strategy.

5. Card Visuals: Key Metrics Sum of Amount: 438K Sum of Profit: 37K Insight: These KPIs provide a quick snapshot of overall sales and profitability.

6. Line Chart: Sum of Quantity by State and Category Insight: Maharashtra and Uttar Pradesh are the leading states in terms of quantity sold, especially for Clothing. There is a steep drop-off after the top states, with other states contributing much less. This geographic breakdown helps identify high-performing regions and potential markets for growth.

Payment Mode Analysis Page

1. Sum of Amount of Good Stolen by State (Top Left Bar Chart) Insight: This chart displays the total monetary value of stolen goods ("Stole" sub-category) across different states. Madhya Pradesh and Maharashtra have the highest losses, each with amounts exceeding ₹3,000, followed by Delhi, Uttar Pradesh and West Bengal. The losses drop sharply after the top states, indicating that theft is a more significant issue in a few key regions. The high loss in Madhya Pradesh and Maharashtra suggests these states either have higher sales volumes (and thus more exposure) or may face greater theft risks. The business should investigate operational, logistical, or security factors in these states to address the disproportionately high losses.

2. Sum of Quantity by City and Payment Mode (Top Right Line Chart) Insight: This line chart tracks the quantity of goods (units) sold across cities, segmented by payment mode. COD (Cash on Delivery) is the dominant payment mode in nearly all cities, with the highest quantities, followed by Credit Card, EMI, and others. The sharp decline after the top city (likely Mumbai or Delhi) shows that a few cities account for most transactions. COD’s dominance may contribute to higher theft or loss risks, as goods are in transit longer and may be more vulnerable before payment is collected. Cities with high quantities and COD preference should be prioritized for risk management.

3. Sum of Amount by Sub-Category and Payment Mode (Bottom Left Stacked Bar Chart) Insight: This chart shows sales amount by product sub-category, further broken down by payment mode. For COD, Saree is the leading sub-category in terms of sales amount, with COD and Credit Card being the most common payment methods. For Credit Card, printers and phones are the front runners.

4. Sum of Amount and Sum of Profit by Payment Mode (Bottom Right Bar Chart) Insight: COD leads by a large margin in both total sales amount and profit, followed by Credit Card and EMI. UPI and Debit Card have much lower figures. Interpretation: While COD drives revenue and profit, it may also be associated with higher risk of loss (as seen in the "Stole" sub-category). Balancing COD convenience with risk mitigation is crucial.

Key Insight: Stolen Goods Amount Loss The "Stole" sub-category represents a significant source of financial loss, especially in Madhya Pradesh and Maharashtra. High COD usage in these regions and sub-categories may be a contributing factor, as goods are more vulnerable before payment is secured.

Actionable Recommendations: Strengthen security and tracking for COD shipments, especially for "Stole" goods in top-loss states. Consider piloting pre-payment or secure delivery options in high-risk areas. Analyze operational processes in Madhya Pradesh and Maharashtra to identify and address vulnerabilities.

City and Category Analysis Page

1. Sum of Profit by City and Category (Top Chart) This clustered bar chart displays the profit generated in each city, segmented by product category: Clothing (yellow), Electronics (blue), and Furniture (gray/blue). Insights: Indore stands out with the highest profit, especially in Electronics, followed by significant profits in Clothing. Pune, Mathura, and Chandigarh also show strong profits, again with Electronics leading. Several cities (e.g., Mumbai, Bhopal, Udaipur, Hyderabad) show negative profits (bars below zero), particularly in Electronics and Furniture, indicating losses in those categories. Many cities have relatively low or neutral profits, suggesting that profit generation is concentrated in a few key urban centers and product lines. Electronics is the most profitable category in most top cities, but also carries risk, as seen in cities with losses. Negative profits in certain cities/categories may indicate operational issues, high costs, or low sales prices. Targeting high-profit cities for expansion and investigating loss-making cities/categories for corrective action could improve overall profitability.

2. Sum of Quantity by City and Category (Bottom Chart) This line chart visualizes the total quantity of products sold in each city, again segmented by category. Insights: Clothing (yellow line) dominates in quantity sold across nearly all cities, with Indore and Mumbai leading by a wide margin. Electronics and Furniture (blue lines) have much lower quantities sold, with a relatively flat trend across cities. After the top few cities, the quantity sold drops sharply, indicating that most sales volume is concentrated in a handful of locations. Clothing is the most popular category by volume, but not always by profit (as seen above). Electronics, while lower in quantity, can be highly profitable in the right cities. The sharp drop-off in both profit and quantity after the top cities suggests a need to focus marketing and distribution efforts where they are most effective.

Overall Page Insights

• Indore, Pune, and Mathura are critical cities for both sales volume and profit, especially for Electronics and Clothing.
• Negative profits in some cities/categories highlight areas for cost control or sales strategy review.
• Clothing is the top-selling category by quantity, but Electronics can deliver higher profits per unit in certain cities.
• Sales and profit are highly concentrated in a few cities—expanding successful strategies from these cities to others could drive growth.

Actionable Next Steps:

• Investigate reasons for losses in specific cities/categories.
• Focus marketing and inventory on high-performing city-category pairs.
• Explore ways to improve profitability in lower-performing regions.

Monthly Analysis Page

1. Sum of Profit and Sum of Amount by Month (Top Left Clustered Column Chart) The orange bars represent the Sum of Amount (total sales revenue) each month. The blue bars represent the Sum of Profit each month.

Insights: Sales amount is generally much higher than profit, indicating margins vary. Some months (e.g., month 1 and month 2) have high sales and profits. Mid-year months show dips in both sales and profit. Towards the end of the year, sales and profits rise again, possibly reflecting seasonal trends.

2. Sum of Profit by Month and Category (Top Right Clustered Column Chart Chart) Profit is broken down by Category: Clothing (yellow), Electronics (blue), and Furniture (gray). Each month displays profit contributions from each category.

Insights: Electronics and Clothing dominate profit in most months. Some months show negative profits, especially in Electronics and Furniture, indicating losses or returns. Profit peaks in months 1, 2, 3 and 11, suggesting strong performance during these periods. Fluctuations highlight the need for category-specific strategies per month.

3. Sum of Quantity by Month and Category (Bottom Line Chart) This line chart tracks the quantity sold each month, split by category.

Insights: Clothing consistently leads in quantity sold across all months, with noticeable peaks in months 1, 2, 3, 8, and 11. Electronics and Furniture have much lower and relatively stable quantities, with only minor fluctuations. The gap between Clothing and the other categories is significant, indicating that while Electronics may drive profit volatility, Clothing is the main volume driver.

4. Month Slicer (Left Sidebar) Purpose: Allows users to filter all visuals on the page by selected months. Users can select one or multiple months (from 1 to 9 visible here) to focus the analysis on specific time periods.

Effect: When a month or range of months is selected, all charts update dynamically to reflect data only for those months. This interactivity helps identify trends or anomalies in specific months

Overall Page Insights

• Seasonality: Sales, profit, and quantity fluctuate throughout the year, with early and late months generally performing better.
• Category Performance: Clothing leads in quantity sold, while Electronics and Clothing dominate profit, though Electronics shows some months with losses.
• Profit vs. Sales: High sales do not always translate to high profits, highlighting margin considerations.
• Interactive Filtering: The month slicer enables targeted analysis to support decision-making for specific periods.

Actionable Next Steps:

• Investigate causes of negative profits in specific months, especially for Electronics.
• Leverage strong months for future promotions.
• Explore strategies to boost Furniture sales and stabilize Electronics profit.