|Datasets prepared in a single worksheet (Aka "Flat")
|Datasets prepared in Knoema’s house style (Aka "Regular"/"KNox")
|A flat dataset is equivalent to a pivot table.
All data are in one worksheet. Details and an example are here.
|Data and metadata are spread across multiple Excel worksheets in a specific format. Details and an example are here.
|Typically simpler and faster to prepare because there is only one tab.
|Requires a special file format that contains at least 3 sheets to define dataset structure. With practice this becomes more intuitive!
|We strongly recommend using the Custom upload settings following upload in the UI to verify all metadata.
|All metadata should be clearly labeled in the file, so custom upload settings are not necessary.
|Dimension members order
|Dimension members are always alphabetized
|Can be ordered.
On-the-fly aggregation options, e.g., aggregations across dimensions and averages and counts.
Transformations may be available.
Note: Please check with your system administrator to see if transformations are applied to your system.
|Display non-numeric data
Able to display details and non-numeric data in maps, geo playground, and in grid form.