Unit - Start | - Importing SOLUTION: Training examples
- Exporting Solutions
- Add new data node
- Naming of nodes (see Wiki: „TIS:Benennung_von_Knoten")
- HTML-Formatting (Wiki: „TIS:HTML-Formatierung")
- Conversions– why (Convert From Date/From-Time/To-Time)
- Node references (create and change), hide, show, and change details work with node A00
- Add operations
- Sum on days and weeks (Sum and count)
- Chart „Histogram Time Pattern", formatting the chart
| - change time scale in chart
- different sum interval in new node
- Different sum rule (i.e. start time in interval)
|
Unit II | - Get familiar with the data data from A01
- Scaling node working time
- Pivot table time x weekdays
- Chart „Histogram time pattern"
- Set reference to node A00
- Link to calendar
- Pivot table time x weekdays
- Deactivate / activate operations
| - Set reference to node A01
- Analyse the new data (is it possible?)
|
Unit III | - Create new folder B03, and new node B03_01
- Data management on server / local installation
- Data management on server & prepare import data (txt, csv)
- ... Download a node into EXCEL, save a *.txt file on your desktop, upload it to data management & import it with import CSV operator
- Understand the implications of zero-values, empty data fields, and value „0"
- … Difference 0 & missing value.
- … When you import data with the "Import CSV operator" there are different options to deal with missing values
- Create new node B03_02
- Connect with „General Calendar"
- Scale data
- Create new node B03_03
- Scale data
- Connect with „General calendar"
| - Find difference between B03_02 and B03_03
- Explain the differences
|
Unit IV | - Create new folder B04 and new node B04_01 – based on A01
- Create new column with „General calendar" containing „year, calendar week"
- Create new column with „General calendar" containing „weekday"
- Create auxiliary calendar date with „Formula operator"
- … System.DateTime.ParseExact("20080225","yyyyMMdd",null)
- Create new node B04_02
- „Formula operator (row-by-row)": write field with given value in calendar date format
- „Formula operator (row-by-row)": extract part of a text field;
- convert a number in text format into number format; add a given number of days to a field in calendar date format; „Formula operator (row-by-row)":
add a given number of hours, minutes, and seconds to a field in calendar date format, create column „To_Aux" with „#From_Aux#.AddTicks((#To#-#From#).Ticks)" - Operator „Sort rows"
- Operator „Delete columns"
- Operator „Chart: 2D map (Start table list)
| - Rename, reorder and delete columns
- Manage number of identifiers
|
