Power Apps, Power Automate, and Power BI — Integrated Business Solutions Training Course

This instructor-led, live training in Kenya (online or onsite) is aimed at business analysts who wish to automate workflows and tasks with Microsoft Flow / Power Automate.

By the end of this training, participants will be able to:

• Create business applications without needing any developer experience.
• Manage and analyze flows for business solutions.
• Create flows, define triggers, add actions, and set conditions.

This instructor-led, live training in Kenya (online or on-site) is aimed at business personnel, managers, developers, and data analysts who wish to adopt, implement, integrate, and oversee Microsoft Power Platform components and features within their organizations.

Upon completion of this training, participants will be capable of:

• Developing simple applications using Power Apps to craft custom solutions for routine business requirements.
• Automating workflow processes with Power Automate (previously known as Microsoft Flow) to reduce manual and repetitive tasks.
• Generating data reports and dashboards using Power BI to derive insightful analytics for the business.
• Constructing chatbots via Power Virtual Agents to automate and address common customer inquiries and issues.

This course provides a foundational understanding of the core components of Power Virtual Agents, Power Automate, and Power Apps, while also offering a high-level overview of Power BI. The curriculum is centered around a practical workflow derived from my experience with a previous employer. We will construct a Power App using Microsoft Power Apps to monitor tasks related to houses under construction (utilizing SharePoint for data storage to keep things straightforward). Subsequently, we will leverage Power Virtual Agents to demonstrate how to configure bots within Microsoft Teams, guiding users to documents that might be dispersed across various SharePoint sites, such as loan agreements, budgets, and sales contracts. I believe these bots have significant potential for HR and IT teams, particularly in addressing repetitive inquiries. Next, we will configure basic flows in Power Automate to archive attachments from designated senders (in our scenario, saving inspection reports organized by the bank for the units). We will also explore other straightforward flows that capture data from Microsoft Forms back into SharePoint and establish fully automated processes using the Approvals app in Microsoft Teams. Once the application, bot, and flow are finalized, the concluding phase involves creating a simple Power BI report. We will use Power Automate to dispatch a snapshot of the table containing the most recent completed tasks every two weeks to a specific recipient (the bank in this example). This request will include the draw date and the budget allocations for those tasks, all of which are captured within the app. Given that this course operates at a high level, I recommend that all learners employ ChatGPT for more technical aspects, such as coding elements or formulas within Power Apps. However, the course does cover this topic, where I demonstrate how to effectively utilize ChatGPT to assist with Power Apps formulas.

This instructor-led, live training in Kenya empowers beginner to intermediate users to master the Microsoft Power Platform. Participants will engage in building custom apps, automating workflows, and applying governance best practices using Power Apps and Power Automate within a hands-on lab setting.

Candidates undertaking this course focus on automating time-intensive and repetitive tasks through the use of Microsoft Power Automate. They assess solution requirements, generate process documentation, and design, develop, troubleshoot, and evaluate solutions. Candidates collaborate with business stakeholders to enhance and automate business workflows. They also partner with administrators to deploy solutions into production environments and provide ongoing support for these solutions.

The Solution Architect holds responsibility for the effective design, implementation, deployment, and adoption of the entire solution. This role ensures that the proposed solution addresses the customer's requirements both currently and in the future. Through this course, participants will explore the critical decisions made by Solution Architects during implementation, including aspects such as security, integrations, Power Apps architecture, Power Automate architecture, and more. Designed to provide an introduction to the Solution Architect role, this course equips learners with essential knowledge.

This instructor-led, live training in Kenya (online or onsite) targets intermediate-level IT professionals who wish to use the Power Platform to effectively automate processes and enhance data insights.

Upon completion of this training, participants will be able to:

• Develop and customize applications using Power Apps.
• Manage and analyze data utilizing DataVerse and Power BI.
• Automate complex processes with Power Automate.
• Design and deploy intelligent chatbots using Power Virtual Agents.
• Integrate and optimize workflows across the Power Platform suite.