Course Outline
Introduction to the Microsoft Power Platform
- Overview of Power BI, Power Apps, and Power Automate.
- How the Power Platform unifies data, logic, and insights.
- Core advantages of low-code business solutions.
Getting Started with Power BI
- Setup and configuration of Power BI Desktop.
- Establishing connections to Excel, databases, and online sources.
- Data cleaning and transformation using Power Query.
- Creation and publication of interactive dashboards.
Introduction to Power Apps
- Navigating the Power Apps environment.
- Generating canvas apps from existing data sources.
- Designing intuitive app layouts and forms.
- Enhancing logic and interactivity through Power Fx formulas.
Connecting Power Apps with Data Sources
- Leveraging Dataverse, SharePoint, and Excel as back-end systems.
- Managing forms, galleries, and controls effectively.
- Executing CRUD operations within the application.
Introduction to Power Automate
- Exploring flow types: automated, instant, and scheduled.
- Development and testing of automation workflows.
- Integration of Power Automate with Power Apps and Power BI.
- Utilizing templates and connectors for standard business scenarios.
Integrating Power Apps, Power Automate, and Power BI
- Facilitating data exchange between applications and workflows.
- Triggering automated actions based on Power Apps events.
- Embedding Power BI dashboards within Power Apps.
- Orchestrating end-to-end processes across all three tools.
Security, Governance, and Sharing Solutions
- Administration of permissions and data access.
- Implementing environment and role-based governance.
- Deployment and sharing of Power Platform solutions.
Capstone Project: Developing an Integrated Business Solution
- Designing a streamlined business process workflow.
- Developing a Power App for data entry and validation.
- Automating notifications and approval chains using Power Automate.
- Building a Power BI dashboard for real-time reporting.
Summary and Future Steps
Requirements
- Foundational knowledge of data management and reporting procedures.
- Basic proficiency with Microsoft Excel or similar Office suite applications.
Target Audience
- Business Analysts
- Data and Process Automation Specialists
- Managers and Key Decision-Makers
- IT Professionals supporting 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