Course Outline
Introduction to the Microsoft Power Platform
- An overview of Power BI, Power Apps, and Power Automate
- The way the Power Platform links data, logic, and insights
- Primary advantages of low-code business solutions
Beginning with Power BI
- Setting up and configuring Power BI Desktop
- Linking to Excel, databases, and online data sources
- Cleaning and transforming data using Power Query
- Constructing and publishing interactive dashboards
Introduction to Power Apps
- Exploring the Power Apps environment
- Creating canvas apps based on data sources
- Designing app layouts and forms
- Incorporating logic and interactivity via Power Fx formulas
Linking Power Apps with Data Sources
- Utilizing Dataverse, SharePoint, and Excel as back-end systems
- Working with forms, galleries, and controls
- Executing CRUD operations within the application
Introduction to Power Automate
- Distinguishing flow types: automated, instant, and scheduled
- Creating and testing automation workflows
- Integrating Power Automate with Power Apps and Power BI
- Leveraging templates and connectors for typical business scenarios
Combining Power Apps, Power Automate, and Power BI
- Transferring data between applications and workflows
- Initiating automation from Power Apps events
- Embedding Power BI dashboards within Power Apps
- Coordinating end-to-end processes across all three tools
Security, Governance, and Solution Sharing
- Administering permissions and data access
- Environment and role-based governance
- Deploying and sharing Power Platform solutions
Capstone Project: Constructing an Integrated Business Solution
- Designing a simple business process workflow
- Building a Power App for data entry and validation
- Automating notifications and approvals using Power Automate
- Developing a Power BI dashboard for real-time reporting
Recap and Future Steps
Requirements
- A foundational grasp of basic data management 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 providing support for 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