Online Course
Data Analysis with ChatGPT

Master ChatGPT for data analysis. Boost your productivity at work and become a first adopter of AI-powered data analysis

4.8

862 reviews on
11,578 students already enrolled
  • Institute of Analytics
  • The Association of Data Scientists
  • E-Learning Quality Network
  • European Agency for Higher Education and Accreditation
  • Global Association of Online Trainers and Examiners

Skill level:

Basic

Duration:

2 hours
  • Lessons (2 hours)

CPE credits:

2.5
CPE stands for Continuing Professional Education and represents the mandatory credits a wide range of professionals must earn to maintain their licenses and stay current with regulations and best practices. One CPE credit typically equals 50 minutes of learning. For more details, visit NASBA's official website: www.nasbaregistry.org

Accredited

certificate

What you learn

  • Enhance your data analysis capabilities using ChatGPT.
  • Learn to leverage AI effectively with real‑world datasets.
  • Audit and correct erroneous data with AI assistance.
  • Use ChatGPT to clean, organize, and manage messy data.
  • Perform exploratory data analysis using ChatGPT.

Topics & tools

ChatGPTAIData Analysis

Your instructor

Course OVERVIEW

Description

CPE Credits: 2.5 Field of Study: Specialized Knowledge
Delivery Method: QAS Self Study
Leverage ChatGPT's Advanced Data Analysis tool to outpace competitors in the rapidly evolving tech 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. 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 this course? 1. Don’t get replaced by AI 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. 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. Today you have the chance to embrace AI-driven data analysis in your workplace as an early adopter. 2. Instructor In this course, you will have the opportunity to learn ChatGPT for data analysis from an instructor who has created taught over 3 million students online. In his career as a financial analyst and financial consultant, Ned Krastev has worked with consulting firms, investment banks, and Fortune 100 companies. Learn real-world skills that will prove invaluable on the job. 3. Hands-on experience The best way to learn ChatGPT for Data Analysis is by solving case studies and exploring how ChatGPT can help us in real-world situations. You can follow the videos, work on your own, and complete all tasks alongside the instructor, which will ensure that you gain practical experience and develop a deep understanding of the applications of ChatGPT in data analysis. As usual, the course comes with a 30-day money-back guarantee, and gives the promise to transform your career with sought-after skills. So, what are you waiting for? Enrol today, and let’s start this transformational journey together!

Prerequisites

  • Access to ChatGPT
  • Basic familiarity with data concepts
  • Microsoft Excel (any recent version, such as Excel 2019, 2021, or Microsoft 365)

Curriculum

