This is Hamamoto from TIMEWELL.
Data-driven decision-making matters, but the time cost of data analysis has been a persistent bottleneck for consultants and marketers. This workflow — developed and demonstrated by AI educator mikimiki — combines ChatGPT and Gemini 2.5 Pro to produce strategic analysis documents in approximately 15 minutes. Here's how it works.
Step 1: ChatGPT O3 Pro — Automated Data Discovery and Insight Extraction
The first stage uses ChatGPT with the O3 Pro model and a specialized prompt to locate credible data sources automatically.
Example prompt logic: Given a target company (e.g., Alphabet/Google) and a time window (2020 onward), the prompt instructs O3 Pro to identify the top five most relevant financial documents based on criteria including recency, credibility, originality, and accessibility. The output is a ranked list with direct URLs — no manual search required.
What makes O3 Pro effective here is its reasoning capability. Rather than simply summarizing documents, it identifies the strategic questions worth asking — for example, how fast Google Cloud's growth can continue to accelerate, or which product revenue lines are accelerating versus plateauing. The output isn't a data dump; it's a structured set of inflection points framed for strategic discussion.
Key principle: The quality of O3 Pro's output scales with the specificity of the prompt. Vague instructions produce vague results. Detailed context — the company, time period, analytical dimension, and intended use — yields targeted, actionable insights. This is why prompt engineering is the most important skill in this workflow.
A demonstration using Alphabet's actual financial data showed O3 Pro generating PDF links with direct access to source documents, breakdowns of Google Cloud growth rates, YouTube ad revenue, and subscription vs. advertising revenue trends — in minutes rather than hours.
Looking for AI training and consulting?
Learn about WARP training programs and consulting services in our materials.
Step 2: Gemini 2.5 Pro Canvas Mode — Data to Visual
The second stage uses Gemini 2.5 Pro with its canvas mode enabled to convert the extracted insights into charts and graphs.
Process:
- Enable canvas mode in Gemini 2.5 Pro
- Upload the source PDF document(s)
- Input a dedicated prompt (formatted for Gemini, distinct from the ChatGPT prompt)
- The tool auto-generates color-coded, labeled charts across multiple data dimensions
In the demonstration using Alphabet financial data, Gemini 2.5 Pro generated charts for Google Cloud growth rates, YouTube Premium revenue, Google One subscriptions, and YouTube TV — each organized by product family with hover interactivity. English labels were converted to Japanese; dollar figures were converted to yen — all through additional prompts rather than manual editing.
When errors occurred during initial generation, the tool's built-in error correction function resolved them without manual intervention. The final output was screenshot-ready for direct import into PowerPoint or Canva.
What Gemini 2.5 Pro does better than ChatGPT here: Visual quality and chart flexibility. ChatGPT can produce charts, but Gemini 2.5 Pro's canvas mode generates more polished, customizable outputs with live data adjustment — color changes, axis labeling, unit conversion, category splitting — all in natural language.
Why This Matters for Consulting Practice
The combined workflow replaces a process that previously required several hours of manual research, data formatting, and chart production. The time saving isn't marginal — it's structural. Consultants who previously spent the first half of a client engagement just gathering and formatting data can now arrive at the insight stage in the first 15 minutes.
More importantly, the workflow shifts the consultant's role. The bottleneck is no longer data handling — it's the quality of the questions being asked. Prompt engineering, in this context, is strategic thinking translated into AI instructions.
For firms using ZEROCK or similar enterprise AI platforms, this kind of analysis workflow integrates naturally into existing knowledge management and output generation processes.
Summary
The 15-minute strategic analysis workflow in practice:
- ChatGPT O3 Pro + detailed prompt → ranked list of credible data sources + strategic insight extraction
- Upload PDF to Gemini 2.5 Pro canvas mode + Gemini-specific prompt → auto-generated, customizable charts in minutes
- Screenshot + import to presentation tool → ready-to-use visual material
The key variable throughout is prompt quality. The more specific the instruction, the higher the analytical output. Prompt engineering is not a technical skill — it's the practice of making strategic thinking explicit.
Reference: https://www.youtube.com/watch?v=94WKYiQLK6M
