This project focuses on analyzing business sales performance using data analytics and visualization techniques using Power BI.
The objective of this project is to identify important business trends, product performance, regional profitability, and revenue patterns to generate meaningful business insights and recommendations.
This project was completed as part of the Future Interns Data Science & Analytics Internship – Task 1 (2026).
The main objective of this project is to analyze business sales data and answer important business questions such as:
- Which products generate the highest revenue?
- How do sales change over time?
- Which category performs best?
- Which region is most profitable?
- Where can business performance be improved?
- Power BI – Data visualization and dashboard creation
- CSV Dataset – Business sales data analysis
- Microsoft Word – Documentation and reporting
The dataset includes important business-related information such as:
- Order ID
- Order Date
- Ship Date
- Product Name
- Category
- Region
- Sales
- Profit
- Quantity
- Discount
This dataset represents a retail business sales scenario and helps in performing real-world business analysis.
Before analysis, the dataset was cleaned and prepared for accurate results.
The following preprocessing steps were performed:
- Converted Order Date and Ship Date into proper date format
- Fixed date formatting issues using locale settings
- Verified numeric columns such as:
- Sales
- Profit
- Quantity
- Discount
- Checked for missing values
- Cleaned and prepared the data for business analysis
| KPI | Value |
|---|---|
| Total Sales | 2.30M |
| Total Profit | 286.40K |
| Total Quantity Sold | 38K |
| Total Orders | 5.009K |
The dashboard includes the following business analytics visualizations:
Analyzes how business sales changed over time.
Compares revenue generated by different product categories.
Shows profitability across different business regions.
Identifies products contributing the highest revenue.
Compares category profitability.
Allows dashboard interaction using region-based filtering.
- West region generated the highest profit
- Central region generated the lowest profit
- Technology category generated the highest profit
- Furniture category generated the lowest profit
- A limited number of products contributed significantly to overall sales.
- Sales fluctuated over time but showed an overall increasing trend.
Based on the analysis, the following recommendations are suggested:
- Increase investment in Technology products
- Improve performance in the Central region
- Review pricing and discount strategies in the Furniture category
- Prioritize marketing and inventory for Top-selling products
- Analyze seasonal sales trends for better business planning
Business-Sales-Performance-Analytics/
│── Sample - Superstore.csv
│── Business_Sales_Performance_Analytics.pbix
│── Business Sales Performance Analytics Report.docx
│── Dashboard Screenshot.png
│── Dashboard.pdf
│── README.md
This project demonstrates how data analytics and Power BI can be used to transform raw business sales data into meaningful insights and actionable recommendations.
Through KPI analysis, trend analysis, category comparison, regional profitability analysis, and product performance evaluation, this project provides a data-driven approach to business decision-making.
Pushp Jain
BTech Computer Science Student
Aspiring Data Science & Analytics Professional