Teams live event log analysis Power BI

%3CLINGO-SUB%20id%3D%22lingo-sub-1418146%22%20slang%3D%22en-US%22%3ETeams%20live%20event%20log%20analysis%20Power%20BI%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1418146%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EI'm%20seeing%20a%20huge%20increase%20in%20the%20number%20of%20live%20events%20that%20my%20customers%20have%20been%20using%20either%20internally%20for%20their%20employees%20or%20externally%20with%20customers%20and%20suppliers.%20They%20have%20been%20looking%20for%26nbsp%3Ba%20ready%20made%20Power%20BI%20report%20than%20enables%20them%20to%20analyse%20their%20live%20event%20data%2C%20individually%20and%20across%20a%20series%20of%20events.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWe've%20put%20together%20this%20Power%20BI%20report%20and%20are%20freely%20sharing%20it%20so%20anyone%20can%20use%20it%20for%20their%20own%20live%20events.%3CBR%20%2F%3E%3CBR%20%2F%3EVideo%20walkthrough%20at%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DTBMHMZ8nqeQ%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DTBMHMZ8nqeQ%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3EGet%20the%20Power%20BI%20report%20and%20Deployment%20Guide%20at%20%3CA%20href%3D%22https%3A%2F%2Faka.ms%2FTeamsLiveEventsReport%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Faka.ms%2FTeamsLiveEventsReport%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22liveeventoverview.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F194446i825933CADFEF0CED%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22liveeventoverview.png%22%20alt%3D%22liveeventoverview.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22liveeventoverviewp2.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F194447iCB4C8EB47EFE1042%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22liveeventoverviewp2.png%22%20alt%3D%22liveeventoverviewp2.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22overviewpage.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F194444iDF4E828C2F6A35A5%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22overviewpage.png%22%20alt%3D%22overviewpage.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22userinsights.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F194445iB2F05552DBA7F99D%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22userinsights.png%22%20alt%3D%22userinsights.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1418146%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAnalytics%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Teams%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20BI%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1742078%22%20slang%3D%22en-US%22%3ERe%3A%20Teams%20live%20event%20log%20analysis%20Power%20BI%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1742078%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F259716%22%20target%3D%22_blank%22%3E%40stuartridout%3C%2FA%3E%26nbsp%3B-%20Thanks%20for%20article%20%2Cvery%20informative%20and%20useful.%20I%20have%20one%20question%20though%20%2C%20let's%20say%20i%20am%20organizing%205%20live%20events%20in%20a%20day%20and%20want%20to%20get%20the%20info%20from%20all%20the%20events%20directly%20into%20the%20Teams%20log%20Event%20Power%20BI%20report%20%2Cwithout%20any%20manual%20activity%20(%20for%20e.g.%20calling%20any%20API%20or%20after%20initial%20setup%20for%20first%20event%20%2C%20log%20files%20are%20getting%20updated%20automatically%20for%20subsequent%20events).%20Is%20it%20possible%20to%20achieve%20%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1742152%22%20slang%3D%22en-US%22%3ERe%3A%20Teams%20live%20event%20log%20analysis%20Power%20BI%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1742152%22%20slang%3D%22en-US%22%3EUnfortunately%20you%20can%E2%80%99t%20do%20this%20programmatically%20at%20the%20moment.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1742163%22%20slang%3D%22en-US%22%3ERe%3A%20Teams%20live%20event%20log%20analysis%20Power%20BI%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1742163%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F259716%22%20target%3D%22_blank%22%3E%40stuartridout%3C%2FA%3E%26nbsp%3BThanks%20for%20quick%20update.%20so%20currently%20optimized%20way%20is%20to%20ask%20Teams%20Live%20Event%20Producer%20to%20consolidate%20the%20Event%20logs%20file%20after%20each%20Event%20and%20upload%20it%20at%20some%20SharePoint%20Site%20Folder%20.%20From%20SharePoint%20Folder%20Power%20BI%20Event%20report%20can%20read%20the%20updated%20data%26nbsp%3B%20using%20scheduling%20or%20some%20other%20similar%20mechanism.%20Your%20thoughts!!!!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1742188%22%20slang%3D%22en-US%22%3ERe%3A%20Teams%20live%20event%20log%20analysis%20Power%20BI%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1742188%22%20slang%3D%22en-US%22%3EPossibly%20with%20some%20clever%20scripting.%20The%20report%20needs%20to%20be%20able%20to%20consolidate%20the%20attendance%20logs%20and%20the%20Q%26amp%3BA%20logs%20together%20as%20well%20as%20add%20in%20some%20metadata%20that%20is%20not%20in%20the%20report%20such%20as%20date%2C%20time%20and%20title%20of%20the%20event.%20This%20is%20why%20the%20process%20is%20to%20manually%20combine.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1809031%22%20slang%3D%22en-US%22%3ERe%3A%20Teams%20live%20event%20log%20analysis%20Power%20BI%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1809031%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F259716%22%20target%3D%22_blank%22%3E%40stuartridout%3C%2FA%3E%26nbsp%3BWondering%20if%20there%20is%20a%20way%20to%20breakdown%20who%20has%20joined%20a%20live%20event%20by%20region%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1810206%22%20slang%3D%22en-US%22%3ERe%3A%20Teams%20live%20event%20log%20analysis%20Power%20BI%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1810206%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F18076%22%20target%3D%22_blank%22%3E%40Rahim%20Alibhai%3C%2FA%3E%26nbsp%3BUnfortunately%20that%20information%20isn't%20in%20the%20logs%20so%20not%20possible%20without%20being%20able%20to%20cross-reference%20email%20addresses%20to%20an%20external%20list%20of%20regions.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1957549%22%20slang%3D%22en-US%22%3ERe%3A%20Teams%20live%20event%20log%20analysis%20Power%20BI%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1957549%22%20slang%3D%22en-US%22%3EOnly%20if%20you%20have%20that%20data%20from%20another%20source%20e.g.%20AAD%20records%20you%20can%20match%20the%20UPN%20against.%20There%E2%80%99s%20no%20location%20data%20in%20the%20logs.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2140145%22%20slang%3D%22en-US%22%3ERe%3A%20Teams%20live%20event%20log%20analysis%20Power%20BI%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2140145%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F259716%22%20target%3D%22_blank%22%3E%40stuartridout%3C%2FA%3E%26nbsp%3BFirstly%20this%20is%20awesome%2C%20thanks!%3CBR%20%2F%3E%3CBR%20%2F%3EI've%20noticed%20the%20%22total%20view%20time%22%20on%20the%20Home%20tab%20is%20different%20to%20the%20%22%3CSPAN%3Etotal%20mins%20viewed%22%26nbsp%3B%20on%20User%20Insights%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20reason%20behind%20this%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2140226%22%20slang%3D%22en-US%22%3ERe%3A%20Teams%20live%20event%20log%20analysis%20Power%20BI%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2140226%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F696450%22%20target%3D%22_blank%22%3E%40Bailey44%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20total%20views%20on%20the%20home%20tab%20includes%20named%20and%20anonymous%20participants.%26nbsp%3B%20So%20if%20you%20had%20150%20named%20participants%20and%207%20different%20anonymous%20participants%20(with%20different%20session%20IDs)%20that%20would%20give%20you%20157%20views.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EOn%20the%20User%20Insights%20page%20we%20can%20only%20track%20those%20named%20participants%20across%20multiple%20sessions.%26nbsp%3B%20If%20you%20were%20in%20session%201%20anonymously%20yesterday%20and%20session%202%20anonymously%20today%20you%20would%20have%20different%20session%20IDs%20so%20you%20aren't%20tracked%20in%20the%20User%20Insights%20tab.%26nbsp%3B%20%26nbsp%3B%20So%20the%20User%20Insights%20tab%20would%20only%20show%20150%20views%20(which%20is%20the%20named%20participants).%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHope%20that%20helps%3C%2FP%3E%0A%3CP%3EStuart%3C%2FP%3E%3C%2FLINGO-BODY%3E
Microsoft

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 

 

liveeventoverview.png

 

liveeventoverviewp2.png

 

overviewpage.png

 

userinsights.png

 

9 Replies

@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 ? 

Unfortunately you can’t do this programmatically at the moment.

@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!!!!

Possibly with some clever scripting. The report needs to be able to consolidate the attendance logs and the Q&A logs together as well as add in some metadata that is not in the report such as date, time and title of the event. This is why the process is to manually combine.

@stuartridout Wondering if there is a way to breakdown who has joined a live event by region? 

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

Only if you have that data from another source e.g. AAD records you can match the UPN against. There’s no location data in the logs.

@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? 

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