Comprehensive Sales & Financial Analysis for Global Electrical Supply Clients

Data Cleaning & Structuring: Organized raw sales records (SAP, KVA, KV, QTY, SO, Unit Price, Currency, Total Price) into a clear, analyzable format.

Pivot Table Reporting: Built summary dashboards showing total quantities and revenues per customer, highlighting top contributors like Sahary Misr Group (€2.49M) and Arab Industrial ($1.02M).

Currency & Pricing Insights: Compared unit prices across EUR, USD, and EGP transactions to identify pricing trends and opportunities.

Client Segmentation: Delivered actionable insights on customer purchasing behavior, frequency, and product preferences.