Course Outline
Introduction to the Microsoft Power Platform
- Overview of the capabilities of Power BI, Power Apps, and Power Automate.
- Exploring how the Power Platform unifies data, logic, and analytical insights.
- Key advantages of adopting low-code business solutions.
Getting Started with Power BI
- Setting up and configuring Power BI Desktop.
- Establishing connections to Excel files, databases, and web-based data sources.
- Utilizing Power Query for data cleansing and transformation.
- Creating and deploying interactive dashboards.
Introduction to Power Apps
- Navigating the Power Apps development environment.
- Developing canvas apps directly from existing data sources.
- Structuring app layouts and designing user-friendly forms.
- Enhancing interactivity and logic through Power Fx formulas.
Linking Power Apps with Data Sources
- Leveraging Dataverse, SharePoint, and Excel as backend storage systems.
- Working effectively with forms, galleries, and interface controls.
- Executing Create, Read, Update, and Delete (CRUD) operations within the application.
Introduction to Power Automate
- Distinguishing between automated, instant, and scheduled flow types.
- Constructing and validating automation workflows.
- Integrating Power Automate with both Power Apps and Power BI.
- Applying templates and connectors to address common business scenarios.
Integration of Power Apps, Power Automate, and Power BI
- Facilitating data transfer between applications and workflows.
- Initiating automation processes in response to Power Apps events.
- Embedding Power BI dashboards within Power Apps interfaces.
- Orchestrating end-to-end business processes across the three tools.
Security, Governance, and Solution Sharing
- Overseeing permissions and controlling data access.
- Implementing environment-level and role-based governance policies.
- Distributing and sharing Power Platform solutions effectively.
Capstone Project: Developing an Integrated Business Solution
- Mapping out a straightforward business process workflow.
- Developing a Power App for data entry and validation purposes.
- Automating notification and approval sequences using Power Automate.
- Creating a Power BI dashboard for real-time performance reporting.
Summary and Recommended Next Steps
Requirements
- A foundational grasp of data management and reporting procedures.
- Basic proficiency with Microsoft Excel or other Microsoft Office applications.
Target Audience
- Business analysts.
- Specialists in data management and process automation.
- Managers and individuals involved in strategic decision-making.
- IT professionals providing support for business operations.
Testimonials (3)
Practical and hands on labs on report developmemt using Power BI The labs were excellent and the trainer offered very good hands on sessions
Sinzala Sichaanji - Bank of Zambia
Course - Mastering Power Platform: Power Apps, Power Automate, DataVerse, Power BI, and Power Virtual Agents
We did quite complex examples, so we could get a feeling of how the real work with Power Automate Desktop can look like in the real world scenario.
Michal Strnad - MicroNova AG
Course - Microsoft Flow/Power Automate
Dynamic, adaptive, and informative
