Get in Touch
 Duration 21 hours

Course Outline

Overview of the Microsoft Power Platform

  • Introduction to Power BI, Power Apps, and Power Automate
  • The mechanism by which Power Platform unifies data, logic, and insights
  • Primary advantages of adopting low-code business solutions

Initial Steps with Power BI

  • Setting up and configuring Power BI Desktop
  • Establishing connections to Excel, databases, and online data sources
  • Data cleansing and transformation utilizing Power Query
  • Construction and publication of interactive dashboards

Introduction to Power Apps

  • Exploring the Power Apps development environment
  • Generating canvas apps based on existing data sources
  • Structuring app layouts and forms
  • Incorporating logic and interactivity through Power Fx formulas

Linking Power Apps to Data Sources

  • Utilizing Dataverse, SharePoint, and Excel as backend systems
  • Managing forms, galleries, and various controls
  • Executing CRUD operations within the application

Introduction to Power Automate

  • Differentiating flow types: automated, instant, and scheduled
  • Creation and testing of automation workflows
  • Integrating Power Automate with Power Apps and Power BI
  • Leveraging templates and connectors for standard business scenarios

Unifying Power Apps, Power Automate, and Power BI

  • Facilitating data exchange between apps and workflows
  • Initiating automation via Power Apps events
  • Embedding Power BI dashboards within Power Apps
  • Orchestrating end-to-end processes across all three tools

Security, Governance, and Solution Sharing

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

Capstone Project: Developing a Unified Business Solution

  • Designing a streamlined business process workflow
  • Building a Power App for data entry and validation
  • Automating notifications and approvals via Power Automate
  • Creating a Power BI dashboard for real-time reporting

Recap and Future Directions

Requirements

  • A foundational understanding of basic data management and reporting procedures
  • Basic familiarity with Microsoft Excel or similar Office applications

Target Audience

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

Number of participants


Price per participant

Testimonials (3)

Upcoming Courses

Related Categories