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
Introduction to the Microsoft Power Platform
- Overview of 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
Foundations of Power BI
- Setup and configuration of Power BI Desktop
- Connecting to diverse data sources (Excel, databases, cloud services)
- Data cleansing and transformation via Power Query
Data Modeling and Relationships in Power BI
- Grasping data models and their relationships
- Utilizing DAX (Data Analysis Expressions) for calculations
- Constructing hierarchies and measures
Data Visualization and Dashboard Creation
- Designing impactful and interactive dashboards
- Leveraging visual elements: charts, maps, slicers, and tables
- Implementing filters, drill-through capabilities, and conditional formatting
Introduction to Power Apps
- Exploring the Power Apps development environment
- Building canvas and model-driven applications
- Crafting user interfaces and layouts
Integrating Power Apps with Data Sources
- Employing Dataverse, SharePoint, and Excel as data backends
- Creating forms, galleries, and data cards
- Developing logic through formulas and actions
Automation and System Integration
- Collaborating Power Automate with Power Apps and Power BI
- Configuring triggers and automated workflows
- Real-world automation scenarios: approvals, notifications, and data updates
Publishing, Sharing, and Security Protocols
- Deploying dashboards and apps within the organization
- Overseeing permissions, environments, and data governance
- Best practices for solution maintenance and updates
Summary and Future Pathways
Requirements
- Familiarity with data handling and reporting procedures
- Basic proficiency with Microsoft Excel or comparable spreadsheet tools
Target Audience
- Business analysts
- Data professionals
- Managers and 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
The basic structure of Power BI, its main functions, as well as some advanced functions