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
- Overview of Power BI, Power Apps, Power Automate, and Power Virtual Agents.
- Integration between Microsoft 365 and the Power Platform.
- Understanding the business advantages of low-code development.
Getting Started with Power BI
- Installing and setting up Power BI Desktop.
- Linking to diverse data sources, including Excel, databases, and cloud services.
- Cleaning and transforming data using Power Query.
Data Modeling and Relationships in Power BI
- Grasping the concept of data models and their relationships.
- Applying DAX (Data Analysis Expressions) for calculations.
- Establishing hierarchies and creating measures.
Data Visualization and Dashboards
- Designing impactful and interactive dashboards.
- Utilizing visual components such as charts, maps, slicers, and tables.
- Implementing filters, drill-through functionality, and conditional formatting.
Introduction to Power Apps
- Exploring the Power Apps development environment.
- Building canvas-based and model-driven applications.
- Crafting user interfaces and layouts.
Connecting Power Apps with Data Sources
- Leveraging Dataverse, SharePoint, and Excel as data backends.
- Developing forms, galleries, and data cards.
- Constructing logic using formulas and actions.
Automation and Integration
- Integrating Power Automate with Power Apps and Power BI.
- Configuring triggers and setting up automated workflows.
- Examining real-world automation scenarios, such as approvals, notifications, and data updates.
Publishing, Sharing, and Security
- Deploying dashboards and applications across the organization.
- Administering permissions, environments, and data governance.
- Following best practices for the ongoing maintenance and updating of solutions.
Conclusion and Next Steps
Requirements
- Familiarity with 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.
- Workflow automation experts.
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
