You're reading from Microsoft 365 Fundamentals Guide

Product typeBook

Published inMay 2022

PublisherPackt

ISBN-139781801070195

Edition1st Edition

Tools

Office 365 Microsoft OneNote

Concepts

Document Preparation

Authors (2):

Gustavo Moraes

Douglas Romao

View More author details

From a form to a Power BI dashboard

Analyzing the survey data on our dashboard more deeply can be done simply if our form was created in Excel. We just connected our Power BI to the source Excel file and thus built the charts; however, most Microsoft forms are not created this way.

To analyze the answers of forms that were not made in Excel, it is necessary to export the answers to be able to use them as a data source in Power BI. This manual work makes it difficult to act and analyze in real time, which is required in certain scenarios.

Let's use an example of a form that is available globally to collect complaints about environmental deforestation. The faster these complaints appear in the indicators and generate alerts, the more chance there is of action being effective. To technically set up this scenario, we will use three tools that we have already seen in this book (Microsoft Forms, Power Automate, and Power BI), and with them, we will have the form data in real time...

The rest of the page is locked

You have been reading a chapter from

Microsoft 365 Fundamentals Guide

Published in: May 2022Publisher: PacktISBN-13: 9781801070195

Authors (2)

Gustavo Moraes

Gustavo Moraes is the CEO of Trentim, a company focused on providing management methodologies and tools mainly in the Microsoft ecosystem, with a large client base in Brazil and abroad. He is an MCT (Microsoft Certified Trainer). He has been working with Microsoft technologies for over 12 years with extensive expertise in process automation, and project and task management. He is one of the leading names in the field of automation on Microsoft and Low Code platforms in Brazil. He has led many events and communities in addition to being a prominent user in the Microsoft community. Christian, married to Aline for 8 years and father of Alexia and Natasha.
Read more about Gustavo Moraes

Douglas Romao

Douglas Romão has been a Microsoft Most Valuable Professional in Office Apps & Services and Business Applications since 2017. He is a Microsoft Certified Trainer and has been working with Microsoft technologies for over 15 years, focusing mainly on developing productivity and collaborative solutions. Currently, work as a Senior Solution Architect & Business Consultant within the Power Platform and Project & Portfolio Management field, leading technical communities and sharing knowledge through conferences, his YouTube channel/blog, and a podcast. Christian, father of Vicente (a 7-month-old baby boy by the time this book has been released) and married to Mariana.
Read more about Douglas Romao

Personalised recommendations for you

Based on your interests and search pattern

Engineering Manager's Handbook

Engineering Manager's Handbook is a comprehensive guide for managers to excel in their role, foster customer-centric digital products, learn leadership, team building, and balancing technical work with management. You’ll also explore how to develop trust, authority, and collaboration to drive success and make a lasting impact.

BookSep 2023278 pages

C++ Game Animation Programming

Video game characters have a fascinating history, evolving from simple 2D sprites to high-polygon 3D models. Take a look behind the curtain and learn how to build a 3D renderer, load character models, play animations and blend between them, and create large crowds of animated people with this comprehensive C++ game animation programming guide.

BookDec 2023480 pages

Gamification for Product Excellence

This book helps you to take your product management strategy to the next level by standing out in crowded markets. Along with boosting user adoption rates by creating engaging products that incorporate playful elements, learn gamification theory and how to integrate it into your design, product development, and product management processes.

BookSep 2023350 pages

Supercharging Productivity with Trello

Supercharging Productivity with Trello is the ultimate guide for anyone looking to boost their productivity with digital tools. Whether you're new to Trello or a seasoned professional, this book covers everything from core features to advanced automation, and Power-Ups.

BookAug 2023342 pages

Automate It with Zapier and Generative AI

This comprehensive guide takes you through the concepts of business process automation, showing you how Zapier can facilitate it without having to write code and helping you to boost productivity. You’ll learn how to save time, reduce costs, and make your business recession-proof by using Zapier to automate tasks in your cloud-based business apps.

BookAug 2023706 pages

Scoring to Picture in Logic Pro

In this book, you’ll explore a variety of techniques to synchronize music to picture using Logic Pro. Though this is not a technical manual, it will teach you how to make the best use of Logic Pro and how to wield this technology to maximize your potential when scoring to picture.

BookSep 2023412 pages

Mastering Information Security Compliance Management

This concise book equips you with the knowledge and practices needed to establish and maintain an effective information security management system. The chapters provide insights into ISO/IEC 27001/27002:2022, risk management, ISMS development, incident management, audit processes, and strategies for continuous improvement.

BookAug 2023236 pages1

Implementing Atlassian Confluence

Implementing Atlassian Confluence provides both a high-level overview and an insightful path for remote collaboration with Atlassian Confluence. With this multi-layered yet practical guide, you’ll be able to set up Confluence-based collaboration with minimum external consultancy services to ensure smooth and close coordination between teams.

BookSep 2023406 pages

R Bioinformatics Cookbook

This book takes a unique problem–solution approach to handling complex tasks in the bioinformatics domain using different datasets present in the book. With the help of real-world examples, you’ll learn to put each independent recipe to use to tackle problems in the field of bioinformatics.

BookOct 2023396 pages

Build Your Own Metaverse with Unity

Build Your own Metaverse with Unity is a practical guide for developers to create their own metaverse - a virtual world with infinite possibilities. It empowers you to identify gaps in existing metaverses and improve upon them, enabling you to shape your virtual world.

BookSep 2023586 pages5