Power BI Capstone Project YouTube Performance & Audience Engagement Dashboard
This capstone project presents an interactive YouTube Performance & Audience Engagement Dashboard developed using Microsoft Power BI. The objective of this dashboard is to analyze channel performance metrics, audience engagement behavior, and category-level trends to generate actionable insights for content strategy and digital growth optimization.
Project Objective
The primary goal of this project is to:
Evaluate YouTube channel performance across multiple categories
Analyze subscriber growth and engagement metrics
Identify high-performing content types
Compare upload frequency versus audience reach
Support data-driven decision-making for content creators and media organizations
Key Performance Indicators (KPIs)
The dashboard highlights several critical metrics:
Total Uploads: 9M+
Maximum Uploads (Single Channel): 301K
Average Views (Last 30 Days): 165.73M
Minimum Video Rank: 1
These KPIs provide a macro-level understanding of overall platform activity and channel competitiveness.
Category-Level Insights Subscribers by Category
The dashboard compares subscriber distribution across major content types such as:
Entertainment
Music
Gaming
Education
Comedy
People & Blogs
Sports
News
Tech
The analysis reveals that Entertainment and Music dominate subscriber engagement, followed by Gaming and People categories.
Channel Type by Viewed-by-Subscribers
Total Views by Subscribers: 455,967.68
Top-performing categories:
Entertainment: 137,829.23
Music: 123,843.52
People: 42,864.78
Games: 35,691.14
Education: 24,077.66
This indicates that entertainment-driven content significantly outperforms informational and niche categories in subscriber-based views.
Rank-wise Category Analysis
Based on aggregated ranking:
Entertainment holds the highest cumulative rank score (123,525)
Music follows (90,092)
People & Blogs (70,554)
Gaming (50,590)
This confirms the dominance of mass-appeal content formats.
Business Insights
High upload frequency does not always guarantee proportional engagement.
Entertainment and Music channels show stronger subscriber retention.
Educational content has moderate engagement but lower viral potential.
News channels show high upload volumes but comparatively lower subscriber view concentration.
Audience engagement varies significantly by content category.
Technical Implementation
The dashboard was built using:
Power Query for data cleaning and transformation
DAX for calculated measures and KPIs
Interactive slicers for category-level filtering
Rank analysis visuals
Bar and comparative charts for performance benchmarking