Course Information

Discover how AI tools like ChatGPT and Google Looker Studio can enhance your data analysis workflows. This immersive course provides data professionals with the tools and techniques to leverage ChatGPT and Google Looker Studio for streamlined data collection, in-depth exploration, and impactful visualisation. Designed for analysts with basic coding knowledge, this course enables you to automate insights, transform data with ease, and create engaging visual narratives. 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 like 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.

Outcomes

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

• apply AI-driven techniques for data collection and preparation using ChatGPT
• perform advanced data exploration and visualisation in Google Looker Studio
• use ChatGPT to automate complex data cleaning and transformation tasks
• create custom dashboards with interactive, multi-layered visualisations
• draft insightful narratives and comprehensive 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 advanced visualisations in Google Looker Studio

• Customising charts and creating advanced, 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 complex results

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

Intended audience

This course is ideal for data analysts, data scientists, 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.

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.

Additional information

• Please bring your own device to class.
• Create a ChatGPT account prior to class (choose the free or paid version).
• Create a free Google account prior to class.