Open Data·Open Metrics
Open Data Waterloo Region · Note

Dashboard Mock Data Generator: Design Against Numbers That Behave Like Real Ones

July 30, 2026 · Uncategorized

Build a dashboard against a table of zeros and it will lie to you. The chart looks tidy, the layout holds, every tile fits, and then real numbers arrive and the whole thing buckles. A revenue figure runs seven digits and breaks the column. A quiet Sunday leaves a gap the axis was not built for. The design that looked finished was only finished for data that never behaves like the real thing. This dashboard mock data generator fixes the root cause: it builds believable daily rows, with a trend, weekend dips, and the ordinary jitter of a real business, so you can design against numbers that move the way yours will.

DateSessionsSignupsRevenue

CSV

JSON

Everything runs in your browser. Each click makes a fresh random set, so regenerate until the shape feels right, then copy the format you need. The columns are date, sessions, signups, and revenue, the four a sales or marketing board almost always leans on.

The generator is the shortcut. The rest of this is why designing against realistic data changes what you build, and what makes a sample set worth trusting.

Why empty and flat data both lie

Two kinds of fake data get people into trouble. Empty data hides every problem, because a dashboard with nothing in it looks calm no matter how it is built. Flat data is worse, because it looks like real data while behaving like nothing real ever does. A line that climbs by exactly the same amount every day tells you nothing about how the chart handles a bad week. A revenue column where every row is a round hundred never tests whether the layout survives a five-figure day sitting next to a two-figure one. You end up shipping a board that was only ever tested against the one situation your business will never actually be in.

What makes sample data believable

Real business data carries three things at once, and this tool bakes all three in. Start with the trend, a slow upward drift the eye can read across the whole range. Layer in a rhythm, most obviously the weekend dip that shows up in almost any business people touch on work days, which the checkbox lets you switch on or off. Then the noise, the day-to-day jitter that keeps two Tuesdays from ever being identical. Strip any one of those out and the data reads as fake to anyone who has stared at the real thing. Put all three together and a stakeholder glancing at your mockup cannot tell it from a live feed, which is exactly the point during design and review.

How the mock data generator builds each column

The output is deliberately narrow: date, sessions, signups, and revenue. They are not independent columns of random noise, they follow the shape of a real funnel. Sessions come first, from the daily baseline you set. Signups are a slice of those sessions at the conversion rate you choose, so they rise and fall with traffic instead of drifting on their own. Revenue follows from signups at your average order value. Because the chain holds, the numbers stay internally honest: a big traffic day produces more signups and more revenue, just as it would in your own reporting. If you want the meaning behind each of those figures and the formulas that turn them into rates, the companion dashboard metrics calculator walks through every one.

CSV or JSON, and where each one goes

Two formats cover almost everything you would do with a sample set. CSV drops straight into a spreadsheet or a BI import, so you can pivot it, chart it, or hand it to a tool that expects a flat file. JSON is what you paste into a front-end build, a charting library, or a quick prototype where the data needs to arrive as objects your code can loop over. Generate once, copy whichever the next tool expects, and you have skipped the half hour usually spent hand-typing believable rows into a fixture file.

From sample rows to a working board

Sample data is most useful when the board it feeds is already built, so you are testing the design rather than inventing it. That is the case for starting from a layout that already has the tiles and charts wired up: a set of templates that ship with sample data wired in lets you swap this generator’s output straight into a working structure and watch how it holds under a spiky week, a slow month, or a revenue figure three digits longer than the design expected. Once the layout survives realistic data, the principles in the guide on dashboard design are what take it from working to genuinely readable. Design against numbers that behave like yours, and the board you ship will not flinch when the real ones show up.

← All community notes