Turn Business Data Into Answers

    The Vision Most business users can't access their own data. The marketing analyst who needs last month's regional numbers has to file a ticket and wait two days. The ops manager tracking deal velocity is working from a spreadsheet that's…

    TypeScript
    React
    Web App
    Postgres
    B2B SaaS
    Data Products
    AI Integration
    Estimated Time:
    45 minutes
    Difficulty:Intermediate
    Status:Not started
    Start this challenge

    Create a free account to upload your work. Your progress saves as a draft until you submit.

    What You'll Be Doing

    The Vision

    Most business users can't access their own data. The marketing analyst who needs last month's regional numbers has to file a ticket and wait two days. The ops manager tracking deal velocity is working from a spreadsheet that's three weeks old. The business owner who wants to understand their top customers has no idea where to even start.

    Golden Analytics is building toward "Canva for data" — a world where any business user can understand, explore, and act on their data, without needing an engineer, a BI tool license, or a SQL degree. The people we're building for are not technical. They are smart, they have real questions, and they are currently stuck.

    You're joining the team. Your first challenge is also the most important one we work on every day: how do you make data genuinely useful for someone who has never written a query?


    The Challenge

    You have 30 minutes and a real dataset to work with: Washington State fiscal data (link to data set below as well) — public government spending broken down by fund type and fiscal year. This is real data, with real shape and real quirks. You do not need a database connection; you can embed the data directly or load it from the file.

    Your task: Propose one way to help a non-technical user get value from this data. Then build it as a proof-of-concept web app.

    The solution is yours to design. We want to see your product instincts alongside your engineering. What do you think would genuinely help someone who has never looked at a government budget? A city councilmember trying to understand where the money went. A journalist tracking spending trends. A policy analyst who knows the questions but not the SQL. Build something for one of them.


    Constraints

    Every solution — whatever direction you take — must satisfy these two things:

    1. It must target a non-technical user. The person using your app has never written a query. Design for them. SQL must not be visible unless the user has explicitly requested it.
    2. It must be a working web app. A mock or stub is acceptable for data that isn't wired up, but the UI must be functional and the core interaction must work. If you can demo it, even better.

    AI usage: Golden Analytics builds AI-native features — it's a core part of what this role does. If your solution includes an AI or intelligent component, great. If it doesn't, explain in your README why you made that choice and where you see AI adding value in a future iteration. Either approach is valid. What we're looking for is intentional product thinking, not checkbox compliance.

    If you use AI/ML components: All inputs to any model, vector store, or intelligent component must be logged — even in the POC. You do not need a persistent log store, but your code must show clearly where and how logging would happen. This is a governance requirement in enterprise B2B contexts.

    This is a proof-of-concept. You are not expected to ship production code in 30 minutes. What we're evaluating is your thinking, your trade-offs, and how you approach the problem — not polish.


    AI Usage Guidance

    We expect you to use AI tools. We evaluate how you use them — not whether you use them. Evidence of iteration, redirection, and critical evaluation scores higher than a polished output with no process documentation.

    The single highest-signal indicator: your video answer to the mandatory AI question. If you cannot name a specific moment where you redirected AI output, evaluators will assume you did not.

    Mandatory AI question (answer in your video):

    Walk me through one moment where you disagreed with, pushed back on, or redirected what the AI gave you — and what you did instead. Name the specific moment. Explain what the AI produced that didn't meet the bar, what you did differently, and why.

    Dataset

    Vendor-Payments_2021-23.xlsx

    What You'll Accomplish

    Product instincts for designing data tools for non-technical users — translating the "Canva for data" vision into a concrete implementation decision

    Ability to build a working web app proof-of-concept under a real time constraint, with explicit reasoning about what you built and what you deferred

    Awareness of the gap between a proof-of-concept and production software — what would need to change before this could ship

    Genuine AI collaboration — using AI as a thinking partner with documented process, not as a code generator

    How Your Work Will Be Scored

    Engineering Execution — Delivers working code; names at least two explicit trade-offs; code structure reflects intentional decisions (28%)AI-Native Product Thinking — Makes at least one explicit UX decision referencing the non-technical user; explains why they chose this approach over alternatives (22%)Production & Data Mindset — Articulates the gap between the prototype and production; names what would break or change; if AI used, addresses data handling (22%)AI Fluency — Documents AI collaboration with specificity; answers the mandatory video question with a concrete example of redirection (28%)

    What to Submit

    Deliverable 1 — Your web app code

    Any FileRequired

    Format: no restrictions

    A working proof-of-concept demonstrating your chosen approach. This can be a single-file component, a small app, or a clearly structured set of files. It does not need to run against a live database — a mock or stub is acceptable if documented. Any stack is acceptable: use what lets you build fastest and show your thinking most clearly.

    Sign in to upload files

    Deliverable 2 — Your README

    DocumentRequired

    Format: .pdf, .doc, .docx, .rtf, .txt, .md

    Three things, in your own words:

    • The problem you set out to solve — what is the specific user pain you're addressing, and why did you choose this direction over the other directions you could have taken?
    • The tech and architectural choices you made — what did you build, how does it work, what did you explicitly defer, and what would you change in a production version?
    • Your AI usage log — for each significant AI interaction during the challenge, briefly note: what you asked, what it gave you, and what you kept, changed, or rejected. Three interactions is sufficient. This is not a trick — we want to see how you work with AI, not whether you used it.

    Sign in to upload files

    Deliverable 3 — Video walkthrough

    Video · 10–15 minutesRequired

    Format: .mp4, .mov, .webm

    Record your walkthrough as an MP4 or MOV file and upload it directly on the Provn platform.

    Your video should cover:

    • (60 seconds) Summary: The problem you chose to solve and why
    • (3–4 minutes) Code walkthrough: Walk through what you built, what you decided, and what you intentionally left out
    • (3–4 minutes) Product and production walkthrough: What does the user experience look like and why did you design it that way? What would need to change before this could go to production?
    • (1–2 minutes) Mandatory AI question: Walk me through one moment where you disagreed with, pushed back on, or redirected what the AI gave you — and what you did instead.
    • (30–60 seconds) Reflection: What would you build next? What would you do differently with more time?

    Speak naturally. Communication is assessed on clarity of technical ideas and logical structure — not verbal polish, accent, or filler words.

    Sign in to upload files