Smart Data View: the Boosted Table
SDK aka Smart Data View
This is a boosted table view in our application. What does that mean? Beyond a simple table, you will find the most important information about your columns and the values. It shows the column name, data quality and type, minimum and maximum values, 80th percentile, and mini-charts. Clicking on the mini-chart, opens a larger view. Besides these attributes, the filters are also available in the smart data view and you can customize your spreadsheet easily.
Tip: Set filters and download your filtered spreadsheet in one click.
Columns Are Variable
To be more understandable, your columns are customizable. You can change the name, unit, and description of the column. Just click on the column name and type in your own description. Doing so will help you to identify the column later, and your colleagues will appreciate it as well. Additionally, you can change the icons at any time. More than 15.000 icons are available. The relation map uses the columns’ icons, so it is useful to change the similar ones to make them different.
Good to Know: If you upload an SPSS file, the app will automatically import your Label and Value fields and add them to the column descriptions. Additionally, if you hover your cursor over your logical field, you will see the description of your Label and Value.
Tip: Set eye-catching icons for your most important columns to find them quickly and easily.
If you are working with five or six columns, then it is very easy to compare one to another. However, what if you have 20, 70 or more than 100 columns? How can you compare the first column to the 24th and the 52nd columns? In the app, you can highlight the columns that you want to compare. You can also highlight the column names on the left sidebar. The selected columns will be pinned to the first places on your spreadsheet. If you pin four or more columns, only the picked columns will be visible, and the rest will be hidden.
Tip: If you switch between menus (Charts, Relation Map, and so on), the previously selected columns will be shown.
Sometimes, you have hundreds of columns and do not have time or are not in tune for searching the columns for hours to find what you need. The good news is that you can find your wanted columns in a second in the app. On the top of the left sidebar, you will find the search console. Type in the name of the column and select them by clicking on their names. You can give the exact name or just a part of it.
Always have a look at your data view and change what you need to change to improve your experience and make more precise analyses.