Pick a depth. Each prompt opens in your AI pre-loaded with the lesson. Click a row to preview the prompt.
Most people think analytics means charts, dashboards, or knowing Excel wizardry, so they either avoid it or produce dashboards nobody uses. The real job is smaller and harder: take a decision someone actually has to make, turn it into a question data can answer, and hand back an answer they can act on today. Until recently the technical gate - formulas, SQL, pivot tables - kept non-coders out, so the person who understood the business rarely got to touch the numbers. AI removes that gate: it will write every formula and query for you, which means the scarce skill is no longer typing syntax, it is asking the right question and knowing when the answer is trustworthy. That is exactly what this course builds, and it starts today with one real answer.
Consider two versions of the same work. Version A: a marketing manager opens the sales export, makes a colorful pie chart of revenue by product, drops it in a slide titled 'Q3 Overview,' and moves on. Nobody does anything with it - that is reporting theater. Version B: the same manager starts from a decision her boss faces - 'should we keep spending on the Instagram ad campaign?' - and turns it into a question data can answer: 'Did customers who came from Instagram in June spend more or less than customers from Google?' She filters the export to June, sums revenue by source, and finds Instagram customers spent an average of 412 dollars versus 268 dollars from Google. The answer is a sentence: 'June Instagram customers spent 54 percent more on average, so keep the campaign and test raising its budget.' That sentence changes what someone does on Monday. The pie chart did not. Notice what separated them: not the tool, not the chart - the fact that Version B started from a decision. Now the AI angle: the manager did not know the formula to average revenue by source. She typed into ChatGPT, 'I have a Google Sheet with columns Date, Source, Revenue. Write a formula to average Revenue where Source is Instagram and Date is in June,' pasted the AVERAGEIFS formula it returned into her sheet, and got the number in ten seconds. The thinking was hers; the syntax was the AI's.