Instagram & Facebook Ads Dashboard | Power BI Project
Developed a comprehensive Ads Performance Dashboard for both Instagram and Facebook to analyze and optimize digital advertising campaigns across multiple metrics and audiences.
Cleaned, transformed, and modeled raw ads data to ensure accuracy and consistency across platforms.
Built advanced DAX measures to calculate key KPIs including impressions, clicks, CTR, engagement rate, conversions, purchases, and average budget.
Designed interactive visuals to analyze ad performance by:
Gender and age groups
Ad type (Image, Video, Carousel, Stories)
Time (hours, days, and weeks)
Created platform-specific views while maintaining a unified data model for cross-platform comparison between Instagram and Facebook campaigns.
Implemented dynamic filters and slicers to enable deep-dive analysis and data-driven optimization decisions.
This project demonstrates strong expertise in Power BI, DAX, data modeling, marketing analytics, and transforming complex ads data into actionable insights for performance optimization.