Course Overview
Module 1: Get started with Microsoft Power Platform for app makers
- How to identify which Microsoft Power Platform component to use based on a specific scenario.
- How to determine what type of app you should create based on your needs.
- Dataverse and directions on when and how to apply it.
- Environments and how makers use them.
- Copilot and why it matters to you as a maker.
Module 2: Create tables in Dataverse
- Create tables with Dataverse
- Import data into a Dataverse database
Module 3: Create and manage columns within a table in Dataverse
- What a column is in Dataverse.
- The types of columns that are available in Dataverse.
- How to add a column to a table.
- What a primary name column is in Dataverse.
- How to identify restrictions that are associated with columns.
- How to create an auto-numbering column.
- How to create an alternate key.
Module 4: Load/export data and create data views in Dataverse
- View data within a table.
- Create or edit views of data in a table.
- Load data into a table.
- Export data from a table.
- Add, update, or delete data in a table by using Excel.
- Import data using Power Query in Maker Portal
- Generate a new dataflow from an Excel Template
- Learn about dataflows
Module 5: Export data from Dataverse and use Microsoft Excel to edit records
- Learn how to export data from Dataverse into Excel files.
- Discover the different exported file types.
- Learn about the security concepts for the exported data.
Module 6: Get started with Microsoft Dataverse for Teams
- Learn how to build apps, workflows, chatbots, and dashboards.
- Learn how to provision Dataverse for Teams and then create a table for your data.
Module 7: Build your first app with Power Apps and Dataverse for Teams
- Create an app by using the hero template.
- Customize and publish your app.
- Install templates.
Module 8: Build your first workflow with Power Automate and Dataverse for Teams
- Build a flow to respond to changes in Teams.
- Extend an app in Microsoft Power Apps to trigger a flow.
- Schedule a flow to complete routine tasks.
Module 9: Create reports with Power BI and Dataverse for Teams
- Import a Microsoft Dataverse dataset into Power BI.
- Create a new Power BI report based on the dataset.
- Edit a report.
- Share a report with others in Teams channels, chats, or meetings.
Module 10: Get started building with Power BI
- How Power BI services and applications work together.
- Explore how Power BI can make your business more efficient.
- How to create compelling visuals and reports.
Module 11: Explore what Power BI can do for you
- Understand basic concepts and terminology of the Power BI service.
- Find your content in dashboards, reports, and apps.
- View and export data from dashboards and reports.
- View filters that are used in a report.
- Explain the relationship between dashboards and reports, visualizations, and tiles.
- Display action menus for tiles and details for report visualizations.
- Collapse and expand the nav pane and the filters and bookmarks panes.
- Subscribe to a dashboard and report.
- Set a data alert.
- Collaborate by using dashboard commenting.
Module 12: Manage workspaces and datasets in Power BI
- Create and manage workspaces in Power BI
- Manage semantic models in Power BI
- Create dashboards in Power BI
- Implement row-level security
Module 13: Create dashboards in Power BI
- Set a mobile view.
- Add a theme to the visuals in your dashboard.
- Add real-time semantic model visuals to your dashboards.
- Pin a live report page to a dashboard.
Module 14: Secure, publish, and share data in Power BI
- Share reports in Power BI.
- Create scorecards with goals in Power BI.
- Configure row-level security for a Power BI report.
- Publish a Power BI data model to a workspace.
- Control access to a workspace.
- Create comments and personal bookmarks in a report.
- Use endorsements to certify or promote datasets.
- Protect data with Microsoft Purview Information Protection.
- Apply refresh and alert schedules for a Power BI report.
Module 15: Embed Power BI content
- Programmatically embed all types of Power BI content.
- Optimize the embedding experience.
Module 16: How to build your first model-driven app with Dataverse
- Discover the value and key features of Dataverse.
- Learn about the value and key features of model-driven apps.
- Explore sample model-driven template apps.
Module 17: Get started with model-driven apps in Power Apps
- Model-driven app design
- Creating a model-driven app
Module 18: Configure forms, charts, and dashboards in model-driven apps
- Use form elements and controls
- Configure forms
- Use specialized form components
- Use editable grids
- Identify views and use public views
- Learn how to configure charts
- Learn how to configure dashboards
Module 19: Manage Dynamics 365 model-driven app settings and security
- Manage role-based security
- Explore customization functionality and customize themes
Module 20: Use specialized components in a model-driven form
- Learn about other components in a model-driven form.
- Create a business process flow.
- Embed a canvas app in a model-driven form.
- Add a timeline in a model-driven form.
- Create a report in a model-driven form.
Module 21: Create a canvas app in Power Apps
- Get started with Power Apps canvas apps
- Customize a canvas app in Power Apps
- How to build the User Interface in a canvas app in Power Apps
- Navigation in a canvas app in Power Apps
- Manage apps in Power Apps
- Build a mobile-optimized app from Power Apps
Module 22: Use and understand Controls in a canvas app in Power Apps
- Understand how to use controls in a canvas app
- Use the different types of controls
- Understand how Galleries and Forms relate to controls
Module 23: Create formulas to change properties in a Power Apps canvas app
- Understand the basics of how to use formulas in a canvas app
- Change the format of a date control
- Use a formula to do simple math calculations
- Change the position of an icon using a formula
- Understand how to implement conditional formatting in canvas apps using a formula
Module 24: Use imperative development techniques for canvas apps in Power Apps
- Understand imperative vs. declarative development.
- Understand the variables in Power Apps.
- Understand when to utilize each of the three different types of variables.
Module 25: Manage apps in Power Apps
- Learn how to view and restore app versions.
- Explore how to share an app, including permissions and notifications.
- Learn about what environments are, how to create them, and how to manage security.
- Find more information about Power Apps.
Module 26: Use basic formulas to make better Power Apps canvas apps
- Create formulas to change properties in a Power Apps canvas app
- Create formulas to change behaviors in a Power Apps canvas app
- Author a basic formula that uses tables and records in a Power Apps canvas app
Module 27: Build a canvas app for a real estate solution with Copilot in Power Apps
- Create a canvas app by using Copilot in Power Apps.
- Customize the Dataverse table data that Copilot generates.
- Add more data to the table.
Module 28: Automate a business process using Power Automate
- Get started with Power Automate
- Build approval flows with Power Automate
- Build flows to manage user information
- Power Automate's deep integration across multiple data sources
- Use the Admin center to manage environments and data policies in Power Automate
- Use AI Builder in Power Automate
- Optimize your business process with process advisor
Module 29: Optimize your business process with process advisor
- Create your first recording.
- Edit recordings and group actions.
- Analyze recordings and interpret results.
Module 30: Build flows for a real estate solution using Copilot in Power Automate
- Features and capabilities of Copilot in Power Automate.
- How to create and manage flows with Copilot in Power Automate.
Module 31: Use Dataverse triggers and actions in Power Automate
- Dataverse triggers and actions in Power Automate.
- Other available inputs.
Module 32: Validate your app maker skills
- Create tables in Dataverse
- Create and manage columns within a table in Dataverse
- Get started with Power Apps canvas apps
- How to build the User Interface in a canvas app in Power Apps
- Get started with Power Automate
- Challenge Project - Build a booking requests app with Power Apps and Power Automate
