Get in Touch

Course Outline

Introduction to the Microsoft Power Platform

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

Getting Started with Power BI

  • Installation and configuration of Power BI Desktop
  • Establishing connections to various data sources (Excel, databases, cloud services)
  • Data cleaning and transformation techniques using Power Query

Data Modeling and Relationships in Power BI

  • Understanding data models and defining relationships
  • Performing calculations using DAX (Data Analysis Expressions)
  • Creating hierarchies and measures

Data Visualization and Dashboard Design

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

Introduction to Power Apps

  • Navigating the Power Apps environment
  • Creating canvas and model-driven applications
  • Designing intuitive user interfaces and layouts

Connecting Power Apps with Data Sources

  • Utilizing Dataverse, SharePoint, and Excel as data sources
  • Building forms, galleries, and data cards
  • Implementing logic with formulas and actions

Automation and Integration

  • Integrating Power Automate with Power Apps and Power BI
  • Configuring triggers and automated workflows
  • Real-world automation scenarios: approvals, notifications, and data updates

Publishing, Sharing, and Security

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

Summary and Next Steps

Requirements

  • A solid understanding of data handling and reporting processes.
  • Basic proficiency 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