Course Outline
Introduction to the Microsoft Power Platform
- Comprehensive overview of Power BI, Power Apps, and Power Automate
- Understanding how the Power Platform unifies data, logic, and insights
- The strategic benefits of adopting 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
- Performing data cleaning and transformation using Power Query
- Construction and publication of interactive dashboards
Introduction to Power Apps
- Exploring the Power Apps development environment
- Building canvas apps based on existing data sources
- Designing intuitive app layouts and forms
- Enhancing logic and interactivity through Power Fx formulas
Linking Power Apps with Data Sources
- Leveraging Dataverse, SharePoint, and Excel as back-end systems
- Working effectively with forms, galleries, and interface controls
- Implementing CRUD (Create, Read, Update, Delete) operations within the application
Introduction to Power Automate
- Distinguishing between automated, instant, and scheduled flow types
- Designing and testing automation workflows
- Connecting Power Automate with Power Apps and Power BI for synergy
- Utilizing templates and connectors to address common business scenarios
Integrating Power Apps, Power Automate, and Power BI
- Facilitating data transfer between applications and workflows
- Triggering automated processes from events within Power Apps
- Embedding Power BI dashboards directly into Power Apps
- Orchestrating end-to-end processes across all three platform tools
Security, Governance, and Solution Sharing
- Managing user permissions and data access controls
- Implementing environment and role-based governance structures
- Deploying and sharing Power Platform solutions effectively
Capstone Project: Developing an Integrated Business Solution
- Designing a streamlined business process workflow
- Building a Power App focused on data input and validation
- Automating notifications and approval processes using Power Automate
- Creating a Power BI dashboard for real-time reporting and visibility
Summary and Future Steps
Requirements
- A foundational grasp of basic data handling and reporting procedures
- Fundamental proficiency with Microsoft Excel or other Office suite applications
Target Audience
- Business analysts
- Specialists in data and process automation
- Managers and key decision-makers
- IT professionals responsible for 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
