Portfolio Dashboard Builder
by a5c-ai
Generates portfolio dashboards with visualizations, trends
Skill Details
Repository Files
1 file in this skill directory
name: portfolio-dashboard-builder description: Generates portfolio dashboards with visualizations, trends allowed-tools:
- Read
- Write
- Glob
- Grep
- Bash
- WebFetch metadata: specialization: venture-capital domain: business skill-id: vc-skill-034
Portfolio Dashboard Builder
Overview
The Portfolio Dashboard Builder skill creates visual dashboards for portfolio monitoring and LP reporting. It generates standardized and custom visualizations to communicate portfolio performance effectively.
Capabilities
Dashboard Generation
- Create standardized portfolio dashboards
- Support custom dashboard configurations
- Generate multiple view types (summary, detail)
- Enable drill-down capabilities
Visualization Creation
- Generate charts and graphs
- Create portfolio heatmaps
- Build comparison visualizations
- Support interactive elements
Performance Tracking
- Visualize fund performance metrics
- Track company performance over time
- Compare against benchmarks
- Highlight top/bottom performers
LP Reporting Support
- Generate LP-ready visualizations
- Support ILPA reporting formats
- Create quarterly report exhibits
- Enable export to presentations
Usage
Build Portfolio Dashboard
Input: Portfolio data, dashboard configuration
Process: Generate visualizations
Output: Complete dashboard, export files
Create Custom Visualization
Input: Data, visualization specifications
Process: Build specified visualization
Output: Custom chart/graph
Generate LP Report Exhibits
Input: Quarterly data, report template
Process: Create standardized exhibits
Output: LP-ready visualizations
Update Existing Dashboard
Input: New data, existing dashboard
Process: Refresh with new data
Output: Updated dashboard
Dashboard Components
| Component | Purpose |
|---|---|
| Portfolio Summary | High-level fund metrics |
| Company Grid | Status by company |
| Performance Charts | Returns over time |
| Sector Analysis | Allocation views |
| Benchmark Comparison | Performance vs. benchmarks |
Integration Points
- Quarterly Portfolio Reporting: Dashboard for reporting
- Exit Readiness Assessment: Exit-focused views
- KPI Aggregator: Feed data into dashboards
- Portfolio Reporter (Agent): Support reporting
Visualization Types
| Type | Use Case |
|---|---|
| Bar Charts | Period comparisons |
| Line Charts | Trends over time |
| Heatmaps | Multi-dimensional status |
| Pie/Donut | Allocation breakdown |
| Scatter Plots | Multi-variable analysis |
| Tables | Detailed data display |
Best Practices
- Prioritize clarity over complexity
- Use consistent color schemes
- Include appropriate context
- Enable drill-down for details
- Optimize for audience (internal vs. LP)
Related Skills
Attack Tree Construction
Build comprehensive attack trees to visualize threat paths. Use when mapping attack scenarios, identifying defense gaps, or communicating security risks to stakeholders.
Grafana Dashboards
Create and manage production Grafana dashboards for real-time visualization of system and application metrics. Use when building monitoring dashboards, visualizing metrics, or creating operational observability interfaces.
Matplotlib
Foundational plotting library. Create line plots, scatter, bar, histograms, heatmaps, 3D, subplots, export PNG/PDF/SVG, for scientific visualization and publication figures.
Scientific Visualization
Create publication figures with matplotlib/seaborn/plotly. Multi-panel layouts, error bars, significance markers, colorblind-safe, export PDF/EPS/TIFF, for journal-ready scientific plots.
Seaborn
Statistical visualization. Scatter, box, violin, heatmaps, pair plots, regression, correlation matrices, KDE, faceted plots, for exploratory analysis and publication figures.
Shap
Model interpretability and explainability using SHAP (SHapley Additive exPlanations). Use this skill when explaining machine learning model predictions, computing feature importance, generating SHAP plots (waterfall, beeswarm, bar, scatter, force, heatmap), debugging models, analyzing model bias or fairness, comparing models, or implementing explainable AI. Works with tree-based models (XGBoost, LightGBM, Random Forest), deep learning (TensorFlow, PyTorch), linear models, and any black-box model
Pydeseq2
Differential gene expression analysis (Python DESeq2). Identify DE genes from bulk RNA-seq counts, Wald tests, FDR correction, volcano/MA plots, for RNA-seq analysis.
Query Writing
For writing and executing SQL queries - from simple single-table queries to complex multi-table JOINs and aggregations
Pydeseq2
Differential gene expression analysis (Python DESeq2). Identify DE genes from bulk RNA-seq counts, Wald tests, FDR correction, volcano/MA plots, for RNA-seq analysis.
Scientific Visualization
Meta-skill for publication-ready figures. Use when creating journal submission figures requiring multi-panel layouts, significance annotations, error bars, colorblind-safe palettes, and specific journal formatting (Nature, Science, Cell). Orchestrates matplotlib/seaborn/plotly with publication styles. For quick exploration use seaborn or plotly directly.