Course Outline
Introduction to the Microsoft Power Platform
- Overview of Power BI, Power Apps, and Power Automate
- How the Power Platform unifies data, logic, and insights
- Key advantages of adopting low-code business solutions
Getting Started with Power BI
- Setup and configuration of Power BI Desktop
- Establishing connections to Excel, databases, and web-based data sources
- Data preparation and transformation using Power Query
- Construction and publication of interactive dashboards
Introduction to Power Apps
- Navigating the Power Apps development environment
- Generating canvas applications from existing data sources
- Structuring app layouts and form designs
- Incorporating logic and interactivity via Power Fx formulas
Linking Power Apps with Data Sources
- Utilizing Dataverse, SharePoint, and Excel as backend infrastructure
- Implementing forms, galleries, and user controls
- Executing Create, Read, Update, and Delete (CRUD) operations within the application
Introduction to Power Automate
- Distinguishing between flow types: automated, instant, and scheduled
- Development and testing of automation workflows
- Integration of Power Automate with Power Apps and Power BI
- Application of templates and connectors for standard business scenarios
Integrating Power Apps, Power Automate, and Power BI
- Facilitating data exchange between applications and workflows
- Initiating automation sequences triggered by Power Apps events
- Embedding Power BI dashboards directly into Power Apps interfaces
- Orchestrating end-to-end business processes across all three tools
Security, Governance, and Solution Sharing
- Administration of user permissions and data access controls
- Implementation of environment and role-based governance strategies
- Deployment and distribution of Power Platform solutions
Capstone Project: Constructing an Integrated Business Solution
- Designing a streamlined business process workflow
- Developing a Power App for data entry and validation
- Automating notification and approval cycles using Power Automate
- Creating a Power BI dashboard for real-time performance reporting
Recap and Future Directions
Requirements
- Foundational knowledge of basic data management and reporting methodologies
- Basic proficiency with Microsoft Excel or other Microsoft Office 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
Dynamic, adaptive, and informative