Course Outline
Introduction to the Microsoft Power Platform
- Overview of the capabilities of Power BI, Power Apps, and Power Automate
- Exploring how the Power Platform unifies data, logic, and actionable insights
- The primary advantages of adopting low-code business solutions
Getting Started with Power BI
- Installing and setting up Power BI Desktop
- Establishing connections to Excel files, databases, and online data sources
- Performing data cleaning and transformation tasks using Power Query
- Developing and publishing interactive dashboards
Introduction to Power Apps
- Navigating the Power Apps development environment
- Generating canvas apps directly from existing data sources
- Designing intuitive app layouts and input forms
- Enhancing logic and interactivity through Power Fx formulas
Connecting Power Apps to Data Sources
- Leveraging Dataverse, SharePoint, and Excel as backend storage systems
- Utilizing forms, galleries, and various controls effectively
- Executing CRUD (Create, Read, Update, Delete) operations within the application
Introduction to Power Automate
- Distinguishing between flow types: automated, instant, and scheduled
- Building and testing automated workflow processes
- Linking Power Automate with Power Apps and Power BI for enhanced functionality
- Applying templates and connectors to address common business scenarios
Integrating Power Apps, Power Automate, and Power BI
- Facilitating data exchange between applications and workflows
- Initiating automated actions based on events triggered in Power Apps
- Embedding Power BI dashboards directly into Power Apps interfaces
- Orchestrating end-to-end business processes across all three platforms
Security, Governance, and Solution Sharing
- Overseeing permissions and data access controls
- Implementing environment-specific and role-based governance strategies
- Rolling out and sharing Power Platform solutions organization-wide
Capstone Project: Developing an Integrated Business Solution
- Mapping out a streamlined business process workflow
- Constructing a Power App focused on data input and validation
- Automating alert notifications and approval cycles using Power Automate
- Designing a Power BI dashboard for real-time performance reporting
Course Summary and Future Roadmap
Requirements
- A foundational grasp of basic data handling and reporting procedures
- Familiarity with Microsoft Excel or other Office suite applications
Target Audience
- Business analysts
- Specialists in data and process automation
- Managers and strategic decision-makers
- IT professionals 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
