🚀 Portfolio Project: E-Commerce Data Pipeline & Analytics (PostgreSQL)
Processed and analyzed ~500,000 raw transactional logs from the Online Retail II dataset to clean messy operational records and extract executive business intelligence metrics.
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...