Modern Data Analyst: SQL, Python & ChatGPT for Data Analysis
Modern Data Analyst: SQL, Python & ChatGPT for Data Analysis
Data Analyst Course: SQL, Python, NumPy, Pandas, Data Visualization, Cleaning and ChatGPT
Created by Frank Andrade, Cristopher Kevin Gargate Osorio | 20.5 hours on-demand video course
Welcome to Modern Data Analyst: SQL, Python & ChatGPT for Data Analysis Course. The role of the data analyst has evolved and now it’s not enough to know Excel to be a data analyst. In this course, we will learn how to use SQL, Python & ChatGPT for Data Analysis.
First, we’ll learn SQL from scratch. SQL is a programming language that will help us work with data. We’ll use a free database for this course: MySQL. Here are some of the SQL concepts this course covers.
- Basic SQL commands and clauses (SELECT FROM, WHERE, INSERT, HAVING, UPDATE, etc)
- Aggregate functions with GROUP BY commands
- SQL Joins
- Logical operators
- Subqueries. temporary tables, rank, etc
- Projects, exercises, and more!
Then we’ll learn Python from zero. Python is used for data analysts to collect data, explore data, and make visualizations. Here’s what the Python section covers.
- Python Crash Course: We’ll learn all the Python core concepts such as variables, lists, dictionaries, and more.
- Python for Data Analysis: We’ll learn Python libraries used for data analysis such as Pandas and Numpy. We’ll use them to do data analysis tasks such as cleaning and preparing data.
- Python for Data Visualization: We’ll learn how to make visualizations with Pandas.
Finally, we’ll learn ChatGPT for data analysis. We’ll learn how to use ChatGPT’s code interpreter to analyze data, extract data from websites, automate Excel reports, and more.
What you’ll learn
- Learn SQL to create queries and work with databases
- Learn Python to collect data, explore data and make visualizations
- How to use ChatGPT for data analysis
- Exercises and data analysis projects
Recommended Course
Data Lake Mastery: The Key to Big Data & Data Engineering Hot & NEW
The Data Science Course: Complete Data Science Bootcamp 2024 Best seller
Data Analyst Skillpath: Zero to Hero in Excel, SQL & Python
Data Analysis with ChatGPT in Excel
Who this course is for:
- Anyone who wants to become a data analyst
- Excel analysts who want to learn more powerful tools like SQL, Python
- Anyone who wants to learn ChatGPT for data analysis
