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
Introduction to the Microsoft Power Platform
- Overview of Power BI, Power Apps, Power Automate, and Power Virtual Agents.
- Integration between Microsoft 365 and the Power Platform.
- Understanding the business value of low-code development.
Getting Started with Power BI
- Installation and configuration of Power BI Desktop.
- Connecting to diverse data sources (Excel, databases, cloud services).
- Data cleaning and transformation using Power Query.
Data Modelling and Relationships in Power BI
- Understanding data models and relationships.
- Utilising DAX (Data Analysis Expressions) for calculations.
- Creating hierarchies and measures.
Data Visualisation and Dashboards
- Designing effective and interactive dashboards.
- Employing visual elements: charts, maps, slicers, and tables.
- Applying filters, drill-through, and conditional formatting.
Introduction to Power Apps
- Understanding the Power Apps environment.
- Creating canvas and model-driven apps.
- Designing user interfaces and layouts.
Connecting Power Apps with Data Sources
- Using Dataverse, SharePoint, and Excel as data sources.
- Creating forms, galleries, and data cards.
- Building logic with formulas and actions.
Automation and Integration
- Utilising Power Automate alongside Power Apps and Power BI.
- Setting up triggers and automated workflows.
- Real-world automation examples: approvals, notifications, and updates.
Publishing, Sharing, and Security
- Publishing dashboards and apps within the organisation.
- Managing permissions, environments, and data governance.
- Best practices for maintaining and updating solutions.
Summary and Next Steps
Requirements
- A foundational understanding of data handling and reporting processes.
- Basic familiarity with Microsoft Excel or comparable spreadsheet tools.
Audience
- Business analysts.
- Data professionals.
- Managers and decision-makers.
- Process automation specialists.
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