Course Outline
Exploring the Microsoft Power Platform
- A comprehensive look at Power BI, Power Apps, and Power Automate
- How the Power Platform links data, business logic, and insights
- The primary advantages of adopting low-code business solutions
Initiating Your Journey with Power BI
- Setup and configuration of Power BI Desktop
- Establishing connections to Excel, databases, and online data sources
- Refining data through cleaning and transformation using Power Query
- Construction and publication of interactive dashboards
Understanding Power Apps Fundamentals
- Navigating the Power Apps development environment
- Generating canvas apps from various data sources
- Crafting app layouts and user forms
- Enhancing logic and interactivity through Power Fx formulas
Linking Power Apps to Data Sources
- Utilizing Dataverse, SharePoint, and Excel as back-end storage systems
- Manipulating forms, galleries, and UI controls
- Executing CRUD operations within the application
Getting to Know Power Automate
- Distinguishing between automated, instant, and scheduled flows
- Building and validating automation workflows
- Integrating Power Automate with Power Apps and Power BI
- Leveraging templates and connectors for standard business scenarios
Synergizing Power Apps, Power Automate, and Power BI
- Transferring data seamlessly between applications and workflows
- Initiating automations triggered by Power Apps events
- Embedding Power BI dashboards directly into Power Apps
- Orchestrating end-to-end processes across the three core tools
Security, Governance, and Solution Sharing
- Administering permissions and data access controls
- Implementing environment and role-based governance strategies
- Rollout and sharing of Power Platform solutions
Capstone Project: Constructing a Unified Business Solution
- Architecting a straightforward business process workflow
- Developing a Power App for data entry and validation
- Automating notifications and approval processes via Power Automate
- Creating a Power BI dashboard for real-time reporting capabilities
Recap and Future Directions
Requirements
- A foundational grasp of basic data management and reporting methodologies
- Basic proficiency with Microsoft Excel or other Microsoft Office suite applications
Target Audience
- Business analysts
- Specialists in data and process automation
- Managers and strategic decision-makers
- IT professionals assisting with 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