Get in Touch

Course Outline

Introduction to Microsoft Power Platform

  • Overview of Power BI, Power Apps, and Power Automate.
  • How the Power Platform connects data, logic, and insights.
  • Key benefits of low-code business solutions.

Getting Started with Power BI

  • Installing and configuring Power BI Desktop.
  • Connecting to Excel, databases, and online data sources.
  • Data cleaning and transformation using Power Query.
  • Building and publishing interactive dashboards.

Introduction to Power Apps

  • Understanding the Power Apps environment.
  • Creating canvas apps from existing data sources.
  • Designing app layouts and forms.
  • Adding logic and interactivity with Power Fx formulas.

Connecting Power Apps with Data Sources

  • Utilizing Dataverse, SharePoint, and Excel as back-end systems.
  • Working with forms, galleries, and controls.
  • Implementing CRUD operations within the app.

Introduction to Power Automate

  • Understanding flow types: automated, instant, and scheduled.
  • Creating and testing automation workflows.
  • Connecting Power Automate with Power Apps and Power BI.
  • Using templates and connectors for common business scenarios.

Integrating Power Apps, Power Automate, and Power BI

  • Passing data between apps and workflows.
  • Triggering automation from Power Apps events.
  • Embedding Power BI dashboards into Power Apps.
  • Coordinating end-to-end processes across all three tools.

Security, Governance, and Sharing Solutions

  • Managing permissions and data access.
  • Environment and role-based governance.
  • Deploying and sharing Power Platform solutions.

Capstone Project: Building an Integrated Business Solution

  • Designing a simple business process workflow.
  • Building a Power App for data input and validation.
  • Automating notifications and approvals with Power Automate.
  • Creating a Power BI dashboard for real-time reporting.

Summary and Next Steps

Requirements

  • A foundational understanding of basic data handling and reporting processes.
  • Basic familiarity with Microsoft Excel or other Office applications.

Target Audience

  • Business analysts.
  • Data and process automation specialists.
  • Managers and decision-makers.
  • IT professionals supporting business operations.
 21 Hours

Number of participants


Price per participant

Testimonials (2)

Upcoming Courses

Related Categories