Hands-On Data Science using SQL, Tableau, Python, and Spark
1h 14mIntermediate2024-03-05
Authors
Ben Sullins
Data Geek, Tech Consultant
Free the Data Academy
Data Analytics Training Company
Course details
Looking to expand your technical know-how on the world’s most widely used data science platforms? In this course, join instructor Ben Sullins of Free the Data Academy as he shows you how to build four distinct data science projects using SQL, Tableau, Python, and Spark. Get hands-on, professional practice analyzing employee data with SQL, building a sales dashboard in Tableau, conducting sales analysis in Python, and analyzing services in Spark. By the end of this course, you’ll be equipped with cutting-edge, highly sought-after skills to take your data science career to the next level.
Skills covered
TableauTableau SoftwareData Science FoundationsSQLData VisualizationDatabase AdministrationBusiness AnalyticsDatabase DevelopmentPythonDatabase ManagementData AnalysisProgramming LanguagesData ScienceBusiness Analysis and StrategyBusiness Software and ToolsOpen SourceSoftware DevelopmentOne-Off
Concepts
Introduction
- Welcome
- What you should know
- Getting started
Analyzing Employee Data with SQL
- Introduction and setup
- Employee data structure
- Querying employee data with SQL
Sales Dashboard in Tableau
- Tableau setup
- Exploring data visually in Tableau
- Building a dashboard
Sales Analysis in Python
- Setting up Python and Jupyter
- Working in pandas
- Aggregating data with pandas
- Creating data visualization in Python
Services Analysis in Spark
- Seting up Spark on Databricks
- Working with data in Spark
- Aggregating data in Spark
- Visualizing data in Spark
Conclusion
- Summary and next steps