Course Outline

Introduction to Microsoft Power Platform

  • Overview of Power BI, Power Apps, Power Automate, and Power Virtual Agents
  • Integration between Microsoft 365 and Power Platform
  • Understanding the business value of low-code development

Getting Started with Power BI

  • Installing and configuring Power BI Desktop
  • Connecting to various 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
  • Using 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

  • 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

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

Audience

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

Testimonials (5)

Upcoming Courses

Related Categories