The Data Explorer allows you to get a quick read on your data before you begin planning and designing your data models. Fast and agile, it allows you to easily explore the statistical distribution of field values in a data sample, as well as visualize the statistical relationship between values in different fields.
Step 1: Select the data
- To get started, identify the table in Devo that contains the data you want to explore. Alternatively, you can enter a more complex query by clicking Editor if you want to apply filters or enrich the data before analysis.
- Select the date range that you would like to analyze.
- Select from the options for data sampling that specify the number of rows to select and how to select them (random or otherwise).
- Click Run query to gather the sample. Click Reset if you wish to start over.
- While the data is loading you can cancel the query. You can still run the same query again after cancelation.
Step 2: Explore the data
When the sample data is gathered, the table's fields are grouped together on the left. You can choose to group them by data type or alphanumerically.
Select any field to view a chart that plots the distribution of its values in the selected data set. Hover over the chart groupings to display tooltips with group details.
The chart type depends on the data type of the field values.
- For fields with numerical data types, a histogram is drawn. Hover over it to get details about the minimum and maximum group values and the group's population. A summary table of statistics below the histogram reports the maximum and minimum values in the set along with the mean, medium, and standard deviation.
- For fields with categorical values, a bar chart is drawn. Hover over a bar to see how many records contain the field value. A summary table below reports the number of distinct values as well as the highest and lowest count value.