A comprehensive Power BI dashboard analyzing social media user engagement across major platforms — surfacing KPIs, content performance trends, demographic breakdowns, and platform reach analytics through interactive DAX-powered visualizations built during an internship at Code from Basics, Chennai.
Developed during an internship at Code from Basics, Chennai (Oct 2024 – Jan 2025), this Power BI dashboard transforms raw social media engagement data into a fully interactive analytics suite. The project demonstrates end-to-end BI workflow — from data ingestion and cleaning through DAX measure development to dashboard design and insight communication. Key deliverables include cross-platform engagement benchmarks, content type performance analysis, and demographic reach visualizations.
Unified KPI layer comparing reach, engagement rate, impressions, and follower growth across Instagram, YouTube, TikTok, Twitter, and Facebook.
Advanced DAX formulas for engagement rate calculation, YoY growth metrics, rolling averages, and dynamic top-N content rankings.
Age group, gender, and geographic segmentation of audience engagement — revealing which demographics respond to which content types.
Time-series analysis of post performance by content type (video, image, carousel, story) with peak engagement time identification.
Dynamic filtering by platform, date range, content type, and demographic segment — enabling drill-down analysis without code.
Clean one-page overview with key insights, traffic-light KPI indicators, and strategic recommendations for marketing teams.
Engagement data collected from multiple social platforms via exports and APIs — consolidated into a structured flat-file format for Power BI ingestion.
Power Query M transformations handle null values, type casting, date normalization, and column standardization across heterogeneous platform exports.
Star schema built with fact table (engagement events) and dimension tables (platform, content type, date, demographics) — optimized for DAX performance.
Custom measures for engagement rate, reach efficiency, demographic affinity scores, and comparative performance benchmarks using calculated columns and measures.
Multi-page dashboard built with consistent visual language — published to Power BI Service for web access and embedded in the project site via iframe.