Course Outline
Introduction to the Microsoft Power Platform
- Overview of Power BI, Power Apps, Power Automate, and Power Virtual Agents
- Integration capabilities between Microsoft 365 and the Power Platform
- Exploring the business advantages of low-code development
Initial Setup and Configuration of Power BI
- Installation and configuration of Power BI Desktop
- Establishing connections to diverse data sources (Excel, databases, cloud services)
- Performing data cleansing and transformation via Power Query
Data Modelling and Relationships in Power BI
- Grasping the concepts of data models and relationships
- Applying DAX (Data Analysis Expressions) for complex calculations
- Structuring hierarchies and defining measures
Visualising Data through Dashboards
- Designing clear and interactive dashboard layouts
- Utilising visual components such as charts, maps, slicers, and tables
- Implementing filters, drill-through features, and conditional formatting
Getting Started with Power Apps
- Navigating the Power Apps environment
- Building canvas apps and model-driven apps
- Crafting user interfaces and layout structures
Integrating Power Apps with Data Sources
- Leveraging Dataverse, SharePoint, and Excel as backend data sources
- Constructing 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
- Practical automation scenarios: handling approvals, notifications, and updates
Deployment, Sharing, and Security Protocols
- Releasing dashboards and applications within the organisation
- Administering permissions, environments, and data governance
- Best practices for solution maintenance and updates
Conclusion and Future Steps
Requirements
- Familiarity with data handling and reporting procedures
- Basic proficiency with Microsoft Excel or comparable spreadsheet applications
Target 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