Marketing Campaign Analysis & Interactive Dashboard (Excel + Power Query)

Analyzed a dataset of 5,000+ marketing campaigns across multiple channels (Social Media, Email, Google Ads, Influencer) using Excel and Power Query.

Key tasks:

- Cleaned and transformed raw data using Power Query

- Built PivotTables to analyze: Acquisition Cost, Conversion Rate, ROI, and Engagement Score by channel and campaign type

- Designed a professional Dashboard with a cohesive color scheme, KPI cards, and interactive Slicers

- Extracted insights on the most cost-efficient and highest-ROI channels

Tools: Excel, Power Query, PivotTables, Data Visualization