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
Overview of the Microsoft Power Platform
- Introduction to Power BI, Power Apps, Power Automate, and Power Virtual Agents
- How Microsoft 365 integrates with the Power Platform
- The strategic business benefits of adopting low-code development models
Foundations of Power BI
- Setup and configuration of Power BI Desktop
- Establishing connections to diverse data sources such as Excel, databases, and cloud services
- Applying data cleaning and transformation techniques with Power Query
Building Data Models and Relationships in Power BI
- Grasping the concepts of data modeling and entity relationships
- Utilizing DAX (Data Analysis Expressions) for advanced calculations
- Constructing hierarchical structures and defining key measures
Advanced Data Visualization and Dashboard Design
- Crafting intuitive and interactive dashboard experiences
- Leveraging visual components like charts, maps, slicers, and tables
- Implementing filters, drill-through navigation, and conditional formatting rules
Getting to Know Power Apps
- Navigating the Power Apps development environment
- Building both canvas and model-driven applications
- Designing user-friendly interfaces and structured layouts
Integrating Power Apps with Data Sources
- Utilizing Dataverse, SharePoint, and Excel as primary data repositories
- Developing functional forms, galleries, and data cards
- Establishing application logic through formulas and triggered actions
Workflow Automation and System Integration
- Coordinating Power Automate with Power Apps and Power BI
- Configuring triggers and automated business processes
- Real-world automation scenarios, including approval chains, notifications, and data updates
Deployment, Collaboration, and Security Governance
- Rolling out dashboards and applications across the organization
- Administering access rights, environments, and data governance policies
- Best practices for the ongoing maintenance and evolution of solutions
Recap and Future Learning Paths
Requirements
- Foundational knowledge of data management and reporting cycles
- Basic proficiency with Microsoft Excel or comparable spreadsheet applications
Target Audience
- Business analysts
- Data specialists
- Managers and strategic decision-makers
- Workflow 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