Course Outline
Microsoft Power Platform Orientation
- Summary of Power BI, Power Apps, and Power Automate capabilities
- Mechanisms for linking data, operational logic, and analytical insights
- Strategic advantages of low-code implementations in public sector contexts
Initiation and Configuration of Power BI
- Installation and setup of Power BI Desktop for government use
- Integration with Excel, database systems, and external data repositories
- Data preparation and modification via Power Query
- Construction and release of interactive dashboard reports
Power Apps Fundamentals
- Review of the Power Apps operational environment
- Development of canvas-based applications from existing data sources
- Layout design and form structuring for user interaction
- Incorporation of business logic and dynamic responses using Power Fx formulas
Linking Power Apps to Data Repositories
- Utilization of Dataverse, SharePoint, and Excel as backend infrastructure
- Management of forms, data galleries, and interface controls
- Execution of Create, Read, Update, and Delete (CRUD) functions within the application
Introduction to Power Automate
- Analysis of flow categories: automated, instant, and scheduled executions
- Development and verification of automated process workflows
- Synchronization of Power Automate with Power Apps and Power BI modules
- Application of standard templates and connectors for routine administrative tasks
Consolidation of Power Apps, Power Automate, and Power BI
- Data exchange protocols between applications and workflow triggers
- Activation of automation processes through Power Apps user events
- Integration of Power BI visual reports within Power Apps interfaces
- Orchestration of comprehensive business processes spanning all three platforms
Security, Governance, and Solution Distribution
- Administration of access controls and data permission levels
- Deployment and distribution of Power Platform solutions for government compliance
Capstone Project: Development of a Unified Operational Solution
- Blueprinting of a streamlined business process workflow
- Construction of a Power App for data capture and integrity validation
- Automation of alert systems and approval chains via Power Automate
- Generation of a Power BI dashboard for real-time performance monitoring
Conclusion and Future Implementation Steps
Requirements
- Foundational knowledge of data management and reporting procedures
- Basic proficiency with Microsoft Excel or comparable Office suite applications
Intended Audience
- Business analysts
- Data and process automation specialists
- Managers and strategic decision-makers
- IT professionals supporting operational business functions
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