Course Outline
Introduction to the Microsoft Power Platform
- Comprehensive overview of Power BI, Power Apps, and Power Automate
- How the Power Platform bridges data, logic, and business insights
- Strategic advantages of adopting low-code business solutions
Getting Started with Power BI
- Installation and configuration of Power BI Desktop
- Establishing connections to Excel, databases, and cloud-based data sources
- Cleaning and transforming data using Power Query
- Constructing and publishing interactive dashboards
Introduction to Power Apps
- Exploring the Power Apps development environment
- Generating canvas applications from existing data sources
- Designing user interfaces, layouts, and forms
- Implementing logic and interactivity through Power Fx formulas
Connecting Power Apps with Data Sources
- Utilizing Dataverse, SharePoint, and Excel as backend systems
- Managing forms, galleries, and various controls
- Executing CRUD operations within the application
Introduction to Power Automate
- Distinguishing flow types: automated, instant, and scheduled
- Building and validating automation workflows
- Synchronizing Power Automate with Power Apps and Power BI
- Leveraging templates and connectors for standard business scenarios
Integrating Power Apps, Power Automate, and Power BI
- Facilitating data exchange between applications and workflows
- Initiating automation processes triggered by Power Apps events
- Embedding Power BI dashboards directly into Power Apps
- Orchestrating end-to-end processes across all three platforms
Security, Governance, and Solution Sharing
- Administering permissions and data access controls
- Implementing environment and role-based governance structures
- Deploying and distributing Power Platform solutions
Capstone Project: Developing an Integrated Business Solution
- Architecting a streamlined business process workflow
- Building a Power App for data entry and validation purposes
- Automating notifications and approval chains using Power Automate
- Creating a Power BI dashboard for real-time performance reporting
Summary and Future Steps
Requirements
- Foundational knowledge of data handling and reporting procedures.
- Basic proficiency with Microsoft Excel or other Office suite applications.
Target Audience
- Business analysts
- Specialists in data and process automation
- Managers and strategic decision-makers
- IT professionals providing support to 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
