Power BI Competition - YouTube Data Analysis
Вставка
- Опубліковано 5 вер 2024
- We've just launched Power BI Contest #5! In this Power BI competition, you can connect to a live database containing all of my UA-cam channel data containing metrics like views, subscribers, comments, revenue, etc. This contest is free and open to everyone. Build an amazing Power BI report for the chance to win free training and a demo of your report on the channel!
UA-cam Data Competition:
training.bieli...
To enroll in my introductory or advanced Power BI courses:
training.bieli...
Elite Power BI Consulting:
bielite.com/
Data Insights Tools:
www.impktful.com/
Connect with me on Twitter!
/ powerbielite
Leaving a message to show up in the dashboards :)
And I see it in the database 😁
From where we can get tha database?
All of the database login info is here: training.bielite.com/courses/youtube-data-competition/ (Available only during the competition)
Is there a way to disable “Export Data” just to a particular report?
Hi. The mailing mentions that the database is updated daily, but it looks like for some tables the last update was on 2021-04-05 (eg. VideoDailyStats). Will the data be updated daily or once in a while, broken down by day? Also, will all tables be updated or only selected? This is important from the data model perspective :)
Hi Mateusz, the daily data from the UA-cam API is lagged a few days. As of right now, I’m manually running the refresh a few times a day. In reality, this is refreshing the channel stats table and comments tables every refresh and only refreshing the other tables when UA-cam has finalized the data for the other tables. I’m not sure what time of the day that occurs, that’s why I’m running multiple times a day. Hope that makes sense!
Do you have the video names anywhere? I only see ID.
There is a table named Videos with the ID, Title, Description, etc.