Hands-On Data Science: 1 Analyzing Employee Data with SQL

Hands-On Data Science: 1 Analyzing Employee Data with SQL

45mIntermediate2021-08-30

Authors

Ben Sullins

Ben Sullins

Data Geek, Tech Consultant

Free the Data Academy

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
40,000 Toman