The “Data Modeler” option is for more advanced use – including combining data from multiple sources – and is not covered in this manual.
In the following, in the demo description as well as in the exercises for this lesson, we will be using a couple of Sample Excel files. These file scan be downloaded from the TARGIT Portal, http://portal.targit.com, in this section:
• Download and Support / Download Center / Other Downloads / TARGIT University.
• The zipped file is called “TFUN Excel sheets for Data Service lesson”.
If we have a look at the DSDemoSheet.xlsx file, we will see a typical extract from a database in a format that adheres to the required format for Data Service. This file contains approximately 4200 rows across 30 columns.
• Rows: Each row represent a single transaction.
• Columns: The columns represent the information that has been logged for each transaction. Data Service will read the content and data types of these columns to automatically detect if they are to be used as measures and/or dimensions.
Notice the Date columns: Posting date, Document date and Shipment date columns. They all contain a full date, and the Cell data type has also been set to “Date”. This will ensure that Data Service reads dates correctly and furthermore create correct Time hierarchies from these.