GRC-103: Microsoft Power Platform End-To-End Discovery Workshop

After completing this workshop, students will be able to:

• Build and deploy custom business apps.
• Differentiate canvas apps from model-driven apps.
• Easily bring your data together and quickly integrate compliant and scalable data services.
• Build automated workflows seamlessly and intuitively.
• Create reports and dashboards without depending on IT personnel.

This course is for beginners and non-developers and assumes no prior knowledge of Power Platform. You will be guided on a step-by-step through the process of building your own business app. Thus, minimal, or little technical background is required. However, a good experience of work with Microsoft Office such as Excel is preferred.

Module 1:    Introduction to Power Platform

• What is Power Platform?
• How much does it cost?
• Understanding Power Apps, Power Automate and Power BI.
• The mechanics behind the participating apps and services of Power Platform.

Module 2:    Power Apps Canvas Apps

• Basic concepts of building Power Apps canvas apps.
• Connect to data sources and filter results based on certain criteria.
• Work with screens and navigation.
• Use controls, properties, formulas, and actions to customize user experience.
• Configure app settings.
• Save and share an app.
• Run an app on a mobile device.

Module 3:    Introduction to Microsoft Dataverse

• What is Microsoft Dataverse?
• Create and customize a custom entity.
• Use the Form control.
• Save data into the Microsoft Dataverse using the Form control.

Module 4:    Power Apps Model-driven Apps

• Basic concepts of building Power Apps Model-drive apps.
• Create a standalone Model-driven app.
• Customize forms for the Model-driven app.
• Use of a Business Process flow to guide the user through a process.

Module 5:    Introduction to Power Automate

• Understanding Power Automate.
• Create a flow that is triggered when a new Microsoft Dataverse record is created.
• Automate sending approval requests.
• Customize the approval based on the Microsoft Dataverse record.
• Use the Approval Center.

Module 6:    Introduction to Power BI

• How does Power BI fit into the Power Platform ecosystem?
• Connecting Power BI to the Microsoft Dataverse.
• Transform Microsoft Dataverse data for use in Power BI visualizations.
• Create visualizations on the Microsoft Dataverse data.
• Combine Microsoft Dataverse data with other data sources.

Module 7:    Microsoft SharePoint Online as a Source

• Microsoft SharePoint Online quick start.
• Using SharePoint Online lists as a source of data.
• Mapping Microsoft Dataverse entity to a SharePoint Online list.
• Differentiating scenarios between usage of Microsoft Dataverse and SharePoint Online lists.

Hands-On Lab Exercises:

• Lab 02
  • Creating the wireframe of a Device Ordering app.
  • Creating the basic startup screen of the app. 
  • Adding forms and controls to the app.

• Lab 03
  • Creating the Device Order entity in Microsoft Dataverse.
  • Creating business rules in Microsoft Dataverse.
  • Connecting the Device Ordering app to the Microsoft Dataverse entity.

• Lab 04
  • Composing the Device Procurement model-driven app.
  • Creating the business process flow.
  • Modifying the forms and views.

• Lab 05
  • Creating an Approval Request flow.
  • Adding conditional logic.
  • Testing the flow.
  • Updating the flow.

• Lab 06
  • Importing historical data into Microsoft Dataverse.
  • Connecting Power BI to Microsoft Dataverse.
  • Setting up relationships and calculations.
  • Adding visuals into the report.

• Lab 07
  • Creating a SharePoint Online custom list that maps the Microsoft Dataverse entity.
  • Connecting the Device Ordering app to the SharePoint Online list.
  • Connecting Power BI to the SharePoint Online list.

• Bonus Lab – Conference Management case study
  • Creating a Conference Admin app.
  • Creating a Conference Attendee app.
  • Adding a business card reader to the app.
  • Make a submission page for conference speakers.
  • Adding a business process flow to manage conference sessions.
  • Build a flow to approve a conference session.

GRC-102: Conquering DAX 2019

This GRC-102: Conquering DAX 2019 workshop is a complete course about the DAX language. DAX is the native language of Power BI, Power Pivot for Excel, and SSAS Tabular models in Microsoft SQL Server Analysis Services. The training is aimed at users of Power BI, Power Pivot for Excel, and at Analysis Services developers that want to learn and master the DAX language. This DAX training course covers the latest version of DAX 2019.

GRC-106: Microsoft Power Apps And Power Automate Fundamental Track

This Microsoft Powerapps and Power Automate training course delivers an instructor-led breakdown of Microsoft Power Apps and Power Automate. Students will be taught how to design, test and publish new apps 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.

GRC-109: Intensive Microsoft Power Platform Know-How Workshop

Microsoft Power Platform is made up of Power Apps, Power Automate (formerly known as Flow) and Power BI. This 4-day workshop gives an overall picture to students on how to get up to speed in utilizing all the apps in Power Platform to build a custom solution that automates business processes and the ability to generate reports immediately.

GRC-111: Microsoft Power Platform Build And Admin Workshop

The 4-day portion of this admin power platform workshop gives an overall picture to students on how to get up to speed in utilizing all the apps in Power Platform to build a custom solution that automates business processes and the ability to generate reports immediately. The last day is a run through of administration and management using Microsoft Power Platform Admin Center.

GRC-113: Microsoft Power Platform Essentials Bundle

This instructor-led adventurous workshop is designed for audiences to be equipped with the necessary knowledge and skills to kickstart their analytical journey with Microsoft Power BI, followed by essential guidance to Power Apps and Power Automate. You will be guided from the stage of connecting data, transforming data, and visualizing your data using Power BI.

GRC-114: Developing RPA Flows & AI Builder On Microsoft Power Platform

Microsoft Power Platform is comprised of four key products: Power Apps, Power Automate, Power BI, and Power Virtual Agents. In this GRC-114: Developing RPA Flows & AI Builder On Microsoft Power Platform course, we will cover these four applications in depth, with additional focus on Microsoft Dataverse, AI Builder, connectors, and portals

GRC-115: Developing RPA Flows Using Microsoft Power Automate for Desktop

This course will teach you about the fundamentals of robotic process automation and how to apply them to your company. First, you'll learn the fundamentals of RPA and how to use a programme called Power Automate Desktop flows to design RPA workflows. Second, you'll design your first process using the Power Automate for Desktop interface.