Builds 21 - "Enterprise DNA YouTube Channel Data Analysis"

[Gaelan]

Excited to submit my first challenge entry!
Enterprise DNA YouTube Channel Analysis

My main goal was to make sure I nailed the brief: The objective is to understand the audience better and have a further strategy to drive more channel engagement. To that end, I dug into actionable questions and insights that could respond to audience viewership and drive more engagement:

• Overall trends from a few perspectives
• Length of video and subject matter
• Timing of when videos are released - both time of day and day of week/month
• The length and words in the titles
• The age and gender of viewers
• Where viewers are across the world, particularly where viewership is growing or declining compared to past months
• The five Focus Cities called out in the dataset

I took a bit of liberty on the Video Details page and categorized the videos based on their titles. Each video already has a number of tags, and it seemed like narrowing these down to a few buckets would allow better insight into which videos the audience is most interested in.

A huge thank you to @BrianJ for solving a tricky problem with TopN for the titles - check it out in this thread!

Creating the mobile view was a fascinating challenge. Thanks for adding that and pushing us to learn new tricks.

[FPastor]

@Gaelan

Hi Gaelan,

Welcome to Challenge 21 “Enterprise DNA You Tube Channel Data Analysis”.

Thank you for your entry, well done and excellent work.

Please do not forget to accept the challenge in LinkedIn to make it official and please send me a copy of your file via email to federico.pastor@enterprisedna.co

All the best!!

Regards.

Federico

[ChallengeTeam]

Hi everyone, this is an entry submitted by Sunil Mathew via email.

Here’s how Sunil Mathew described it:

Here is my submission for Enterprise DNA Ltd Challenge 21 - EDNA YouTube Channel Data Analysis.​

I hope you like it

You may view the full report here
Sunil Mathew

Please feel free to give Sunil your feedback on his report.

[ChallengeTeam]

Hi everyone, this is an entry submitted by Mayur Pawar via email.

Here’s how Mayur Pawar described it:

Participating in Enterprise DNA challenge is always superb and a learning experience. I see amazing and incredible work possible in Power BI with the entries already submitted by other participants. There is a lot to learn from each of the participant’s work. Also, I want to adulate the efforts of the Enterprise DNA team, which provides a platform to share work on their platform and seek feedback from experts

You may view the full report here
Mayur Pawar

Please feel free to give Mayur Pawar your feedback on his report.

[Alvi]

Hi Datafam

I am pleased to share the submission for EDNA Challenge 21 and after Team JMAP I have also partnered with another EDNA member @Wishal Khalid who is entering the challenge for the 1st time. This is part of my efforts to motivate Power BI newbies in attempting EDNA challenges. In this case, I am honored to partner with @Wishal Khalid who has done the bulk of the work.

Here is the submission from Team AK

1. Intro screen
   

2. EDNA journey with milestones
   

   
   
   
   
   
   
   
   
   
   

3. Channel Analytics
   

   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   

4. Video Analytics
   

   

The web report can be seen on the following link

Power BI Report

Mobile app snapshots will be posted by @Wishal Khalid shortly.

The detailed submission report will be shared after the deadline.

Thank you King @FPastor for another great challenge. Best of luck everyone!!

Best Regards
Abu Bakar Alvi

[ChallengeTeam]

Hi everyone, this is an entry submitted by Angelina Shrafi via email.

Here’s how Angelina Shrafi described it:

To create my report for this challenge I inspired by the Analytics section of Creator Studio in YouTube profile. I watched some videos on YouTube and tried to make a useful report including top 3 videos based on the selected period, the number of views and subscribers gained along with the date each video is published and some other charts

You can view the full report here
Angelina Shrafi

Please feel free to give Angelina Shrafi your feedback on her report.

[ChallengeTeam]

Hi everyone, this is an entry submitted by Tim Weinzapfel via email.

Here’s how Tim Weinzapfel described it:

For this one, I focused only on a few areas including;​

Overall Analysis.​

Analysis of the Video Data.​

Key Indicators.​

Datasets Comparison

You can view the full report here
Tim Weinzapfel

Please feel free to give Tim Weinzapfel your feedback on his report.

[ChallengeTeam]

Hi everyone, this is an entry submitted by Subham Kumar Das via email.

Here’s how Subham Kumar Das described it:

I accepted Enterprise DNA Challenge 21. Thank you for providing this kind of challenges to us.​
I hope you like it.

You can view the full report here
Subham Kumar Das

Please feel free to give Subham Kumar Das your feedback on his report.

[ChallengeTeam]

Hi everyone, this is an entry submitted by Matthias Smeets via email.

Here’s how Matthias Smeets described it:

I have accepted DNA Challenge 21 - YouTube Channel data analysis. It was a nice dataset to explore and do some visualizations on. Gained so new skills and tried to implement them in my dashboards.

You can view the full report here
Matthias Smeets

Please feel free to give Matthias Smeets your feedback on his report.

[ChallengeTeam]

Hi everyone, this is an entry submitted by Veronica Flores via email.

