Power BI Sales Analysis Report

1. OVERVIEW OF SALES

Overview

This Power BI report provides an in-depth analysis of a company's sales data across various product categories and regions. The report is designed to offer actionable insights by presenting sales performance, trends, and relationships in a user-friendly and interactive format.

Data Categories

The report covers the following product categories:

• Electronics
• Footwear
• Clothing
• Home Appliances
• Accessories
• Kitchenware
• Bags
• Personal Care

Objectives

The Power BI report addresses the following business questions:

1. Top/Bottom Products by Performance

   • Identify the top 5 and bottom 5 products by:
     • Sales
     • Profit
     • Quantity Sold

2. Sales Trends Over Time

   • Analyze how sales vary:
     • Daily
     • Monthly
     • Quarterly
     • Annually

3. Sales and Profit Relationship

   • Visualize and understand the correlation between sales and profit.

4. Product Comparisons

   • Compare sales and profit for any two products over a user-selected timeframe.

5. Total Number of Orders

   • Display the total number of orders across all categories.

6. Average Discount by Category

   • Calculate the average discount offered in each product category.

7. City-wise Sales Distribution

   • Analyze sales distribution across different cities.

Key Features

• Interactive Filters: Allow users to filter data by product category, city, and timeframe.
• Visual Representations: Includes bar charts, line graphs, pie charts, and scatter plots to make data interpretation easy.
• Dynamic Comparisons: Enables side-by-side comparison of sales and profit metrics for any two products.

Instructions for Use

1. Open the Power BI file.
2. Use the navigation pane to explore different report tabs for specific analyses.
3. Apply filters to customize the view as per your requirements.
4. Interact with the visualizations to drill down into specific data points.

Benefits

This report empowers stakeholders to:

• Identify high-performing and underperforming products.
• Make data-driven decisions to optimize sales and profitability.
• Understand customer behavior across cities and product categories.
• Monitor the impact of discounts on sales and profit.

Prerequisites

• Ensure the sales data is up-to-date and formatted correctly.
• Power BI Desktop installed on your system.

Future Enhancements

• Integrate real-time data updates.
• Include customer demographics for targeted marketing insights.
• Expand city-level analysis with region and state-level breakdowns.