Microsoft Dataverse for Teams

Audience:End User / Power User, Business Executive
Duration:2.00 day(s)

 

Price: £975.00

About this course

This 2 day course will guide students through designing low-code applications, automated processes and chatbots directly in Microsoft Teams by leveraging Microsoft Dataverse for Teams and how to use further tools to design reports. This course is focused on end users, rather than administrations, who are looking to create new ways of working that are consumed within Microsoft Teams which is included in the cost of existing Teams user licenses and additional licensed services.

Meet your trainer

Choose a date

Delivery Date Delivery Type Time Zone  
April 27, 2021OnlineEMEA UK Time (9:30 start)
Book now
July 27, 2021OnlineEMEA UK Time (9:30 start)
Book now

All Combined Knowledge courses can be delivered privately online or at a site of your choice.
Contact us to arrange private delivery of a course or to find out more.

Book a private delivery of this course

There are currently no dates scheduled for this course, but all of our courses can be delivered privately at a site of your choice.

Our private on-site / online training can provide your business with the following benefits:

  • Substantial savings on travel and expense costs
  • Group learning – ensuring a consistent transfer of knowledge
  • Open discussions focused on specific business requirements
  • Ability to ‘cherry pick’ modules and tailor course content to your specific needs.
  • Multiple delivery and set-up methods

Contact us to arrange private delivery of a course or to find out more.

Course Syllabus

This 2 day course will guide students through designing low-code applications, automated processes and chatbots directly in Microsoft Teams by leveraging Microsoft Dataverse for Teams and how to use further tools to design reports. This course is focused on end users, rather than administrations, who are looking to create new ways of working that are consumed within Microsoft Teams which is included in the cost of existing Teams user licenses and additional licensed services.

Prerequisites

Experience of managing a team, within Microsoft Teams is preferred, but not essential.

 


 


An Introduction to Microsoft 365

This module will introduce students to Microsoft Dataverse. Microsoft Dataverse has two offerings, a more comprehensive service that is available at a cost, known as Dataverse, and a free to use service that comes as part of your Microsoft Teams license called Microsoft Dataverse for Teams, which is consumed directly from within Microsoft Teams. We will learn about the differences between these services, what are the limitations of Microsoft Dataverse for Teams and when to use each service. We will then discover how Microsoft Dataverse for Teams can be leveraged by Microsoft Power Apps, Microsoft Power Virtual Agents, Power BI and Microsoft Power Automate. In this module we cover how to add the Power Apps for Teams app, directly to Microsoft Teams, which will become our hub for designing business solutions. We will also provide a brief overview of the Microsoft Teams interface to discuss key elements that are essential to Microsoft Dataverse for Teams creations. This module covers the following lessons:

  • Microsoft Dataverse
  • What is the Power Platform?
  • Licensing for Microsoft Dataverse
  • Licensing for the Power Platform
  • What is Microsoft Dataverse for Teams?
  • Database terminology
  • Chatbots, apps and flows
  • Usage scenarios and limitations
  • Power BI in Microsoft Teams
  • An overview of Microsoft Teams
  • Where can you use Microsoft Teams?
  • The desktop app interface
  • Pining apps in Microsoft Teams

 

 


Setting up tables

 

This module will cover how to set up tables in your Microsoft Dataverse for Teams environment. Each Team utilising Microsoft Dataverse for Teams has its own environment where you can design your database. You can create tables, columns, rows, views, and relationships to model your data. The tables that you design can be used to support your apps, chatbots, reports and flows, acting as a centralised data source that you can tap into. Ensuring your data tables are correctly configured and secured is essential for success in other areas of Microsoft Dataverse for Teams. This module covers the following lessons:

  • Getting started with tables
  • Creating an environment for a Team
  • Creating a new table
  • Table settings
  • Adding columns
  • Choice columns
  • Adding rows of data
  • Creating table relationships
  • Designing new views
  • Table security
  • Deleting tables

 


Creating new apps

In this module we will design the interfaces that your Team’s members are going to use to add new rows of data to your tables. We will introduce you to Power Apps for Teams which is tailored to work with Microsoft Dataverse for Teams. The app itself can be based on an existing sample or you can choose to create your own app. This module will also cover adding components to your apps, writing formulas, introducing media, and using variables. We will then show you how to test, publish and use our apps within a Team. Discussed in this module are the following lessons:

  • An introduction to Power Apps
  • Power Apps services
  • The Power Apps interface
  • Creating a new app from a sample
  • Create a blank app
  • Working with screens
  • Connecting to data sources
  • Adding and editing controls
  • Introducing formulas
  • Using variables
  • Media
  • Testing an app
  • App settings
  • Publish to Teams
  • Broad distribution apps

 


