Get in Touch
 Duration 21 hours

Course Outline

Overview of the Microsoft Power Platform

  • Introduction to Power BI, Power Apps, and Power Automate
  • How the Power Platform unifies data, logic, and insights
  • The primary advantages of adopting low-code business solutions

Foundations of Power BI

  • Setting up and configuring Power BI Desktop
  • Establishing connections to Excel, databases, and online data sources
  • Cleaning and transforming data using Power Query
  • Creating and publishing interactive dashboards

Introduction to Power Apps

  • Navigating the Power Apps environment
  • Developing canvas apps from existing data sources
  • Designing app layouts and input forms
  • Adding logic and interactivity through Power Fx formulas

Linking Power Apps to Data Sources

  • Leveraging Dataverse, SharePoint, and Excel as backend systems
  • Utilizing forms, galleries, and UI controls
  • Executing CRUD (Create, Read, Update, Delete) operations within the app

Introduction to Power Automate

  • Understanding flow types: automated, instant, and scheduled
  • Building and testing automation workflows
  • Integrating Power Automate with Power Apps and Power BI
  • Applying templates and connectors for common business scenarios

Unifying Power Apps, Power Automate, and Power BI

  • Facilitating data exchange between apps and workflows
  • Initiating automation triggered by events in Power Apps
  • Embedding Power BI dashboards directly into Power Apps
  • Orchestrating end-to-end processes across all three tools

Security, Governance, and Solution Sharing

  • Administering permissions and data access controls
  • Implementing environment and role-based governance strategies
  • Distributing and sharing Power Platform solutions

Capstone Project: Developing an Integrated Business Solution

  • Designing a straightforward business process workflow
  • Developing a Power App for data entry and validation
  • Automating notifications and approval processes via Power Automate
  • Constructing a Power BI dashboard for real-time reporting

Recap and Future Directions

Requirements

  • A foundational understanding of data handling and reporting procedures
  • Basic proficiency with Microsoft Excel or other Office suite applications

Target Audience

  • Business analysts
  • Specialists in data and process automation
  • Managers and strategic decision-makers
  • IT professionals providing support for business operations

Number of participants


Price per participant

Testimonials (3)

Upcoming Courses

Related Categories