Essential Power Query for Management Consultants

Partner: Udemy
Affiliate Name:
Area:
Description: What is the aim of this course?During many consulting projects, you will have to improve the quality of data before you start analyzing it. This process can be immensely improved by Power Query. Power Query also enables you to automate certain repetitive tasks without resorting to Programming in Excel VBA. In this course, I will teach you how to use Power Query during consulting projects.In the course, you will learn the following things:What are queries, and what is Power Query?How to perform an essential transformation with Power QueryHow to add columns in Power Query using conditions, rules, and AIHow to use Power Query to clean the dataHow to merge data with Power QueryHow to add/append data with Power QueryWhen to use and when NOT to use Power QueryThis course is based on my 15 years of experience as a consultant in top consulting firms and as a Board Member responsible for strategy, performance improvement, and turn-arounds in the biggest firms in Retail, FMCG, SMG, and B2B, and services sectors that I worked for. I have carried out or supervised over 90 different performance improvement projects in different industries that generated a total of 2 billion in additional EBITDA. On the basis of what you will find in this course, I have trained in person over 100 consultants, business analysts, and managers who are now Partners in PE and VC funds, Investment Directors and Business Analysts in PE and VC, Operational Directors, COO, CRO, CEO, Directors in Consulting Companies, Board Members, etc. On top of that, my courses on Udemy were already taken by more than 315 000 students, including people working in EY, McKinsey, Walmart, Booz
Category: Business > Operations > Power Query
Partner ID:
Price: 99.99
Commission:
Source: Impact
Go to Course