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
- Synergy between Microsoft 365 and the Power Platform
- Grasping the business advantages of low-code development
Initial Steps with Power BI
- Setup and configuration of Power BI Desktop
- Linking to diverse data sources (Excel, databases, cloud platforms)
- Refining and transforming data via Power Query
Data Modeling and Relationships in Power BI
- Conceptualizing data models and their relationships
- Implementing DAX (Data Analysis Expressions) for complex calculations
- Building hierarchies and defining measures
Data Visualization and Dashboard Creation
- Crafting effective, interactive dashboards
- Utilizing visual components: charts, maps, slicers, and tables
- Applying filters, drill-through capabilities, and conditional formatting
Introduction to Power Apps
- Navigating the Power Apps environment
- Developing canvas and model-driven applications
- Designing intuitive user interfaces and layouts
Integrating Power Apps with Data Sources
- Leveraging Dataverse, SharePoint, and Excel as data backends
- 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
- Real-world automation scenarios: approvals, notifications, and data updates
Publishing, Collaboration, and Security
- Distributing dashboards and apps across the organization
- Administering permissions, environments, and data governance
- Best practices for maintaining and evolving solutions
Conclusion and Future Pathways
Requirements
- A foundational understanding of data management and reporting workflows
- Basic proficiency with Microsoft Excel or comparable spreadsheet software
Target Audience
- Business analysts
- Data specialists
- Managers and strategic decision-makers
- Process 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
Practical and hands on labs on report developmemt using Power BI The labs were excellent and the trainer offered very good hands on sessions