Data Explorer performs basic statistical analysis on a set of selected tables or columns from selected tables in one or more databases. It stores results from four types of analysis based on simplified versions of the Descriptive Statistics analyses:
- Values
- Statistics
- Frequency
- Histogram
An answer table is produced for each type of analysis, the output including requested table and column names to allow results from multiple tables to be included in each answer table.
Each analysis can be selected individually, with the following exceptions:
- If you select Frequency, you must select Values.
- If you select Histogram, you must select Values and Statistics, including the Count, Minimum, Maximum, Mean, and Standard Deviation.
Data Explorer includes intelligence about which functions should be performed on which columns, with decisions based on column type and on results obtained. It also includes performance enhancements resulting in minimal passes on the input data. You can also specify a separate SQL Where clause to apply to each of the input tables selected for analysis.