Data Visualization for Management Consultants & Analysts (Udemy.com)

What is the aim of this course?

In consulting, you will spend a lot of time creating presentations to show the results of your analyses to the customer. That is why data visualization is so important. With a proper display of data, you have more chances of convincing the customers that your approach makes sense. In this course, I will teach how to use different data visualization techniques to show the results of your analyses during consulting projects.

In the course, you will learn the following things:

1. What types of slides should you use to present your thoughts

2. What types of charts should you use for data visualization

3. How to read the charts

4. How to create charts in Excel

5. How to create charts in PowerPoint

6. How to create dynamic charts in Excel

This 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 from the Retail, FMCG, SMG, 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. Based on 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, Walmart, Booz Allen Hamilton, Adidas, Naspers, Alvarez & Marsal, PwC, Dell, Walgreens, Orange, and many others.

I teach through case studies, so you will have a lot of lectures showing examples of analyses and tools that we use. To every lecture, you will find attached (in additional resources) the Excel files, as well as additional presentations, and materials shown in the lectures, so as part of this course, you will also get a library of ready-made analyses that can, with certain modifications, be applied by you or your team in your work.

Why have I decided to create this course?

Data visualization is one of the most important skills that you should master during your 1st year of work in consulting. If you are able to analyze data but you don’t know how to present it to the customer, you will lose the opportunity to impress them. Data visualization is one of the crucial skills that you should master if you want to get promoted fast. Most firms don’t give you the full toolbox that you need. This may lead to huge frustration during consulting projects and a lot of inefficiencies.

Therefore, I have decided to create this course that will help students understand or refresh the main skills and tools that they need during consulting projects when it comes to data visualization. The course will give you knowledge and insight into the types of charts and slides that you will be using during your work to present the data. It will also make your life during a consulting project much easier. Thanks to this course, you will know what and how to present data and visualize them during consulting projects. On top of that, you will also have access to the library of slides and charts that we use ourselves.

To sum it up, I believe that if you want to become a world-class Management Consultant or Business Analyst, you have to have a pretty decent understanding of data visualization. That is why I highly recommend this course to Management Consultants or Business Analysts, especially those who present the results of their analyses to customers. The course will help you become an expert in data visualization at the level of McKinsey, BCG, Bain, and other top consulting firms.

In what way will you benefit from this course?

The course is a practical, step-by-step guide loaded with tons of analyses, tricks, and hints that will significantly improve the speed with which you understand and analyze businesses. There is little theory – mainly examples, a lot of tips from my own experience, as well as other notable examples worth mentioning. Our intention is that, thanks to the course, you will learn:

1. What types of slides should you use to present your thoughts

2. What types of charts should you use for data visualization

3. How to read the charts

4. How to create charts in Excel

5. How to create charts in PowerPoint

6. How to create dynamic charts in Excel

You can also ask me any questions either through the discussion field or by messaging me directly.

How is the course organized?

The course is currently divided into the following sections:

• Introduction. We begin with a little intro to the course, as well as some general info on how the course is organized

• Types of slides you can use. In this section, I will show you what kind of slides you can use for different purposes during consulting projects.

• How to read charts. In this section, I will show how to read charts and how people can lie to you with charts

• Which chart type should you use? We will discuss in detail what type of charts you can use for different purposes. We have grouped them into 5 different categories.

• Essential Charts in Excel. In the fifth section, we will move to more technical issues. I will show you how you can create and modify specific types of charts in Excel.

• Data Visualization using Conditional Formatting. You can do data visualization not only with charts but also with conditional formatting. In this section, we will see how this can be done in Excel.

• How to create charts in PowerPoint. In the seventh section, we will move to more technical issues. I will show you how you can create and modify specific types of charts in PowerPoint

• PivotCharts. To make the charts more dynamic, you can use PivotCharts. We will see in this section how this can be done in practice.

• PivotCharts Case Studies. In this section, we will see how we can use PivotCharts to present data from analyses.