Course overview
Start hereAI for Business Intelligence Analysts
START HERE

Priya's Wednesday, two ways

8 lessons · 26 prompts

A day in the life of a Business Intelligence Analyst: what changes with these prompts.

Track progress as a member

Priya, a business intelligence analyst at a regional health clinic.

Priya starts Wednesday with a request from the clinic director: show no-show rates by location for the last six months. She opens ChatGPT and uses the SQL Query Basics prompt, pasting the table names and the fields she knows. The first query joins appointments and locations, but the date filter is wrong, so she asks for a fix and checks it in her SQL editor.

Next she needs a clear definition for no-show rate. She uses the Metric Definitions and KPIs prompt in Claude, giving the director's wording and the edge cases she knows, like cancellations and same-day reschedules. The result gives her a formula, a note about patients who cancel, and a short explanation she can share.

After lunch, Priya builds a dashboard for the clinic managers. She uses the Dashboard Building Support prompt in Gemini to plan the layout, then writes a calculated field for the rate. She also uses the Reports and Stakeholder Communication prompt to draft a short summary for the director, with a few talking points and a question for the next meeting.

By four o'clock, the dashboard is ready and the summary is in the director's inbox. Priya uses the time she won back to walk through the numbers with the scheduling team and check one location with a sudden change. She leaves on time, knowing the report is clear and the data was checked.

Before

  • Requests pile up faster than answers.
  • Queries take longer than expected.
  • Metric definitions change with every meeting.
  • Reports eat the end of the day.

After this course

  • Queries start with a clear first draft.
  • Metrics have rules everyone can see.
  • Dashboards come together without the scramble.
  • Reports go out before the last hour.

What you'll learn

  • SQL Query Basics: Turn a business question into working SQL and understand queries you inherit.
  • Data Cleaning: Plan cleaning steps, write transformation code, and design checks for messy data.
  • Metric Definitions: Turn vague metric requests into precise definitions, formulas, and edge-case rules.
  • Dashboard Building: Plan layouts, write calculated fields, and troubleshoot performance or usability issues.
  • Trend Analysis: Interpret query results, form hypotheses, and turn numbers into clear business insights.
  • Stakeholder Reports: Draft performance reports, executive summaries, and talking points for non-technical readers.
  • Documentation and Admin: Write data dictionaries, document requirements, and summarize meetings so work stays traceable.
  • Advanced Analysis: Plan complex analyses, generate reusable scripts, and automate recurring reporting workflows.

How this course works

  1. 8 lessonsOne task of your job each, from sql query basics to advanced analysis and automation.
  2. Ready-to-paste promptsCopy, fill in the parts in {{brackets}}, paste into ChatGPT, Claude or Gemini.
  3. Tick and completeTick the prompts you tried and mark each lesson complete.
  4. Get certifiedFinish and keep the prompts as your own library.