May 26 2020 08:46 AM
I'm seeing a huge increase in the number of live events that my customers have been using either internally for their employees or externally with customers and suppliers. They have been looking for a ready made Power BI report than enables them to analyse their live event data, individually and across a series of events.
We've put together this Power BI report and are freely sharing it so anyone can use it for their own live events.
Video walkthrough at https://www.youtube.com/watch?v=TBMHMZ8nqeQ
Get the Power BI report and Deployment Guide at https://aka.ms/TeamsLiveEventsReport
Oct 03 2020 06:26 AM
@stuartridout - Thanks for article ,very informative and useful. I have one question though , let's say i am organizing 5 live events in a day and want to get the info from all the events directly into the Teams log Event Power BI report ,without any manual activity ( for e.g. calling any API or after initial setup for first event , log files are getting updated automatically for subsequent events). Is it possible to achieve ?
Oct 03 2020 07:23 AM
Oct 03 2020 08:26 AM
@stuartridout Thanks for quick update. so currently optimized way is to ask Teams Live Event Producer to consolidate the Event logs file after each Event and upload it at some SharePoint Site Folder . From SharePoint Folder Power BI Event report can read the updated data using scheduling or some other similar mechanism. Your thoughts!!!!
Oct 03 2020 09:07 AM
Oct 22 2020 08:43 AM
@stuartridout Wondering if there is a way to breakdown who has joined a live event by region?
Oct 22 2020 01:07 PM
@Rahim Alibhai Unfortunately that information isn't in the logs so not possible without being able to cross-reference email addresses to an external list of regions.
Dec 04 2020 01:05 PM
Feb 16 2021 11:26 AM
@stuartridout Firstly this is awesome, thanks!
I've noticed the "total view time" on the Home tab is different to the "total mins viewed" on User Insights
Any reason behind this?
Feb 16 2021 11:44 AM
Thanks @Bailey44
The total views on the home tab includes named and anonymous participants. So if you had 150 named participants and 7 different anonymous participants (with different session IDs) that would give you 157 views.
On the User Insights page we can only track those named participants across multiple sessions. If you were in session 1 anonymously yesterday and session 2 anonymously today you would have different session IDs so you aren't tracked in the User Insights tab. So the User Insights tab would only show 150 views (which is the named participants).
Hope that helps
Stuart