An ex-Google data analyst demonstrates using OpenAI's Codex to analyze a CSV file of customer data. She prompts the AI to perform a root cause and cohort analysis for a retention drop, then automatically generates a leadership presentation, condensing a multi-day task into a two-hour project.
Treat AI data tools like an intern: assign them the mechanical tasks of coding and number crunching. As the expert, your role is to define the problem, provide direction, and critically evaluate the output. This mental model ensures the human analyst retains strategic control and accountability.
To perform AI data analysis safely: 1) Only use AI tools with enterprise-level security approved by your company. 2) Clearly define the problem you're solving to guide the AI effectively. 3) Thoroughly validate the AI's output by checking its logic and simple math before trusting the conclusions.
Despite AI's power, it cannot replace the human element of data analysis, which requires stakeholder management, domain knowledge, and critical thinking to validate results. An AI can produce errors, making human judgment more crucial than ever to avoid costly mistakes and provide true insights.
When presenting a problem or a root cause analysis to leadership, don't stop at the findings. The immediate next question will always be, "What are we doing about it?". Anticipate this by including a slide with proposed solutions or next steps to demonstrate proactivity and strategic thinking.
A critical but often overlooked step is data quality. AI tools assume your data is clean, which can lead to flawed conclusions. Explicitly add a step in your prompt instructing the AI to check for missing values, clean inconsistencies, and normalize the data before running the core analysis.
The true value of a data analyst isn't just crunching numbers but asking counterintuitive and unique questions of the data. This creative problem-framing uncovers remarkably different outcomes. While AI can handle the technical execution, the human expert's role is to define what to investigate.