Power BI and Power Apps for Data Visualization and Business Process Automation Training Course

This instructor-led, live training in Botswana (online or onsite) is aimed at business analysts, data analysts, and developers who wish to use the advanced features and tools in Power BI to perform complex data analysis and create interactive visual reports.

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

• Install and configure Power BI and the necessary components.
• Understand and explore the advanced features, components, and tools in Power BI.
• Get valuable insights on advanced data analysis and strategy.
• Apply advanced data modeling techniques.
• Learn how to implement advanced formulas and calculations using DAX.
• Know the tips and tricks on data handling, visualization, and presentation.
• Make reports and dashboards interactive to enable collaboration within Power BI.
• Learn and explore embedded analytics in Power BI.

This instructor-led live training in Botswana empowers intermediate professionals with advanced Power BI capabilities, including complex data modeling, DAX calculations, and interactive visualization techniques to effectively build powerful business intelligence solutions.

This live, instructor-led training conducted in Botswana is tailored for business and key users interested in building basic Copilot agents.

By the conclusion of the session, participants will be able to:

• Grasp the concept of Copilot agents
• Construct an agent using individual knowledge sources
• Integrate simple actions and verify agent performance
• Share the agent with colleagues

This instructor-led, live training in Botswana (online or onsite) is tailored for 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:

• Build business applications without requiring any development background.
• Manage and analyse flows to support business solutions.
• Create flows, define triggers, add actions, and configure conditions.

This instructor-led, live training in Botswana (online or onsite) is aimed at business staff, managers, developers, and data analysts who wish to adapt, implement, integrate, and manage Microsoft Power Platform components and features in their organization.

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

• Build simple applications with Power Apps to create custom solutions for everyday business needs.
• Automate workflow processes using Power Automate (formerly known as Microsoft Flow) to minimize manual and repetitive tasks.
• Create data reports and dashboards with Power BI to generate insightful analytics for the business.
• Build chatbots using Power Virtual Agents to automate and resolve common customer inquiries and issues.

This course provides a foundational understanding of the core components of Power Virtual Agents, Power Automate, and Power Apps, alongside a high-level introduction to Power BI. The curriculum is grounded in a real-world process I previously handled manually for a former employer. We will construct a Power App using Microsoft Power Apps to monitor tasks associated with residential construction projects, storing the data in SharePoint for ease of access. Subsequently, we will employ Power Virtual Agents to demonstrate how users can enable bots within Microsoft Teams. These bots will guide users to locate documents that may be dispersed across various SharePoint sites, such as loan agreements, budgets, and sales contracts. I perceive significant potential for these bots within HR and IT departments, particularly for managing repetitive inquiries. Furthermore, the course illustrates how to configure straightforward flows in Power Automate to archive attachments from specific senders (in this scenario, inspection reports organised by the bank for the units). We will also explore other simple flows that capture data from Microsoft Forms back into SharePoint and establish fully automated processes using the approvals feature within Microsoft Teams. Upon completion of the app, bot, and flow, the final phase involves creating a concise Power BI report. We will leverage Power Automate to dispatch a snapshot of the table containing the most recently completed tasks every two weeks to a designated recipient (the bank in this example). This report will request a disbursement, including the dates the tasks were completed and their corresponding budget amounts (all data collected via the app). Finally, given that this course is quite high-level, I recommend all learners use ChatGPT for more technical aspects, such as coding elements or formulas in Power Apps. However, this is addressed within the course, where I demonstrate how to harness ChatGPT effectively to assist with Power Apps formulas.

This live instructor-led training in Botswana supports users ranging from beginners to intermediates in mastering the Microsoft Power Platform. Participants will construct custom apps, automate workflows, and apply governance best practices using Power Apps and Power Automate within a hands-on lab setting.

Participants in this course automate time-consuming and repetitive tasks by utilizing Microsoft Power Automate. They review solution requirements, create process documentation, and design, develop, troubleshoot, and evaluate solutions. Participants work with business stakeholders to improve and automate business workflows. They collaborate with administrators to deploy solutions to production environments, and they support solutions.

A Solution Architect is tasked with the effective design, implementation, deployment, and adoption of a comprehensive solution. This role ensures that the solution continues to meet the customer’s needs both currently and in the future. During this course, participants will examine the key decisions made by a Solution Architect throughout an implementation phase, including security, integrations, Power Apps architecture, Power Automate architecture, and other critical areas. The course is structured to provide an introduction to the responsibilities of a Solution Architect.

This instructor-led, live training in Botswana (online or on-site) is aimed at intermediate-level IT professionals who wish to use the Power Platform to effectively automate processes and enhance data insights.

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

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