Course Outline
Overview of the Microsoft Power Platform
- Fundamental components: Power BI, Power Apps, and Power Automate
- Mechanisms for integrating data, application logic, and analytical insights
- Strategic advantages of low-code development within federal operations
Foundations of Power BI Implementation
- Deployment and configuration of Power BI Desktop
- Integration with Excel workbooks, relational databases, and external data repositories
- Data preparation and transformation using Power Query
- Development and distribution of interactive reporting dashboards
Introduction to Power Apps
- Navigation and utilization of the Power Apps development interface
- Construction of canvas applications linked to underlying data sets
- Structuring user interfaces, forms, and layout components
- Implementing business rules and interactivity via Power Fx scripting
Data Connectivity for Power Apps
- Utilizing Microsoft Dataverse, SharePoint, and Excel as primary data back-ends
- Configuration of input forms, data galleries, and interface controls
- Execution of Create, Read, Update, and Delete (CRUD) operations within applications
Introduction to Power Automate
- Classification of automation flows: automated, instant, and scheduled triggers
- Design, deployment, and validation of process automation workflows
- Interoperability between Power Automate and other Microsoft Power Platform services
- Leveraging pre-built connectors and templates to address common operational requirements for government
Unified Integration of Power Apps, Power Automate, and Power BI
- Data exchange protocols between custom applications and automation services
- Event-driven initiation of workflows from Power Apps user actions
- Embedding Power BI analytical visualizations directly into application interfaces
- Orchestration of comprehensive, end-to-end digital processes across platform services
Security Protocols, Governance Frameworks, and Distribution
- Administration of user permissions and data access controls
- Implementation of environment management and role-based governance policies
- Procedures for deploying and disseminating Power Platform solutions to authorized personnel
Capstone Project: Development of an Integrated Operational Solution
- Design specifications for a streamlined business process workflow
- Construction of a Power App to manage data entry and validation processes
- Deployment of automated notification and approval mechanisms using Power Automate
- Development of a Power BI dashboard for real-time performance monitoring and reporting
Program Summary and Future Directions
Requirements
- Knowledge of fundamental data management and reporting procedures for government
- Foundational proficiency with Microsoft Excel or comparable Office suite applications
Intended Audience
- Business analysts
- Data and process automation specialists
- Managers and decision-makers
- IT professionals 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