Data structure
Output elements:
- Customers
- Stores
- Dates
- CurrencyExchanges
- Sales
- Orders & OrderRows (optional)
Data schema (Sales version):
Data schema (Orders & OrderRows version):
“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.