40 lessons 1 exam
  • 1. Course introduction
    3 min
    Explore our Data Analysis with ChatGPT introductory course, featuring the course curriculum and practical examples.
    3 min
    Explore our Data Analysis with ChatGPT introductory course, featuring the course curriculum and practical examples.
    Course introduction Free
  • 2. Overview of ChatGPT Advanced Data Analysis
    8 min
    Discover the benefits of the Advanced Data Analysis tool and learn why proactive yet cautious utilization is vital.
    8 min
    Discover the benefits of the Advanced Data Analysis tool and learn why proactive yet cautious utilization is vital.
    How ChatGPT Advanced Data Analysis will boost your productivity Free
    Is ChatGPT Advanced Data Analysis the killer of the data analyst and data scientist professions? Free
    The limitations of ChatGPT Advanced Data Analysis
  • 3. Exploratory Data Analysis (EDA) with ChatGPT
    20 min
    ChatGPT's Advanced Data Analysis tool simplifies initial dataset exploration. Here, you'll find a practical EDA example showcasing time-saving capabilities.
    20 min
    ChatGPT's Advanced Data Analysis tool simplifies initial dataset exploration. Here, you'll find a practical EDA example showcasing time-saving capabilities.
    Exploratory data analysis - intro
    Extracting descriptive statistics with ChatGPT
    Identifying outliers
    Correlation analysis: Hypothesis formulation and feature ideas
    Crafting a comprehensive EDA prompt
  • 4. Preprocess data with ChatGPT - Deal with inconsistent data
    14 min
    Analysts often need help with messy and irregular data. Navigating these complexities can be time-consuming. In this module, learn how to leverage ChatGPT to efficiently identify and rectify dataset inconsistencies, harmonize units of measurement, and address initial preprocessing challenges with data.
    14 min
    Analysts often need help with messy and irregular data. Navigating these complexities can be time-consuming. In this module, learn how to leverage ChatGPT to efficiently identify and rectify dataset inconsistencies, harmonize units of measurement, and address initial preprocessing challenges with data.
    Identifying and handling erroneous data
    Verifying data for errors
    Eliminating duplicate rows
    Addressing unit discrepancies in data
    Dividing cell content into multiple cells
  • 5. Preprocess data with ChatGPT - Organize messy data
    11 min
    In some cases, resolving formatting and dataset structure issues requires time and experience. This section demonstrates how ChatGPT aids in organizing, classifying, mapping, and ordering data.
    11 min
    In some cases, resolving formatting and dataset structure issues requires time and experience. This section demonstrates how ChatGPT aids in organizing, classifying, mapping, and ordering data.
    Organize messy data
    Data mapping
    Effective data classification
    Order data with ChatGPT
  • 6. Preprocess data with ChatGPT - Working with functions
    14 min
    When using Excel, accessing function assistance from ChatGPT can be invaluable when you encounter difficulties, as it frequently comprehends your needs and offers viable solutions.
    14 min
    When using Excel, accessing function assistance from ChatGPT can be invaluable when you encounter difficulties, as it frequently comprehends your needs and offers viable solutions.
    COUNTIFS, SUMIFS
    Data lookup
    Data ranking
    Fill until non-blank values
    Translating logic into Excel formulas with ChatGPT
  • 7. Preprocess data with ChatGPT - Clean text data
    17 min
    As an analyst, you'll frequently handle text data—master text data preprocessing with ChatGPT's Advanced Data Analysis tool.
    17 min
    As an analyst, you'll frequently handle text data—master text data preprocessing with ChatGPT's Advanced Data Analysis tool.
    Correcting inverted names
    Dealing with trailing and leading spaces in text data
    Standardizing letter capitalization
    Handling multi-lingual text data
    Multiple "Find and Replace" at the same time with ChatGPT
    Criteria-based duplicate removal
    Removing duplicates across multiple columns
  • 8. Preprocess data with ChatGPT - Dates and time data
    8 min
    An analyst should include date and time manipulation in their toolkit. ChatGPT can assist in converting and organizing date-time data within our datasets.
    8 min
    An analyst should include date and time manipulation in their toolkit. ChatGPT can assist in converting and organizing date-time data within our datasets.
    Obtain day and month from date
    Converting hours to decimals
    Obtaining age in years, months, days
    Order dates chronologically
  • 9. Complete Practical example
    26 min
    Demonstrate practical dataset preprocessing using ChatGPT to solidify course knowledge and prepare for real-world tasks.
    26 min
    Demonstrate practical dataset preprocessing using ChatGPT to solidify course knowledge and prepare for real-world tasks.
    Intro to the exercise and preprocessing ideas from ChatGPT
    Preprocessing the 'Free plan users' sheet (1/2)
    Preprocessing the 'Free plan users' sheet (2/2)
    Working on the 'Transactions' sheet
    Dealing with the country mapping issue
    Note from author
  • 10. Course exam
    25 min
    25 min
    Course exam

Free lessons

Course introduction

1.1 Course introduction

3 min

How ChatGPT Advanced Data Analysis will boost your productivity

2.1 How ChatGPT Advanced Data Analysis will boost your productivity

2 min

Is ChatGPT Advanced Data Analysis the killer of the data analyst and data scientist professions?

2.2 Is ChatGPT Advanced Data Analysis the killer of the data analyst and data scientist professions?

3 min

The limitations of ChatGPT Advanced Data Analysis

2.3 The limitations of ChatGPT Advanced Data Analysis

3 min

Exploratory data analysis - intro

3.1 Exploratory data analysis - intro

4 min

Extracting descriptive statistics with ChatGPT

3.2 Extracting descriptive statistics with ChatGPT

2 min

Start for free

ACCREDITED certificates

Craft a resume and LinkedIn profile you’re proud of—featuring certificates recognized by leading global institutions.

Earn CPE-accredited credentials that showcase your dedication, growth, and essential skills—the qualities employers value most.

  • Institute of Analytics
  • The Association of Data Scientists
  • E-Learning Quality Network
  • European Agency for Higher Education and Accreditation
  • Global Association of Online Trainers and Examiners

Certificates are included with the Self-study learning plan.

A LinkedIn profile mockup on a mobile screen showing Parker Maxwell, a Certified Data Analyst, with credentials from 365 Data Science listed under Licenses & Certification. A 365 Data Science Certificate of Achievement awarded to Parker Maxwell for completing the Data Analyst career track, featuring accreditation badges and a gold “Verified Certificate” seal.

How it WORKS

  • Lessons
  • Exercises
  • Projects
  • Practice exams
  • AI mock interviews

Lessons

Learn through short, simple lessons—no prior experience in AI or data science needed.

Try for free

Exercises

Reinforce your learning with mini recaps, hands-on coding, flashcards, fill-in-the-blank activities, and other engaging exercises.

Try for free

Projects

Tackle real-world AI and data science projects—just like those faced by industry professionals every day.

Try for free

Practice exams

Track your progress and solidify your knowledge with regular practice exams.

Try for free

AI mock interviews

Prep for interviews with real-world tasks, popular questions, and real-time feedback.

Try for free

Student REVIEWS

A collage of student testimonials from 365 Data Science learners, featuring profile photos, names, job titles, and quotes or video play icons, showcasing diverse backgrounds and successful career transitions into AI and data science roles.