Microsoft Power Platform Training in Ottawa

This instructor-led, live training in Ottawa (online or onsite) is aimed at intermediate-level IT professionals who wish to use Power Platform to effectively automate processes and enhance data insights. By the end of this training, participants will be able to:

• Develop and customize applications using Power Apps.
• Manage and analyze data with 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.

This instructor-led, live training in Ottawa (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 gives a basic understanding of  the fundamentals of Power Virtual Agents, Power Automate & Power Apps as well as touching on Power BI at a very high level. The course is built around a process that I used to manually complete for a previous employer where we will build a Power App using Microsoft Power Apps to track tasks on houses that are being built (store the data on SharePoint for simplicity) and then utilize Power Virtual Agents to show users how to enable the bots (within Microsoft Teams) to point users to the location of documents that may be scattered across different SharePoint sites such as loan documents, budgets and sales contracts (in the course of example). I see a huge use for these bots within HR & IT teams specifically to handle repetitive questions. I then show you can set up simple flows in Power Automate to save down attachments from specific senders (in the course example - saving down the attachments of the inspections the bank has organized of the units) as well as some other simple flows saving data from Microsoft Forms again on SharePoint & building out fully automated processes using the approvals app within Microsoft Teams. Once the app, bot & flow are complete, the final step is then creating a simple Power BI report and utilizing Power Automate to send a snapshot of the table with the latest tasks completed every 2 weeks to a specific sender (the bank in this example) requesting a draw with the date the tasks were completed and the budget amounts of those tasks (all collected in the app). Finally, this course is very high level, and I suggest to all learners to utilize ChatGPT for the more technical stuff such as the coding element/formula in a Power Apps, but this is covered on the course where I demonstrate how to utilize ChatGPT to the best of it's ability to help with the formula in Power Apps.