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.
- The integration capabilities between Microsoft 365 and the Power Platform.
- The business advantages of adopting low-code development strategies.
Initiating Your Journey with Power BI
- Setup and configuration of Power BI Desktop.
- Establishing connections to diverse data sources, including Excel, databases, and cloud services.
- Data cleansing and transformation processes utilizing Power Query.
Data Modeling and Relationships in Power BI
- Comprehending data models and their inherent relationships.
- Employing DAX (Data Analysis Expressions) for advanced calculations.
- Constructing hierarchies and defining measures.
Data Visualization and Dashboard Creation
- Designing highly effective and interactive dashboards.
- Utilizing various visual elements such as charts, maps, slicers, and tables.
- Implementing filters, drill-through features, and conditional formatting.
Introduction to Power Apps
- Navigating the Power Apps development environment.
- Building both canvas apps and model-driven apps.
- Crafting intuitive user interfaces and layouts.
Integrating Power Apps with Data Sources
- Leveraging Dataverse, SharePoint, and Excel as primary data sources.
- Developing forms, galleries, and data cards.
- Constructing application logic through formulas and actions.
Automation and System Integration
- Synergizing Power Automate with Power Apps and Power BI.
- Configuring triggers and establishing automated workflows.
- Practical automation examples, including approval processes, notifications, and data updates.
Publishing, Collaboration, and Security
- Deploying dashboards and applications across the organization.
- Overseeing permissions, environments, and data governance standards.
- Best practices for the maintenance and continuous improvement of solutions.
Course Summary and Future Pathways
Requirements
- Foundational understanding of data management and reporting procedures.
- Basic proficiency 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
