High school project idea · Technology & AI

Turn Messy Data Into a Live Dashboard

Take a spreadsheet no one trusts and turn it into a clean tool people can use to see what is happening now.

Partner with a real or realistic data owner to clean, structure, update, visualize, and document a small operational dataset.

Original Compass project by Davisville LabsReviewed August 2026Goal real work, evidence, and reflectionEditorial standards →

Why this project matters

Learn by doing something real.

Partner with a real or realistic data owner to clean, structure, update, visualize, and document a small operational dataset. This project feels different from a school assignment because the student serves a team or community group making recurring decisions from data, creates something visible, tests it honestly, responds to feedback, and explains the decisions behind the final result.

What you will create

Your project plan

Use these deliverables as milestones for Turn Messy Data Into a Live Dashboard. Adapt the details to your interests, available time, and real-world opportunities.

  1. 01

    User, data, and risk requirements

    Research decision needs, data ownership, schema, missing values, duplicates, update process, privacy, metric definitions, latency, and user interpretation. Document the needs, constraints, credible sources, and perspectives of a team or community group making recurring decisions from data.

  2. 02

    Technical architecture and test plan

    Turn the evidence into a focused plan for the live operational data dashboard, including success criteria, ethical boundaries, scope, and a realistic path to completion.

  3. 03

    Working product or prototype

    Create the first complete version of the live operational data dashboard. Include a stakeholder question brief, data dictionary, cleaning pipeline, validated dataset, dashboard, update workflow, quality checks, methodology, and owner guide.

  4. 04

    Reliability and usability test log

    ask users to complete recurring decisions with the dashboard, introduce messy new records, and test update reliability and misunderstanding Record what happened, what failed, what users or reviewers said, and which changes you made.

  5. 05

    Final technology case study

    Publish the final live operational data dashboard with a portfolio-ready case study showing the challenge, evidence, process, revisions, results, limits, and next version.

Make the work stronger

What separates a finished project from a meaningful one?

For Turn Messy Data Into a Live Dashboard, use these checkpoints to protect the quality of the work without turning the project into a performance for admissions.

Avoid this

  • Starting the live operational data dashboard before understanding a team or community group making recurring decisions from data
  • Treating assumptions or internet opinions as real evidence
  • Choosing a scope too large to test and finish with care

Evidence that it is working

  • The audience and real problem are clearly defined
  • Research and evidence are documented
  • A working live operational data dashboard was created

If you want to go further

  • Test the work with at least five additional people from a team or community group making recurring decisions from data
  • Interview a professional connected to Data Engineering and compare their advice with your approach

Skills you can build

Capabilities that travel beyond this project.

Data EngineeringDashboard DesignData GovernanceTechnical Problem SolvingResponsible Technology

College application value

Use the project as evidence, not decoration.

Can demonstrate initiative, curiosity, reflection, and growth through the student’s choices, response to setbacks, work with a team or community group making recurring decisions from data, and development of Data Engineering, Dashboard Design, and Data Governance.

Technical CuriosityProblem SolvingCreativityIterationResponsible Innovation

The goal of Turn Messy Data Into a Live Dashboard is not to manufacture an impressive activity. Do real work, keep evidence of the process, and reflect honestly on what changed.

Related college majors

Which fields connect to this work?

Use Turn Messy Data Into a Live Dashboard as a clue, then open a related major guide to compare coursework, career directions, reality checks, and other ways to test the field.

How this guide was made

Turn Messy Data Into a Live Dashboard is an original Compass educational starting point designed around real work, visible evidence, feedback, and reflection. It is not an admissions guarantee.

Read editorial standards →
Ready to build it?

Turn this idea into a step-by-step Compass project.

Try this project in Compass