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

This instructor-led, live training in New Zealand (online or on-site) is aimed at business analysts, data analysts, and developers who wish to leverage 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 its essential components.
• Understand and explore the advanced features, components, and tools available in Power BI.
• Gain valuable insights into advanced data analysis and strategic planning.
• Apply advanced data modelling techniques.
• Learn how to implement advanced formulas and calculations using DAX.
• Discover tips and tricks for effective data handling, visualisation, and presentation.
• Create interactive reports and dashboards to enable collaboration within Power BI.
• Learn about and explore embedded analytics capabilities in Power BI.

This instructor-led, live training in New Zealand (online or on-site) is designed for beginner-level professionals who wish to clean and analyse data, make statistical projections, and create insightful visualisations using these tools.

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

• Understand the basics of Python, R, Power Query, and Power BI for data analysis.
• Clean and organise datasets using Python and Power Query.
• Perform statistical analysis and projections with R.
• Create professional dashboards and reports with Power BI.
• Integrate and analyse data from multiple sources effectively.

This instructor-led, live training in New Zealand (online or on-site) is designed for data analysts who wish to learn techniques for preparing data in Excel and then visualising it in Power BI.

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

• Understand the principles, objectives, and approaches of data analysis.
• Use DAX formulas in Power BI for complex calculations.
• Create and utilise visualisations and charts for specific analysis scenarios.
• Import data using Power View to transition from Excel-based Power BI to a standalone Power BI environment.

This instructor-led, live training in New Zealand (online or on-site) is designed for business analysts who wish to automate workflows and tasks using Microsoft Flow/Power Automate.

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

• Create business applications without requiring any prior developer experience.
• Manage and analyse flows to support business solutions.
• Build flows, define triggers, add actions, and set conditions.

This instructor-led, live training in New Zealand (online or on-site) is designed for business staff, managers, developers, and data analysts who wish to adapt, implement, integrate, and manage Microsoft Power Platform components and features within their organisation.

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 minimise 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 principles of Power Virtual Agents, Power Automate, and Power Apps, with a high-level introduction to Power BI. The curriculum is structured around a real-world process I previously managed manually for a former employer. We will develop a Power App using Microsoft Power Apps to track construction tasks for new homes, storing the data on SharePoint for ease of use. We will then implement Power Virtual Agents to guide users on enabling bots within Microsoft Teams, directing them to documents scattered across various SharePoint sites, such as loan paperwork, budgets, and sales contracts. I see significant potential for these bots within HR and IT teams, particularly for handling repetitive inquiries. Next, I will demonstrate how to configure simple flows in Power Automate to automatically save attachments from specific senders (in our example, saving inspection reports organised by the bank) and create other straightforward flows to capture data from Microsoft Forms into SharePoint. We will also build fully automated processes using the Approvals app within Microsoft Teams. Once the app, bot, and flow are complete, the final step involves creating a simple Power BI report. We will use Power Automate to send a snapshot of the latest completed tasks to a specific recipient (the bank in this scenario) every two weeks. This snapshot will include the completion dates and budget amounts for the tasks, all of which are collected within the app, to support drawdown requests. Finally, as this course is designed at a high level, I recommend that learners leverage ChatGPT for more technical aspects, such as the coding elements or formulas in Power Apps. This is covered during the course, where I demonstrate how to effectively utilise ChatGPT to assist with Power Apps formulas.

This instructor-led, live training in New Zealand guides beginner to intermediate users in mastering the Microsoft Power Platform. Participants will create custom apps, automate workflows, and apply governance best practices using Power Apps and Power Automate in a hands-on lab environment.

This instructor-led, live training in New Zealand (online or on-site) 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 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.