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 (5)
I thought the trainer was really engaging and was very quick on his feet to answer questions that were related to our work and really tailored the teaching towards our needs and went above and beyond to meet them. I could not recommend Shaun enough!
Tom King - Complete Coherence
Course - Microsoft Power Platform Fundamentals
Discussing about our issues
Rr Dwi Putri Periska Sari - PT. Becton Dickinson Indonesia
Course - Power BI for Developers
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.
Patrycja - EY GDS
Course - Microsoft Flow/Power Automate
I really enjoyed the training exercise.
Edward Dan Dree Manalad - Marine Benefits, Inc.
Course - Power BI for Business Analysts
Offering a more in-depth scope about Power BI more than any training institute that I came across to.
