Retail Store Transaction Analysis & Dashboard ( Excel Project)
Cleaned and standardized retail transaction data, formatting Date/Time fields, handling missing values, and creating a consistent data structure for analysis
• Built interactive Pivot Table reports to analyse monthly sales performance, product volumes, and payment method distributions for management reporting
• Designed an interactive executive dashboard using KPI metrics, Slicers, and Timeline controls to monitor sales performance and support data-driven decision-making
• Identified business trends from transactional data and presented key performance information through structured reports and visualizations