PhraseryPhrasery homeGet Phrasery
Data & SQL21 categories

Choose the shape for this report's data

Deciding between wide, long, or pre-aggregated before you build anything.

Longmodellingreportingdesign
Help me choose the data shape for the report described below.

Compare at least three options, which may include: a long or tidy table with one row per entity-metric-period, a wide table with one column per metric, a pre-aggregated summary table, and querying the raw source live.

For each, state:
- What one row represents
- Which questions become easy and which become awkward
- What happens when a new metric or dimension is added
- Storage and refresh cost
- How it behaves when a historical figure is restated

Then recommend one and say what would have to change for your answer to flip. Do not give me a balanced comparison with no conclusion.

Report and its audience:
Questions it must answer:
Update frequency and data volume:

Making it yours

  • Paste your own material where the prompt asks for it. Everything above that line is instruction, not content.
  • Delete any rule that does not apply to you. A shorter prompt that fits beats a thorough one that does not.
  • If the answer comes back vague, add a line saying what you do not want. Constraints work better than encouragement.

Schema and data quality. Designing tables, migrating them without breaking live code, and cleaning what you have been handed.

Related prompts

Review this schema designBefore you create the tables everyone will depend on for years.Write data quality checks for this tableBefore you trust a table you've just been handed.Write a safe migration for this changeChanging a schema that live code is already reading and writing.Plan the cleanup of a messy columnFree-text data that half-works and needs to become reliable.Explain this query to me line by lineYou inherited a 200-line query and need to understand it before changing it.Make this slow query fasterA query that used to be fine now takes minutes.

Keep this one

Phrasery saves prompts with a right-click and puts them back the same way. Add this to your own library in one click.

Add to your browser — free