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

This instructor-led live training in France (online or onsite) is designed for business analysts, data analysts, and developers who wish to utilize the advanced features and tools of 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 France provides intermediate professionals with advanced Power BI competencies, covering complex data modeling, DAX computations, and interactive visualization techniques to effectively create robust business intelligence solutions.

This instructor-led live training in France is tailored for business and key users aiming to construct simple Copilot agents.

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

• Comprehending the nature of Copilot agents
• Building agents with custom knowledge sources
• Incorporating basic actions and testing the agent
• Sharing the agent with colleagues

This instructor-led, live training in France (online or onsite) is aimed at beginner-level professionals who wish to clean and analyze data, make statistical projections, and create insightful visualizations 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 organize datasets using Python and Power Query.
• Perform statistical analysis and projections with R.
• Create professional dashboards and reports with Power BI.
• Integrate and analyze data from multiple sources effectively.

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

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

• Develop business applications without requiring any prior developer experience.
• Manage and analyze flows to support business solutions.
• Create flows, define triggers, add actions, and configure conditions.

This instructor-led, live training in France (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 overview of Power Virtual Agents, Power Automate, and Power Apps, along with a high-level introduction to Power BI. The curriculum is designed around a real-world process I previously managed manually for a former employer. We will construct a Power App using Microsoft Power Apps to monitor tasks related to newly built homes, storing the data on SharePoint for simplicity. Additionally, we will employ Power Virtual Agents to guide users on enabling bots within Microsoft Teams, directing them to documents that may be dispersed across various SharePoint sites, such as loan agreements, budgets, and sales contracts, using a construction example. I see significant potential for these bots within HR and IT departments to address repetitive inquiries. I will also demonstrate how to establish simple flows in Power Automate to archive attachments from specific senders (for instance, saving inspection reports organized by the bank for the units). Furthermore, we will explore other straightforward flows that save data from Microsoft Forms back to SharePoint and develop fully automated workflows using the Approvals app within Microsoft Teams. After completing the app, bot, and flow, the final step involves creating a basic Power BI report. We will use Power Automate to send a snapshot of the table containing the most recently completed tasks every two weeks to a designated recipient (the bank in this scenario), requesting a drawdown that includes the completion dates and budget amounts for those tasks (all data collected via the app). While this course covers concepts at a high level, I recommend that learners use ChatGPT for more technical aspects, such as coding elements and formulas in Power Apps. However, the course itself includes a demonstration on how to effectively leverage ChatGPT to assist with Power Apps formulas.

This live, instructor-led training in France supports beginners and intermediate users in gaining proficiency with the Microsoft Power Platform. Participants will develop custom applications, automate workflows, and apply governance best practices by working with Power Apps and Power Automate in a hands-on lab setting.

This instructor-led, live training (online or onsite) is designed for intermediate-level IT professionals who aim to leverage the Power Platform to efficiently automate workflows and deepen their data insights.

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

• Developing and customizing applications using Power Apps.
• Managing and analyzing data through Dataverse and Power BI.
• Automating intricate processes with Power Automate.
• Designing and deploying intelligent chatbots using Power Virtual Agents.
• Integrating and optimizing workflows across the entire Power Platform suite.