SQL for Data Analytics · AI in Data Analytics
AI in Data Analytics
This unit is about using AI in data analytics. AI tools can write a lot of SQL, which makes them useful in an analysis. Using them well takes skill.
The lessons:
- What the query misses (15 min). Five AI answers about a shop's orders, and what went wrong in the ones with problems. Then what a table leaves out, through a problem from the Second World War.
- AI in an analysis (14 min). Questions an AI asks about a coffee chain's sales, which you answer before you've seen the data. Then how to direct an AI in each step of an analysis, and why you're still learning SQL.
- A mistake Claude made (5 min). A time an AI misread the video game sales data while I was building this course.
The practice for this unit is three questions where you check an AI's answer about Northwind. This week's main assignment is the midterm review, which is on the midterm check-in page. There's also a page on how the midterm check-in works.