Below is a full, production-ready Excel VBA script that reads raw data, analyzes numeric KPIs, creates a dashboard, and calls the OpenAI API to generate an executive summary. This uses the OpenAI text-davinci-003 completion endpoint via VBA XMLHTTP.

Analyzes any structured raw data • Automatically detects numeric & categorical columns • Calculates key KPIs • Builds a clean executive dashboard • Requires no external add-ins • Is easy for a non-technical user to install and run