Welcome to DataTile! To get started with your first crosstab, simply open any database, and you'll automatically be redirected to the Data Explorer (DeX) page. This is where you can begin working with tables and performing various operations.
You can kickstart your training by using our ready-made dummy datasets. These datasets are readily available to all registered users within our Sandbox.
For a quick and clear demonstration of how to create a crosstab, we recommend watching our short instructional video. It will guide you through the initial steps to help you get started seamlessly.
The short summary:
The default state of the Data Explorer interface is the Crosstab mode.
Short summary here:
Located on the left side of the screen, the codebook pane contains all the variables that you can utilize when creating crosstabs.
To fill the crosstab:
Create a new tab to start a request;
Select the variables you want to analyze from the codebook and add them to the crosstab by one of the methods:
simple drag&drop them onto the rows/columns of your table, choose ‘as list’ from the popup menu, and click ‘Calculate’;
to populate the rows double-click on the variable, to populate the columns - CTRL/CMD + double-click on the variable. In that case, the calculation is made automatically.
if you wish to change the variables in your rows, double-click on another variable and the system will automatically replace the rows in your crosstab. To replace the columns, CTRL/CMD + double-click on another variable.
Choose metrics you need to have in the crosstab. By default, it’s vertical %.
To add a significance test click on the ‘Sign’ button above the table. By default, DataTile applies a Z-test with a 5% confidence level to compare values against those in the Total column. Blue downward arrows indicate that the value is significantly lower than in the Total and red upward arrows indicate that the value is significantly higher.
After setting up your crosstab, you can further enhance your analysis by incorporating logical expressions, and mathematical operations. Building new requests remember to save your previous requests using decks. This way, you can easily return to them whenever needed.
When your first crosstab is ready you can also explore the exciting option of creating your first crosstab-based chart to visualize your data in a meaningful way.