Course Outline
Overview of the Microsoft Power Platform
- Introduction to 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 data sources
- Data cleansing and transformation using Power Query
- Constructing and publishing interactive dashboards
Introduction to Power Apps
- Navigating the Power Apps environment
- Creating canvas apps linked to data sources
- Structuring app layouts and forms
- Enhancing logic and interactivity through Power Fx formulas
Linking Power Apps with Data Sources
- Utilizing Dataverse, SharePoint, and Excel as backend systems
- Interacting with forms, galleries, and controls
- Executing CRUD operations within the application
Introduction to Power Automate
- Understanding flow types: automated, instant, and scheduled
- Developing and testing automation workflows
- Synchronizing Power Automate with Power Apps and Power BI
- Leveraging templates and connectors for common business scenarios
Integrating Power Apps, Power Automate, and Power BI
- Facilitating data exchange between applications and workflows
- Initiating automation based on Power Apps events
- Embedding Power BI dashboards within Power Apps
- Orchestrating end-to-end processes across all three tools
Security, Governance, and Solution Sharing
- Controlling permissions and data access
- Implementing environment and role-based governance
- Deploying and distributing Power Platform solutions
Capstone Project: Developing an Integrated Business Solution
- Designing a streamlined business process workflow
- Building a Power App for data entry and validation
- Automating notifications and approval processes with Power Automate
- Creating a Power BI dashboard for real-time reporting
Recap and Future Steps
Requirements
- A fundamental grasp of data management and reporting procedures
- Basic knowledge of Microsoft Excel or other Microsoft Office applications
Target Audience
- Business analysts
- Specialists in data and process automation
- 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