Course Outline
Introduction to the Microsoft Power Platform
- An overview of Power BI, Power Apps, and Power Automate
- Understanding how the Power Platform unifies data, logic, and insights
- The primary advantages of adopting low-code business solutions
Beginning with Power BI
- Installation and configuration of Power BI Desktop
- Establishing connections to Excel, databases, and online data sources
- Data cleansing and transformation utilizing Power Query
- Construction and publication of interactive dashboards
Introduction to Power Apps
- Exploring the Power Apps development environment
- Generating canvas apps from existing data sources
- Designing app layouts and input forms
- Incorporating logic and interactivity via Power Fx formulas
Linking Power Apps with Data Sources
- Utilizing Dataverse, SharePoint, and Excel as back-end systems
- Managing forms, galleries, and interface controls
- Executing CRUD operations within the application
Introduction to Power Automate
- Understanding different flow types: automated, instant, and scheduled
- Creation and testing of automation workflows
- Integrating Power Automate with Power Apps and Power BI
- Leveraging templates and connectors for typical business scenarios
Integrating Power Apps, Power Automate, and Power BI
- Facilitating data transfer between applications and workflows
- Initiating automation based on events from Power Apps
- Embedding Power BI dashboards within Power Apps
- Orchestrating end-to-end processes across all three tools
Security, Governance, and Solution Distribution
- Managing permissions and data access controls
- Implementing environment and role-based governance
- Deployment and sharing of Power Platform solutions
Capstone Project: Developing an Integrated Business Solution
- Designing a workflow for a simple business process
- Building a Power App for data entry and validation
- Automating notifications and approval processes with Power Automate
- Creating a Power BI dashboard for real-time reporting
Conclusion and Future Directions
Requirements
- A foundational understanding of data management and reporting procedures
- Basic proficiency with Microsoft Excel or other Office suite applications
Target Audience
- Business analysts
- Data and process automation specialists
- Managers and strategic decision-makers
- IT professionals involved in supporting business operations
Testimonials (3)
Practical and hands on labs on report developmemt using Power BI The labs were excellent and the trainer offered very good hands on sessions
Sinzala Sichaanji - Bank of Zambia
Course - Mastering Power Platform: Power Apps, Power Automate, DataVerse, Power BI, and Power Virtual Agents
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
Knowledge of the application and its uses
Jose Everardo Hernandez Esmeralda - Comercializadora NIMMKA
Course - Microsoft Power Platform Fundamentals
Machine Translated