Here’s how Veronica Flores described it:

I accepted Enterprise DNA Challenge 21. Thank you for providing this kind of challenges to us.​
I hope you like it.

You can view the full report here
Veronica Flores

Please feel free to give Veronica Flores your feedback on her report.

[ChallengeTeam]

Hi everyone, this is an entry submitted by Bankim Ghosh via email.

Here’s how Bankim Ghosh described it:

I accepted Enterprise DNA Challenge 21.​
I hope you like it

You can view the full report here
Bankim Ghosh

Please feel free to give Bankim Ghosh your feedback on his report.

[FPastor]

Hi Enteprise DNA Subscribers,

Enterprise DNA Challenge 21 is officially closed.

Another remarkable EDNA Challenge with a new record numbers of entries "62"

First and most important, we have reached over 1,600 group members during data challenge 21!!!

Let us revisit some highlights happened during Challenge 21:

Our data challenge hub grew up to 1,658 subscribers within 5 months.

We launched 33 posts in EDNA Challenges Community Group in LinkedIn.

We engaged 21,058 post views.

We interacted over 150 comments.

We accepted 62 finals entries.

Our participants have produced well over 240+ analysis pages.

Our participants’ reports contain more than 550+ DAX measures, well over 350+ Navigation buttons, Bookmarks and Tool tips.

The variety of native and customs visuals in the reports is a mastery of Data Visualization.

All highlights cannot be achieved without your dedication. You are the owner of our community; we love your passion and motivation on your data journey!

Congratulations to all participants, you have done excellently well. Enterprise DNA thanks you for your efforts and dedication.

A round of applause to the Enterprise DNA Community Lead Team for a tremendous effort in the making and coordination of this challenges.

Let us say goodbye to Challenge 21 and wait for the winner announcement and Challenge 22 soon!

Federico Pastor
Head of Platform Experience & Data Challenges
Enterprise DNA

Challene 21_All Participants.pdf (7.9 MB)

[ChallengeTeam]

Hi everyone, this is an entry submitted by Darpan Sahai via email.

Here’s how Darpan Sahai described it:

“I accepted Enterprise DNA Challenge 21.​
I hope you like my report. A very interesting dataset”

You can view the full report here
Darpan Sahai

Please feel free to give Darpan Sahai your feedback on his report.

[ChallengeTeam]

Hi everyone, this is an entry submitted by Vera Ambrosio via email.

Here’s how Vera Ambrosio described it:

I accepted Enterprise DNA Challenge 21.​
I hope you like my report. A simple 4 pages report

You can view the full report here
Vera Ambrosio

Please feel free to give Vera Ambrosio your feedback on his report.

[Wishal-Khalid]

Hi. Apologies for the delay. Here is the mobile view

[sam.mckay]

Congratulations on a fantastic report. Really enjoyed looking into the creative analytics that you worked up.

Sam

[sam.mckay]

Fantastic challenge round. Well done everyone

[FPastor]

Hi Enterprise DNA Subscribers

We are proud to announce the winners of the Enterprise DNA Challenge 21 “Enterprise DNA You Tube Channel Data Analysis”

This month’s Winners are:

Overall and Platform Member Winner

Rachwen Mosbehi
Challenge Winner badge
Display of Report into the EDNA Showcases

Newcomer Winner

Matthew Braun
TBA with Winner

Non-Member Winner

Gaelan Smith​:1st_place_medal:
Winner of a free subscription to Enterprise DNA learning Platform

Mobile View Winner

Veronica Aides​:1st_place_medal:
Winner of a free subscription to Enterprise DNA learning Platform

We would also like to congratulate our finalists and participants.

It has been amazing to see the Enterprise DNA data platform family and Challenges Group members come together and learn on this month’s challenge and create stunning and creative reports!

Thank you to our judges panel Gustaw Dudek, Solar Zhu, Brian Julius and Mudassir Ali for providing their expertise and time. Thank you to the Enterprise DNA Expert group for their inputs and feedback to the participants in the Enterprise DNA forum.

Check the recording of the judging panel

Enterprise DNA Challenge 21 Judging Of Entries - YouTube Data Analysis

Finally, a big thank you to the Enterprise DNA Challenges Group “Community Lead Team” for their help and support during challenge 21, Solar Zhu and Kiruba Selvi.

The Challenges Team is working hard to bring you Challenge 22. Challenge 22 will be out on 19th August 2021.

Join us on

https://www.linkedin.com/groups/14069197/ ]

The winners_C21.pdf (1.2 MB)

Thank you.

Federico Pastor

[DavieJoe]

Well done to all the winners and entrants, amazing content as always!

Thanks also to the Challenges Team for organising.

DJ

[rufaiahmadel]

Building data analysis for the Enterprise DNA YouTube channel is no small feat. Kudos to you! Have you ever tried using a YouTube Channel Dashboard to spice up your analytics game? I found this awesome one on Pinterest https://www.pinterest.com/pin/1012747034939312190/ that might add an extra layer of insights.