Introduction to Data Analytics

Intro to Data Analytics with ChatGPT Unlock the power of your data without writing a single line of code. This beginner-friendly course teaches you how to inspect, clean, and visualize datasets using ChatGPT’s natural-language interface. You’ll work hands-on with real public sector examples like budgets, 311 service requests, and vendor payments. By the end, you’ll know how to turn spreadsheets into clear tables, charts, and narratives that support smarter decisions.
Product image for Introduction to Data Analytics

📊 Intro to Data Analysis for ChatGPT (Beginner)


Turn everyday spreadsheets into clear, decision-ready insights—no coding required. This hands-on course shows public-sector professionals how to use ChatGPT to inspect, clean, summarize, visualize, and explain data from CSV or Excel. You’ll practice a simple 5-prompt workflow you can reuse on any dataset and leave with tables, charts, and narratives you can share with leaders.


🎯 What you’ll learn

  • Upload and inspect CSV/Excel (columns, types, date range, sample rows)
  • Clean messy data: find blanks, standardize labels, remove duplicates
  • Build summary tables (group, sort, add % of total, variance)
  • Create quick charts (bar, line, histogram) with prompt follow-ups
  • Write a plain-English narrative that communicates insights and caveats
  • Apply a repeatable workflow you can use on your own data after class


👥 Intended Audience

  • City and county staff who work with spreadsheets and reports
  • Program managers, analysts, finance/procurement/public works staff
  • Beginners to AI/ChatGPT (no statistics or coding required)


🤖 Why ChatGPT for analysis?

Plain-English prompts beat complex formulas for first-pass analysis. ChatGPT helps you go from spreadsheet to story in minutes—so lean teams can spend time on decisions, not mechanics.


📦 What’s included

  • One hour course lecture video with presentation.
  • Student workbook with step-by-step prompts and practice tasks
  • Downloadable practice datasets (CSV)
  • Prompt templates for inspect → clean → summarize → visualize → explain
  • Printable cheat sheet for on-the-job use
  • Lecture script (great for internal re-training)


🧭 Course outline (at a glance)

  1. Getting started: files, formats, and the 3-step workflow
  2. Inspecting data: schema, samples, and quick questions
  3. Cleaning data: blanks, duplicates, and simple standardization
  4. Summaries: group-by tables, percent of total, variance
  5. Visuals: choosing the right chart and polishing labels/titles
  6. Explaining results: 120-word narrative + one caveat
  7. Capstone mini-project: one table, one chart, one memo


🧰 Requirements

  • A computer with a modern browser
  • Basic comfort with spreadsheets (CSV/Excel)
  • A ChatGPT plan that supports file uploads (recommended)


❓ FAQ

Does ChatGPT connect to our database?
No. You’ll export to CSV/XLSX and upload for analysis.

Do I need to code or know statistics?
No coding required. The course focuses on practical, no-code analysis and clear communication.

Can I use my own data later?
Yes—your workbook and cheat sheet are designed to work with any clean CSV/one-sheet Excel file.

Will this replace our BI tools?
No. Think of ChatGPT as a rapid first-pass analyst. Validate important results in Excel or BI tools.


🚀 Call to action

Start analyzing smarter and enroll in Intro to Data Analysis for ChatGPT!

Course content

1 sections | 3 lessons