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 strategies between Microsoft 365 and the Power Platform
- Exploring the business value of low-code development
Getting Started with Power BI
- Installation and configuration of Power BI Desktop
- Establishing connections to various data sources (Excel, databases, cloud services)
- Data cleaning and transformation techniques using Power Query
Data Modeling and Relationships in Power BI
- Understanding data models and defining relationships
- Performing calculations using DAX (Data Analysis Expressions)
- Creating hierarchies and measures
Data Visualization and Dashboard Design
- Designing effective and interactive dashboards
- Leveraging visual elements: charts, maps, slicers, and tables
- Applying filters, drill-through features, and conditional formatting
Introduction to Power Apps
- Navigating the Power Apps environment
- Creating canvas and model-driven applications
- Designing intuitive user interfaces and layouts
Connecting Power Apps with Data Sources
- Utilizing Dataverse, SharePoint, and Excel as data sources
- Building forms, galleries, and data cards
- Implementing logic with formulas and actions
Automation and Integration
- Integrating Power Automate with Power Apps and Power BI
- Configuring triggers and automated workflows
- Real-world automation scenarios: approvals, notifications, and data updates
Publishing, Sharing, and Security
- Publishing dashboards and apps across the organization
- Managing permissions, environments, and data governance
- Best practices for maintaining and updating solutions
Summary and Next Steps
Requirements
- A solid understanding of data handling and reporting processes.
- Basic proficiency with Microsoft Excel or similar spreadsheet tools.
Target Audience
- Business analysts
- Data professionals
- Managers and decision-makers
- Process automation specialists
21 Hours
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