Course Outline
Overview of the Microsoft Power Platform
- Exploring the interplay between data, logic, and insights within the Power Platform.
- Advantages of adopting low-code strategies for business solutions.
Initial Steps with Power BI
- Setting up and customizing Power BI Desktop.
- Establishing connections to Excel, databases, and cloud-based data sources.
- Refining and reshaping data using Power Query.
- Constructing and sharing dynamic, interactive dashboards.
Foundations of Power Apps
- Navigating the Power Apps workspace.
- Developing canvas-based applications from existing data sources.
- Structuring app interfaces and input forms.
- Introducing logic and user interaction through Power Fx formulas.
Linking Power Apps to Data Sources
- Leveraging Dataverse, SharePoint, and Excel as backend data stores.
- Utilizing forms, galleries, and UI controls effectively.
- Executing Create, Read, Update, and Delete (CRUD) actions within the application.
Getting to Know Power Automate
- Differentiating between automated, instant, and scheduled flows.
- Designing and validating automation sequences.
- Syncing Power Automate with Power Apps and Power BI.
- Applying templates and connectors to address standard business needs.
Unified Integration of Power Apps, Power Automate, and Power BI
- Facilitating data exchange between applications and workflows.
- Initiating automated actions based on events in Power Apps.
- Incorporating Power BI visualizations directly into Power Apps.
- Orchestrating end-to-end processes that span all three tools.
Security, Governance, and Distribution
- Controlling permissions and regulating data access.
- Releasing and sharing Power Platform solutions with stakeholders.
Capstone: Developing a Comprehensive Business Solution
- Mapping out a straightforward business process flow.
- Creating a Power App for data entry and verification.
- Automating alerts and approval steps using Power Automate.
- Generating a Power BI dashboard for real-time performance tracking.
Wrap-up and Future Directions
Requirements
- A foundational grasp of data management and reporting procedures.
- Basic proficiency with Microsoft Excel or similar 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
