Sales Data Analysis

This repository contains a Power BI project that provides a comprehensive analysis of Monthly E-commerce Sales data. The dashboard allows users to explore key metrics, trends, and insights to make informed business decisions.

Table of Contents

• Project Overview
• Features
• Data Sources
• Dashboard Walkthrough
• Installation
• Usage
• Contributing
• License

Project Overview

The Sales Analysis Dashboard is designed to help an E-commerce Business to overview their Sales performance throughout the year. It includes a report and visualizations that cover sales performance, customer segmentation, product analysis, and more.

Features

• Sales Performance: Track overall sales, growth trends, and performance against targets.
• Customer Segmentation: Analyze customer demographics, purchasing behavior, and profitability.
• Product Analysis: Identify top-selling products, product categories, and sub-categories insights.
• Geographical Insights: Visualize sales data by State and City.
• Time-Based Analysis: Explore sales trends over time, including Monthly and Quarterly patterns over the year.
• Payment Metrics: Identifying the distribution of Payment Methods across the Sales Percentage.

Data Sources

The dashboard is built using data from the following CSV file sources:

• Details: The Details table contains the data which includes Amount, Category, Order ID, Payment Mode, Profit, Quantity and Sub-Category.
• Orders: The Orders table contains columns such as Order ID, Order Date, State, City and Customer Name.

Dashboard Walkthrough

1. Sales Overview

Displays total sales, total profit, average order value, profit margin and the need to improve sales based on specific region.

2. Top Products

Highlights the top-selling products and categories. Provides insights into average order value and profit.

3. Customer Insights

Segments customers based on purchasing behavior. Identifies high-value customers and their impact on revenue.

4. Geographical Distribution

Maps sales data by State and City to identify top-performing areas. Analyzes regional trends and market penetration.

5. Monthly Sales Trends

Visualizes sales trends over time, highlighting peak periods. Compares monthly performance across different years. Also compares max revenue generated by top customers.

Usage

• Explore the interactive visuals to gain insights into sales performance.
• Use filters and slicers to focus on specific Quarterly time or States.
• Share insights with your team by exporting reports or sharing the dashboard via Power BI service.

Contributing

Contributions are welcome! If you have any suggestions or feedbacks for improvements, feel free to submit a pull request or open an issue.