Course Outline
Overview of the Microsoft Power Platform
- Introduction to Power BI, Power Apps, and Power Automate
- The mechanism by which Power Platform unifies data, logic, and insights
- Primary advantages of adopting low-code business solutions
Initial Steps with Power BI
- Setting up and configuring 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 based on existing data sources
- Structuring app layouts and forms
- Incorporating logic and interactivity through Power Fx formulas
Linking Power Apps to Data Sources
- Utilizing Dataverse, SharePoint, and Excel as backend systems
- Managing forms, galleries, and various controls
- Executing CRUD operations within the application
Introduction to Power Automate
- Differentiating 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 standard business scenarios
Unifying Power Apps, Power Automate, and Power BI
- Facilitating data exchange between apps and workflows
- Initiating automation via Power Apps events
- Embedding Power BI dashboards within Power Apps
- Orchestrating end-to-end processes across all three tools
Security, Governance, and Solution Sharing
- Administration of permissions and data access
- Environment and role-based governance strategies
- Deployment and distribution of Power Platform solutions
Capstone Project: Developing a Unified Business Solution
- Designing a streamlined business process workflow
- Building a Power App for data entry and validation
- Automating notifications and approvals via Power Automate
- Creating a Power BI dashboard for real-time reporting
Recap and Future Directions
Requirements
- A foundational understanding of basic data management and reporting procedures
- Basic familiarity with Microsoft Excel or similar Office applications
Target Audience
- Business analysts
- Data and process automation specialists
- Managers and key 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
Dynamic, adaptive, and informative