Course Outline
Introduction to Microsoft Power Platform
- Overview of Power BI, Power Apps, and Power Automate
- How the Power Platform integrates data, logic, and insights for government
- Key benefits of low-code business solutions for government operations
Getting Started with Power BI
- Installing and configuring Power BI Desktop for government use
- Connecting to Excel, databases, and online data sources for government
- Data cleaning and transformation using Power Query for enhanced accuracy in government reporting
- Building and publishing interactive dashboards to support decision-making for government
Introduction to Power Apps
- Understanding the Power Apps environment and its application in government settings
- Creating canvas apps from data sources to streamline governmental processes
- Designing app layouts and forms for efficient user interaction within government agencies
- Adding logic and interactivity with Power Fx formulas to enhance functionality for government applications
Connecting Power Apps with Data Sources
- Utilizing Dataverse, SharePoint, and Excel as back-end systems for government data management
- Working with forms, galleries, and controls to facilitate data entry and retrieval in government applications
- Implementing CRUD operations within the app to ensure robust data handling for government use
Introduction to Power Automate
- Understanding flow types: automated, instant, and scheduled, in the context of government workflows
- Creating and testing automation workflows to improve efficiency in government operations
- Connecting Power Automate with Power Apps and Power BI for integrated government solutions
- Using templates and connectors for common business scenarios relevant to government agencies
Integrating Power Apps, Power Automate, and Power BI
- Passing data between apps and workflows to ensure seamless integration in government processes
- Triggering automation from Power Apps events to streamline government operations
- Embedding Power BI dashboards into Power Apps for real-time monitoring of government performance
- Coordinating end-to-end processes across all three tools to enhance overall government efficiency
Security, Governance, and Sharing Solutions
- Managing permissions and data access to ensure compliance with government regulations
- Implementing environment and role-based governance for secure government operations
- Deploying and sharing Power Platform solutions within government agencies to foster collaboration
Capstone Project: Building an Integrated Business Solution
- Designing a simple business process workflow for government use
- Building a Power App for data input and validation to support government operations
- Automating notifications and approvals with Power Automate to enhance governmental efficiency
- Creating a Power BI dashboard for real-time reporting to inform government decision-making
Summary and Next Steps
Requirements
- An understanding of fundamental data management and reporting procedures for government.
- Basic proficiency with Microsoft Excel or other Office applications.
Audience
- Business analysts
- Data and process automation specialists
- Managers and decision-makers
- IT professionals supporting government operations
Testimonials (2)
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
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.
