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
Overview of the Microsoft Power Platform
- Introduction to Power BI, Power Apps, Power Automate, and Power Virtual Agents
- Exploring integration points between Microsoft 365 and the Power Platform
- Understanding the strategic business value of low-code development
Foundations of Power BI
- Setting up and configuring Power BI Desktop
- Connecting to diverse data sources such as Excel, databases, and cloud services
- Cleaning and transforming data with Power Query
Data Modeling and Relationships in Power BI
- Grasping data models and entity relationships
- Utilizing DAX (Data Analysis Expressions) for complex calculations
- Constructing hierarchies and defining measures
Visualizing Data and Building Dashboards
- Designing impactful and interactive dashboards
- Leveraging visual components like charts, maps, slicers, and tables
- Implementing filters, drill-through navigation, and conditional formatting
Introduction to Power Apps
- Navigating the Power Apps development environment
- Building both canvas and model-driven applications
- Crafting user-friendly interfaces and layouts
Integrating Power Apps with Data Sources
- Utilizing Dataverse, SharePoint, and Excel as underlying data sources
- Developing forms, galleries, and data cards
- Implementing logic through formulas and actions
Automation and System Integration
- Combining Power Automate with Power Apps and Power BI
- Configuring triggers and automated workflows
- Real-world automation scenarios: handling approvals, sending notifications, and managing updates
Deployment, Sharing, and Security
- Publishing dashboards and apps for organizational use
- Managing permissions, environments, and data governance standards
- Adopting best practices for solution maintenance and updates
Summary and Future Directions
Requirements
- A solid grasp of data management and reporting processes
- Basic proficiency with Microsoft Excel or comparable spreadsheet tools
Target Audience
- Business analysts
- Data professionals
- Managers and key 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