Get in Touch

Course Outline

Introduction to the Microsoft Power Platform

  • Overview of Power BI, Power Apps, and Power Automate
  • Key advantages of low-code business solutions

Getting Started with Power BI

  • Installation and configuration of Power BI Desktop
  • Establishing connections to Excel, databases, and online data sources
  • Data cleansing and transformation utilizing Power Query
  • Creation and publication of interactive dashboards

Introduction to Power Apps

  • Exploration of the Power Apps environment
  • Development of canvas apps from existing data sources
  • Design of app layouts and forms
  • Incorporation of logic and interactivity through Power Fx formulas

Linking Power Apps with Data Sources

  • Utilization of Dataverse, SharePoint, and Excel as backend systems
  • Interaction with forms, galleries, and controls
  • Implementation of CRUD operations within the application

Introduction to Power Automate

  • Understanding flow categories: automated, instant, and scheduled
  • Development and testing of automation workflows
  • Integration of Power Automate with Power Apps and Power BI
  • Application of templates and connectors for common business scenarios

Integration of Power Apps, Power Automate, and Power BI

  • Data exchange between applications and workflows
  • Triggering automations based on Power Apps events
  • Embedding Power BI dashboards within Power Apps
  • Coordination of end-to-end processes across all three tools

Security, Governance, and Solution Sharing

  • Management of permissions and data access
  • Environment and role-based governance strategies
  • Deployment and sharing of Power Platform solutions

Capstone Project: Constructing an Integrated Business Solution

  • Design of a simple business process workflow
  • Development of a Power App for data entry and validation
  • Automation of notifications and approvals using Power Automate
  • Creation of a Power BI dashboard for real-time reporting

Recap and Future Directions

Requirements

  • Familiarity with fundamental data management and reporting procedures
  • Basic knowledge of Microsoft Excel or other Office suite applications

Intended Audience

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

Number of participants


Price per participant

Testimonials (3)

Upcoming Courses

Related Categories