Generates comprehensive KPI dashboards with drill-down capabilities
"Design a CFO dashboard tracking: Revenue (by segment/geography), Gross Margin trends, EBITDA margin, Cash conversion cycle, DSO/DPO/DIO, Working capital metrics, Debt ratios, Employee productivity metrics. Include: 1) Current vs Prior Period 2) vs Budget 3) vs Forecast 4) Sparklines for trends 5) RAG status indicators. Output as interactive Excel with slicers."
Co-founder of Prompt Magic and ThinkingDeeply.ai Career Chief Marketing Officer
Build your personal prompt library, save your favorites, and access curated AI prompts created by the community
Access a vast library of high-quality AI prompts for every use case
Save prompts to your personal library and organize them your way
Get started with full access to our core features at no cost
No credit card required • Free forever • Join 10,000+ users
Identifies cash trapped in working capital with specific improvement actions
Creates a full‑funnel KPI dashboard (GA4/Data Studio/Sheets) with alerts and benchmarks.
What it does: Defines the key metrics a SaaS CEO should track for real-time business health visibility. When to use it: Setting up analytics, board prep, or when you feel disconnected from the business pulse.
As a financial controller, i am managing a retail business in canada. Right now, i am struggling with monitoring the business performance in shorter span of time like on monthly basis. I wanted to build a business tracker model that can give me very quick insights of the products sold with names, budget vs actual products sold comparison. performance of customer sales with actual vs projection comparison. It should also include monthly profit and loss statement actual vs projections.
Use when: you want to detect operational deterioration, earnings quality issues, or balance-sheet risk for a public company.
When to use: You need to understand unit economics and plan for growth.