Consulting Approach to Problem Solving (Coursera)

Offered by Emory University,
Consulting Approach to Problem Solving (Coursera)

This is the #3 course in the specialization on management consulting. Management consultants excel at solving difficult and complex business problems. How do they do this? Shouldn’t clients know more about their situation than external consultants?

Class Deals by MOOC List - Click here and see Coursera's Active Discounts, Deals, and Promo Codes.

Consultants are trained to systematically break down problems into logical pieces, then aggressively pursue answers with data:
• Think about the problem broadly; strategy, operations, people, technology
• Define the problem clearly; articulate “what does success look like?”
• Break the problem into “buckets” so it is easy to understand
• Use hypotheses to “guess” your way to the potential answer(s)
• Find and clean up messy data; convert the data into useful recommendations
Course 3 of 5 in the Management Consulting Specialization.

What You Will Learn
How to break down problems? How to use hypotheses? How to request data? How to clean data? How to use a DMAIC process improvement framework?

Syllabus

WEEK 1
Problem Definition and Scoping
Problem definition may sound abstract or boring, but it's incredibly important to solve the RIGHT PROBLEM. Like a detective at a crime scene, a consultant needs to stay open-minded; think broadly about the problem and "look around" for obvious (and missing) clues. In practical terms, a clear problem statement helps the consulting manager keep the scope broad enough for flexibility and creativity, while narrow enough that the work can get done within the project time-frame.

WEEK 2
Frameworks and Logical Structuring
Using the analogy of a jigsaw puzzle, the prior step of "problem definition" was looking at the picture on the box and defining the edges of the puzzle. This step of "problem break down" is sorting the puzzle pieces into different colors: red, yellow, blue, green. Different business frameworks help to simplify complex problems and identify the key drivers (e.g., 80/20 pareto principle). It also offers the opportunity to get early client feedback and form early hypotheses on what the answer(s) could be. Finally, it helps to organize the work so the team can divide up the work effectively.

WEEK 3
Hypothesis-Based Consulting
Unless you are a scientist, the word "hypothesis" will likely seem a little strange. It's the idea that you are making an "educated guess" on what the solutions could be. It's a statement (not a question) that you work to prove through testing. How is this related to consulting? Consultants are often hired to solve the toughest problems in a short amount of time. The only way to accomplish that is by being smart and selective in what they do. This is the secret to how consultants successfully "crack the case" on their clients' problems.

WEEK 4
Consultants Love Data
Yes, consultants LOVE data. It is the raw ingredients in the cooking of useful recommendations. Too often, the data is messy, biased, old, fragmented, or missing. As a result, one of the first tasks in a consulting project is to identify and collect usable data sets. It's an enormous task - often unglamorous - but also the only way you can test your hypotheses and develop recommendations. Data lends credibility to consultants' recommendations.

WEEK 5
Data Request and Data Cleansing
Once you've identified the data you need, the journey has just begun. Using a cooking analogy, you've only put together the shopping list. You still need to get the ingredients, check for freshness, get enough, wash / peel / cut them before you can do the cooking. The same applies for data. It takes effort, client engagement, and some wisdom to request data efficiently.

WEEK 6
Get the "Right Data" for the Project
There is too much data out there to analyze it all; you need to be selective. One way to do that is to follow a structured process or methodology. It doesn't have to be fancy or proprietary. It just needs to outline for yourself and the client, what you are going to do when. This project plan is at a high-level and helps you to reorient your efforts to the right data, right analysis, and right timing. The following DMAIC framework is used frequently in performance improvement projects.

Go to Class
MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Related Courses

Big Data Integration and Processing (Coursera) Coursera
University of California, San Diego

Big Data Integration and Processing (Coursera)

At the end of the course, you will be able to: Retrieve data from example database and big data management systems; Describe the connections between data management operations and the big data processing patterns needed to utilize them in large-scale analytical applications; Identify when a big data problem needs data integration; Execute simple big data integration and processing on Hadoop and Spark platforms.

Jun 1st 2026
5-12 Weeks
Data Analysis Tools (Coursera) Coursera
Wesleyan University

Data Analysis Tools (Coursera)

In this course, you will develop and test hypotheses about your data. You will learn a variety of statistical tests, as well as strategies to know how to apply the appropriate one to your specific data and question. Using your choice of two powerful statistical software packages (SAS or Python), you will explore ANOVA, Chi-Square, and Pearson correlation analysis. This course will guide you through basic statistical principles to give you the tools to answer questions you have developed. Throughout the course, you will share your progress with others to gain valuable feedback and provide insight to other learners about their work.

