Sample Data Maker
Show what you built without showing real data. Mask a spreadsheet so names, IDs, numbers and dates are fake but still match across sheets and files, or make a sample model for an industry as DAX functions you paste into Power BI. No AI needed.
What do you want to do?
Everything happens in this page. Your files are never uploaded or saved.
Load your files
Every sheet is a table, with its column names in the first row. Load every file that shares keys at the same time, so the links can be kept.
Check each column
The page guessed what each column holds. Change any that are wrong. Keep as is is right for things that aren’t private, such as categories, regions or status.
What each choice does
- Fake ID: digits and letters are swapped, the shape and any shared start (such as
CUST-) stay. Each ID gets its own fake one. - Person name, Company name, City, Street address, Phone: made-up values. The same original always gets the same fake value, in every file.
- Email: built from the fake person name in the same row when there is one, at example.com.
- Numbered labels: each different value becomes the column name and a number, such as Product 12.
- Scale numbers: the whole column is multiplied by a hidden factor, with a little noise per value, so totals and trends keep their shape. Totals that should add up across columns won’t exactly.
- Shift dates: every date in every file moves by the same hidden number of whole weeks, so weekdays, gaps and seasons stay true.
Links between tables
Linked columns get the same fake values, so a key in one sheet still finds its row in another. These were found from matching values. Untick any that aren’t real links.
Check and download
Each file you loaded comes back as an .xlsx with the same sheets and columns. Values only: formulas, charts and pivot tables aren’t copied.
The same seed and the same files give the same fake values every time. Keep the seed to yourself: with it and your real files, someone could work out the hidden factor and date shift.
Pick one or more industries
Each one comes with the tables and measures that industry usually reports on, plus a date table. Pick more than one to put them in one model.
Sizes and dates
Rows per table, and the dates the data covers. The date table runs in whole years.
_Measures table, in a folder for each table
Preview
The first rows of each table, as Power BI will build them.
Columns and measures
Add it to Power BI
One TMDL script adds every table, relationship and measure.
Tables with the same names are replaced. Change the seed for different rows with the same shape.