For a hands-on learning experience to develop LLM applications, join our LLM Bootcamp today.
First 3 seats get a 10% discount! So hurry up!
  • 7 December 2022
Data Science

A Crash Course on Data Wrangling using SQL

Agenda

Data wrangling is the art of bringing data together and preparing it for analysis. It is often the most time-consuming aspect of an analytics project. A survey of analysts found that almost half of their time is spent wrangling data. Part of the complication is that analysts have several tools and languages at their disposal, making it difficult to understand which one is the right one for their data-wrangling needs.

Though this crash course focuses on data wrangling with SQL, it will build a foundation for transforming data as you develop your analytics skills. It is intended for beginners with little to no prior experience in SQL. By the end of the session, you will know:

  • How to query a dataset
  • How to join the data
  • How to append data
  • How to apply a filter to your datasets
  • How to create new data fields
Selma Dogic
Selma Dogic

Manager – Analytics COE & Strategy at Carters

Selma leads Carter’s Analytics Center of Excellence. She works with business teams to drive insights and tell data stories more effectively. She serves as the data translator and works to bridge the gaps between IT and business analytics. Selma has been a part of data science teams at both The Home Depot and NCR. Prior to that, Selma worked in state and local consulting. She received a Master’s in Economics from the Georgia Institute of Technology (Georgia Tech). Selma served as one of GeorgiaForward’s Young Gamechangers. In 2018 she received NCR’s CFO Excellence award.

Resources

GitHub Repository with Data

DataCamp SQL Basics Cheat Sheet

SQL Tutorial Cheat Sheet

Training
Enterprise
Community
About
X-twitter
© Copyright – Data Science Dojo | Privacy Policy | Terms of Service