Jun 1st 2026
4 Weeks
Business Metrics for Data-Driven Companies (Coursera) Coursera
Duke University

Business Metrics for Data-Driven Companies (Coursera)

In this course, you will learn best practices for how to use data analytics to make any company more competitive and more profitable. You will be able to recognize the most critical business metrics and distinguish them from mere data. You’ll get a clear picture of the vital but different roles business analysts, business data analysts, and data scientists each play in various types of companies. And you’ll know exactly what skills are required to be hired for, and succeed at, these high-demand jobs.

Jun 1st 2026
4 Weeks
Exploratory Data Analysis (Coursera) Coursera
Johns Hopkins University

Exploratory Data Analysis (Coursera)

This course covers the essential exploratory techniques for summarizing data. These techniques are typically applied before formal modeling commences and can help inform the development of more complex statistical models. Exploratory techniques are also important for eliminating or sharpening potential hypotheses about the world that can be addressed by the data.

Jun 1st 2026
4 Weeks
Data Science Companion (Coursera) Coursera
MathWorks

Data Science Companion (Coursera)

The Data Science Companion provides an introduction to data science. You will gain a quick background in data science and core machine learning concepts, such as regression and classification. You’ll be introduced to the practical knowledge of data processing and visualization using low-code solutions, as well as an overview of the ways to integrate multiple tools effectively to solve data science problems.

Jun 5th 2026
4 Weeks
Analyze Data to Answer Questions (Coursera) Coursera
Google

Analyze Data to Answer Questions (Coursera)

This is the fifth course in the Google Data Analytics Certificate. These courses will equip you with the skills needed to apply to introductory-level data analyst jobs. In this course, you’ll explore the “analyze” phase of the data analysis process. You’ll take what you’ve learned to this point and apply it to your analysis to make sense of the data you’ve collected. You’ll learn how to organize and format your data using spreadsheets and SQL to help you look at and think about your data in different ways. You’ll also find out how to perform complex calculations on your data to complete business objectives.

Jun 2nd 2026
4 Weeks
Data Management and Visualisation (Coursera) Coursera
Wesleyan University

Data Management and Visualisation (Coursera)

Whether being used to customize advertising to millions of website visitors or streamline inventory ordering at a small restaurant, data is becoming more integral to success. Too often, we’re not sure how use data to find answers to the questions that will make us more successful in what we do. In this course, you will discover what data is and think about what questions you have that can be answered by the data – even if you’ve never thought about data before. Based on existing data, you will learn to develop a research question, describe the variables and their relationships, calculate basic statistics, and present your results clearly.

Jun 1st 2026
4 Weeks
A Crash Course in Data Science (Coursera) Coursera
Johns Hopkins University

A Crash Course in Data Science (Coursera)

By now you have definitely heard about data science and big data. In this one-week class, we will provide a crash course in what these terms mean and how they play a role in successful organizations. This class is for anyone who wants to learn what all the data science action is about, including those who will eventually need to manage data scientists. The goal is to get you up to speed as quickly as possible on data science without all the fluff. We've designed this course to be as convenient as possible without sacrificing any of the essentials.

Jun 1st 2026
1 Week
Process Data from Dirty to Clean (Coursera) Coursera
Google

Process Data from Dirty to Clean (Coursera)

This is the fourth course in the Google Data Analytics Certificate. These courses will equip you with the skills needed to apply to introductory-level data analyst jobs. In this course, you’ll continue to build your understanding of data analytics and the concepts and tools that data analysts use in their work. You’ll learn how to check and clean your data using spreadsheets and SQL as well as how to verify and report your data cleaning results. Current Google data analysts will continue to instruct and provide you with hands-on ways to accomplish common data analyst tasks with the best tools and resources.

Jun 2nd 2026
5-12 Weeks
Foundations of marketing analytics (Coursera) Coursera
ESSEC Business School

Foundations of marketing analytics (Coursera)

Who is this course for? This course is designed for students, business analysts, and data scientists who want to apply statistical knowledge and techniques to business contexts. For example, it may be suited to experienced statisticians, analysts, engineers who want to move more into a business role, in particular in marketing. You will find this course exciting and rewarding if you already have a background in statistics, can use R or another programming language and are familiar with databases and data analysis techniques such as regression, classification, and clustering. However, it contains a number of recitals and R Studio tutorials which will consolidate your competences, enable you to play more freely with data and explore new features and statistical functions in R.

Jun 1st 2026
5-12 Weeks