Hands-On Data Science: 1 Analyzing Employee Data with SQL
45mIntermediate2021-08-30
Authors

Ben Sullins
Data Geek, Tech Consultant
Free the Data Academy
Data Analytics Training Company
Course details
If you’re interested in working in the field of data or looking to advance in the field, you need a foundational knowledge of several key areas of data science. Not only that, you need to be able to demonstrate that knowledge. In this four-part, hands-on series, Ben Sullins shows how to build four distinct data science projects using SQL, Tableau, Python, and Spark. In this first installment, Ben uses SQL to analyze employee data, which is notoriously difficult to analyze given its structure. He breaks down the specific structure of employee data, and the best way to track this kind of information, then covers how you can start answering specific questions utilizing SQL. Finally, he gives advice on how to present your data, considering both your audience and the visuals you use, in order to convey your knowledge of the subject.
Skills covered
Apache SparkTableauTableau SoftwareApacheSQLDatabase AdministrationDatabase DevelopmentPythonDatabase ManagementProjectData AnalysisProgramming LanguagesData ScienceBusiness Analysis and StrategyBusiness Software and ToolsOpen SourceSoftware Development
Concepts
0. Introduction
- 01 - Welcome to hands-on data science
1. Hands-On Data Science
- 02 - How to use this course
- 03 - What you will learn
2. Analyzing Employee Data with SQL
- 04 - Introduction and setup
- 05 - Employee data structure
- 06 - Querying employee data with SQL
- 07 - Presenting your analysis