Course Outline
Introduction to Microsoft Power Platform
- Overview of Power BI, Power Apps, and Power Automate
- How 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 with Power Query
- Building and publishing interactive dashboards
Introduction to Power Apps
- Understanding the Power Apps environment
- Creating canvas apps from data sources
- Designing app layouts and forms
- Adding logic and interactivity with Power Fx formulas
Connecting Power Apps with Data Sources
- Using 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
- An understanding of basic data handling and reporting processes
- Basic familiarity with Microsoft Excel or other Office applications
Audience
- Business analysts
- Data and process automation specialists
- Managers and decision-makers
- IT professionals supporting business operations
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
- Flexible Schedule: Dates and times adapted to your team's agenda.
- Format: Online (live), In-company (at your offices), or Hybrid.
Price per private group, online live training, starting from 4800 € + VAT*
Contact us for an exact quote and to hear our latest promotions
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