From the course: Data Analysis: Investigate with SQL
Unlock the full course today
Join today to access over 24,800 courses taught by industry experts.
Solving the case with data-driven insights - SQL Tutorial
From the course: Data Analysis: Investigate with SQL
Solving the case with data-driven insights
- Welcome to the final step of our analytical journey. In the last video, we refined our query results and zeroed in on the text messages sent by the people we identified on our short list of suspects. What we're about to do in this video is called manual analysis, which will clue us in to any additional evidence that pinpoints who stole the painting. If you recall, we did a bit of this earlier when we composed our list of suspects. Now we're about to do it once again. So if you're not already there, head on back to query number five in the WSDA SQL editor. Are you with me? Okay. Our focus here is on the results that our query produced. Let's shrink our query writing area so we can see more of the records. Our results here are the text messages that were sent between October 25th by the people we have identified on our list of suspects. So we're going to step through each record, keeping our eye…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.