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 Microsoft Power Platform
- Overview of Power BI, Power Apps, Power Automate, and Power Virtual Agents.
- Integration between Microsoft 365 and the Power Platform.
- Grasping the business value of low-code development.
Getting Started with Power BI
- Installing and configuring Power BI Desktop.
- Connecting to diverse data sources including Excel, databases, and cloud services.
- Cleaning and transforming data using Power Query.
Data Modeling and Relationships in Power BI
- Understanding data models and their relationships.
- Utilizing DAX (Data Analysis Expressions) for complex calculations.
- Creating hierarchies and measures.
Data Visualization and Dashboards
- Designing effective and interactive dashboards.
- Utilizing visual elements such as charts, maps, slicers, and tables.
- Implementing filters, drill-through functionality, and conditional formatting.
Introduction to Power Apps
- Navigating the Power Apps environment.
- Building both canvas and model-driven applications.
- Designing user interfaces and layouts.
Connecting Power Apps with Data Sources
- Leveraging Dataverse, SharePoint, and Excel as data sources.
- Constructing forms, galleries, and data cards.
- Developing logic using formulas and actions.
Automation and Integration
- Integrating Power Automate with Power Apps and Power BI.
- Configuring triggers and automated workflows.
- Exploring real-world automation examples such as approvals, notifications, and updates.
Publishing, Sharing, and Security
- Publishing dashboards and apps within the organization.
- Managing permissions, environments, and data governance.
- Best practices for the maintenance and updating of solutions.
Summary and Next Steps
Requirements
- A foundational understanding of data management and reporting processes.
- Basic proficiency with Microsoft Excel or comparable spreadsheet applications.
Audience
- Business analysts.
- Data professionals.
- Managers and strategic 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
