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
- The primary advantages of adopting low-code business solutions
Foundations of Power BI
- Setting up and configuring Power BI Desktop
- Establishing connections to Excel, databases, and online data sources
- Cleaning and transforming data using Power Query
- Creating and publishing interactive dashboards
Introduction to Power Apps
- Navigating the Power Apps environment
- Developing canvas apps from existing data sources
- Designing app layouts and input forms
- Adding logic and interactivity through Power Fx formulas
Linking Power Apps to Data Sources
- Leveraging Dataverse, SharePoint, and Excel as backend systems
- Utilizing forms, galleries, and UI controls
- Executing CRUD (Create, Read, Update, Delete) operations within the app
Introduction to Power Automate
- Understanding flow types: automated, instant, and scheduled
- Building and testing automation workflows
- Integrating Power Automate with Power Apps and Power BI
- Applying templates and connectors for common business scenarios
Unifying Power Apps, Power Automate, and Power BI
- Facilitating data exchange between apps and workflows
- Initiating automation triggered by events in Power Apps
- Embedding Power BI dashboards directly into Power Apps
- Orchestrating end-to-end processes across all three tools
Security, Governance, and Solution Sharing
- Administering permissions and data access controls
- Implementing environment and role-based governance strategies
- Distributing and sharing Power Platform solutions
Capstone Project: Developing an Integrated Business Solution
- Designing a straightforward business process workflow
- Developing a Power App for data entry and validation
- Automating notifications and approval processes via Power Automate
- Constructing a Power BI dashboard for real-time reporting
Recap and Future Directions
Requirements
- A foundational understanding 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 for 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