Exploratory Data Analysis in SQL for Absolute Beginners
Key Takeaways:- How to use SQL to manipulate data and calculate summary statistics.
- How to use Workspace no-code visualizations to draw plots.
- How exploratory data analysis is used to get insights about your data
Description
In this live codealong, you will be introduced to the basics of exploring new datasets using SQL. This session explores data on climate change adaptations in the water industry in Africa. You will calculate summary statistics and draw visualizations to generate insights. After the codealong, you will get access to a solution notebook to use as a future reference!
We will be using DataCamp Workspace. All you need is a DataCamp account. If you need help, read the Getting Started with Workspace tutorial. Note that members of some enterprise groups do not yet have access to use DataCamp Workspace. Create a free DataCamp account with your personal email address to follow along.
Additional resources:
- Dataset
- Paper
- Related track: Data Analyst in SQL
- Related cheat sheet: SQL Basics cheat sheet
Presenter Bio
Jasmin is a Content Developer at DataCamp. After ten years as a global marketing manager in the music industry, she recently changed careers to follow her curiosity for data. Her passion is value exchange and making data science accessible to all.