farstic/ai-servicenow-architect / .claude/skills/reporting-analytics-specialist
reporting-analytics-specialist
VerifiedUse when reporting is in scope — report, dashboard, KPI, Performance Analytics, indicator, breakdown, scorecard, target, data collection. Decides report versus Performance Analytics. Produces report and analytics designs, not code or the data model.
| File | Kind | Size |
|---|---|---|
| EXAMPLES.md | markdown | 3.2 KB |
| SKILL.md | skill md | 8.5 KB |
EXAMPLES.md
View on GitHub# Reporting & Analytics Specialist v1.0 — Worked Example
One example. Read alongside `SKILL.md`.
---
## Example — "A CSM leadership dashboard: open cases, SLA attainment trend, and resolution time by tier."
```markdown
# Reporting & Analytics Design — CSM leadership dashboard
## Metrics
- **Open cases** — count of `sn_customerservice_case` where state ∈ {New, Open, Awaiting…}; unit = cases; grain = now.
- **SLA attainment %** — % of `task_sla` met vs breached on cases; unit = %; grain = daily trend over 12 months.
- **Avg resolution time by customer tier** — mean (resolved_at − opened_at) grouped by account tier; unit = hours; grain = monthly trend.
## Report vs PA decision
- **Open cases** → **Report** (operational, real-time, small live result).
- **SLA attainment % (12-mo trend)** → **PA indicator** — it's a *trend over time*; a live report can't show historical movement, and re-querying `task_sla` per load is wasteful. Snapshot daily.
- **Resolution time by tier (monthly trend)** → **PA indicator with a breakdown by tier** — trend + dimension; PA is the right tool, not a custom monthly-rollup table.
## PA model
- Indicator: *SLA attainment* (formula indicator over met/breached counts), daily collection.
- Indicator: *Avg resolution time*, monthly, **breakdown = customer tier** (Platinum/Gold/Silver).
- Targets/thresholds: SLA attainment target 95% (red <90, amber 90–95, green ≥95).
- Widgets: time-series + scorecard with target; breakdown widget for resolution-by-tier.
## Reports
- *Open cases* — source `sn_customerservice_case`, filter on open states (indexed `state`), bar by priority, drill-down to the list.
## Dashboard composition
Audience: CSM leadership. One tab: top row = Open cases + SLA attainment scorecard (with target); second row = SLA trend line + resolution-by-tier breakdown. Consistent date filter.
## Visibility & ACL
Dashboard shared to a CSM-leadership group. Customer-identifying detail stays out of leadership aggregates → confirm with **Security & GRC** that drill-downs don't expose PII beyond the audience's rights.
## §1.1 verdict
**Configuration — PROCEED.** Reports + PA indicators/breakdowns/targets. **No custom rollup table** — the monthly/daily aggregates are PA snapshots, which is exactly what PA is for.
## Handoffs & consults
- **Performance & Scale** — confirm the SLA indicator collection job is efficient on `task_sla` at volume.
- **UI/UX** — if this dashboard lives inside the CSM workspace as a surface.
- **Security & GRC** — drill-down visibility on customer data.
## Open questions
OQ-CN-1. Is PA (and PA Premium for advanced breakdowns) licensed in this engagement?
OQ-CN-2. How far back should the trend history go (drives initial PA data-collection backfill)?
OQ-CN-3. Tier values source — `customer_account` tier field or entitlement level?
```
---
## Reading this example
The specialist makes the **report-vs-PA call per metric** (operational → report; trend/dimension → PA), and explicitly blocks the reflexive **custom monthly-rollup table** in favour of a **PA indicator** (§1.1). Scale and visibility are routed to the right consults.
---
*End of Reporting & Analytics Specialist EXAMPLES.md v1.0.*
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 |