Power BI Project

?? Excited to Share My Latest Power BI Dashboard! ??

I’m thrilled to showcase my recent Power BI report, a dynamic 2-page dashboard that dives into my personal YouTube data! Here's a quick overview of what makes this project special:

?? Unique Visualizations

I pushed the boundaries of traditional visuals by incorporating Deneb and custom HTML code to craft engaging and highly detailed visuals. The experience truly leveled up my dashboard design skills!

• Mastered Power BI Bookmarks and Selection Pages for tailored interactivity.
• Designed customized tooltips to enhance the user experience.

??? DIY Data Creation

The dataset for this project was entirely self-created! Using Python coding ?? and the YouTube API, I extracted personal data, including:

• Total subscribed and liked channels
• Detailed channel statistics
• Country-based insights
• Video URLs
• Video Categories, and much more

This project also gave me hands-on experience with Google Cloud Console to set up OAuth 2.0 credentials for secure data access.

?? Learning Highlights

• Developed a deeper understanding of API integration workflows, from authentication to data extraction.
• Enhanced Python coding skills, especially in data handling and working with libraries like requests and pandas.
• Mastered concepts like loops, iterations, and managing API rate limits effectively.
• Explored creative problem-solving techniques, like merging disparate datasets and ensuring data accuracy for visualization.

?? Data Science Experimentation

I even took a shot at predictive modeling! Tried applying Linear Regression and Decision Tree algorithms for predictions. While the results weren’t as efficient due to data specificity limitations, it was a valuable learning experience, and I’m eager to refine these skills in future projects with Tableau.

?? This project was a fusion of creativity, coding, and analytics—each step taught me something new! Excited for what’s next in this data journey!

?? Link to Dashboard: ?? Click here to view the dashboard!

?? Link to GitHub Code ?? Click here to view the Code!

Feedback is always welcome—let me know your thoughts! ??

#PowerBI #DataVisualization #Python #YouTubeAPI #DataAnalytics #LearningJourney #PowerOfData ???

Page 1: YouTube Channel and Subscriber Insights

• Deneb Visuals for Comment Trends Using Deneb, a custom visual in Power BI, I utilized JSON syntax from Vega-Lite to create a dynamic visualization showing total comments based on dates.

Visual - Top Channels By Category

• Challenge: I wanted to enable a drill-down feature to show top channels within categories, but the visual displayed counts instead of channel names.
• Solution: I created bookmarks for each category and used them with bar charts to display top 10 channels. This added a detailed layer to the visualization.

Visual - Top Subscribed Channels by Country

• Challenge: Filtering the top 10 channels by country removed countries without top subscribers from the visual.
• Solution: I wrote a DAX formula:

Rank by Subscribers =  
RANKX(  
    ALLSELECTED('SubscribedChannels'[channel_name]),  
    CALCULATE(SUM('SubscribedChannels'[subscribers])),  
    ,  
    DESC,  
    Dense  
)          

Readability of Values: Large numbers like subscriber counts were converted into a user-friendly format (e.g., “M” for millions) using DAX:

Subscribers in M = FORMAT([Total Subscribers] / 1000000, "0.0") & "M"  
        

Page 2: Liked Video Insights with HTML Content

On the second page, I explored a creative use of the HTML Content Visual to dynamically display the thumbnail of my most-liked YouTube video.

• Challenge: Extracting and displaying the video thumbnail with the highest like count.
• Solution: A DAX formula was used to retrieve the URL of the most-liked video, which was then embedded in HTML for rendering

_Image = 
VAR x = 
    CALCULATE(
        MAX('Rakesh_liked_videos_with_details'[thumbnail_url]),
        'Rakesh_liked_videos_with_details'[like_count] = MAX('Rakesh_liked_videos_with_details'[like_count])
    )
RETURN         

Tooltip Issue: I wanted the tooltip to display channel names only during drill-downs.

• Solution: A DAX formula returned channel names only when a specific channel was selected.

Channel Name Tooltip =  
VAR SelectedChannel = SELECTEDVALUE('SubscribedChannels'[channel_name])  
RETURN IF(NOT ISBLANK(SelectedChannel), SelectedChannel, "")  
        

?? Key Takeaways and Learnings

• Mastered New Visual Tools: Deneb for custom visuals and HTML for dynamic content.
• Problem-Solving in Visualization: Leveraged bookmarks, DAX, and creative workarounds for challenges in interactivity and display logic.
• Deeper API Integration Skills: Extracted personal YouTube data using Python and the YouTube API, secured with Google Cloud OAuth 2.0 credentials.
• Data Modeling with DAX: Improved ranking, filtering, and formatting data for more intuitive visuals.