Get in Touch
 Duration 21 hours

Course Outline

Introduction to the Microsoft Power Platform

  • Overview of Power BI, Power Apps, and Power Automate
  • How the Power Platform unifies data, logic, and insights
  • Key advantages of adopting low-code business solutions

Getting Started with Power BI

  • Setup and configuration of Power BI Desktop
  • Establishing connections to Excel, databases, and web-based data sources
  • Data preparation and transformation using Power Query
  • Construction and publication of interactive dashboards

Introduction to Power Apps

  • Navigating the Power Apps development environment
  • Generating canvas applications from existing data sources
  • Structuring app layouts and form designs
  • Incorporating logic and interactivity via Power Fx formulas

Linking Power Apps with Data Sources

  • Utilizing Dataverse, SharePoint, and Excel as backend infrastructure
  • Implementing forms, galleries, and user controls
  • Executing Create, Read, Update, and Delete (CRUD) operations within the application

Introduction to Power Automate

  • Distinguishing between flow types: 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 standard business scenarios

Integrating Power Apps, Power Automate, and Power BI

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

Security, Governance, and Solution Sharing

  • Administration of user permissions and data access controls
  • Implementation of environment and role-based governance strategies
  • Deployment and distribution of Power Platform solutions

Capstone Project: Constructing an Integrated Business Solution

  • Designing a streamlined business process workflow
  • Developing a Power App for data entry and validation
  • Automating notification and approval cycles using Power Automate
  • Creating a Power BI dashboard for real-time performance reporting

Recap and Future Directions

Requirements

  • Foundational knowledge of basic data management and reporting methodologies
  • Basic proficiency with Microsoft Excel or other Microsoft Office applications

Target Audience

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

Number of participants


Price per participant

Testimonials (3)

Upcoming Courses

Related Categories