The Young Consultant · Client engagement · 2024

plenti.

Finding the market for adaptable living.

On a seven-person consulting team, I helped turn an early-stage startup’s broad UK expansion question into a clearer story about customers, pricing, and research quality.

Team introduction slide showing the seven-person Plenti Space consulting team

3 / 29Team introduction

Scroll sideways, swipe, or use the arrows

RoleJunior Consultant

Team7 consultants

FocusSurvey · market · SQL

TimelineOct 2024—Jan 2025

01 / Survey redesign

Before

How the initial survey worked.

Original 96-response baseline

Question 01 What is your age?

Question 02 Where do you live?

Question 03 What housing accommodation do you have?

Housing tenure n=22 Owner

Owner question Would you prefer smart walls?

Yes50%

No50%

Housing tenure n=74 Renter

Renter question Would you prefer smart walls?

Yes74%

No26%

Preference percentages are reported directly in the final presentation. The “No” percentages are their complements.

After

The second survey added more branches to capture how different people valued smart walls.

Excel could still store every response, but the growing number of conditional paths made a flat export difficult to navigate. A separate question-and-rule map would make each route easier to reconstruct, filter, and verify.

Illustrative model405responses

This 405-response scenario models how the redesigned survey could branch at scale. Every card shows the modeled count reaching that option; only the leading card continues so the route remains readable.

Question 01What is your age?

Question 02Where do you live?

Question 03What is your current accommodation?

7 accommodation types

Question 04Do you rent or own your home?

R · renterO · ownerF · family / other

Question 05Would you prefer smart walls?

Y · yesM · maybeN · no

Question 06What is fair for the same-size smart-wall space?

Modeled rent values

Question 07What is fair for the smaller smart-wall space?

Modeled rent values

Card number responses reaching that option Blue outline branch continued into the next question Curved line observed transition

Modeled counts are illustrative. They preserve the original survey’s category structure while adding routes introduced by the redesign; they are not reported study results.

02 / Technical direction

Proposed companion tool

Building a survey navigation tool.

Even a 405-row survey export would be easy to store, pivot, and summarize in Excel. The harder problem was reconstructing which questions, answer options, and display rules belonged to each route. The proposed companion tool would normalize those relationships in SQLite, then use JavaScript to reveal one respondent path at a time.

Qualtrics exportSQLite question mapPath filterJS navigator

Keep Excel for analysisRaw responses and quick summaries remain in the spreadsheet.

Model logic in SQLiteQuestions, options, versions, and display rules become queryable relationships.

Navigate routes in JavaScriptReview renter, owner, same-size, or smaller-space paths without false missingness.

Filter path

Proposed interface—not the original Qualtrics survey

Visible routeAll questions

WHERE audience IN ('all', :route)

01 · AllProduct videoEstablish what smart walls are

02 · AllRespondent profileAge, location, and housing

03 · RenterCurrent rent and room typeRenter branch

04 · OwnerProperty price and typeOwner branch

05 · AllSame-size comparisonPreference and price change

06 · AllSmaller-space comparisonPreference and price change

Interactive concept showing how SQLite-backed branch filtering could make the survey easier to inspect. The original response data is not published.

Next project

Designing a source-grounded advising assistant for UW students.

Explore AdvisrLab →