In the Dimension section, create a hierarchy for Category and Sub-Category.
Exercise: Use Tableau sample data source Sample- Superstore.xls located under \My Tableau Repository\Data sources. Use the Orders datasheet and prepare data for dashboarding. Refer to downloaded workbook – Review Dimensions and Measures.
A TDS file stores the data source connection information. Developers can connect to the TDS file to get the data source details. TDS file is created by right-clicking on the data source and selecting “Add to Saved Data Sources”
TDS file is in XML format and contains the following information
Data Source Type.
Data Source connection details such as Server, Port, Location of local files.
Joins, tables joined and type of join.
Default field properties such as number formats, aggregation, and sort Order.
Exercise: Use the file you have created in the previous section and save the data source .TDS file under \My Tableau Repository\Data sources. Navigate to the above path and open .Tds file and review it in a notepad.