Exploratory data analysis in Alteryx and surfacing the datasets for BI tools
To extract value from your dataset, you need to perform Exploratory Data Analysis (EDA). EDA is the process of finding patterns and anomalies in your dataset. It is also a method for testing any assumptions or hypotheses you may have. Typically, you will create visualizations to find the insight and confirm the assumptions and hypotheses. You can also create statistical summary tables to get an overview and general understanding of the metrics in your data.
A general process for EDA would cover the following areas:
- Identifying whether any fields are missing values and summarizing their properties
- Understanding the distribution of the fields in your dataset
- Finding any significant relationships between fields in your dataset
- Searching for any outlier values in your dataset
Each of these steps will explain what your data represents and provide a strong starting position for further...