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%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%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%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%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
Highlighted
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

 

6 Replies
Highlighted

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

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

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

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

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

Highlighted

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