Course Outline
Overview of the Microsoft Power Platform
- Introduction to Power BI, Power Apps, Power Automate, and Power Virtual Agents
- Integration strategies between Microsoft 365 and the Power Platform
- Evaluating the business impact of low-code development
Foundations of Power BI
- Setting up and configuring Power BI Desktop
- Establishing connections to diverse data sources such as Excel, databases, and cloud services
- Cleaning and transforming data with Power Query
Power BI Data Modeling and Relationships
- Comprehending data structures and relationships
- Performing calculations using DAX (Data Analysis Expressions)
- Defining hierarchies and creating measures
Visualization and Dashboard Design
- Crafting effective, interactive dashboards
- Utilizing visual components including charts, maps, slicers, and tables
- Implementing filters, drill-through capabilities, and conditional formatting
Getting Started with Power Apps
- Navigating the Power Apps ecosystem
- Building both canvas and model-driven applications
- Structuring user interfaces and layouts
Power Apps Data Connectivity
- Leveraging Dataverse, SharePoint, and Excel as backend data sources
- Developing forms, galleries, and data cards
- Constructing application logic using formulas and actions
Automation and System Integration
- Incorporating Power Automate with Power Apps and Power BI
- Configuring triggers and setting up automated workflows
- Applying real-world automation scenarios for approvals, notifications, and data updates
Deployment, Sharing, and Security
- Publishing dashboards and applications across the organization
- Administering permissions, environments, and data governance policies
- Adopting best practices for ongoing solution maintenance and updates
Recap and Future Directions
Requirements
- Familiarity with data handling and reporting procedures
- Basic proficiency with Microsoft Excel or comparable spreadsheet software
Target Audience
- Business analysts
- Data professionals
- Managers and key 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 (2)
How to use relationships in Power BIand the differences between columns and measurements
LEUNG Chun Hei - HAESL
Course - Advanced Power BI: Data Modeling, DAX, and Enhanced Analytics
Practical and hands on labs on report developmemt using Power BI The labs were excellent and the trainer offered very good hands on sessions
