From the course: Hands-On Data Science using SQL, Tableau, Python, and Spark
Join today to access over 24,800 courses taught by industry experts.
Querying employee data with SQL
From the course: Hands-On Data Science using SQL, Tableau, Python, and Spark
Querying employee data with SQL
- Now that we have our data loaded into data.world, it's time to start to query it and explore our employee data. So here in data.world, I have my employees project, and you can just jump over to this if you'd like, or you can follow along and do it on your own project. And we have our two data sets, our dates and our employee's table. Now if we want to run a query, we can simply click on the little three ellipse here and say Query. This is going to give me a basic Select Star statement. So if I run this, it'll just give me everything in the table and we can kind of see again, the unique thing about the employee's data, our start and end dates and our status. So you can kind of see exactly what's going on with all the different employees and as they change over time, that slowly changing dimension. Okay, so the first question that we often get asked in this type of analysis on the people team as it's called now, are how many people started by a given day. And I'm going to walk you…
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.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.