Reporting on all employees' appointments

%3CLINGO-SUB%20id%3D%22lingo-sub-1592549%22%20slang%3D%22en-US%22%3EReporting%20on%20all%20employees'%20appointments%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1592549%22%20slang%3D%22en-US%22%3E%3CP%3EMorning%20everyone!%20First%20post%20here%20so%20go%20easy%20with%20me!%3C%2FP%3E%3CP%3EWe%20have%20a%20new%20requirement%20in%20the%20organisation%20to%20be%20able%20to%20report%20on%20how%20~500%20of%20our%20front-line%20staff%20(grouped%20into%20separate%20teams)%20engage%20with%20customers%20and%20other%20members%20of%20the%20public.%3C%2FP%3E%3CP%3EI'm%20wondering%20whether%20this%20could%20be%20achieved%20using%20Outlook%20Calendar%20appointments%20and%20then%20reporting%20on%20this%20in%20Power%20BI%20using%20Graph%20apis%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20example%2C%20I%20go%20and%20see%20person%20x%20at%20location%20y%2C%20and%20the%20stuff%20that%20gets%20discussed%20is%26nbsp%3Badded%20in%20the%20appointment's%20description.%20I%20categorise%20the%20appointment%20using%20pre-defined%20categories%20(for%20example%20%22Community%22%2C%22KIN%22%2C%22Adhoc%22)%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20it%20possible%2C%20using%20Graph's%20apis%20(or%20some%20other%20M365%20magic)%20to%20report%20on%20a%20whole%20team's%20appointments%20of%20this%20type%2C%20determining%20how%20much%20time%20has%20been%20spent%20at%20%22Ad%20Hoc%22%20appointments%2C%20how%20many%20have%20not%20been%20%22Community%22%20appointments%2C%20who%20has%20had%20the%20most%20engagement%20in%20minutes%20this%20week%2C%20etc%20etc.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETaking%20it%20one%20step%20further%2C%20there%20are%20weekly%2C%20recurring%20engagement%20requirements.%20Could%20these%20appear%20on%20all%20team%20members'%20calendars%20until%20one%20of%20the%20team%20completes%20the%20engagement%3F%20(Can%20tasks%20be%20in%20appointments%3F)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20have%20Power%20BI%2C%20so%20could%20the%20data%20be%20presented%20directly%20here%2C%20producing%20graphs%20and%20other%20visuals%20automatically%20for%20the%20management%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20thoughts%20%2F%20ideas%20welcome%2C%20and%20signposting%20to%20documents%20to%20read%20is%20also%20encouraged!%3C%2FP%3E%3CP%3EDJ%3C%2FP%3E%3C%2FLINGO-BODY%3E
Regular Visitor

Morning everyone! First post here so go easy with me!

We have a new requirement in the organisation to be able to report on how ~500 of our front-line staff (grouped into separate teams) engage with customers and other members of the public.

I'm wondering whether this could be achieved using Outlook Calendar appointments and then reporting on this in Power BI using Graph apis?

 

For example, I go and see person x at location y, and the stuff that gets discussed is added in the appointment's description. I categorise the appointment using pre-defined categories (for example "Community","KIN","Adhoc") 

 

Is it possible, using Graph's apis (or some other M365 magic) to report on a whole team's appointments of this type, determining how much time has been spent at "Ad Hoc" appointments, how many have not been "Community" appointments, who has had the most engagement in minutes this week, etc etc. 

 

Taking it one step further, there are weekly, recurring engagement requirements. Could these appear on all team members' calendars until one of the team completes the engagement? (Can tasks be in appointments?)

 

We have Power BI, so could the data be presented directly here, producing graphs and other visuals automatically for the management?

 

Any thoughts / ideas welcome, and signposting to documents to read is also encouraged!

DJ

0 Replies