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
Overview of the Microsoft Power Platform
- Introduction to Power BI, Power Apps, Power Automate, and Power Virtual Agents
- Integrating Microsoft 365 with the Power Platform
- Evaluating the business benefits of low-code development
Initiating with Power BI
- Setup and configuration of Power BI Desktop
- Linking to diverse data sources such as Excel, databases, and cloud services
- Refining and transforming data via Power Query
Data Modeling and Linkages in Power BI
- Grasping data models and their relationships
- Employing DAX (Data Analysis Expressions) for complex calculations
- Establishing hierarchies and defining measures
Visualizing Data and Creating Dashboards
- Constructing efficient and interactive dashboards
- Leveraging visual components like charts, maps, slicers, and tables
- Implementing filters, drill-through features, and conditional formatting
Introduction to Power Apps
- Exploring the Power Apps environment
- Building both canvas and model-driven applications
- Designing user interfaces and layouts
Linking Power Apps to Data Sources
- Utilizing Dataverse, SharePoint, and Excel as data repositories
- 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: handling approvals, notifications, and data updates
Deployment, Distribution, and Security
- Releasing dashboards and apps within the organization
- Administering permissions, environments, and data governance
- Best practices for the ongoing maintenance and updates of solutions
Recap and Future Directions
Requirements
- Familiarity with data management and reporting procedures.
- Basic knowledge of Microsoft Excel or comparable spreadsheet software.
Intended Audience
- Business analysts.
- Data specialists.
- Managers and strategic decision-makers.
- Workflow 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