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 between Microsoft 365 and the Power Platform.
  • Understanding the business value of low-code development.

Getting Started with Power BI

  • Installation and configuration of Power BI Desktop.
  • Connecting to diverse data sources (Excel, databases, cloud services).
  • Data cleaning and transformation using Power Query.

Data Modelling and Relationships in Power BI

  • Understanding data models and relationships.
  • Utilising DAX (Data Analysis Expressions) for calculations.
  • Creating hierarchies and measures.

Data Visualisation and Dashboards

  • Designing effective and interactive dashboards.
  • Employing visual elements: charts, maps, slicers, and tables.
  • Applying filters, drill-through, and conditional formatting.

Introduction to Power Apps

  • Understanding the Power Apps environment.
  • Creating canvas and model-driven apps.
  • Designing user interfaces and layouts.

Connecting Power Apps with Data Sources

  • Using Dataverse, SharePoint, and Excel as data sources.
  • Creating forms, galleries, and data cards.
  • Building logic with formulas and actions.

Automation and Integration

  • Utilising Power Automate alongside Power Apps and Power BI.
  • Setting up triggers and automated workflows.
  • Real-world automation examples: approvals, notifications, and updates.

Publishing, Sharing, and Security

  • Publishing dashboards and apps within the organisation.
  • Managing permissions, environments, and data governance.
  • Best practices for maintaining and updating solutions.

Summary and Next Steps

Requirements

  • A foundational understanding of data handling and reporting processes.
  • Basic familiarity with Microsoft Excel or comparable spreadsheet tools.

Audience

  • Business analysts.
  • Data professionals.
  • Managers and decision-makers.
  • Process automation specialists.

Number of participants


Price per participant

Testimonials (2)

Upcoming Courses

Related Categories