Get in Touch

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
 21 Hours

Number of participants


Price per participant

Testimonials (3)

Upcoming Courses

Related Categories