This project showcases an E-commerce Sales Dashboard created using Power BI. The dashboard provides key insights into sales performance, profit analysis, customer behavior, and more, allowing stakeholders to make informed decisions and optimize business strategies.
- Profit by Month: Visualizes monthly profits to identify revenue trends over time.
- Profit by Sub-category: Drill down into sub-categories to identify top-performing product lines.
- Orders by Category: Analyzes sales distribution across different product categories.
- Payment Mode Analysis: Identifies preferred payment methods to inform payment gateway decisions.
- Top 5 States by Revenue: Identifies high-revenue regions for targeted marketing efforts.
- Top 5 Customers: Recognizes top customers for personalized engagement strategies.
- Interactive dashboard with complex parameters for drilling down and filtering.
- Utilizes Power BI functionalities for data manipulation and visualization.
- Includes connections to e-commerce sales data sources and joined tables for comprehensive analysis.
To explore the dashboard:
- Download and install Power BI Desktop from Microsoft Power BI.
- Clone or download this repository to your local machine.
- Open the Power BI file (
Ecommerce_Sales_Dashboard.pbix) using Power BI Desktop. - Interact with the dashboard visuals and explore the data insights.
Ecommerce_Sales_Dashboard.pbix: Power BI file containing the dashboard visuals and data connections.data/: Folder containing sample e-commerce sales data for analysis.
Your feedback and contributions are welcome! Feel free to submit issues, suggestions, or pull requests to enhance this project.