Course Outline
Introduction to the Microsoft Power Platform
- Overview of Power BI, Power Apps, and Power Automate
- Key advantages of low-code business solutions
Getting Started with Power BI
- Installation and configuration of Power BI Desktop
- Establishing connections to Excel, databases, and online data sources
- Data cleansing and transformation utilizing Power Query
- Creation and publication of interactive dashboards
Introduction to Power Apps
- Exploration of the Power Apps environment
- Development of canvas apps from existing data sources
- Design of app layouts and forms
- Incorporation of logic and interactivity through Power Fx formulas
Linking Power Apps with Data Sources
- Utilization of Dataverse, SharePoint, and Excel as backend systems
- Interaction with forms, galleries, and controls
- Implementation of CRUD operations within the application
Introduction to Power Automate
- Understanding flow categories: automated, instant, and scheduled
- Development and testing of automation workflows
- Integration of Power Automate with Power Apps and Power BI
- Application of templates and connectors for common business scenarios
Integration of Power Apps, Power Automate, and Power BI
- Data exchange between applications and workflows
- Triggering automations based on Power Apps events
- Embedding Power BI dashboards within Power Apps
- Coordination of end-to-end processes across all three tools
Security, Governance, and Solution Sharing
- Management of permissions and data access
- Environment and role-based governance strategies
- Deployment and sharing of Power Platform solutions
Capstone Project: Constructing an Integrated Business Solution
- Design of a simple business process workflow
- Development of a Power App for data entry and validation
- Automation of notifications and approvals using Power Automate
- Creation of a Power BI dashboard for real-time reporting
Recap and Future Directions
Requirements
- Familiarity with fundamental data management and reporting procedures
- Basic knowledge of Microsoft Excel or other Office suite applications
Intended Audience
- Business analysts
- Data and process automation specialists
- Managers and strategic 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