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 (3)
Answered all our questions. Led course based on our areas of interest and regularly checked in to make sure we are following.
- Complete Coherence
Course - Microsoft Power Platform Fundamentals
What I liked the most was the coach's openness regarding the change in content as well as the approach that was previously prepared to accommodate our real needs
Ernesto Sitoe Junior - Electricidade de Mocambique
Course - Advanced Power BI
I really admire Trainer's patience for all the people who were asking him to repeat something 4-5 times. I also believe that he has great knowledge about the topic, but like said above, we didn't spend enough time on this. Moreover, it was good it was hands-on training, where we could practice in real time what we're taught, but again, I'd like to know more about the PowerApps, not about SharePoint, as I'm really familiar with that one, and if I wanted to learn more, I'd probably just choose a training for the SharePoint, not PowerApps.
