12 שיטות עבודה לבנייתדשבורדים פיננסיים עם AI

"Build an FP&A dashboard for a SaaS company. Hostable HTML file — single self-contained output, no external dependencies, must render offline. Target audience: CFO and board — monthly performance review, needs at-a-glance budget vs. actuals with clear narrative hierarchy, no interactivity required. My data attached as a 3-month sample — use this structure to wire the dashboard; I will provide the full dataset once the layout is approved. Layout: dark executive theme, sidebar navigation, large metric cards, subtle grid lines on all charts."

"Before building the dashboard, display the Theme Factory showcase so I may choose a style — then apply my chosen theme throughout the entire HTML artifact. If none suit, generate a custom theme using our brand colors: olive-lime #b8c45a and near-black #0b0d10."

"Build the complete dashboard layout using realistic placeholder figures for a B2B SaaS company at approximately ₪35M ARR. I shall upload the true data once the design is approved by stakeholders."

"Attached is a Dribbble reference I find most distinguished — dark background, ivory cards, fine-weight typography, generous white space. Recreate this aesthetic precisely, but replace the content with our FP&A metrics: Revenue, EBITDA Margin, Headcount, and Free Cash Flow."

"Build an FP&A dashboard artifact containing: (1) live KPI cards, (2) a trend chart via Chart.js, (3) a scenario model with adjustable sliders, and (4) a natural-language query input — using the Anthropic API to answer questions with the dashboard data held as context in the system prompt."

"Ensure the final HTML file is entirely self-contained. All Chart.js scripts, fonts, and CSS must be inlined or loaded from a CDN. The artifact must open and render with complete fidelity in the absence of an internet connection."

"Add an 'Upload CSV' button above the KPI cards. Expect these columns exactly: Month, Revenue, COGS, Opex, Headcount. Parse the file client-side with PapaParse, show a clear warning if any column is missing, and recalculate every KPI card, chart, and total from the new data on upload. Store the parsed dataset so the dashboard remembers the last upload the next time I open the file."

"Restructure this into a single-page app with a fixed sidebar containing five tabs: Overview, P&L, Balance Sheet, Cash Flow, Scenarios. Clicking a tab swaps the main panel via simple show/hide JavaScript — no page reload. Keep the four KPI cards pinned above the panel on every tab. Highlight the active tab with an accent bar in our theme color."

"Add a scenario simulator panel with three sliders: Headcount Growth (0–40%), Gross Margin Improvement (0–10pt), Churn Reduction (0–5pt). Bind each slider to the underlying revenue and EBITDA formulas so all KPI cards and the trend chart recalculate live as the sliders move. Include a 'Reset to Base Case' button."

"Add a sensitivity analysis section below the simulator. Test four variables — Price (±10%), Volume (±15%), COGS % (±5pt), Discount Rate (±2pt) — one at a time against base-case EBITDA. Render the results as a horizontal tornado chart sorted by impact, widest bar at top, in our theme's accent color. Below the chart, auto-generate one sentence naming the largest driver."

"Before I present this dashboard, walk me through how each KPI card is calculated — state the exact formula and which columns it reads from. Then identify the three largest month-over-month changes in the data and explain what's driving each one, citing the specific rows. Finally, tell me what would break this dashboard if I uploaded a file with a missing month."