Course Outline
Introduction to the Microsoft Power Platform
- Overview of Power BI, Power Apps, Power Automate, and Power Virtual Agents.
- Integration capabilities between Microsoft 365 and the Power Platform.
- Understanding the business value inherent in low-code development.
Getting Started with Power BI
- Installation and configuration of Power BI Desktop.
- Connecting to diverse data sources, including Excel, databases, and cloud services.
- Performing data cleaning and transformation using Power Query.
Data Modeling and Relationships in Power BI
- Understanding the concepts of data models and relationships.
- Utilizing DAX (Data Analysis Expressions) for calculations.
- Creating hierarchies and measures.
Data Visualization and Dashboards
- Designing effective and interactive dashboards.
- Leveraging visual elements such as charts, maps, slicers, and tables.
- Applying filters, drill-through functionalities, and conditional formatting.
Introduction to Power Apps
- Familiarizing with the Power Apps environment.
- Creating canvas and model-driven apps.
- Designing user interfaces and layouts.
Connecting Power Apps with Data Sources
- Utilizing Dataverse, SharePoint, and Excel as data sources.
- Creating forms, galleries, and data cards.
- Implementing logic through formulas and actions.
Automation and Integration
- Integrating Power Automate with Power Apps and Power BI.
- Configuring triggers and automated workflows.
- Exploring real-world automation examples, including approvals, notifications, and updates.
Publishing, Sharing, and Security
- Publishing dashboards and apps within the organizational structure.
- Managing permissions, environments, and data governance.
- Adhering to best practices for maintaining and updating solutions.
Summary and Next Steps
Requirements
- A foundational understanding of data handling and reporting processes.
- Basic familiarity with Microsoft Excel or comparable spreadsheet tools.
Audience
- Business analysts
- Data professionals
- Managers and decision-makers
- Process automation specialists
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 (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