Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Introduction to the Microsoft Power Platform
- Overview of Power BI, Power Apps, Power Automate, and Power Virtual Agents
- Integration between Microsoft 365 and the Power Platform
- Understanding the business value of low-code development
Getting Started with Power BI
- Installing and configuring Power BI Desktop
- Connecting to diverse data sources (Excel, databases, cloud services)
- Data cleaning and transformation using Power Query
Data Modeling and Relationships in Power BI
- Understanding data models and relationships
- Utilizing DAX (Data Analysis Expressions) for calculations
- Creating hierarchies and measures
Data Visualization and Dashboards
- Designing effective and interactive dashboards
- Using visual elements: charts, maps, slicers, and tables
- Applying filters, drill-through capabilities, and conditional formatting
Introduction to Power Apps
- Understanding the Power Apps environment
- Creating canvas and model-driven apps
- Designing user interfaces and layouts
Connecting Power Apps with Data Sources
- Using Dataverse, SharePoint, and Excel as data sources
- Creating forms, galleries, and data cards
- Building logic with formulas and actions
Automation and Integration
- Using Power Automate with Power Apps and Power BI
- Setting triggers and automated workflows
- Real-world automation examples: approvals, notifications, and updates
Publishing, Sharing, and Security
- Publishing dashboards and apps within the organization
- Managing permissions, environments, and data governance
- 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
Target Audience
- Business analysts
- Data professionals
- Managers and decision-makers
- Process automation specialists
21 Hours
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
The coding and analysis, how the information come together in a report which will be useful for my work