Get in Touch

Course Outline

Overview of the Microsoft Power Platform

  • Examination of core components: Power BI, Power Apps, Power Automate, and Power Virtual Agents
  • Interoperability between Microsoft 365 and the Power Platform
  • Assessment of the operational value associated with low-code development for government agencies

Initiating Work with Power BI

  • Installation and configuration of Power BI Desktop
  • Establishing connections to diverse data sources, including Excel files, relational databases, and cloud services
  • Execution of data cleaning and transformation procedures using Power Query

Data Modeling and Relational Structures in Power BI

  • Comprehension of data model architecture and relationship mapping
  • Utilization of DAX (Data Analysis Expressions) for complex calculations
  • Development of hierarchical structures and calculated measures

Data Visualization and Dashboard Development

  • Design principles for effective and interactive data dashboards
  • Deployment of visual components: charts, maps, slicers, and tabular views
  • Implementation of filtering mechanisms, drill-through capabilities, and conditional formatting

Fundamentals of Power Apps

  • Familiarization with the Power Apps development environment
  • Development of canvas apps and model-driven applications
  • Designing user interfaces and responsive layouts for government systems

Linking Power Apps to Data Sources

  • Integration with Dataverse, SharePoint lists, and Excel workbooks as data backends
  • Construction of data entry forms, gallery views, and data cards
  • Implementation of business logic through formulas and automated actions

Workflow Automation and System Integration

  • Leveraging Power Automate to enhance functionality within Power Apps and Power BI environments
  • Configuration of triggers and automated workflow sequences
  • Application scenarios: approval processes, system notifications, and data updates relevant for government operations

Deployment, Distribution, and Security Protocols

  • Publishing dashboards and applications across organizational networks
  • Administration of user permissions, development environments, and data governance standards
  • Adherence to best practices for the maintenance and lifecycle management of solutions

Conclusion and Future Directions

Requirements

  • Competency in data management and analytical reporting procedures
  • Foundational proficiency with Microsoft Excel or comparable spreadsheet applications

Target Audience

  • Business analysts
  • Data specialists
  • Executive managers and policy decision-makers
  • Automation implementation experts
 21 Hours

Number of participants


Price per participant

Testimonials (2)

Upcoming Courses

Related Categories