Course Outline
Introduction to the Microsoft Power Platform
- An overview of Power BI, Power Apps, and Power Automate.
- Understanding how the Power Platform unifies data, logic, and insights.
- The primary advantages of adopting low-code business solutions.
Initiating Power BI
- Setup and configuration of Power BI Desktop.
- Establishing connections to Excel, databases, and online data sources.
- Cleaning and transforming data using Power Query.
- Creating and publishing dynamic, interactive dashboards.
Introduction to Power Apps
- Exploring the Power Apps environment.
- Building canvas apps based on existing data sources.
- Designing user-friendly app layouts and forms.
- Incorporating logic and interactivity through Power Fx formulas.
Linking Power Apps with Data Sources
- Utilizing Dataverse, SharePoint, and Excel as backend systems.
- Managing forms, galleries, and interface controls.
- Executing CRUD operations within the application.
Introduction to Power Automate
- Distinguishing between automated, instant, and scheduled flow types.
- Developing and testing automation workflows.
- Integrating Power Automate with Power Apps and Power BI.
- Leveraging templates and connectors for common business scenarios.
Integration of Power Apps, Power Automate, and Power BI
- Facilitating data transfer between applications and workflows.
- Activating automations triggered by events within Power Apps.
- Embedding Power BI dashboards directly into Power Apps.
- Orchestrating end-to-end processes across all three platforms.
Security, Governance, and Solution Sharing
- Overseeing permissions and data access controls.
- Implementing environment and role-based governance.
- Rolling out and distributing Power Platform solutions.
Capstone Project: Constructing an Integrated Business Solution
- Mapping out a simple business process workflow.
- Developing a Power App for data entry and validation.
- Automating notifications and approval processes using Power Automate.
- Building a Power BI dashboard for real-time reporting.
Recap and Future Directions
Requirements
- Foundational knowledge of data management 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 key decision-makers.
- IT professionals involved in 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
