This repository contains a comprehensive sales dashboard for the year 2023, developed to provide actionable insights for improving sales performance. The dashboard focuses on monthly sales analysis, patterns in weekday and weekend sales, and the impact of events on sales. The project is built using Power BI with Power Query and DAX for data manipulation and analysis.
- Overview
- Features
- Additional Insights
- Technical Details
- Files Included
- Schema
- How to Use the Dashboard
- Power BI Dashboard
- Contact
- Monthly Sales Analysis: Track the performance of different product categories, sales channels, warehouses, and states.
- Weekday vs. Weekend Sales Analysis: Identify patterns and trends in sales based on the day of the week.
- Event-Driven Sales Analysis: Analyze how sales are influenced by special events and promotions.
- Seasonal Trends: Identify and visualize seasonal trends affecting sales.
- Regional Performance: Compare sales performance across various regions to identify opportunities for growth.
- Underperforming Areas: Highlight areas that need attention for improvement.
- Tools Used: Power BI
- Data Manipulation: Power Query and DAX
- Data Sources: All relevant files used for this project are included in the repository.
- Power BI Dashboard File:
Madeleine Home Sales.pbix
- Data Files: All relevant data files used for analysis.
- Monthly Sales View: Navigate to the Monthly Sales tab to see a breakdown of sales performance by category, channel, warehouse, and state.
- Weekday vs. Weekend Sales: Explore the patterns in sales based on weekdays and weekends in the corresponding tab.
- Event Impact: Analyze the impact of special events on sales in the Events tab.
For any questions or feedback, please contact me at meabhaykr@gmail.com.
Thank you for checking out the Sales Dashboard 2023 project! Your feedback and contributions are highly appreciated.