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.
Duration 21 hours
Course Outline
Introduction to the Microsoft Power Platform
- An overview of Power BI, Power Apps, Power Automate, and Power Virtual Agents
- Exploring the synergy between Microsoft 365 and the Power Platform
- Recognizing the business impact of low-code development strategies
Initiating Work with Power BI
- Setting up and configuring Power BI Desktop
- Establishing connections to diverse data sources such as Excel, databases, and cloud services
- Performing data cleansing and transformation via Power Query
Data Modeling and Relationships in Power BI
- Grasping the concepts of data models and their relationships
- Applying DAX (Data Analysis Expressions) to perform calculations
- Constructing hierarchies and defining measures
Visualizing Data and Building Dashboards
- Designing dashboards that are both effective and interactive
- Utilizing various visual components including charts, maps, slicers, and tables
- Implementing filters, drill-through capabilities, and conditional formatting
Introduction to Power Apps
- Navigating the Power Apps development environment
- Developing both canvas and model-driven applications
- Crafting intuitive user interfaces and layouts
Integrating Power Apps with Data Sources
- Leveraging Dataverse, SharePoint, and Excel as foundational data sources
- Building forms, galleries, and data cards
- Implementing logic through formulas and actions
Automation and System Integration
- Utilizing Power Automate in conjunction with Power Apps and Power BI
- Configuring triggers and establishing automated workflows
- Real-world automation scenarios: handling approvals, sending notifications, and updating records
Publishing, Sharing, and Security Protocols
- Deploying dashboards and apps across the organization
- Administering permissions, environments, and data governance standards
- Adopting best practices for the maintenance and evolution of solutions
Summary and Path Forward
Requirements
- A foundational grasp of data management and reporting procedures
- Familiarity with Microsoft Excel or comparable spreadsheet applications
Target Audience
- Business analysts
- Data specialists
- Managers and key decision-makers
- Process automation experts
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