Problem Statement:
This project intends to conduct a comprehensive analysis of YouTube songs data using Power BI. The analysis aims to uncover trends, preferences, and patterns in the data to aid content creators and stakeholders in optimizing their YouTube song content.
Problem Objective:
The goal is to utilize Power BI to create insightful visualizations and reports that provide a deeper understanding of YouTube songs' performance, popularity, and user engagement.
Dataset Information:
The songs.csv dataset contains 19345 rows and 13 following columns:
- video_id: Unique identifier for each YouTube video.
- channelTitle: Title of the YouTube channel publishing the song.
- title: Title of the YouTube song video.
- description: Description provided for the YouTube song video.
- tags: Tags associated with the YouTube song video.
- publishedAt: Date and time when the YouTube song video was published.
- viewCount: Number of views received by the YouTube song video.
- likeCount: Number of likes received by the YouTube song video.
- favoriteCount: Number of times the YouTube song video has been marked as a favorite.
- commentCount: Number of comments posted on the YouTube song video.
- duration: Duration of the YouTube song video.
- definition: Video definition or quality (e.g., HD, SD).
- caption: Availability of captions for the YouTube song video.
Steps involved:
- Data Cleaning and Preparation
- Exploratory Data Analysis (EDA)
- Content and Channel Analysis
- Temporal Trends
- User Engagement Insights
Dashboards:
- Home Dashboard:
The Home Dashboard provides a high-level summary with key metrics and trends about the data:
- KPIs: Total videos, views, likes, comments, favorites, and average engagement rate.
- Trending Metrics: Recent trends in views, likes, and comments.
- Top Performers: Highlights of top channels and videos.
- Interactive Filter: Options to filter data by channel, video quality, and other relevant parameters.
- Video Performance Dashboard:
The Video Performance Dashboard provides detailed insights into how individual videos are performing in terms of views, likes, comments, favorites, and other metrics. This dashboard helps identify top-performing videos, understand trends over time, and uncover factors contributing to video success.
- Top Videos by Key Metrics: Bar charts or tables showcasing top videos based on views, likes, comments, and favorites.
- Performance Trends Over Time: Line charts showing trends for key metrics over time.
- Video Duration Analysis: Histograms or scatter plots analyzing the impact of video duration on performance.
- Video Quality Analysis: Pie charts or bar charts analyzing the distribution of video quality.
- Caption Availability Analysis: Bar charts or pie charts analyzing the impact of captions on video performance.
- Tag Analysis: Word clouds or bar charts showing popular tags and their impact on performance.
- Engagement Dashboard:
The Engagement Dashboard provides insights into how users interact with your YouTube videos. It focuses on various engagement metrics like views, likes, comments, shares, and favorites. This dashboard helps you understand which videos resonate the most with your audience and why.
- Engagement Overtime: A line chart showing the trend of engagement rate over time.
- Video Duration Analysis: Histograms or scatter plots analyzing the impact of video duration on engagement rate.
- Top Songs by Engagement Rate: Bar charts or tables showcasing top songs based on engagement rate.
- Distribution of Metrics: Pie charts analyzing the distribution of engagement metrics.
- Tag Analysis: Line charts showing impact of tags on engagement rate.
Inferences:
- Which song video has the highest view counts?
- Vaaste Song: Dhvani Bhanushali, Tanishk Bagchi | Nikhil D | Bhushan Kumar | Radhika Rao, Vinay Sapru has the highest view counts.
- What is the trend in engagement (likes, comments, favorites) over time?
- From the engagement dashboard, we can see a significant increase in the engagement rate over the years.
- Are there specific tags or keywords that consistently correlate with higher viewer engagement?
- Tags like 'tseries', 'hindi songs' and 'bollywood songs' correlate highly with the viewer engagement rate.
- Is there a correlation between video duration and viewer engagement (views, likes, comments)?
- The songs having short duration have higher viewer engagement as compared to songs having long duration.
- Which songs have the highest engagement rate (engagements per view)?
- The songs having highest engagement rate are:
- De De Pyaar De - Official Trailer (Russian) | Ajay Devgn, Tabu, Rakul Preet Singh | Akiv Ali
- Tere Mere Beech Mein Song | Babul Supriyo | Lal Sarkar
- Jubin Nautiyal: Aise Kaise (Lyrical) | Rohanpreet Singh, Rana Sotal | Bhushan Kumar
- Are there seasonal trends in song popularity or viewer engagement?
- There doesn't appear to be any seasonal trends in viewer engagement.
- How does video quality (e.g., HD vs. SD) impact viewer engagement?
- 'HD' quality videos show much higher viewer engagement as compared to 'SD' quality videos.
- What were the top songs in the past year (2023) by likes?
- Top songs in 2023 by likes were:
- Ram Siya Ram (Hindi) Adipurush | Prabhas | Sachet-Parampara, Manoj Muntashir | Om Raut | Bhushan K
- Achha Sila Diya |Jaani & B Praak Feat. Nora Fatehi & Rajkummar Rao | Nikhil-Vinay,Yogesh | Bhushan K
- Jai Shri Ram (Hindi) Adipurush | Prabhas | Ajay-Atul, Manoj Muntashir Shukla | Om Raut | Bhushan K
