Create an interactive analytics dashboard for Whole bank view focusing on future…
- User
Create an interactive analytics dashboard for Whole bank view focusing on future pipeline but also looking retrospectively at recent large movements aimed at CEO. Include KPI summary cards with trend indicators, a mix of line, bar, and donut charts with hover tooltips and smooth transitions, a sortable and filterable data table, and date-range and segment filters that update every view live. Use a clean, modern visual style with clear layout hierarchy and a dark mode toggle, generate realistic sample data so every chart feels alive, and make it fully responsive.
Assistant
I have built a complete interactive analytics dashboard for the Whole Bank View tailored for the CEO, focusing on future deal pipelines and retrospective large movements.
Key Features Implemented:
-
CEO Executive Header & Live Filters:
- Global Segment Selector: Whole Bank (All Units), Corporate & Investment, Commercial, Wealth Management, Treasury & Markets, Retail & SME.
- Global Regional Selector: Global (All), AMER, EMEA, APAC.
- Horizon & Date Range Filters: Next 30 Days, Q1 2026, Q2 2026, Full Year 2026.
- Executive Currency Switcher: Live conversion between USD ($), EUR (€), and GBP (£).
- Dark / Light Mode Toggle: Seamless dark theme with executive contrast and glassmorphism styling.
- CEO AI Copilot Trigger: Opens an AI Assistant Drawer featuring strategic priority alerts and interactive Q&A.
- Board Presentation Mode: One-click toggle into a high-impact presentation layout designed for board meetings.
-
KPI Summary Cards:
- Total Future Pipeline: Gross pipeline vs. win-probability weighted value with QoQ trend pill and probability distribution.
- Projected NII & Revenue: Annualized net interest income and advisory fee yields.
- Retrospective Net Movement (30D): Net cash flow expansion, splitting total inflows (1.38B).
- Liquidity Buffer (LCR): Solvency monitoring showing 142.8% LCR (+42.8% above Basel III minimum) and HQLA reserves.
- Credit Approval Bottleneck: Alerts highlighting large commitments ($2.67B across 3 mega-deals) pending Credit Committee review.
-
Rich Charts & Visualizations:
- Executive Timeline Horizon (Composed Bar/Line/Area): Retrospective monthly inflows and outflows paired with projected weighted deal closings.
- Segment & Sector Concentration Donut Charts: Interactive breakdown of portfolio exposure across energy, tech, industrials, healthcare, and real estate.
- Deal Pipeline Funnel & Stage Progression: Stage-by-stage conversion tracking (Origination → Underwriting → Credit Committee → Documentation → Closing).
- Movement Category Vertical Bar Chart: Inflows vs. outflows categorized by loan drawdowns, bond settlements, deposit shifts, and collateral transfers.
-
CEO "What-If" Scenario Stress Simulator:
- Interactive sliders for Deal Conversion Win Rate, Central Bank Rate Shifts (-150 to +200 bps), Credit Spread Widening, and Outflow Stress.
- Live recalculation of adjusted weighted pipeline, NII annual earnings, LCR liquidity, and CET1 capital solvency buffers with automated risk assessment alerts.
- Pre-configured macro scenario presets (Soft Landing Baseline, Hawkish Rate Surge, Credit Crunch Stress, Bullish Deal Boom).
-
Master Searchable & Sortable Data Table:
- Sortable columns (Client, Segment, Value, Win Prob %, Closing Date, Stage, Risk Rating).
- Row expansion to view full credit committee notes, relationship managers, and ESG badges.
- CSV Export button to download filtered pipeline data.
-
Interactive Simulation Modals:
- Simulate / Inject Deal Modal: Allows injecting hypothetical deal facilities live into the pipeline.
- Deal Inspection Drawer: Offers options to advance pipeline stages, flag deals to the Chief Risk Officer (CRO), or print deal sheets.
Files built:
index.html,src/types/dashboard.ts,src/utils/formatters.ts,src/data/mockData.ts,src/components/Header.tsx,src/components/KPISummary.tsx,src/components/ExecutiveOverviewTab.tsx,src/components/FuturePipelineTab.tsx,src/components/RetrospectiveTab.tsx,src/components/ConcentrationTab.tsx,src/components/ScenarioSimulator.tsx,src/components/DataTable.tsx,src/components/AIAssistantDrawer.tsx,src/components/NewDealModal.tsx,src/components/DealDetailModal.tsx,src/components/BoardDeckView.tsx,src/App.tsx-
Other models, same or similar prompt
Responses were produced in different, uncontrolled contexts (system prompts, settings, prior turns). This is not a benchmark.