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

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.

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.

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.

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.

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.

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.

DJ Lockwood, a Unit Director at the Arlington Boys & Girls Club, is an Emerging Leader. (Olivia Vanni / The Herald)
DJ Lockwood: Helping the community care for its kids

As director of the Arlington Boys & Girls Club, Lockwood has extended the club’s programs to more locations and more kids.

Alex Tadio, the admissions director at WSU Everett, is an Emerging Leader. (Olivia Vanni / The Herald)
Alex Tadio: A passion for education and equality

As admissions director at WSU Everett, he hopes to give more local students the chance to attend college.

Dr. Baljinder Gill and Lavleen Samra-Gill are the recipients of a new Emerging Business award. Together they run Symmetria Integrative Medical. (Olivia Vanni / The Herald)
Emerging Business: The new category honors Symmetria Integrative Medical

Run by a husband and wife team, the chiropractic and rehabilitation clinic has locations in Arlington, Marysville and Lake Stevens.

People walk along the waterfront in front of South Fork Bakery at the Port of Everett on Thursday, April 11, 2024 in Everett, Washington. (Olivia Vanni / The Herald)
Port of Everett inks deal with longtime Bothell restaurant

The port will break ground on two new buildings this summer. Slated for completion next year, Alexa’s Cafe will open in one of them.

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.