Get in Touch
 Duration 21 hours

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

Number of participants


Price per participant

Testimonials (3)

Upcoming Courses

Related Categories