PranavNagrecha/AwesomeSalesforceSkills / skills/admin/analytics-dashboard-design
analytics-dashboard-design
VerifiedUse when designing or troubleshooting CRM Analytics dashboards — chart types, bindings, faceting, dashboard interactions, mobile layout, and filters. NOT for standard Salesforce reports and dashboards — use admin/reports-and-dashboards-fundamentals. NOT for hand-editing dashboard JSON or a SAQL step — use admin/analytics-dashboard-json.
| File | Kind | Size |
|---|---|---|
| SKILL.md | skill md | 14.1 KB |
| references/examples.md | markdown | 4.0 KB |
| references/gotchas.md | markdown | 3.2 KB |
| references/llm-anti-patterns.md | markdown | 4.6 KB |
| references/well-architected.md | markdown | 2.8 KB |
| scripts/check_analytics_dashboard_design.pyexecutable | script | 3.7 KB |
| templates/analytics-dashboard-design-template.md | markdown | 2.1 KB |
templates/analytics-dashboard-design-template.md
View on GitHub# CRM Analytics Dashboard Design — Work Template
Use this template when designing or troubleshooting a CRM Analytics dashboard.
## Scope
**Skill:** `analytics-dashboard-design`
**Dashboard name:** (fill in)
**Target audience:** (executive / operations / self-service)
**Datasets in use:** (list all dataset names the dashboard will reference)
## Interaction Design
**Single dataset?** [ ] Yes [ ] No (multiple datasets)
**Filtering mechanism:**
- [ ] Faceting (same-dataset) — no JSON editing required
- [ ] Selection bindings (cross-dataset) — requires JSON editing
- [ ] Both
**Dynamic measure/grouping?** [ ] Yes [ ] No
If Yes: [ ] columnMap replaced with `"columns": []` for affected widgets
## Widget Plan
| Widget Name | Step Name | Dataset | Chart Type | Participates in Faceting? |
|---|---|---|---|---|
| | | | | [ ] Yes / [ ] No |
| | | | | [ ] Yes / [ ] No |
| | | | | [ ] Yes / [ ] No |
## Binding Configuration (if applicable)
| Source Step | Field | Target Step | Binding Syntax |
|---|---|---|---|
| | | | `{{cell(sourceStep.selection, 0, 'FieldName')}}` |
## Chart Type Rationale
| Widget | Chart Type Selected | Reason |
|---|---|---|
| | | |
| | | |
## Mobile Layout
**Mobile access required?** [ ] Yes [ ] No
If Yes:
- [ ] Mobile Designer mode opened
- [ ] Widgets arranged in single-column mobile layout
- [ ] Tested on mobile device
## columnMap Audit
For any widget using dynamic bindings:
| Widget Name | Binding Type | columnMap → columns: [] Applied? |
|---|---|---|
| | measure / grouping / filter | [ ] Yes / [ ] N/A |
## Post-Build Verification Checklist
- [ ] All SAQL steps execute without errors in isolation
- [ ] Faceting tested: clicking a chart element filters other same-dataset widgets
- [ ] Bindings tested: cross-dataset filtering works as expected
- [ ] Dynamic measure/grouping selector tested: chart renders correct data for each selection
- [ ] columnMap fix confirmed for any dynamic binding widgets
- [ ] Mobile layout tested on a real mobile device (if applicable)
- [ ] Dashboard tested with a non-admin user account
## Notes
(Record any deviations from standard design and the rationale.)
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| deprecation-and-migrationaddyosmani/agent-skillsManages deprecation and migration. Use when removing old systems, APIs, or features. Use when migrating users from one implementation to another. Use when migrating a database schema in production, such as renaming or dropping a column without downtime (expand/contract). Use when deciding whether to maintain or sunset existing code. | Stars: 119k | Updated | Claude CodeCodex | Verified | Install |
| performance-optimizationaddyosmani/agent-skillsOptimizes application performance across frontend, backend, queries, and databases. Use when performance requirements exist, when you suspect performance regressions, when Core Web Vitals or load times need improvement, when N+1 query patterns need fixing, or when profiling reveals bottlenecks. | Stars: 119k | Updated | Claude CodeCodex | Verified | Install |
| agent-cost-reportthedotmack/claude-memBelievable agent cost report for any period, default the last 7 full days PT, not counting today. Measured tokens from Claude Code transcripts priced at OpenRouter list prices (ESTIMATED), measured provider spend when a sanctioned source exists, note-taker cost separate, Timing-style HTML/PDF plus report.json, line-items.csv, evidence.json. | Stars: 118k | Updated | Claude CodeCodex | Verified | Install |
| agent-cost-reportthedotmack/claude-memBelievable agent cost report for any period, default the last 7 full days PT, not counting today. Measured tokens from Claude Code transcripts priced at OpenRouter list prices (ESTIMATED), measured provider spend when a sanctioned source exists, note-taker cost separate, Timing-style HTML/PDF plus report.json, line-items.csv, evidence.json. | Stars: 118k | Updated | Claude CodeCodex | Verified | Install |