Course Outline
Introduction to Microsoft Power Platform for Government
- Overview of Power BI, Power Apps, Power Automate, and Power Virtual Agents
- Integration between Microsoft 365 and the Power Platform for government
- Understanding the business value of low-code development for government operations
Getting Started with Power BI for Government
- Installing and configuring Power BI Desktop for government use
- Connecting to various data sources (Excel, databases, cloud services) for government datasets
- Data cleaning and transformation using Power Query for enhanced government data integrity
Data Modeling and Relationships in Power BI for Government
- Understanding data models and relationships to support government reporting
- Using DAX (Data Analysis Expressions) for advanced calculations in government analytics
- Creating hierarchies and measures to enhance government data insights
Data Visualization and Dashboards for Government
- Designing effective and interactive dashboards for government stakeholders
- Utilizing visual elements: charts, maps, slicers, and tables to present government data
- Applying filters, drill-through, and conditional formatting to enhance government data visualization
Introduction to Power Apps for Government
- Understanding the Power Apps environment tailored for government use
- Creating canvas and model-driven apps to support government processes
- Designing user interfaces and layouts for efficient government application development
Connecting Power Apps with Data Sources for Government
- Using Dataverse, SharePoint, and Excel as data sources for government applications
- Creating forms, galleries, and data cards to streamline government workflows
- Building logic with formulas and actions to automate government tasks
Automation and Integration for Government
- Using Power Automate with Power Apps and Power BI to enhance government efficiency
- Setting triggers and automated workflows to support government operations
- Real-world automation examples: approvals, notifications, and updates for government processes
Publishing, Sharing, and Security for Government
- Publishing dashboards and apps within the organization to support government collaboration
- Managing permissions, environments, and data governance to ensure compliance with government regulations
- Best practices for maintaining and updating solutions to meet evolving government needs
Summary and Next Steps for Government
Requirements
- An understanding of data handling and reporting processes for government
- Basic familiarity with Microsoft Excel or similar spreadsheet tools
Audience
- Business analysts
- Data professionals
- Managers and decision-makers
- Process automation specialists
Testimonials (2)
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
