Overview
This course will teach you how to build apps with low-code techniques to simplify, automate, and transform business tasks and processes using Microsoft Power Platform. This course may contain a 1-day Applied Workshop that is in preview. This workshop will allow you to practice your App Maker skills by creating an end-to-end solution to solve a problem for a fictitious company. The solution will include a Microsoft Dataverse database, Power Apps canvas app, and Power Automate flows.
Prerequisites
- Basic data modelling, user experience design, requirements analysis, and process analysis skills.
- A personal growth mindset and are comfortable using technology to solve business problems.
- An understanding of the operational need and have a vision of the desired outcome. They approach problems with phased and iterative strategies.
Course Duration
4 Days
Course Outline
- What is Microsoft Power Platform?
- The business value of Microsoft Power Platform
- Data Connectors
- Data loss prevention, compliance, privacy, and accessibility
- Pulling it all together
- Introduction to Dataverse
- Introduction to model-driven apps
- Model-driven apps, powered by Microsoft Dataverse
- Explore sample apps
- Introduction to Microsoft Dataverse
- Table characteristics
- Dual-write vs. virtual tables
- Dataverse auditing
- Exercise – Create a Microsoft Dataverse table
- Import data into your Microsoft Dataverse database
- Exercise – Create a custom table and import data
- Introducing model-driven apps
- Components of model-driven apps
- Design model-driven apps
- Exercise
- Exercise – Control security when sharing model-driven apps
- Incorporate business process flow
- Exercise – Create a model-driven app
- Define columns in Microsoft Dataverse
- Column types in Microsoft Dataverse
- Add a column to a table
- Create a primary name column
- Restrictions that apply to columns in a table
- Create an auto numbering column
- Create an alternate key
- Exercises
- Introduction to environment roles
- Understand environment roles
- Adding or disabling an environment user
- Understand security concepts in Dataverse
- Understand user security roles and security role defaults
- Exercise – Create a custom role
- Check the roles that a user belongs to
- Configure Dataverse teams for security
- Configure Dataverse group teams for security
- Create test plans
- User interface testing
- Performance optimization
- Diagnostics and analytics
- Documentation and the customer
- Provision your first Dataverse environment
- Create your first table to store data
- Create your first app with the hero template
- Customize your app with Power Apps Studio
- Publish your app
- Install template apps
- Introduction to Power Apps
- Power Apps building blocks
- Exercise – Create your first app in Power Apps
- Ways to build Power Apps
- Power Apps related technologies
- Additional Power Apps related technologies
- Designing a Power Apps app
- Understanding navigation
- The navigation and back function
- Lab – Create navigation functions
- More ways to use the navigation function
- Use themes to quickly change the appearance of your app
- Branding a control
- Icons
- Images
- Personalization
- Using the tablet or phone form factors
- Exercise – Create UI for a new canvas app
- Introduction to controls
- Core properties of controls
- Entering and displaying data with text controls
- Additional controls for enhancing your app’s usability
- Media
- Lab – Create a canvas app with unique controls
- Introducing Power Automate
- Exercise – Create your first flow
- Exercise – Create recurring flows
- Exercise – Monitor incoming emails
- Exercise – Share flows
- Troubleshoot flows
- Administer flows
- Export and import flows
- Learn how to distribute button flows
- Identify Microsoft Power Platform environments
- Data Loss Prevention policies
- Microsoft Power Platform Center of Excellence Starter Kit
- Exercise – Create a Power Platform environment
- Types of workflows that Power Automate can build in Dataverse
- Exercise – Create a workflow that triggers when a new message is created
- Exercise – Add a flow to your Power Apps app
- Schedule a flow
- Use Power BI
- Building blocks of Power BI
- Tour and use the Power BI service
- Overview of Power BI Desktop
- Explore Power BI Desktop
- Connect to data sources
- Get data from Excel
- Transform data to include in a report
- Combine data from multiple sources
- Clean data to include in a report
- Connect to and transform Dataverse for Teams data from Power BI
- Create a Power BI report
- Publish the report
- Share the data
- Introduction to AI Builder
- Choose an AI capability
- Create your first model
- Ways to use your models
- Create your first chatbot
- Create and modify topics
- Add inputs, variables, and conditions
- Call an action to pull in Dataverse for Teams data
- Publish and share your new chatbot
