课程: Hands-On Data Science using SQL, Tableau, Python, and Spark

免费学习该课程！

今天就开通帐号，24,700 门业界名师课程任您挑！

Querying employee data with SQL

Querying employee data with SQL

课程: 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…

内容