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
- An overview of Power BI, Power Apps, Power Automate, and Power Virtual Agents.
- The synergy between Microsoft 365 and the Power Platform.
- Exploring the business advantages of low-code development.
Getting Started with Power BI
- Setting up and configuring Power BI Desktop.
- Linking to diverse data sources, including Excel, databases, and cloud services.
- Cleaning and transforming data via Power Query.
Data Modelling and Relationships in Power BI
- Gaining a deeper understanding of data models and their relationships.
- Applying DAX (Data Analysis Expressions) for complex calculations.
- Establishing hierarchies and defining measures.
Data Visualisation and Dashboards
- Crafting effective and engaging interactive dashboards.
- Leveraging visual components such as charts, maps, slicers, and tables.
- Implementing filters, drill-through features, and conditional formatting.
Introduction to Power Apps
- Navigating the Power Apps development environment.
- Building both canvas-based and model-driven applications.
- Structuring user interfaces and layouts.
Connecting Power Apps with Data Sources
- Utilising Dataverse, SharePoint, and Excel as underlying data sources.
- Developing forms, galleries, and data cards.
- Incorporating logic through formulas and actions.
Automation and Integration
- Integrating Power Automate with Power Apps and Power BI.
- Configuring triggers and setting up automated workflows.
- Exploring real-world automation scenarios, such as approvals, notifications, and status updates.
Publishing, Sharing, and Security
- Distributing dashboards and applications across the organisation.
- Overseeing permissions, environments, and data governance.
- Adopting best practices for the ongoing maintenance and updating of solutions.
Summary and Next Steps
Requirements
- A solid grasp of data handling and reporting procedures.
- Foundational knowledge of Microsoft Excel or comparable spreadsheet software.
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
Practical and hands on labs on report developmemt using Power BI The labs were excellent and the trainer offered very good hands on sessions
