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
- Synergy between Microsoft 365 and the Power Platform
- Recognizing the business advantages of low-code development
Initial Setup for Power BI
- Installing and setting up Power BI Desktop
- Establishing connections to diverse data sources (Excel, databases, cloud services)
- Cleansing and transforming data via Power Query
Data Modeling and Relationships in Power BI
- Grasping data models and their relationships
- Applying DAX (Data Analysis Expressions) for calculations
- Constructing hierarchies and measures
Data Visualization and Dashboard Creation
- Designing effective, interactive dashboards
- Utilizing visual components: charts, maps, slicers, and tables
- Implementing filters, drill-through capabilities, and conditional formatting
Getting Started with Power Apps
- Exploring the Power Apps environment
- Building canvas-based and model-driven applications
- Crafting user interfaces and layouts
Linking Power Apps with Data Sources
- Leveraging Dataverse, SharePoint, and Excel as data repositories
- Developing forms, galleries, and data cards
- Constructing logic through formulas and actions
Automation and System Integration
- Integrating Power Automate with Power Apps and Power BI
- Configuring triggers and automated workflows
- Real-world automation case studies: approvals, notifications, and updates
Publishing, Sharing, and Security Protocols
- Distributing dashboards and applications across the organization
- Overseeing permissions, environments, and data governance
- Best practices for maintaining and updating solutions
Wrap-up and Future Directions
Requirements
- A foundational understanding of data management and reporting workflows
- Basic proficiency with Microsoft Excel or comparable spreadsheet software
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
