How to use data to solve the problem

  • By Andrew Ballard Growth Strategies
  • Monday, February 2, 2015 3:28pm
  • Business

In January, I covered Part 2 of the problem-solving process — gathering the data — used by business-consulting firms. This column explores the third step — interpreting the data.

Here is a recap. In the first step, you framed the problem that is keeping your business from achieving your growth goals by creating an issue tree, designed to lay out the issue and sub-issues of the problem in a visual progression. Then, by gathering the data you asked the right people the right questions and documented your results.

This column is dedicated to the third step, interpreting the data, that you gathered in the second step, to identify the best solution to your business problem.

The process involves more than merely analyzing the data you gathered; rather, developing actionable insights that lead to a solution to your business problem. The purpose is to either prove or disprove the solution hypothesis you developed when framing the problem during the first step.

Your course of action in Part 3 includes two functions: 1) tabulating the data, and 2) developing a key findings report.

Tabulation involves sorting through the data to separate the irrelevant facts from those relevant to the problem. Using the same example I presented in Parts 1 and 2, “how do we increase gross margin on XYZ widget sales,” you would start by reviewing the results of interviews you conducted with your procurement staff and your suppliers. You’d then weed out any information that wasn’t directly relevant to your goal of increasing gross margin.

Once you have narrowed your data set down to only the relevant facts, you’ll organize those data (the responses from your interviews) and group them by similar responses.

One interview respondent’s answer to a question is not necessary meaningful, unless it matches up with several other respondent’s answers to the same question. You may recall from the gathering the data column, that my company documents all of the responses from interviews into an easy-to-sort spreadsheet.

After you have tabulated the data (grouped similar responses), enter the dominate themes into a key-findings report. Even if you are only reporting to yourself, it is important to document your key findings. It is difficult, if not impossible, to look at an entire spreadsheet of individual responses and perceive any meaningful correlations.

While evaluating a written report, that presents and prioritizes the dominate themes from each interview question, actionable insights will become evident.

In summary, after gathering your data organize the results to separate out irrelevant responses and tabulate the relevant information to surface dominant themes. Then format those data into a key findings report and look for actionable insights.

Be sure to check back next month for the fourth and final step — implementing the solution—in the business consulting problem solving process.

Talk to us

> Give us your news tips.

> Send us a letter to the editor.

> More Herald contact information.

More in Business

Everett
Red Robin to pay $600K for harassment at Everett location

A consent decree approved Friday settles sexual harassment and retaliation claims by four victims against the restaurant chain.

magniX employees and staff have moved into the company's new 40,000 square foot office on Seaway Boulevard on Monday, Jan. 18, 2020 in Everett, Washington. magniX consolidated all of its Australia and Redmond operations under one roof to be home to the global headquarters, engineering, manufacturing and testing of its electric propulsion systems.  (Andy Bronson / The Herald)
Harbour Air plans to buy 50 electric motors from Everett company magniX

One of the largest seaplane airlines in the world plans to retrofit its fleet with the Everett-built electric propulsion system.

Simreet Dhaliwal speaks after winning during the 2024 Snohomish County Emerging Leaders Awards Presentation on Wednesday, April 17, 2024, in Everett, Washington. (Ryan Berry / The Herald)
Simreet Dhaliwal wins The Herald’s 2024 Emerging Leaders Award

Dhaliwal, an economic development and tourism specialist, was one of 12 finalists for the award celebrating young leaders in Snohomish County.

Lynnwood
New Jersey company acquires Lynnwood Land Rover dealership

Land Rover Seattle, now Land Rover Lynnwood, has been purchased by Holman, a 100-year-old company.

Szabella Psaztor is an Emerging Leader. (Olivia Vanni / The Herald)
Szabella Pasztor: Change begins at a grassroots level

As development director at Farmer Frog, Pasztor supports social justice, equity and community empowerment.

Simreet Dhaliwal is an Emerging Leader. (Olivia Vanni / The Herald)
Simreet Dhaliwal: A deep-seated commitment to justice

The Snohomish County tourism and economic specialist is determined to steer change and make a meaningful impact.

Nathanael Engen, founder of Black Forest Mushrooms, an Everett gourmet mushroom growing operation is an Emerging Leader. (Olivia Vanni / The Herald)
Nathanael Engen: Growing and sharing gourmet mushrooms

More than just providing nutritious food, the owner of Black Forest Mushrooms aims to uplift and educate the community.

Owner and founder of Moe's Coffee in Arlington Kaitlyn Davis poses for a photo at the Everett Herald on March 22, 2024 in Everett, Washington. (Annie Barker / The Herald)
Kaitlyn Davis: Bringing economic vitality to Arlington

More than just coffee, Davis has created community gathering spaces where all can feel welcome.

Emerging Leader John Michael Graves. (Ryan Berry / The Herald)
John Michael Graves: Champion for diversity and inclusion

Graves leads training sessions on Israel, Jewish history and the Holocaust and identifying antisemitic hate crimes.

Gracelynn Shibayama, the events coordinator at the Edmonds Center for the Arts, is an Emerging Leader. (Olivia Vanni / The Herald)
Gracelynn Shibayama: Connecting people through the arts and culture

The Edmonds Center for the Arts coordinator strives to create a more connected and empathetic community.

Eric Jimenez, a supervisor at Cocoon House, is an Emerging Leader. (Olivia Vanni / The Herald)
Eric Jimenez: Team player and advocate for youth

As an advocate for the Latino community, sharing and preserving its traditions is central to Jimenez’ identity.

Molbak's Garden + Home in Woodinville, Washington closed on Jan. 28 2024. (Photo courtesy of Molbak's)
Molbak’s, former Woodinville garden store, hopes for a comeback

Molbak’s wants to create a “hub” for retailers and community groups at its former Woodinville store. But first it must raise $2.5 million.

Support local journalism

If you value local news, make a gift now to support the trusted journalism you get in The Daily Herald. Donations processed in this system are not tax deductible.