Sample dataset

A new DataMind OS installation includes a sample dataset for first reports: six Warehouse tables that carry a fictional business-to-business sales story, with a semantic model and a report already built on them. Use it to try DataPrism before your own data is modelled.

What the sample dataset contains

The six tables are Static tables, grouped by the DataPrism Template Report logical model, and their names carry a BI prefix.

TableWhat it holds
Bi Dim ChannelThe five channels orders arrive through: Direct Sales, Online, Partner, Reseller and Marketplace.
BI Dim Customer200 fictional customer companies, each with a segment, an industry and a country.
BI Dim DateOne row per day from 2025-01-01 to 2026-07-31, for time slicing and year-over-year comparisons.
BI Dim Product41 products with a category, a subcategory, a brand and a price.
BI Dim Sales Rep20 sales reps in the teams Alpha, Beta and Gamma, 18 of them active.
BI Fact SalesInvoice line items that connect a customer, a product, a rep and an order date, with quantities, prices and discounts.

On top of the tables sit the sample semantic model, DataPrism Default Semantic Model, and its report, DataPrism Default Reports, whose pages cover an overview, products, the sales team and year-over-year trends. The model's owner role is the admin role.

To build your own first report from a table, follow From a table to a shared report; Concepts and glossary explains the terms.

What the data looks like

Keep the sample tables paired

The sample semantic model and its report match the six tables by name, so renaming a table breaks that pairing.

Warning

Do not rename the sample tables. If you need a table under a different name, create a new table instead of renaming a sample one.

Limits and edge cases

Questions, answered

Can I rename a sample table?

No. The sample semantic model and its report pair with the tables by name, and a rename breaks that pairing. Keep the six names as they are, or create a table of your own for your own data.

Can I delete the sample dataset?

Yes, with your usual Warehouse and DataPrism permissions. The sample is created once and not recreated later, so a deleted sample stays gone.

Is the sample data real?

No. All of it is fictional: the companies, people, products and invoices are invented for demonstration.

What is the DataPrism Template Report?

It is the logical model that groups the six sample tables in the Warehouse. The sample semantic model and its report are built on those tables.

What period does the sample cover?

Orders run from 2025-01-01 to 2026-07-31, and the calendar table holds one row per day for the same period.

Why does the sample report show busy quarters and quiet weekends?

The data follows a built-in rhythm: the fourth quarter is the busiest, July and August are quieter, and weekends see the fewest orders. The pattern is deliberate.

Can I build my own reports on the sample tables?

Yes, within your permissions: they are ordinary Static tables, so a semantic model of your own can use them as BI tables. From a table to a shared report walks through the flow.

Why can't I see the sample dataset?

Two causes are common. The sample tables carry the admin permission group, so a role outside the admin group reaches them only after an administrator adds that role to the tables' permission groups, as for any Warehouse table. And an installation that already had tables with the six names when it was set up does not get the sample at all.

Why don't the sample tables appear under Dimension and Fact in the Warehouse?

All six are Static tables in Warehouse terms. Their names describe the roles they play in the sample star schema: five dimensions around one fact. See Static tables for that kind of table.