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

Black Press Media operates Sound Publishing, the largest community news organization in Washington State with dailies and community news outlets in Alaska.
Black Press Media concludes transition of ownership

Black Press Media, which operates Sound Publishing, completed its sale Monday (March 25), following the formerly announced corporate restructuring.

Maygen Hetherington, executive director of the Historic Downtown Snohomish Association, laughs during an interview in her office on Thursday, Feb. 15, 2024, in Snohomish, Washington. (Ryan Berry / The Herald)
Maygen Hetherington: tireless advocate for the city of Snohomish

Historic Downtown Snohomish Association receives the Opportunity Lives Here award from Economic Alliance.

FILE - Washington Secretary of State Steve Hobbs poses in front of photos of the 15 people who previously held the office on Nov. 22, 2021, after he was sworn in at the Capitol in Olympia, Wash. Hobbs faces several challengers as he runs for election to the office he was appointed to last fall. (AP Photo/Ted S. Warren, File)
Secretary of State Steve Hobbs: ‘I wanted to serve my country’

Hobbs, a former Lake Stevens senator, is the recipient of the Henry M. Jackson Award from Economic Alliance Snohomish County.

Mark Duffy poses for a photo in his office at the Mountain Pacific Bank headquarters on Wednesday, Feb. 14, 2024 in Everett, Washington. (Annie Barker / The Herald)
Mark Duffy: Building a hometown bank; giving kids an opportunity

Mountain Pacific Bank’s founder is the recipient of the Fluke Award from Economic Alliance Snohomish County.

Barb Tolbert poses for a photo at Silver Scoop Ice Cream on Thursday, Feb. 29, 2024 in Arlington, Washington. (Annie Barker / The Herald)
Barb Tolbert: Former mayor piloted Arlington out of economic brink

Tolbert won the Elson S. Floyd Award, honoring a leader who has “created lasting opportunities” for the underserved.

Photo provided by 
Economic Alliance
Economic Alliance presented one of the Washington Rising Stem Awards to Katie Larios, a senior at Mountlake Terrace High School.
Mountlake Terrace High School senior wins state STEM award

Katie Larios was honored at an Economic Alliance gathering: “A champion for other young women of color in STEM.”

The Westwood Rainier is one of the seven ships in the Westwood line. The ships serve ports in the Pacific Northwest and Northeast Asia. (Photo provided by Swire Shipping)
Westwood Shipping Lines, an Everett mainstay, has new name

The four green-hulled Westwood vessels will keep their names, but the ships will display the Swire Shipping flag.

A Keyport ship docked at Lake Union in Seattle in June 2018. The ship spends most of the year in Alaska harvesting Golden King crab in the Bering Sea. During the summer it ties up for maintenance and repairs at Lake Union. (Keyport LLC)
In crabbers’ turbulent moment, Edmonds seafood processor ‘saved our season’

When a processing plant in Alaska closed, Edmonds-based business Keyport stepped up to solve a “no-win situation.”

Angela Harris, Executive Director of the Port of Edmonds, stands at the port’s marina on Wednesday, Jan. 24, 2024, in Edmonds, Washington. (Ryan Berry / The Herald)
Leadership, love for the Port of Edmonds got exec the job

Shoring up an aging seawall is the first order of business for Angela Harris, the first woman to lead the Edmonds port.

The Cascade Warbirds fly over Naval Station Everett. (Sue Misao / The Herald file)
Bothell High School senior awarded $2,500 to keep on flying

Cascade Warbirds scholarship helps students 16-21 continue flight training and earn a private pilot’s certificate.

Rachel Gardner, the owner of Musicology Co., a new music boutique record store on Thursday, Jan. 18, 2024 in Edmonds, Washington. Musicology Co. will open in February, selling used and new vinyl, CDs and other music-related merchandise. (Olivia Vanni / The Herald)
New Edmonds record shop intends to be a ‘destination for every musician’

Rachel Gardner opened Musicology Co. this month, filling a record store gap in Edmonds.

MyMyToyStore.com owner Tom Harrison at his brick and mortar storefront on Tuesday, Sept. 6, 2022 in Everett, Washington. (Olivia Vanni / The Herald)
Burst pipe permanently closes downtown Everett toy store

After a pipe flooded the store, MyMyToystore in downtown Everett closed. Owner Tom Harrison is already on to his next venture.

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.