Builds 21 - "Enterprise DNA YouTube Channel Data Analysis"

[FPastor]

@Gustaw

Boom! Great report.

Excellent work.

[Rachwen_Mesbehi]

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

PS : The full YouTube experience is guaranteed !!

Power BI Report

[ChallengeTeam]

Hi everyone, this is an entry submitted by Varshada Vengurlekar​​ via email.

Here’s how Varsha described it:

I am a first-timer for the power bi challenges on EDNA and I must say it was a great learning experience for me. It helped me practically understand the approach for any data analysis like getting familiar with data provided and what is it that we need to answer and bring out from the data that helps.

You may view the full report here
Varshada Vengulekar

[ChallengeTeam]

Hi everyone, this is an entry submitted by ​​ Divya Harikrishnan via email.

Here’s how Divya described it:
This is my entry into EDNA Challenges. I have given an attempt. Thanks for the wonderful opportunity. Looking forward to learn more from the upcoming challenges

You may view the full report here
Divya​ Harikrishnan​

Please feel free to give Divya your feedback on her report.

[ChallengeTeam]

Hi everyone, this is an entry submitted by ​​ Nachiket Mehendaler via email.

Here’s how Nachiket described it:
This is my entry into EDNA Challenges. Thanks for providing the opportunity to work on the challenge.

You may view the full report here
Nachiket Mehendaler

Please feel free to give Nachiket your feedback on the report.

[ChallengeTeam]

Hi everyone, this is an entry submitted by ​​ Matthew Braun via email.

Here’s how Matthew described it:
TI accepted the Enterprise DNA Challenge 21 - EDNA YouTube Activity Reporting. I have been a long-time follower of the Enterprise DNA platform, yet this is my first challenge submission.

You may view the full report here
Matthew Braun

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

[ChallengeTeam]

Hi everyone, this is an entry submitted by ​​ Francis Folaranmi via email.

Here’s how Francis described it:
I accepted the Enterprise DNA Challenge 21 - EDNA YouTube Activity Reporting. Excellent dataset, I hope you enjoy my report.

You may view the full report here
Francis Folaranmi

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

[ChallengeTeam]

Hi everyone, this is an entry submitted by ​​ Balqees Al Mashajari via email.

Here’s how Balqees described it:

I accepted the Enterprise DNA Challenge 21 - EDNA YouTube Activity Reporting. Excellent dataset, I hope you like my report.

You may view the full report here
Balqees

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

[ChallengeTeam]

Hi everyone, this is an entry submitted by Victor Antonio Samane ​​via email.

Here’s how Victor Antonio described it:

I accepted the Enterprise DNA challenge! my first challenge was completed and ready for the next ones!

You may view the full report here
Victor Antonio Samane

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

[ChallengeTeam]

Hi everyone, this is an entry submitted by Santiago Cancela via email.

Here’s how Santiago Cancela described it:

I took the courage to get involved in the challenge a bit late, so I decided to make it as simple as possible. I do like the strategy that EnterpriseDNA has been teaching about Background and themes, so I decided to put it into practice. I think also as the Data is from Enterprise DNA, it makes more sense to use the templates developed.

You may view the full report here
Santiago Cancela

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

[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.