Course Outline
Introduction to the Microsoft Power Platform
- Overview of Power BI, Power Apps, and Power Automate.
- How the Power Platform unifies data, logic, and insights.
- Primary advantages of adopting low-code business solutions.
Initial Steps with Power BI
- Installation and configuration of Power BI Desktop.
- Connecting to Excel, databases, and web-based data sources.
- Data cleansing and transformation using Power Query.
- Creation and publication of interactive dashboards.
Introduction to Power Apps
- Navigating the Power Apps environment.
- Building canvas apps based on existing data sources.
- Designing app layouts and input forms.
- Enhancing 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 UI controls.
- Executing CRUD operations within the application.
Introduction to Power Automate
- Distinguishing flow types: automated, instant, and scheduled.
- Developing and testing automation workflows.
- Connecting Power Automate with Power Apps and Power BI.
- Applying templates and connectors for standard business scenarios.
Integrating Power Apps, Power Automate, and Power BI
- Transferring data between applications and workflows.
- Initiating automations via Power Apps events.
- Embedding Power BI dashboards within Power Apps.
- Orchestrating end-to-end processes across all three tools.
Security, Governance, and Solution Sharing
- Administration of permissions and data access controls.
- Environment management and role-based governance.
- Deployment and distribution of Power Platform solutions.
Capstone Project: Creating an Integrated Business Solution
- Designing a streamlined business process workflow.
- Developing a Power App for data entry and validation.
- Automating notifications and approval processes with Power Automate.
- Building a Power BI dashboard for real-time reporting.
Recap and Future Steps
Requirements
- Fundamental knowledge of data management and reporting processes.
- Basic proficiency with Microsoft Excel or similar Office applications.
Target Audience
- Business analysts.
- Specialists in data and process automation.
- Managers and strategic 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
