Mô tả

Leverage ChatGPT's Advanced Data Analysis Code Interpreter to outpace competitors in a rapidly evolving landscape.

Today, ChatGPT is the most exciting office productivity tool globally. Unsurprisingly, the demand for professionals navigating this software has been surging exponentially.

The Problem

It’s challenging to acquire practical skills that will teach you how to leverage ChatGPT and AI at work. Most ChatGPT courses focus on generic prompt engineering and cannot build the bridge between basic prompting and practical implementation that will boost your productivity on the job.

The Solution

This Data Analysis with ChatGPT course teaches you how to effectively utilize ChatGPT for data analysis throughout the entire data analysis lifecycle:

  • Exploratory Data Analysis (EDA)

  • Data preprocessing

  • Data analysis

  • Data visualization

  • Data interpretation

Each topic seamlessly builds upon the previous one, and the practical example that unfolds throughout the course allows you to see the bigger picture and understand how ChatGPT can help you in a real-world working environment.

Data Analysis with ChatGPT in Excel

Excel is the world’s most popular office productivity and data analysis tool. We’ll use Excel files to input data to ChatGPT and evaluate its output. The same principles apply if you use other tools like Python, R, Tableau, and Power BI for data analysis.

Why Take the Course?

A common social media statement declares, ‘’AI won’t replace you, but those embracing AI will,” underscoring the need to welcome change. Progress and new technologies are unstoppable, so we must adapt and boost productivity with available, effective tools

Prompt engineering in AI tools like ChatGPT shows remarkable promise in the data analysis field. Once you become familiar with its capabilities, you’ll appreciate that ChatGPT democratizes data analysis and makes it easier for individuals unfamiliar with Python or advanced Excel modeling. In the next few years, all productivity tools will rapidly shift towards AI.

Embrace AI-driven data analysis in your workplace as an early adopter with a 30-day money-back guarantee, transforming your career with sought-after skills.

So, what are you waiting for?

Enroll today, and let’s start this transformational journey together.

Bạn sẽ học được gì

Perform exploratory data analysis (EDA)

Audit datasets for erroneous data

Deal with inconsistent data

Organize messy data

Perform data analysis tasks

Yêu cầu

  • Access to ChatGPT Plus

Nội dung khoá học

9 sections

Course introduction

1 lectures
Intro to the course and quick demo of ChatGPT Advanced Data Analysis
02:40

Overview of ChatGPT Advanced Data Analysis

3 lectures
How ChatGPT Advanced Data Analysis will boost your productivity
02:06
Is ChatGPT Advanced Data Analysis the killer of the data science profession?
02:44
The limitations of ChatGPT Advanced Data Analysis
03:13

Exploratory Data Analysis (EDA) with ChatGPT

5 lectures
Exploratory data analysis - intro
03:47
Extracting descriptive statistics with ChatGPT
02:13
Identifying outliers
02:46
Correlation analysis: Hypothesis formulation and feature ideas
01:59
Crafting a comprehensive EDA prompt
09:03

Preprocess data with ChatGPT - Deal with inconsistent data

5 lectures
Identifying and handling erroneous data
03:19
Verifying data for errors
03:40
Eliminating duplicate rows
01:20
Addressing unit discrepancies in data
01:51
Dividing cell content into multiple cells
04:18

Preprocess data with ChatGPT - Organize messy data

4 lectures
Organize messy data
03:51
Data mapping
02:50
Effective data classification
02:16
Order data with ChatGPT
02:11

Preprocess data with ChatGPT - Working with functions

5 lectures
COUNTIFS, SUMIFS
02:33
Data lookup
02:47
Data ranking
02:49
Fill until non-blank values
02:59
Translating logic into Excel formulas with ChatGPT
02:06

Preprocess data with ChatGPT - Clean text data

7 lectures
Correcting inverted names
01:43
Dealing with trailing and leading spaces in text data
01:55
Standardizing letter capitalization
01:50
Handling multi-lingual text data
03:27
Multiple "Find and Replace" at the same time with ChatGPT
02:35
Criteria-based duplicate removal
02:31
Removing duplicates across multiple columns
01:58

Preprocess data with ChatGPT - Dates and time data

4 lectures
Obtain day and month from date
02:37
Converting hours to decimals
01:40
Obtaining age in years, months, days
01:24
Order dates chronologically
01:32

Complete practical example

5 lectures
Intro to the exercise and preprocessing ideas from ChatGPT
04:37
Preprocessing the 'Free plan users' sheet (1/2)
07:18
Preprocessing the 'Free plan users' sheet (2/2)
03:33
Working on the 'Transactions' sheet
05:43
Dealing with the country mapping issue
02:52

Đánh giá của học viên

Chưa có đánh giá
Course Rating
5
0%
4
0%
3
0%
2
0%
1
0%

Bình luận khách hàng

Viết Bình Luận

Bạn đánh giá khoá học này thế nào?

image

Đăng ký get khoá học Udemy - Unica - Gitiho giá chỉ 50k!

Get khoá học giá rẻ ngay trước khi bị fix.