Get in Touch

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

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

Data Modeling and Relationships in Power BI

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

Data Visualization and Dashboards

  • Designing effective and interactive dashboards.
  • Utilizing visual elements: charts, maps, slicers, and tables.
  • Applying filters, drill-through features, 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

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

Publishing, Sharing, and Security

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

Summary and Next Steps

Requirements

  • Understanding of data handling and reporting processes.
  • Basic familiarity with Microsoft Excel or similar spreadsheet tools.

Target Audience

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

Testimonials (2)

Upcoming Courses

Related Categories