This project analyzes Walmart historical sales data to identify sales trends, holiday impacts, seasonal patterns, and regional performance using Power BI.
The project focuses on helping decision-makers improve inventory management, promotional planning, and sales forecasting through data-driven insights.
- Analyze historical Walmart sales data
- Identify the impact of holidays and markdowns on sales
- Discover seasonal sales patterns and trends
- Compare regional and departmental performance
- Build an interactive Power BI dashboard for business insights
- Power BI
- Data Cleaning & Preprocessing
- Data Visualization
- Sales Trend Analysis
- Handled missing and inconsistent data
- Normalized dates and categorical fields
- Processed outliers affecting sales trends
- Prepared the dataset for analysis and visualization
Key questions explored:
- How do sales vary during holiday weeks?
- Which departments achieve the highest holiday sales?
- What regional differences affect sales performance?
- What seasonal trends can be identified?
Created an interactive Power BI dashboard including:
- Weekly sales trend analysis
- Holiday vs non-holiday comparisons
- Department sales performance
- Regional sales visualization
- Provided business recommendations for inventory optimization
- Identified high-performing departments and peak periods
- Highlighted the influence of markdowns and holidays on sales
The Power BI dashboard file is included in the repository.
- Improved understanding of sales behavior during holiday periods
- Generated actionable business insights using data visualization
- Developed practical experience in Power BI and data analytics
Mostafa Mansor