4 mins video tour
The same but in text and details
DATATILE crosstabing interface is an intuitive instrument that is used for all variety of data types. Small ad-hoc studies, global trackers with millions of interviews or retail data are handled universally.
It has 9 main zones or components (see the picture below). Please note that interface could look slightly different for different data sets according to their settings.
Variables tree (1)
All metadata is available in the hierarchy on the left panel.
DATATILE supports following main types of variables:
- Categorical – correspond to questions with a single choice.
- MR-groups –Multi Response group. Reflect questions with multiple answer options.
- Numeric variables – actual numeric values. For example, «Age» or «Price of the purchase» etc.
- Dates – calendar dates. For example, «Date of birth».
- Text - open-ended questions.
For your convenience, types of variables are indicated with relevant icons as shown below.
Feel free to use full text search on top of left panel.
Click on the variable and you will see its content.
You can create ad hoc intervals for Numeric and Date variables. E.g. numeric variable Age provides more flexibility than predefined categorical "Age groups".
Drop-zones (2, 3, 6, 7, 8)
Drag a variable to build a query. Once you drag a variable from left panel, acceptable drop zones will be highlighted.
There are 5 drop-zones on cosstab query builder:
- Rows (2) and columns (3) of the crosstab;
- FILTER zone (6);
- SPLIT BY zone (7);
- VALUE zone (8).
The following items are located on the toolbar (from left to right)
- «Calculate»– calculates a query.
- Table/Chart – use it to switch between the table and its chart representation.
- Drop-down menu with icon is for exporting the table or chart you have to Excel or PowerPoint. In the same submenu there may be other options like automated reports or documents attached to the data set.
- «Star» icon is for bookmarks. You can build and save any query as a named bookmark.
- «Weight» (W) - This button allows you to apply a weighting factor to a query. Appears if there're weights declared in the database.
- Trimming – performs «trimming» of zero data from the calculated table.
- - publishes table or chart on a dashboard.
- Share opens sharing dialog for the current data set.
- Settings button redirects to the back office of the current data set.
Statistical metrics (4)
These are majority of metrics supported by DATATILE:
Some metrics are contextual and become available only in the context of the respective data types. E.g. retail-audit, aggregated data, rotated data sets.
Switch on/of metrics to extend query.
Metrics from left to the right:
- Aff.idx – Affinity Index
- Aff.idx (Unfiltered) – same as Affinity Index, but calculated without applied filter.
- Avg – Average. For non-numeric variables, the digital equivalents of categories are used.
- Base% - percent of respondents in the cell to Total in the crosstab.
- Count – the number of respondents in the cell.
- Horiz% - Horizontal percentage - percent of respondents in the cell to the Total value in the line.
- Vert% - Vertical percentage - percent of respondents in the cells among the total number in the column.
- VertBase – Vertical base - the number of not-sysmis values for the variable sitting in the column in raw data.
- HorizBase – Horizontal base - the number of not-sysmis values for the variable sitting in the row of the crosstab.
- Base – vertical sampling base without weighting, coincides with the usual vertical base for unweighted queries.
- Vol – Volume. This is the sum of the numeric values in the cell. This metric can be considered as Count - only instead of 1, as in Count, an equivalent numeric value is substituted.
- Vert SOV – Vertical Share of Voice – Vol in the cell divided by Total Vol for the column.
- Horiz SOV – Horizontal Share of Voice – Vol in the cell divided by Total Vol for the row.
There are 3-4 metrics that are most commonly used in the project - for example, Vert%, Count, Base. Owner of the data set can hide, rename or reorder metrics in settings of the data set.
Query settings (5)
Directly above the crosstable you will see the query modification tools.
From the left to the right:
- Totals: Columns/Rows – adds, respectively, the first column and the row in the table with the Total values.
- Sgn – enables an indication of significance.
- МА – Moving Average - this functionality is used on trends. When this button is active, the number of columns for which averaging is performed is indicated (averaging is set up in the raw data and not in the table results).
- TOP – limits the calculation results by specified number of rows in the table. When you enable this button, you will see a field for a line number specification.
- CALC –is an arithmetic calculator that allows you to set a formula for calculating new rows and columns based on existing ones.
Building a data query
To build a query for your data, you need to drag variables from the left panel and drop to one or both sides of the crosstab. If necessary, specify a FILTER and a SPLIT BY.
Selected area is always highlighted blue.
Note that you can drag a variable as a whole or contained features inside it.
Use indicated buttons next to the drop zones (see circled icons on the picture below) to removed its content.
Once you are done, press CALCULATE to process the analysis.
DATATILE in addition to simple features can apply logical expressions of any complexity to filter or any row or column of the crosstab.
Click inside filter drop zone or on the right side of a column/row header in the crosstab to open Logical Expression Builder.
You can build logical expressions by dragging features from left panel on top of another features in the window of the builder.
See the animation below.
Press CHART button to visualize the table you have on a chart.
You can always get back from chart to your crosstab by clicking on TABLE.