AI For Analytics

This class will be live online (i.e. synchronous).

This course is a part of ProTech. Please review eligibility requirements below before applying.

How can the latest AI tools be integrated into your analytics workflow?

For many data analysts, the AI hype hasn’t quite lived up to the reality of daily work. While coding assistants for Python took off immediately, reliable support for Excel and SQL has lagged behind. That’s finally changing. The opportunity to integrate powerful AI tools into your day-to-day workflow as a data analyst has never been greater. But using AI in analytics requires a new kind of skill: knowing where these tools succeed, where they fail, and how to use precise prompting to get the reliable results you need.

This course is designed to help you explore some of the current tools and to recognize the strengths and weaknesses of each. Students will work through instructor-directed hands-on exercises to demonstrate the abilities and limitations of each. Upon completion of this course, students will be able to safely integrate AI into their analytics workflow to boost efficiency while minimizing risk.

Is this course for you?

  • Are you a current data professional with hands-on, project-based experience in Python and SQL who wants to integrate AI tools into your everyday data workflows?
  • Do you want to learn to use AI as a technical mentor?
  • Do you want to get hands-on experience using AI plugins, including Claude Code and Claude for Excel?
  • Do you want to build a foundational understanding of how Large Language Models (LLMs) operate under the hood, giving you the context needed to spot errors and trust your data?

What will the course cover?

  • Overview of LLMs
    Build a working understanding of what's happening under the hood of large language models, so you can use them more effectively.
  • Hands-on experience with 3 Major AI Models
    GitHub Copilot, Claude Code and Claude for Excel, and ChatGPT
  • AI as Technical Mentor
    Imagine having a senior analyst available 24/7. Learn to use AI to break down unfamiliar functions, translate complex business processes into technical steps, and provide real-time guidance as you tackle new analytical challenges.
  • Claude for Excel
    Get hands-on with one of the latest AI-powered add-ins that works directly inside your Excel workbook.
  • AI-Powered SQL Workflows
    SQL-specific AI tools are finally becoming a viable part of an analyst’s toolkit. Learn how to leverage these tools to speed up your workflow while being vigilant for logical errors.
  • Prompt Engineering
    Learn to craft precise, effective prompts that get better results on the first try, saving you time and reducing frustration.
  • VS Code AI Plugins
    Discover how AI-powered plugins, like Claude Code and GitHub Copilot, can assist you in real time as you write and troubleshoot Python code in a Jupyter Notebook.
  • Clean Up Existing Code
    Use AI to review, improve, and explain changes to existing SQL and Python code, while learning to spot potential issues before they become problems.

How will you learn the material?

Hands-on Learning
Students actively engage in hands-on exercises and projects as opposed to being passively lectured to. Students leave with a deeper understanding of the subject matter and are ready to apply their new skills on the job.
Live Online Learning
Students have the opportunity to interact as a class, in smaller working groups and one-on-one with the instructor in a live virtual classroom.
Reflection Exercises
Reflections are integrated into exercises to help you understand processes and concepts. This ‘big picture’ approach will prepare you for professional conversations, including interviews.

  • Schedule

    Mondays and Wednesdays 6PM - 9PM CT

  • Location

    This class is live online (i.e. synchronous).

  • Dates

    July 6 - August 28, 2026

  • Tuition

    FREE

    This course is a part of ProTech. Please review eligibility requirements below before applying.
What is required?
  • Personal Computer
  • Must be 18+ years old
  • Hands-on, project-based experience in Python & SQL
  • Recommended: Exposure to Excel
ProTech Eligibility
  • Must reside in Middle Tennessee
  • Graduate of NSS, another coding bootcamp, or college/university with tech-related degree AND searching for your first job in tech.
  • Data Analyst or related tech professional who is unemployed after being laid off from a tech job

Attendance Information

Our policy regarding absences is based on making sure you get the most out of your professional development. Attendance is tracked for this course. Excused absences should be arranged with your instructor before they occur. Due to the short duration of this course we recommend that you not miss multiple days of this course. Absence due to emergencies are always excused as long as the instructor is notified as soon as possible.

Have questions?
Email Us
Ready to take the leap?
Apply