Microsoft Office 365 case study: Forms, Flow, SharePoint & PowerBI

What is office 365 a short guide
The need
There was a requirement to capture information from visitors to our stand at an event, have that data available quickly to our Managing Director who was speaking, display it on a screen on the stand, and then make it available for our Business Development team to follow-up after the event. We considered having something created for us, but it would have been expensive and involved long lead times. We also looked at several off-the-shelf cloud-based services designed to survey event attendees, but they were either intended for live audience participation, or for surveying with analysis after the event, so none were really suitable.
The solution
So, we decided to build our own solution using pulling together elements of the Microsoft Office 365 platform – Forms, Flow, SharePoint and PowerBI. Microsoft Office 365 – Forms Microsoft Forms was used to quickly create a form to capture answers to questions, which was run on a Windows 10 tablet. As the survey form was browser based, no data was stored on the tablet. We also asked for GDPR contact consent and depending on their answer, then prompted for an e-mail address. With the correct permissions survey results are summarised live within Forms, so our Managing Director could refer to live information in his talk. Microsoft Office 365 – Flow Microsoft Flow was used to automatically push the responses into a SharePoint Online list. Flow can be used to easily automate many processes within Office 365. For example, we use it within ramsac for automating onboarding a new client, it creates standard files and folders within SharePoint Online, and sends various e-mails to the appropriate teams. Microsoft Office 365 – PowerBI Microsoft PowerBI was then used to display the survey results on a large screen. Creating attractive reports is quick and straightforward in PowerBI, and as it’s cloud based it just requires a browser, no back-end servers or locally installed reporting software. Microsoft Office 365 – SharePoint Finally, after the event the information in the SharePoint Online list could easily be imported into our CRM system. Nothing was stored on the tablet used for the survey, or the laptop used to display the data. It was easy to just delete the contact information in Forms and SharePoint Online for GDPR compliance, and there was no risk of data being compromised if any of the hardware were lost or stolen at the event.

Related Posts

  • How to share PowerPoint slides on Teams

    How to share PowerPoint slides on Teams

    Office 365

    There are numerous ways to share your PowerPoint slides in calls on Teams. Discover what you can do to make sharing slides in calls easier. Read our blog [...]

    Read article

  • Microsoft Teams web vs desktop

    Microsoft Teams web vs desktop

    Office 365

    Do you use the web or desktop version of Teams at work? Discover which is best, and how they stack up in key functionality. Read today. [...]

    Read article

  • Microsoft Teams cheat sheet

    Microsoft Teams cheat sheet

    Office 365

    Learn everything from sharing to collaborating on team documents and how to communicate more efficiently in our Microsoft Teams cheat sheet. Read today. [...]

    Read article

  • New features in Microsoft Teams – Speaker Coach, Facial Filters and Quiet Time  

    New features in Microsoft Teams – Speaker Coach, Facial Filters and Quiet Time  

    Office 365

    Microsoft is continually rolling out new features to improve Teams, in this blog we will highlight 3 new features and explain how they work. [...]

    Read article

  • How to schedule a meeting in Microsoft Teams

    How to schedule a meeting in Microsoft Teams

    Office 365

    Using Teams to schedule meetings offers a range of options to help make your meetups as efficient as possible. Discover how to schedule meetings on Microsoft Teams today. [...]

    Read article

  • What is Microsoft Planner?

    What is Microsoft Planner?

    Office 365

    Microsoft Planner is a lightweight project management tool, allowing teams to work together and have full visibility on the progress of tasks, workloads and deadlines. Discover what it is [...]

    Read article