The AI-augmented analyst

AI for Data Analysts

Andy Cotgreave

Author and Speaker, Former Technical Evangelist at Tableau

Meet your instructor...

The journey ahead

 

→ Use AI across the full data analysis cycle

• Videos → Gemini and Claude
  • Principles apply to any tool you use

The journey ahead

 

• Exercises → DataCamp's AI analytics tool

The data analysis workflow

The data analysis workflow, augmented

Natural language data exploration

 

 

• Conversation-driven exploration

 

Before: Blank screens + SQL from-scratch

After: Asking the right questions

 

→ Goal: more time on planning and decisions, less time on implementation

Understand and clean your data

 

Data Exploration

• Infer field descriptions and logic
• Spot anomalies

→ Later: data dictionaries and semantic layers

Understand and clean your data

 

Data Cleaning

• Fix spelling and formatting
• Identify duplicates and rogue entries

Find insights

Build and share: dashboards, apps, and stories

The AI application landscape

The AI application landscape

Challenges... and how we'll tackle them

 

• Hallucinations can leak into calculations and stories

Challenges... and how we'll tackle them

 

• Hallucinations can leak into calculations and stories
• Probabilistic → same prompt, different results

Challenges... and how we'll tackle them

 

• Hallucinations can leak into calculations and stories
• Probabilistic → same prompt, different results
• Lacks context → your data, your intent
• Integrations + good prompting close the gap → this course covers both

Let's practice!

AI for Data Analysts