Designing chatbots

In this module we will cover using Power Virtual Agents within Microsoft Teams. Power Virtual Agents allows us to design chatbots. A chatbot is an interface where an individual can type in a question or request information or support. The chatbot will look at the entry and interpret a logical response. Power Virtual Agents allows us to design the pace of these conversations. The full tool allows chatbots to be designed for enterprise use and for external facing customers. Within Teams these chatbots are only applied to a Team but are free whereas the full tool is not. We will show you how to get started with designing a chatbot, implement logic, test, and publish a chatbot to a Team. As Microsoft Teams is a chat enriched platform, understanding how to build chatbots can help you field common conversations that emerge within your Team. This module covers the following lessons:

  • An introduction to Power Virtual Agents
  • Chatbot topics
  • How do chatbots work in Teams?
  • The Power Virtual Agents interface
  • The authoring canvas
  • Entities
  • Creating a new chatbot
  • Working with topics
  • Setting up triggers
  • Adding nodes
  • Call a flow
  • Testing your chatbot
  • Publish a chatbot
  • Using a chatbot in Microsoft Teams
  • Maintaining a chatbot

Adding automated processes

With the ability to create chatbots and apps as well all the capabilities Teams has to offer, it can prove to be a challenge to form a narrative between these services. Enter Power Automate in Teams. Power Automate offers Teams users the option to create business processes that bring together services from across Microsoft 365 and Microsoft Dataverse for Teams. Power Automate in Teams prioritises workflows that interact with features in Teams, such as chat and channel posts. It can also interact with elements of Microsoft Dataverse for Teams. This module provides instructions on how to get new business processes up and running quickly, and how to customise workflows further to enhance their logic and reach. In this module we will discuss:

  • An introduction to Power Automate
  • How does Power Automate help Microsoft Team users?
  • Configuring Microsoft Teams flows
  • Testing a flow
  • Designing new flows or customising flows
  • The Power Automate interface
  • Working with actions
  • Branching logic
  • Connect a flow to Dataverse for Teams
  • Expressions and variables
  • Publish a flow
  • Flow history and error resolution

 

Designing reports

Data within our tables in Microsoft Dataverse for Teams can tell a story. But often displaying the data as a table does not offer an invested party much insight into this information. Microsoft Dataverse for Teams can connect to Power BI Desktop to allow you to design reports against the live data in your custom tables. Although there is a lot of value in this, it is worth noting that Power BI does require additional licensing for the service to work. In this module we will show you how to connect to your data tables in Microsoft Dataverse for Teams and use Power BI Desktop to design and publish an engaging report. Once published we will show you how to schedule the report to update on its own so that it is displaying up to date information. In this module we will discuss:

  • An introduction to Power BI
  • The Power BI suite
  • User based licensing
  • Premium capacity workspaces
  • Connecting to tables
  • Queries and data modelling
  • Designing reports
  • Hide and rename columns
  • Adding basic content
  • Visualisations
  • Publishing reports
  • Scheduling a data refresh
  • Share in Teams

Courses related to Microsoft Dataverse for Teams

Microsoft Teams is a full collaboration platform and offers facilities for peer to peer collaboration as well as full team collaboration. This course will give guidance on how to use the tools for chat, file sharing, meetings and calls. The course will also give direction on best practices for sharing files with external parties and show how to access other services available in the tenant directly from within Teams. There will be a series of labs to practice the methods taught during the course.

View course

This 3-day course provides detailed hands-on experience for companies looking to make the most of their Microsoft 365 licenses and the data they hold. This course looks at the different parts of Microsoft 365, including some that apps and features you may not be aware of. We will show you how you can utilise all these tools to get the full benefit of 365 as individuals and as a business. We will cover everything from the more familiar applications to the building of customised business solutions.

View course

This course delivers an instructor-led product showcase for Microsoft Power Automate from start to finish in an engaging and practical way. Power Automate is a diverse product, turning business processes into automated, consistent and visual workflows. Power Automate is designed to interweave the various products in Office 365 as well as connect to other on-premises and web-based solutions. This course will give you the confidence to select the right actions and workflow logic for your business workflows.

View course

This course delivers an instructor-led breakdown of Microsoft Power Apps. Students will be taught how to design, test and publish new applications that work with a variety of data sources. We will take users through a selection of well-crafted lessons to help them build new applications for their business.

View course

Comprising of 3 individual classes, this expert track will equip you with the skills to build powerful solutions to manipulate data, overcome business challenges, automate repetitive tasks, and boost productivity.
This track is perfect for anyone who has been using Office 365 for some time and is looking to optimise business processes or designing new ones.

View course