Thanks Federico, this video has some useful tips on how to improve click through rate. https://www.google.com/search?q=card+clicks+in+video&oq=card+clicks+in+video&aqs=chrome..69i57j33i160l3j33i22i29i30.7244j0j7&gs_lcrp=EgZjaHJvbWUyBggAEEUYOTIHCAEQIRigATIHCAIQIRigATIHCAMQIRigATIKCAQQIRgWGB0YHtIBCDcyNDRqMGo3qAIAsAIA&sourceid=chrome&ie=UTF-8#kpvalbx=_YMrQYt2WOPnw4-EPjNukmAM17
Hello everyone,
If I understood correclty, I can just post my entry in this topic?
So here is my first ever entry. I was focusing using new field parameters features and make it more app like but still not to overdo it as I like rather more minimalistic design
You can see the full report here
1 Like
Hey Michal, Welcome to Challenge 21 “Enterprise DNA YouTube Channel Data Analysis”.
Thank you for your submission and great work.
I would be grateful, also good exposure for you, if you can please post on LinkedIn following the below guidelines.
Take the image plus URL and post them on LinkedIn tagging Enterprise DNA to say, “I accepted the Enterprise DNA challenge.” . Please use the following tags.
#EDNADataChallenge & #EDNAYoutubeVideosReporting
Once more thanks for your entry and well done.
Federico Pastor
Hello,
I see that people have already started publishing their reports and sharing with other users.
Just wondering is it possible to see these reports in mobile view (portrait mode), as this is one of the tasks?
I am opening these reports in Power BI service, however it seems that this is not possible.
1 Like
Hi Stoyan,
Unfortunately mobile view is no visible when report are published to the web.
Regards,
Federico
PS. In my report I am creating a mock up version, so it will be visible as any other page with a custom size (smaller).
1 Like
Hi everyone, this is an entry submitted by Talwar Valluvar sent to us via email.
Here’s how Talwar described it:
This is my first submission to EDNA Challenges as well as my first Power BI dashboard
You may view the full report here:
Talwar Valluvar
Please feel free to give Talwar your feedback on his report.
2 Likes
Wow well done. This is great
1 Like
Hi everyone, this is an entry submitted by Elu Chinwendu sent to us via email.
Here’s how Elu described it:
This is my first entry in EDNA Challenges. I am very happy to participate in the Challenge
You may view the full report here:
Elu Chinwendu
Please feel free to give Elu Chinwendu your feedback on his report.
ATT - IMPORTANT MESSAGE - ATT
Attention Platform members,
We’re bringing to you a new dataset update, only for platform members.
Our CEO, @sam.mckay has made some changes in the dataset giving us the opportunitty to exercise Trends and & Time comparison analysis with Enterprise DNA YouTube Data in Challenge 21.
This dataset can be used in combination with the previosuly provided datasets or as a standalone dataset.
The choice is yours!!
I hope you like the improved dataset and I hope to see your entry in the challenge soon.
All the best.
Federico Pastor
C21_YouTubeViews_2072022.csv (6.5 MB)
I’m in for the Challenge! It’s our own data so I thought I should really dig into it.
I really wanted to identify trends, so I spent some time setting that up in the report. And tried to make it as dynamic as possible.
Here’s my submission below.
Not too many fancy visuals, just solid insights is what I was going for.
I used an advanced theme template (from Analyst Hub) to really speed up my development. It saved me so much time on my visuals and report design. It’s crazy! I won’t create reports any other way now.
There’s much more I’d like to analyze, but I can’t wait to see others ideas
Publish to web link
Tks
Sam
10 Likes
Any explanation for the 300% difference between the views in the Totals tab of Geography (10.8M), the Countries tab in Geography (8.7M) and those in the main dataset (3.5M)? The 3.5M includes the outlier ad video, so that isn’t the reason. The Totals tab should be the sum of the Chart Data (which has dates), but it is 2.2M off. This is really throwing off some analyses!
(This doesn’t include the latest dataset published yesterday, which still isn’t anywhere close to the 10.8M)
1 Like
Thank you Sam, I love the theme and colour palette…the Analysis coming from you is also very inspiring where less is more and a simple display of charts and matrixes do an excellent work.
Welcome to C21 and thanks for your submission.
Federico Pastor
1 Like
Hi Gaelan,
The first and thirds datasets come from different sources (Funnell) - the latest dataset is the one that Sam McKay uses for his presentation.
The second datasets come directly from the you tube channel.
I will not try to match the information, we knew of the discrepancies and it also show how data taken from different sources can be sometimes confusing.
The analysis for this challenge is exploratory in nature, where these discrepancies are to be shown or you just can pick one the datasets, I recomend the first or third one, and produce an overview of the data provided.
It is indicated in the brief and other documents in the challenges that the data is not to be explored or match together but work as indepedent datasets with different outcomes.
I hope this helps.
Federico Pastor
3 Likes
Hi everyone, this is an entry submitted by Veronica Aides sent to us via email.
Here’s how Veronica described it:
“This is my first submission in this challenge, it was very exciting to analyze this new Dataset in Desktop and Mobile versions. I have a lot to learn yet. Thanks for the opportunity!"
Veronica Aides
Please feel free to give Veronica Aides your feedback on her report.
4 Likes
Hi everyone, this is an entry submitted by Sibi Maran sent to us via email.
Here’s how Sibi described it:
I focused on preparing a report that enables the user to analyze multiple metrics across different timelines and videos. Also, I want the report to be simple to interact with and navigate"
You may view the full report here:
Sibi Maran
1 Like
Hi everyone, this is an entry submitted by Noelia Navarro sent to us via email.
Here’s how Noelia described it:
This is my first submission to eDNA challenges. It has been a lot of fun analyzing the data from eDNA’s YouTube Channel. I have tried to simulate the Shield app
You may view the full report here:
Noelia Navarro
Please feel free to give Noelia Navarro your feedback on her report.
3 Likes
Thanks for sharing @sam.mckay. It helps me to have an understanding of what to look at in the data.
What do you mean by average hours watched on the review Page when you are looking at the value for a single video on the table? In that case, as it is only one video is it the same as the total hours watched?
Could you please explain to me, what it means the trending Up and Down, over the last 3 months? i.e: On Trending Up, for How To Make Simple Http Requests In Power Automate on Trend end Date Jul 2022. In Total View is 780 but the 3M Difference (Views) is 1185. I think my doubt starts due to not understanding of what is the 3 months Difference Views. I´m understanding that means the growth of Views over the last 3 months but that´s not possible if the Total Views are 780.
Looking forward to hearing your comments
Hi all
@FPastor what does it mean for each row of that new file? For me, it seems that each month after the video was published it shows a summary of what happened with the video in that particular month. However, I check it and is not 100% true for all of the videos.
What is the column Duration (Time)?
Videos Added To Playlist means that on the Playlist the video is located on that month how many videos were added?
Thanks
1 Like
Hi Santiago,
Thank you for your question, I would like to draw your attention to the type of Analysis you are carrying out, Exploratory Data Analysys (EDA). As such one of yours tasks, outside provide some visuals and metrics, is also to poinpoint discrepancies and irregularities in the data analised. Another area or work to be carried out is a data Q&A (Quality & Assurance), I think you are doing this very well by asking these questions here and in the challenges group.
My asnwer to you will be to ensure these findings are annotated withinin your report and or explain in your report write up when submitting.
I hope this helps.
Federico Pastor
1 Like
Hi everyone, this is an entry submitted by Erika Liljestrand sent to us via email.
Here’s how Erika described it:
This is my first challenge. I have been learning and using Power Bi for only a few months, so I appreciated the openness of this challenge as it let me practice what I was able to figure out.
You may view the full report here:
Erika Liljestrand
Please feel free to give Erika Liljestrand your feedback on her report.
3 Likes