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

This instructor-led live training in Australia (online or onsite) is tailored for business analysts, data analysts, and developers who wish to utilise the advanced features and tools in Power BI to conduct 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.
• Gain valuable insights on advanced data analysis and strategy.
• Apply advanced data modelling techniques.
• Learn how to implement advanced formulas and calculations using DAX.
• Know the tips and tricks on data handling, visualisation, 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 Australia equips intermediate professionals with advanced Power BI skills, including complex data modeling, DAX calculations, and interactive visualisation techniques to build powerful business intelligence solutions effectively.

This live, instructor-led training in Australia is tailored for business and key users interested in creating simple Copilot agents.

Upon completion, participants will be able to:

• Understand the concept of Copilot agents
• Construct an agent utilising their own knowledge sources
• Add basic actions and test the agent
• Share the agent with team members

This instructor-led, live training in Australia (online or onsite) is tailored for beginner-level professionals looking to clean and analyse data, perform statistical forecasting, and generate insightful visualisations using these tools.

By the conclusion of this training, participants will be capable of:

• Gaining a foundational understanding of Python, R, Power Query, and Power BI for data analysis.
• Cleaning and organising datasets using Python and Power Query.
• Conducting statistical analysis and forecasting with R.
• Developing professional dashboards and reports with Power BI.
• Effectively integrating and analysing data from diverse sources.

This instructor-led, live training session in Australia (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 Australia (online or onsite) is designed for business staff, managers, developers, and data analysts who wish to adapt, implement, integrate, and manage Microsoft Power Platform components and features in 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 overview of Power Virtual Agents, Power Automate, and Power Apps, alongside a high-level introduction to Power BI. The curriculum is centred around a real-world scenario derived from my previous employment, where we manually managed a process that we now automate. We will construct a Power App using Microsoft Power Apps to monitor tasks associated with home construction (utilising SharePoint for data storage due to its simplicity). Subsequently, we will employ Power Virtual Agents to demonstrate how to enable bots within Microsoft Teams, guiding users to documents that may be dispersed across various SharePoint sites, such as loan agreements, budgets, and sales contracts (as illustrated in the course example). I believe there is significant potential for these bots within HR and IT teams, particularly for managing repetitive inquiries. I will also demonstrate how to configure straightforward flows in Power Automate to save attachments from designated senders (in this instance, saving attachments from inspections arranged by the bank for the units). Additionally, we will explore other simple flows that save data from Microsoft Forms back to SharePoint and establish fully automated processes using the Approvals app within Microsoft Teams. Once the app, bot, and flow are established, the final step involves creating a basic 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 report will request a drawdown, including the date the tasks were completed and the corresponding budget amounts (all details collected within the app). As this course covers the material at a high level, I recommend learners leverage ChatGPT for more technical aspects, such as coding or formulas in Power Apps. However, this is addressed within the course, where I demonstrate how to utilise ChatGPT effectively to assist with Power Apps formulas.

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

This instructor-led, live training in Australia (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 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.