Course Outline
Introduction to the Microsoft Power Platform
- An overview of Power BI, Power Apps, and Power Automate.
- How the Power Platform unifies data, logic, and insights.
- The key advantages of adopting low-code business solutions.
Getting Started with Power BI
- Installation and configuration of Power BI Desktop.
- Establishing connections to Excel, databases, and online data sources.
- Data cleansing and transformation using Power Query.
- Constructing and publishing interactive dashboards.
Introduction to Power Apps
- Exploring the Power Apps development environment.
- Generating canvas apps directly from data sources.
- Designing intuitive app layouts and forms.
- Incorporating logic and interactivity via Power Fx formulas.
Connecting Power Apps with Data Sources
- Leveraging Dataverse, SharePoint, and Excel as backend systems.
- Utilizing forms, galleries, and UI controls effectively.
- Executing CRUD operations within the application.
Introduction to Power Automate
- Distinguishing flow types: automated, instant, and scheduled.
- Building and testing automation workflows.
- Linking Power Automate with Power Apps and Power BI.
- Applying templates and connectors to address common business scenarios.
Integrating Power Apps, Power Automate, and Power BI
- Facilitating data exchange between applications and workflows.
- Triggering automated actions in response to Power Apps events.
- Embedding Power BI dashboards within Power Apps.
- Orchestrating end-to-end processes across all three tools.
Security, Governance, and Sharing Solutions
- Administering permissions and data access controls.
- Implementing environment and role-based governance strategies.
- Deploying and sharing Power Platform solutions securely.
Capstone Project: Creating an Integrated Business Solution
- Mapping out a simple business process workflow.
- Developing a Power App for data entry and validation.
- Automating notifications and approval steps with Power Automate.
- Building a Power BI dashboard for real-time reporting.
Summary and Next Steps
Requirements
- A foundational understanding of data handling and reporting procedures.
- Basic proficiency with Microsoft Excel or similar Office applications.
Target Audience
- Business analysts.
- Specialists in data and process automation.
- Managers and strategic decision-makers.
- IT professionals who support 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
