Data Visualization for Management Consultants & Analysts
Data Visualization for Management Consultants & Analysts, available at $64.99, has an average rating of 4.63, with 88 lectures, based on 385 reviews, and has 3353 subscribers.
You will learn about What type of slides and charts to use to present data to your customer? How to create charts in Excel How to create charts in PowerPoint How to use PivotCharts How to make the charts more dynamic Main concepts used in Data Visualization This course is ideal for individuals who are Management Consultants or Business Analysts or Financial Controllers or Investment Analysts or Startup Founders or Project Managers It is particularly useful for Management Consultants or Business Analysts or Financial Controllers or Investment Analysts or Startup Founders or Project Managers.
Enroll now: Data Visualization for Management Consultants & Analysts
Summary
Title: Data Visualization for Management Consultants & Analysts
Price: $64.99
Average Rating: 4.63
Number of Lectures: 88
Number of Published Lectures: 88
Number of Curriculum Items: 88
Number of Published Curriculum Objects: 88
Original Price: $89.99
Quality Status: approved
Status: Live
What You Will Learn
- What type of slides and charts to use to present data to your customer?
- How to create charts in Excel
- How to create charts in PowerPoint
- How to use PivotCharts
- How to make the charts more dynamic
- Main concepts used in Data Visualization
Who Should Attend
- Management Consultants
- Business Analysts
- Financial Controllers
- Investment Analysts
- Startup Founders
- Project Managers
Target Audiences
- Management Consultants
- Business Analysts
- Financial Controllers
- Investment Analysts
- Startup Founders
- Project Managers
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:
-
What types of slides you should use to present your thoughts
-
What types of charts you should use for data visualization
-
How to read the charts
-
How to create charts in Excel
-
How to create charts in PowerPoint
-
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 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. On the basis of what you will find in this course, I have trained in person over 100 consultants, business analysts, and managers who now are 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 181 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 Excels as well as additional presentations, and materials shown in the lectures so as a 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 them to the customer, you will lose the opportunity to impress him. 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 toolsthat 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 that present the results of their analyses to customers. The course will help you become an expert in data visualization on 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:
-
What types of slides you should use to present your thoughts
-
What types of charts you should use for data visualization
-
How to read the charts
-
How to create charts in Excel
-
How to create charts in PowerPoint
-
How to create dynamic charts in Excel
You can also ask me any question either through the discussion field or by messaging me directly.
How the course is organized?
The course is divided currently 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 you should 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.
-
Dynamic Charts in Excel. In this 10th section, we will see how we can make the charts more dynamic.
-
Advanced Charts in Excel. In the last section, I will show you more advanced types of charts that you can create in Excel.
As a part of this course, you will get
-
Useful frameworks and techniques
-
Analyses shown in the course
-
Additional resources
-
Links to additional presentations, articles, and movies
-
Links to books worth reading
At the end of my course, students will be able to…
-
How to create charts in Excel
-
How to use PivotCharts
-
How to make the charts more dynamic
-
What type of slides and charts to use to present data to your customer?
Who should take this course? Who should not?
-
Management Consultants
-
Business Analysts
-
Financial Controllers
-
Investment Analysts
-
Startup Founders
-
Project Managers
What will students need to know or do before starting this course?
Basic or intermediate Excel
Course Curriculum
Chapter 1: Introduction
Lecture 1: Introduction
Lecture 2: A little bit about me
Lecture 3: How the course is organized
Lecture 4: How to deal with Blurry image
Lecture 5: How to reach additional resources
Chapter 2: Types of slides you can use
Lecture 1: Types of slides you can use – Introduction
Lecture 2: Process slides
Lecture 3: Comparison of 2 data sets
Lecture 4: Comparison of 2 things using text
Lecture 5: Comparison using 3 criteria – numbers
Lecture 6: Project structure
Lecture 7: Team / Project roles
Lecture 8: Timeline
Lecture 9: Summary slides
Lecture 10: Grouping knowledge slides
Lecture 11: Composition
Lecture 12: Waterfall slides
Lecture 13: Team members
Lecture 14: Maps
Lecture 15: Issue tree slides
Lecture 16: Showing options – Part 1
Lecture 17: Showing options – Part 2
Chapter 3: How to read charts
Lecture 1: How to read charts – Introduction
Lecture 2: How to lie with charts
Lecture 3: What is a good chart
Lecture 4: The process of creating charts
Chapter 4: Which chart type you should use
Lecture 1: Which chart type you should use – Introduction
Lecture 2: How to show that something has changed over time
Lecture 3: How to compare different options across 2 dimensions
Lecture 4: How to compare different options across 3 dimensions
Lecture 5: How to compare different options across more than 3 dimensions
Lecture 6: How to show composition / structure
Lecture 7: How to show funnels
Lecture 8: How to show local differences
Chapter 5: Essential Charts in Excel
Lecture 1: Essential Charts in Excel – Introduction
Lecture 2: Basics of creating a chart in Excel
Lecture 3: How to format the chart
Lecture 4: How to make the chart look nice
Lecture 5: How to have a one chart with 2 axes
Lecture 6: How to reuse formatting from previous charts
Lecture 7: How to reverse the order of data in the chart
Lecture 8: Bar chart with different colors – Part 1
Lecture 9: Bar chart with different colors – Part 2
Lecture 10: How to highlight specific periods on the chart
Lecture 11: How to add total for stacked column charts
Lecture 12: Analysis vs Data for the Slide
Lecture 13: How to create more complicated charts
Lecture 14: Saturating existing markets – Waterfall Chart
Lecture 15: How to expand the brand – How to create Scatter Graph
Chapter 6: Data Visualization using Conditional Formatting
Lecture 1: Data Visualization using Conditional Formatting – Introduction
Lecture 2: Conditional Formating
Lecture 3: Charts using conditional formatting
Lecture 4: Heat Maps using conditional formatting
Lecture 5: Sparklines
Chapter 7: How to create charts in Power Point
Lecture 1: How to create charts in Power Point – Introduction
Lecture 2: Basics of creating a chart in PowerPoint
Lecture 3: How to format charts in PowerPoint
Lecture 4: Library of formatted charts
Lecture 5: How to change the color of charts in PowerPoint
Lecture 6: Chart Animation
Chapter 8: PivotCharts
Lecture 1: PivotCharts – Introduction
Lecture 2: Pivots in a nutshell
Lecture 3: PivotCharts Example
Lecture 4: Pivot Slicers
Lecture 5: Combining slicers with Pivot Charts
Lecture 6: Building a Dashboard – Part 1
Lecture 7: Building a Dashboard – Part 2
Lecture 8: Look & Feel of Pivot Chart
Chapter 9: PivotCharts Case Studies
Lecture 1: Online Storechecks – Cosmetics – Case Introduction
Lecture 2: Online Storechecks – Cosmetics – Available Data
Lecture 3: Online Storechecks – Cosmetics – Analysis by Brands
Lecture 4: Online Storechecks – Cosmetics – Analysis by Applications
Lecture 5: Online Storechecks – Cosmetics – Analysis by Size & Customer Group
Lecture 6: Using Customer reviews – Case Introduction
Lecture 7: Using Customer reviews – Available Data
Lecture 8: Using Customer reviews – Analysis by Industry & Size of Firm
Lecture 9: Using Customer reviews – Customer Segment Size
Chapter 10: Dynamic Charts in Excel
Lecture 1: Dynamic Charts in Excel – Introduction
Lecture 2: Dynamic Chart using Pivot Chart
Lecture 3: Dynamic Chart using VLOOKUP & MATCH
Lecture 4: Dynamic Chart using SUMIFS
Lecture 5: How to add new data to the chart automatically
Chapter 11: Advanced Charts in Excel
Lecture 1: Advanced Charts in Excel – Introduction
Lecture 2: Pareto Chart
Lecture 3: Maps
Lecture 4: Funnel Charts
Lecture 5: Tree Maps
Chapter 12: Conclusions
Lecture 1: Bonus Lecture
Instructors
-
Asen Gyczew
Expert in performance improvement, turnaround and startups
Rating Distribution
- 1 stars: 2 votes
- 2 stars: 15 votes
- 3 stars: 39 votes
- 4 stars: 129 votes
- 5 stars: 200 votes
Frequently Asked Questions
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!
You may also like
- Top 10 Video Editing Courses to Learn in November 2024
- Top 10 Music Production Courses to Learn in November 2024
- Top 10 Animation Courses to Learn in November 2024
- Top 10 Digital Illustration Courses to Learn in November 2024
- Top 10 Renewable Energy Courses to Learn in November 2024
- Top 10 Sustainable Living Courses to Learn in November 2024
- Top 10 Ethical AI Courses to Learn in November 2024
- Top 10 Cybersecurity Fundamentals Courses to Learn in November 2024
- Top 10 Smart Home Technology Courses to Learn in November 2024
- Top 10 Holistic Health Courses to Learn in November 2024
- Top 10 Nutrition And Diet Planning Courses to Learn in November 2024
- Top 10 Yoga Instruction Courses to Learn in November 2024
- Top 10 Stress Management Courses to Learn in November 2024
- Top 10 Mindfulness Meditation Courses to Learn in November 2024
- Top 10 Life Coaching Courses to Learn in November 2024
- Top 10 Career Development Courses to Learn in November 2024
- Top 10 Relationship Building Courses to Learn in November 2024
- Top 10 Parenting Skills Courses to Learn in November 2024
- Top 10 Home Improvement Courses to Learn in November 2024
- Top 10 Gardening Courses to Learn in November 2024