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

  • Still using Windows Server 2012? – You are at risk.

    Still using Windows Server 2012? – You are at risk.

    Office 365

    If you have machines still using Server 2012 you are now at risk and we advise you take immediate action to upgrade to a current Microsoft Operating System. [...]

    Read article

  • Microsoft announce 9% pricing increase for 365

    Microsoft announce 9% pricing increase for 365

    Office 365

    Microsoft have announced that on 1st April 2023 they will be increasing pricing on their cloud products in the UK, by 9%. [...]

    Read article

  • Introducing ‘Reactions’ in Microsoft Outlook 

    Introducing ‘Reactions’ in Microsoft Outlook 

    Office 365

    Microsoft have now integrated WhatsApp style ‘reactions’ in Microsoft Outlook, in this blog we explain how to use them. [...]

    Read article

  • Google Slides vs Microsoft PowerPoint: the ultimate comparison

    Google Slides vs Microsoft PowerPoint: the ultimate comparison

    Office 365

    We compare PowerPoint with Google Slides to see which comes out on top. See how they stack up against each other in the latest blog from ramsac. [...]

    Read article

  • Managing external users in Teams – Add guests to Teams

    Managing external users in Teams – Add guests to Teams

    Office 365

    Managing external users in Teams is relatively simple, but there’s a few tips and tricks to know that can make your life easier. See what you can do and [...]

    Read article

  • 12 essential ground rules for online or hybrid meetings

    12 essential ground rules for online or hybrid meetings

    Office 365

    From webinars to internal 1-1s, online meetings continue to be present in our working lives. Read our guide to virtual meeting etiquette today. [...]

    Read article