Skip to Content
View all events

ChatGPT for Data Analytics Bootcamp

Published by O'Reilly Media, Inc.

Beginner to intermediate content levelBeginner to intermediate

10x Your Productivity with AI — From Everyday Tasks to Advanced Workflows

  • Understand the potential of ChatGPT for data analytics and how to use it with the most common data analysis tools such as Excel, and Google Sheets.
  • Discover data analytics use cases for ChatGPT that will 10x your productivity today
  • Understand future applications of ChatGPT and its potential impact on data analytics
  • Examine the vulnerabilities and risks of using ChatGPT

In this course, you will learn the top use cases and prompt templates that will increase your productivity as a data analyst, data scientist, or BI engineer. You will learn how ChatGPT can help you from structuring your data analysis approach, to using it in Microsoft Excel or Google Sheets, to building even more automated AI analytics workflows. You will learn how to improve the quality and enhance the output of your data analysis using ChatGPT. This hands-on course includes practical examples that any data analyst can immediately relate to and use on the job.

You'll be guided step by step, starting with simple everyday analytics tasks and gradually tackling more advanced workflows. You’ll learn how to automate repetitive tasks, uncover insights faster, and enhance decision-making at different levels of complexity. Through interactive exercises and hands-on practice, you’ll build AI-powered analytics workflows that boost productivity and eliminate manual effort – ready to use right away.

By the end of the course, you’ll confidently apply ChatGPT to your data workflows, saving time, improving accuracy, and making smarter, data-driven decisions – without needing advanced coding skills.

What you’ll learn and how you can apply it

  • Gain a solid understanding of LLMs and ChatGPT to confidently apply AI in data analytics.
  • Develop effective prompt engineering techniques to generate high-quality, actionable insights.
  • Use ChatGPT for problem-solving and decision-making in everyday analytics scenarios.
  • Enhance data storytelling and communication by structuring insights for impact.
  • Build custom GPTs for recurring data analysis tasks in ChatGPT.
  • Streamline spreadsheet-based analytics by integrating ChatGPT with Excel and Google Sheets.
  • Automate and optimize workflows using simple no-code tools.
  • Integrate ChatGPT via API to build scalable AI-powered analytics solutions.
  • Navigate AI security, compliance, and governance to ensure safe and ethical AI use.
  • Evaluate the future of AI in data analytics and identify emerging opportunities.

This live event is for you because...

  • You're a data analyst, business analyst, or BI professional looking to boost productivity and automate repetitive tasks.
  • You work with data in spreadsheets (Excel/Google Sheets) and want to integrate AI for faster insights.
  • You're a non-technical professional (marketing, finance, operations, etc.) who works with data and wants to leverage ChatGPT for analysis, reporting, and decision-making.
  • You’re a data scientist or engineer looking to integrate ChatGPT into your workflows to become more productive.
  • You're a business leader who wants to understand the opportunities AI hold for your team’s analytical workflows.

Prerequisites

  • Analytics Experience: At least a few months of hands-on analytics experience or managing data analytics teams.

Course Preparation

  • A free OpenAI account for ChatGPT access (ChatGPT Plus subscription is preferred for GPT-4).
  • A computer with Microsoft Excel installed.
  • A free Google account to access Google Sheets. (Day 2)
  • A free n8n account (Day 2)

Course Follow-Up

Schedule

The time frames are only estimates and may vary according to how the class is progressing.

Day 1: Fundamentals and ChatGPT for Everyday Analytics

Welcome and Course Introduction (15 minutes)

  • Course Orientation, Agenda, and Outcomes
  • Survey: Participant familiarity with ChatGPT, data analytics, etc.
  • Demo: Showcase what you’ll master after this course

ChatGPT & LLM Fundamentals (45 Minutes, incl. Break)

  • What are LLMs and how do they work?
  • Augmentation vs. Automation
  • Quiz: “Is this a good LLM use case?”
  • Risks & Biases – Common LLM Pitfalls and how to overcome them
  • ChatGPT Fundamentals (Settings, Custom Instructions, Memory, Custom GPT)
  • Exercise: Building your first custom GPT
  • Q&A

Prompt Engineering Essentials (30 minutes)

  • 5 Principles of Effective Prompts
  • Exercise: Create and refine prompts to see how specificity changes ChatGPT’s output
  • Q&A

Everyday Analytics with ChatGPT (60 minutes, incl. break)

  • Everyday Analytics Concepts (SMART Problems, MECE Issue Trees, etc.).
  • Exercises: Use ChatGPT to break down a business scenario, create an issue tree and perform a simple root cause analysis.
  • Everyday Data Storytelling
  • Exercises: Using ChatGPT to structure a narrative and create a presentation for day-to-day reporting
  • Everyday Excel Support
  • Exercises: Use ChatGPT to accelerate data analysis workflows within Excel

Advanced Data Analysis in ChatGPT (60 minutes, incl. breaks)

  • Prerequisites for analyzing data within ChatGPT (Formats, limitations, security)
  • Exercise: Quick walkthrough of Advanced Data Analysis in ChatGPT
  • Exploratory Data Analysis (EDA)
  • Exercise: Perform an EDA in ChatGPT using a custom GPT
  • Customer Segmentation
  • Exercise: Perform a RFM Analysis in ChatGPT using a custom GPT
  • Basic Forecasting
  • Exercise: Build a simple data forecast in ChatGPT using a custom GPT

Wrap-Up Day 1 (30 minutes)

  • Recap Key Takeaways
  • Discussion: Q&A
  • Discussion: Check-out
  • Preview of Day 2

Day 2: Advanced ChatGPT For Data Analytics

Day 1 Recap and Discussion (15 minutes)

  • Key Lessons from Day 1, Agenda for Day 2
  • Survey: Participants’ familiarity with Python & SQL

Integrating LLMs into your Data Analytics Workflow (45 Minutes)

  • Using ChatGPT via API, Setup
  • Exercise: Setting up your OpenAI Account & perform your first request

Integrating ChatGPT into Google Sheets & Excel (75 Minutes, incl. break)

  • Integrate LLMs with and without plugins into spreadsheet software
  • Exercise: Running your first chat completion from within Google Sheets
  • Typical Use Cases for ChatGPT inside Spreadsheet software
  • Exercise 1: Data Cleaning
  • Exercise 2: Text categorization
  • Exercise 3: Topic Mining
  • Exercise 4: Data summarization
  • Exercise 5: Data enrichment

Automating Data Analysis with ChatGPT and other LLMs (75 minutes)

  • Introduction to no-code tools and workflows
  • Exercise 1: Set up n8n and run your first workflow
  • Exercise 2: Build a scalable LLM-powered data analysis workflow

Limitations, Pitfalls, and Future Outlook (30 minutes)

  • Common Pitfalls
  • Ensuring Data Security & Compliance
  • Future Developments
  • Discussion: Closing Q&A and Feedback

Your Instructor

  • Tobias Zwingmann

    Tobias Zwingmann is an experienced data scientist with a strong business background. He has more than 15 years of professional experience in a corporate setting, where he has been responsible for building out data science use cases and developing a company-wide data strategy. He is also a cofounder of the German AI startup RAPYD.AI and is on a mission to help companies adopt machine learning and artificial intelligence faster while achieving meaningful business impact.

    linkedinXsearch

Skill covered

GPT