How tusharsonkamble30/swynex-final-data-analytics-project works
This repository documents a retail-sales analytics case study: prepare a cleaned dataset, explore sales patterns, and present results in a Power BI dashboard for business decisions. The README describes cleaning and validation, analysis of categories, payments, channels, time trends and outliers, plus dashboard KPIs, visuals and slicers. The tree contains the cleaned workbook, notebook and dashboard artifacts, but no cleaning source code; relationships below rely on README documentation rather than inspected implementation.
Main entry points: cleaned_retail_store_sales.xlsx Cleaned Sales Data · SWYNEX-Interactive-Dashboard.pbix Interactive Dashboard · EDA_Retail_Sales.ipynb Sales Exploration · SWYNEX-Interactive-Dashboard.pdf Dashboard Export
Components 6
Sales Data
- Cleaned Sales Data
data/cleaned_retail_store_sales.xlsx
Exploratory Analysis
- Sales Exploration
analysis/EDA_Retail_Sales.ipynb
Business Dashboard
- Interactive Dashboard
dashboard/SWYNEX-Interactive-Dashboard.pbix - Dashboard Export
dashboard/SWYNEX-Interactive-Dashboard.pdf
Other components
- Kaggle Dataset
- Business Decision Makers
Connections 5
- Kaggle Dataset → Cleaned Sales Data: provides source
README.md - Cleaned Sales Data → Sales Exploration: analyzed in
README.md - Cleaned Sales Data → Interactive Dashboard: feeds dashboard
README.md - Interactive Dashboard → Business Decision Makers: supports decisions
README.md - Interactive Dashboard → Dashboard Export: exported as
README.md