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
- The strategic business impact of low-code development
Initial Setup with Power BI
- Setup and configuration of Power BI Desktop
- Establishing connections to diverse data sources (Excel, databases, cloud services)
- Data refinement and modification via Power Query
Data Modeling and Interconnections in Power BI
- Grasping data structures and entity relationships
- Implementing DAX (Data Analysis Expressions) for complex calculations
- Formulating hierarchies and defining measures
Visualizing Data and Building Dashboards
- Crafting compelling and interactive dashboard layouts
- Leveraging visual components: charts, maps, slicers, and tables
- Utilizing filters, drill-through capabilities, and conditional formatting
Fundamentals of Power Apps
- Navigating the Power Apps workspace
- Developing both canvas-based and model-driven applications
- Structuring user interfaces and layout designs
Integrating Power Apps with Data Sources
- Leveraging Dataverse, SharePoint, and Excel as underlying data repositories
- Constructing forms, galleries, and data card elements
- Implementing logic through formulas and actions
Automation and System Integration
- Collaborating Power Automate with Power Apps and Power BI
- Configuring triggers and automated process flows
- Practical automation scenarios: approval chains, notifications, and data synchronization
Deployment, Collaboration, and Security
- Distributing dashboards and apps across the organization
- Overseeing permissions, environments, and data governance policies
- Industry best practices for solution maintenance and updates
Recap and Future Directions
Requirements
- Foundational knowledge of data management and reporting procedures
- Basic proficiency with Microsoft Excel or comparable spreadsheet applications
Target Audience
- Business analysts
- Data specialists
- Senior 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
The basic structure of Power BI, its main functions, as well as some advanced functions