Sales Analysis Power BI Dashboard

Table of Contents

• Introduction
• Dataset Source
• Technologies Used
• Setup Instructions
• How to Use
• Features & Visualizations
• Future Improvements
• Contributing
• License

---

Introduction

This repository contains a comprehensive Sales Analysis Dashboard built with Power BI. The dashboard provides actionable insights into sales performance, customer activity, shipment efficiency, and product trends. It is designed for business analysts, sales managers, and decision-makers to monitor KPIs and drive data-driven strategies.

Key Insights:

• Total orders, sales, and units sold
• Customer segmentation (active, inactive, new)
• Shipment performance (on-time, late)
• Returned orders analysis
• Top-selling items and sales by person
• Yearly trends in sales and profit

---

Dataset Source

The dashboard uses sales, customer, and shipment data. The dataset includes:

• Sales orders
• Customer details
• Shipment records
• Product information

Note: Please update this section with your actual data source (e.g., SQL Server, Excel, CSV) if required.

---

Technologies Used

• Power BI Desktop (.pbix file)
• Data modeling (DAX, Power Query)
• Interactive visualizations

---

Setup Instructions

1. Download Power BI Desktop
   • Power BI Desktop Download
2. Clone this repository

   git clone https://github.com/yourusername/SalesAnalysis.git

3. Open the Dashboard
   • Launch Power BI Desktop.
   • Open the Dashboard.pbix file from the cloned repository.
4. Connect Data (if required)
   • If the dashboard uses external data sources, update the data connections via Home > Transform Data > Data Source Settings.
   • Refresh the data to load the latest records.

---

How to Use

• Explore interactive visuals by clicking on charts, slicers, and filters.
• Drill down into specific years, products, or salespersons.
• Use filters to segment data by time, product group, or customer.
• Export insights or visuals as needed.

---

Features & Visualizations

Dashboard Overview

The dashboard provides the following insights and features:

• KPI Overview:
  • Total Orders: Displays the total number of sales orders.
  • Total Sales: Shows total sales value (e.g., 2.77M).
  • Total Units Sold: Indicates total quantity sold.
• Customer Segmentation:
  • Customers 2024: Number of active customers in 2024.
  • Inactive Customers: Customers with no recent activity.
• Shipment Performance:
  • On Time Shipment %: Percentage of shipments delivered on time.
  • Late Shipment %: Percentage of late shipments.
• Returned Orders:
  • Number of orders returned by customers.
• Sales List & Top Items:
  • Table of customer sales, unique items, and quantities.
  • Bar chart of top-selling products.
• Gross Profit & Sales Trends:
  • Line chart showing profit and quantity trends by product group.
  • Yearly sales value and profit trends.
• Sales by Person:
  • Visual breakdown of sales by individual salespersons.

Preview image above illustrates all major dashboard features. Replace P.png with your actual preview image filename if needed.

---

Future Improvements

• Add more granular filters (e.g., region, product category)
• Integrate real-time data sources
• Enhance mobile responsiveness
• Add predictive analytics and forecasting

---

Contributing

Contributions are welcome! Please open issues or submit pull requests for improvements, bug fixes, or new features.

---

License

This project is licensed under the MIT License.