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
Overview of the Microsoft Power Platform
- Introduction to Power BI, Power Apps, Power Automate, and Power Virtual Agents
- Integration capabilities between Microsoft 365 and the Power Platform
- Exploring the business impact of low-code development
Initiating Work with Power BI
- Setup and configuration of Power BI Desktop
- Establishing connections to diverse data sources (Excel, databases, cloud services)
- Data cleaning and transformation techniques using Power Query
Data Modeling and Relationships in Power BI
- Conceptualizing data models and entity relationships
- Leveraging DAX (Data Analysis Expressions) for computational tasks
- Constructing hierarchies and defining measures
Visualizing Data and Building Dashboards
- Crafting effective, interactive dashboard experiences
- Utilizing visual components: charts, maps, slicers, and tables
- Implementing filters, drill-through capabilities, and conditional formatting
Introduction to Power Apps
- Navigating the Power Apps environment
- Developing canvas and model-driven applications
- Designing intuitive user interfaces and layouts
Linking Power Apps to Data Sources
- Leveraging Dataverse, SharePoint, and Excel as underlying data sources
- Constructing forms, galleries, and data cards
- Implementing business logic through formulas and actions
Automation and System Integration
- Orchestrating workflows using Power Automate alongside Power Apps and Power BI
- Configuring triggers and automated workflow processes
- Applying real-world automation scenarios: approvals, notifications, and data updates
Deployment, Collaboration, and Security
- Publishing dashboards and applications for organizational use
- Administering permissions, environments, and data governance standards
- Best practices for ongoing maintenance and solution updates
Recap and Future Directions
Requirements
- Familiarity with data handling and reporting processes
- Basic knowledge of Microsoft Excel or comparable spreadsheet applications
Target Audience
- Business analysts
- Data professionals
- Managers and key 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