Data Cleaning & Preparation for Influencer Marketing Campaigns (Excel & Power Query)

Processed a large influencer marketing dataset (~150,000 rows, 10 columns) using Excel Power Query.

Cleaned and standardized text fields (platform, influencer_category, campaign_type)

Handled missing dates and invalid entries

Removed duplicates and validated campaign duration

Created derived columns for analysis (Campaign_Year, Engagement_Rate, Sales_per_1K_Reach)

Prepared a clean dataset ready for KPI calculation and dashboarding