Course Outline
Foundational Insights into the Microsoft Power Platform
- Comprehensive overview of Power BI, Power Apps, and Power Automate.
- Understanding how the Power Platform unifies data, logic, and actionable insights.
- Exploring the primary advantages of low-code business solutions.
Initial Steps with Power BI
- Setup and configuration of Power BI Desktop.
- Establishing connections to Excel, databases, and various online data sources.
- Refining and transforming data utilizing Power Query.
- Creating and publishing interactive dashboards.
Introduction to Power Apps
- Navigating the Power Apps development environment.
- Generating canvas apps from existing data sources.
- Structuring app layouts and form designs.
- Incorporating logic and interactivity through Power Fx formulas.
Linking Power Apps with Data Sources
- Utilizing Dataverse, SharePoint, and Excel as backend data stores.
- Managing forms, galleries, and UI controls.
- Executing CRUD (Create, Read, Update, Delete) operations within the application.
Introduction to Power Automate
- Distinguishing between automated, instant, and scheduled flow types.
- Developing and validating automation workflows.
- Synchronizing Power Automate with Power Apps and Power BI.
- Leveraging templates and connectors for standard business scenarios.
Synergizing Power Apps, Power Automate, and Power BI
- Facilitating data transfer between applications and workflows.
- Initiating automation triggered by events within Power Apps.
- Embedding Power BI dashboards directly into Power Apps interfaces.
- Orchestrating end-to-end processes that leverage all three tools.
Security, Governance, and Solution Distribution
- Administering permissions and data access controls.
- Implementing environment and role-based governance strategies.
- Rolling out and sharing Power Platform solutions effectively.
Capstone Project: Developing an Integrated Business Solution
- Conceptualizing a streamlined business process workflow.
- Constructing a Power App for data entry and validation tasks.
- Automating notification and approval chains using Power Automate.
- Designing a Power BI dashboard for real-time performance reporting.
Recap and Future Directions
Requirements
- Fundamental knowledge of data management and reporting procedures.
- Basic proficiency with Microsoft Excel or other Microsoft Office applications.
Target Audience
- Business analysts.
- Specialists in data and process automation.
- Managers and key decision-makers.
- IT professionals who support 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
