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.
- Exploring the integration capabilities between Microsoft 365 and the Power Platform.
- Evaluating the strategic business value of adopting low-code development.
Getting Started with Power BI
- Installation and configuration of Power BI Desktop.
- Connecting to diverse data sources including Excel, databases, and cloud services.
- Executing data cleaning and transformation tasks using Power Query.
Data Modeling and Relationships in Power BI
- Analyzing data structures, models, and inter-table relationships.
- Utilizing DAX (Data Analysis Expressions) for complex calculations.
- Constructing hierarchies and defining measures.
Data Visualization and Dashboard Design
- Designing intuitive, interactive dashboards.
- Leveraging visual elements such as charts, maps, slicers, and tables.
- Implementing filters, drill-through features, and conditional formatting rules.
Introduction to Power Apps
- Navigating the Power Apps development environment.
- Building both canvas and model-driven applications.
- Designing user-friendly interfaces and optimized layouts.
Integrating Power Apps with Data Sources
- Utilizing Dataverse, SharePoint, and Excel as backend data sources.
- Constructing forms, galleries, and data cards for user interaction.
- Implementing business logic through formulas and actions.
Automation and System Integration
- Orchestrating Power Automate workflows with Power Apps and Power BI.
- Configuring triggers and setting up automated task sequences.
- Real-world automation scenarios: managing approvals, notifications, and system updates.
Publishing, Sharing, and Security Governance
- Deploying dashboards and applications across the organization.
- Managing user permissions, environments, and data governance policies.
- Best practices for ongoing solution maintenance and iterative updates.
Summary and Strategic Next Steps
Requirements
- A foundational understanding of data management and reporting lifecycle processes.
- Basic proficiency with Microsoft Excel or comparable spreadsheet applications.
Target Audience
- Business analysts.
- Data specialists and analysts.
- Managers and strategic decision-makers.
- Process automation experts.
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
Practical and hands on labs on report developmemt using Power BI The labs were excellent and the trainer offered very good hands on sessions
