Join Dan Sullivan for an in-depth discussion in this video Next steps, part of SQL for Exploratory Data Analysis Essential Training.
- [Instructor] Let's discuss some tips…for exploring your data.…Data exploration is an important step…in the data science process.…It's used to help understand the quality of data.…This is important, before you start to make hypotheses,…and draw conclusions from your data.…It's used to identify missing values,…which can happen if there are data quality control programs,…with the source systems that supply your data.…It also helps us find unusual, or unexpected values,…such as outliers, that don't make sense…from a business logic perspective.…
Data exploration helps highlight inconsistent data,…especially with regards to business rules.…It also allows us to understand…the distribution of the data,…that is, the shape of the data,…and understand subgroups, using histograms.…And correlations allow us to see relationships…between variables, when we use…the Pearson's Correlation Coefficient.…Exploratory data analysis, is a starting point,…that helps you understand your data,…and avoid potential problems in data analysis,…
Author
Dan Sullivan
Released
6/7/2018- Exploratory data analysis vs. hypothesis-driven statistical analysis
- Performing data quality checks
- Calculating quartiles
- Using box plot to understand the distribution of values
- Using histograms to understand the frequency of values
- Using chi square to understand the correlation between values
Skill Level Beginner
Duration
Views
-
Introduction
-
Welcome54s
-
-
1. Introduction to Exploratory Data Analysis
-
Why explore data?1m 28s
-
-
2. Data Quality Checks
-
Why check data?2m 56s
-
Types of quality checks2m 53s
-
Imputing missing values2m 53s
-
-
3. Calculating Quartiles
-
Ordering and counting2m 22s
-
Calculating quartiles1m 51s
-
Introduction to box plots2m 28s
-
4. Histograms
-
Introduction to histograms1m 50s
-
Partitioning data2m 5s
-
Calculating histograms1m 12s
-
-
5. Checking Correlation between Attributes
-
Introduction to correlation1m 41s
-
-
Conclusion
-
Next steps1m 9s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Next steps