Get in Touch
 Duration 21 hours

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

Number of participants


Price per participant

Testimonials (2)

Upcoming Courses

Related Categories