rugwed09 / regional-sales-dashboard

Regional Sales Dashboard project, using Power BI & Python for customer retargeting & transaction analysis. Improved decision-making, customer engagement, sales efficiency, & location analytics. Boosted business growth through predictive analytics for sales forecasts & inventory management.

Regional Sales Dashboard Project

Overview

The Regional Sales Dashboard is a personal project designed to provide comprehensive insights into sales performance across various dimensions, including customer retargeting, transaction analysis, product insights, sales team analysis, store locations, and time range analysis. This project aims to enhance strategic decision-making through data-driven insights.

Features

• Customer Retargeting Dashboard: Identifies potential customers for retargeting campaigns based on past purchase behavior and engagement.
• Transaction Analysis Dashboard: Breaks down sales transactions to understand patterns, peak times, and customer preferences.
• Product Insights Dashboard: Analyzes product performance, identifying top-selling items and areas for improvement.
• Sales Team Analysis Dashboard: Evaluates sales team performance, highlighting top performers and areas for training.
• Store Locations Analysis Dashboard: Assesses the performance of physical store locations, guiding expansion or optimization strategies.
• Time Range Analysis Dashboard: Offers insights into sales trends over different time frames, aiding in forecasting and planning.

Images of the actual Project

• Home Screen
  
• Location Analysis -Time-Range Analysis -Transaction Analysis

Technologies Used

• Power BI: For creating interactive and visually appealing dashboards.
• Python: Employed for data cleaning, manipulation, and analysis, utilizing libraries such as Pandas and NumPy.
• Predictive Analytics: Applied machine learning models to forecast sales and analyze trends.

Getting Started

To get started with this project, follow these steps:

1. Clone the repository: git clone <repository-url>
2. Install required Python libraries: pip install pandas numpy
3. Open Power BI files: The dashboard files (.pbix) are located in the dashboards folder. Open them using Power BI Desktop.
4. Data Sources: Update the data source connections within Power BI to point to your sales data.

Contributing

Interested in contributing to the Regional Sales Dashboard project? Please read CONTRIBUTING.md for guidelines on how to submit issues or pull requests.

Thank you for exploring the Regional Sales Dashboard project!