Module 4: AI Coding Assist

Leveraging AI in Analytics

Copilot in VS Code

Learn to use GitHub Copilot to autocomplete your SQL queries and generate dbt YAML configurations. It's like having a senior engineer in your pocket!

Best Practices

• Verify everything: AI hallucinates, especially about obscure education codes.
• Security: Never put PII (Student Names) in the prompt!

K-12 Scenario: Risk Flags

We will use AI to help us logic out a complex "Student At Risk" flag based on attendance and grades.