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

  • 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

  • Is OneDrive secure? Data encryption in OneDrive

    Is OneDrive secure? Data encryption in OneDrive

    Office 365

    OneDrive keeps your data secure and encrypts everything you do. Learn what encryption in OneDrive looks like and how it works with ramsac today. Read our blog. [...]

    Read article

  • Are Office 365 Mailboxes backed up? (And how can you back them up?)

    Are Office 365 Mailboxes backed up? (And how can you back them up?)

    Office 365

    Is your Office 365 email backed up? And if not, how can you go about setting up backup? ramsac covers these and related questions in our latest blog. [...]

    Read article

  • 9 ways to optimise your calendar management

    9 ways to optimise your calendar management

    Office 365

    Learn how to optimise your calendar with the latest blog from ramsac. We cover Microsoft tips and tricks, as well as how to optimise your calendar. [...]

    Read article

  • Which version of OneNote should I use?

    Which version of OneNote should I use?

    Office 365

    OneNote has two versions on desktop and today we answer the question, which version should you use. [...]

    Read article

  • An introduction to Teams Loop Components

    An introduction to Teams Loop Components

    Office 365

    Microsoft’s innovative Fluid Framework makes collaboration in Teams even easier, thanks to the Loop Components. Read our how-to blog to get to grips! [...]

    Read article