Course Outline
🔹 Module 1 – Introduction to Microsoft Power Platform
- Overview of the Power Platform capabilities, including Power Apps, Power Automate, Power BI, and Dataverse
- Application scenarios relevant to industrial and engineering organizations
- Low-Code/No-Code methodologies and their organizational benefits for operational efficiency
- Licensing frameworks, environment architecture, and governance strategies for government deployments
🔹 Module 2 – Power Apps Fundamentals
- Differentiation between Canvas and Model-Driven app architectures
- Canvas app structure, including screens, components, controls, and layout management
- Integration with standard data sources: SharePoint, Excel, SQL Server, and Dataverse
- Procedures for connecting to existing enterprise data lists and libraries
- Implementation of data validation rules and conditional logic
Hands-on exercises:
- Development of an inventory management solution featuring entry/output tracking and critical level alerts
- Development of an equipment control and calibration application with expiration date monitoring and status tracking
🔹 Module 3 – Automation with Power Automate
- Flow types: automated, instant, and scheduled workflows
- Configuration of triggers and actions to initiate processes and integrate tools
- Integration points with Power Apps, including button-triggered forms
- Implementation of conditions, approval hierarchies, notifications, and automated record creation
- Standards for creating modular and reusable flow components
Hands-on exercises:
- Automation of the test request process (ST) incorporating multi-step approval workflows
- Configuration of automated alerts for equipment requiring calibration
- Automated logging mechanisms for inventory and stock movements
🔹 Module 4 – Guided Development: Agency Projects
- Rapid requirements gathering with program stakeholders
- Collaborative design of agency-specific interfaces and automated workflows
- Construction of functional prototypes under instructor guidance
- Solution validation, iterative adjustments, and simulated testing environments
🔹 Module 5 – Best Practices, Governance, and Maintenance
- Environment management across Development, Testing, and Production tiers for government use cases
- Management of user permissions and enforcement of data security controls
- Standards for documentation and version control of applications and flows
- Guidelines for ongoing maintenance and system scalability
- Strategic planning for long-term solution evolution post-training
Summary and Next Steps
Requirements
- Competency in business process operations
- Proficiency with Microsoft 365 applications (e.g., SharePoint, Excel)
Target Audience
- Process owners and analysts within industrial and engineering sectors
- IT support personnel and citizen developers
- Managers seeking to automate and digitize workflows for government entities
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