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
Related courses
- Hands-On Data Science using SQL, Tableau, Python, and Spark
- Advanced Tableau Desktop
- Complete Guide to Google BigQuery for Data and ML Engineers
- Artificial Intelligence Foundations: Getting Started with Intelligent Systems
- Hands-On SQL: Building Data Products in Dremio
- Mastering Business Intelligence with DAX, Power BI, and Excel by Microsoft Press
- SAP BI/BW: Project Design and Implementation
- Advanced MySQL Data Analysis
Related learn paths
- Hands-On Data Science
- Moving from Data Analyst to Data Scientist
- Master Digital Transformation
- Master Key Financial Analyst Skills
- Become a Data Analyst
- Introduction to Fundamental Skills for Data Work: Data Processing
- Introduction to Fundamental Skills for Data Work: Data Analysis and Interpretation
- Anaconda Python for Data Science Professional Certificate