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

(Image from Pexels.com)
The real estate pros you need to know: Top 3 realtors in Snohomish County

Buying or selling? These experts make the process a breeze!

Relax Mind & Body Massage (Photo provided by Sharon Ingrum)
Celebrating the best businesses of the year in Snohomish County.

Which local businesses made the biggest impact this year? Let’s find out.

Construction contractors add exhaust pipes for Century’s liquid metal walls at Zap Energy on Monday, Feb. 3, 2025 in Everett, Washington. (Olivia Vanni / The Herald)
Snohomish County becomes haven for green energy

Its proximity to Boeing makes the county an ideal hub for green companies.

A closing sign hangs above the entrance of the Big Lots at Evergreen and Madison on Monday, July 22, 2024, in Everett, Washington. (Ryan Berry / The Herald)
Big Lots announces it will shutter Everett and Lynnwood stores

The Marysville store will remain open for now. The retailer reported declining sales in the first quarter of the year.

George Montemor poses for a photo in front of his office in Lynnwood, Washington on Tuesday, July 30, 2024.  (Annie Barker / The Herald)
Despite high mortgage rates, Snohomish County home market still competitive

Snohomish County homes priced from $550K to $850K are pulling in multiple offers and selling quickly.

Henry M. Jackson High School’s robotic team, Jack in the Bot, shake hands at the 2024 Indiana Robotics Invitational.(Henry M. Jackson High School)
Mill Creek robotics team — Jack in the Bot — wins big

Henry M. Jackson High School students took first place at the Indiana Robotic Invitational for the second year in a row.

The computer science and robotics and artificial intelligence department faculty includes (left to right) faculty department head Allison Obourn; Dean Carey Schroyer; Ishaani Priyadarshini; ROBAI department head Sirine Maalej and Charlene Lugli. PHOTO: Arutyun Sargsyan / Edmonds College.
Edmonds College to offer 2 new four-year degree programs

The college is accepting applications for bachelor programs in computer science as well as robotics and artificial intelligence.

Rick Steves speaks at an event for his new book, On the Hippie Trail, on Thursday, Feb. 27 at Third Place Books in Lake Forest, Washington. (Will Geschke / The Herald)
Travel guru won’t slow down

Rick Steves is back to globetrotting and promoting a new book after his cancer fight.

FILE — Boeing 737 MAX8 airplanes on the assembly line at the Boeing plant in Renton, Wash., on March 27, 2019. Boeing said on Wednesday, Feb. 21, 2024, that it was shaking up the leadership in its commercial airplanes unit after a harrowing incident last month during which a piece fell off a 737 Max 9 jet in flight. (Ruth Fremson/The New York Times)
Federal judge rejects Boeing’s guilty plea related to 737 Max crashes

The plea agreement included a fine of up to $487 million and three years of probation.

Neetha Hsu practices a command with Marley, left, and Andie Holsten practices with Oshie, right, during a puppy training class at The Everett Zoom Room in Everett, Washington on Wednesday, July 3, 2024. (Annie Barker / The Herald)
Tricks of the trade: New Everett dog training gym is a people-pleaser

Everett Zoom Room offers training for puppies, dogs and their owners: “We don’t train dogs, we train the people who love them.”

Andy Bronson/ The Herald 

Everett mayor Ray Stephenson looks over the city on Tuesday, Jan. 5, 2015 in Everett, Wa. Stephanson sees  Utah’s “housing first” model – dealing with homelessness first before tackling related issues – is one Everett and Snohomish County should adopt.

Local:issuesStephanson

Shot on: 1/5/16
Economic Alliance taps former Everett mayor as CEO

Ray Stephanson will serve as the interim leader of the Snohomish County group.

Molbak's Garden + Home in Woodinville, Washington will close on Jan. 28. (Photo courtesy of Molbak's)
After tumultuous year, Molbak’s is being demolished in Woodinville

The beloved garden store closed in January. And a fundraising initiative to revitalize the space fell short.

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.