GeneralIntermediateBusiness Analyst

Year-over-Year Growth Summary

Compare key metrics across years to spot long-term trends.

Example Prompt

“Show year-over-year growth for revenue, customers, and orders”

Expected Insight

Annual comparison of revenue, customer count, and order volume with growth percentages and compound annual growth rates.

Prompt variations

Try these follow-up prompts to explore your data further.

“Export this as a CSV”

“Show a chart instead of a table”

“Add a date range filter”

“Include all columns from the table”

Tips for best results

Be specific with time ranges

Instead of "recently," say "in the last 30 days" or "this quarter." Specific dates produce more accurate results.

Name your dimensions

Say "by region" or "grouped by sales rep" to get the breakdowns you need. The AI works best with explicit grouping.

Ask for the format you want

Request "as a bar chart," "in a table," or "as a percentage" to get results in the format that is most useful to you.

Use follow-up questions

After your first answer, drill deeper with "Why?" or "Break this down further." The AI remembers context.

Try this prompt in AI for Database

Connect my database and get answers in seconds. No SQL required.

Free plan available · No credit card required