Details


Data structure

Output elements:

  • Customers
  • Stores
  • Dates
  • CurrencyExchanges
  • Sales
  • Orders & OrderRows (optional)

Data schema (Sales version):

Schema Sales

Data schema (Orders & OrderRows version):

Schema Sales

“Customers” is filled with fake, but realistic, customer data.

Pre-data-preparation: static data from SQLBI repository

The tool needs some files containing static data: fake customers, exchange rates, postal codes, etc. The files are cached under the “cache” folder specified as a parameter on the command line. The files not found in the cache folder are downloaded from a specific GitHub repository. In normal usage, if you reuse the same cache folder, the files are downloaded only on the first run.

After downloading, some files are processed to create a consistent set of fake customers. The output file, customersall.csv, is placed under the “cache” folder. If you delete it, it will be recreated on the following run.

Last update: Oct 13, 2024