Course summary

Discover how AI tools like ChatGPT and Google Looker Studio can enhance your data analysis workflows. This course provides data professionals with the tools and techniques to leverage ChatGPT and Google Looker Studio for streamlined data collection, exploration and visualisation. Designed for analysts with basic coding knowledge, this course enables you to automate insights, transform data with ease, and create visual narratives in Google Looker Studio. Develop your data analysis skills and stay ahead in a data-driven world with practical, AI-driven methodologies.

Aims

You will learn to integrate AI tools including ChatGPT and Google Looker Studio seamlessly into your data analysis workflow. By the end of this course, you’ll feel empowered to use AI for more efficient, accurate, and insightful data analysis.

Learning outcomes

By the end of this course, you should be able to:

• apply AI-driven techniques for data collection and preparation using ChatGPT
• perform data exploration and visualisation in Google Looker Studio
• use ChatGPT to automate data cleaning and transformation tasks
• create custom dashboards with interactive, multi-layered visualisations
• draft narratives and reports that communicate data insights effectively.

Content

Introduction to AI for data analysis

• Overview of AI’s growing role in data analysis.
• Introduction to AI-enabled tools: ChatGPT, Google Looker Studio, and others (RStudio, Anaconda, VS Code).
  • Comparative chart of tool integrations to help participants understand the broader ecosystem.

Data collection and preparation with ChatGPT

• Generating structured data collection plans with ChatGPT
• Exploring automated approaches for data validation
• Refining data extraction using AI-enhanced iterative prompts

In-depth data exploration in Google Looker Studio

• Understanding Looker Studio’s interface and features
• Importing datasets and using filters for exploratory analysis

AI-Driven data cleaning and transformation with ChatGPT

• Structuring ChatGPT prompts to assist in cleaning and transforming data
• Drafting basic code snippets for data wrangling tasks in Python or SQL

Building visualisations in Google Looker Studio

• Customising charts and creating layered visualisations
• Using interactive features like conditional formatting and complex filters

Automating insights with ChatGPT and Google Looker Studio

• Combining ChatGPT’s narrative generation with Looker Studio dashboards
• Introduction to basic scripting for automation workflows

Presenting and reporting results

• Using ChatGPT to draft concise summaries and data narratives
• Enhancing visual storytelling with Looker Studio reports
• Final project: creating an AI-powered report

Who this course is for

This course is ideal for data analysts and professionals with a basic understanding of coding and data manipulation who want to integrate AI into their workflow and enhance their data visualisation skills in Google Looker.

Prerequisites

Basic experience with data analysis tools (e.g., Excel, SQL, Python) and foundational coding skills are recommended.

Delivery style

Workshop

Delivery mode

Face-to-face, presenter-taught training using your own device.

Materials

Course materials are provided electronically using Dropbox.

What you need to do before the course

To participate in this course, you will need a ChatGPT account (choose the free or paid version) and a Google account. Please bring your account login details with you to class.

Face-to-face classes

Please bring your own laptop with all required accounts already set up.

Online classes

For the best experience, we recommend using a computer with a large monitor or dual screens/devices. Small laptop screens can make it difficult to follow the facilitator’s display while working in the software.

Course Brochure