Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Introduction to Microsoft Power Platform
- Overview of Power BI, Power Apps, and Power Automate.
- How the Power Platform connects data, logic, and insights.
- Key benefits of low-code business solutions.
Getting Started with Power BI
- Installing and configuring Power BI Desktop.
- Connecting to Excel, databases, and online data sources.
- Data cleaning and transformation using Power Query.
- Building and publishing interactive dashboards.
Introduction to Power Apps
- Understanding the Power Apps environment.
- Creating canvas apps from existing data sources.
- Designing app layouts and forms.
- Adding logic and interactivity with Power Fx formulas.
Connecting Power Apps with Data Sources
- Utilizing Dataverse, SharePoint, and Excel as back-end systems.
- Working with forms, galleries, and controls.
- Implementing CRUD operations within the app.
Introduction to Power Automate
- Understanding flow types: automated, instant, and scheduled.
- Creating and testing automation workflows.
- Connecting Power Automate with Power Apps and Power BI.
- Using templates and connectors for common business scenarios.
Integrating Power Apps, Power Automate, and Power BI
- Passing data between apps and workflows.
- Triggering automation from Power Apps events.
- Embedding Power BI dashboards into Power Apps.
- Coordinating end-to-end processes across all three tools.
Security, Governance, and Sharing Solutions
- Managing permissions and data access.
- Environment and role-based governance.
- Deploying and sharing Power Platform solutions.
Capstone Project: Building an Integrated Business Solution
- Designing a simple business process workflow.
- Building a Power App for data input and validation.
- Automating notifications and approvals with Power Automate.
- Creating a Power BI dashboard for real-time reporting.
Summary and Next Steps
Requirements
- A foundational understanding of basic data handling and reporting processes.
- Basic familiarity with Microsoft Excel or other Office applications.
Target Audience
- Business analysts.
- Data and process automation specialists.
- Managers and decision-makers.
- IT professionals supporting business operations.
21 Hours
Testimonials (2)
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