PranavNagrecha/AwesomeSalesforceSkills / skills/admin/einstein-analytics-basics
einstein-analytics-basics
VerifiedUse when deciding whether Salesforce Reports, CRM Analytics, or Tableau is the right level of analytics tooling, and when reviewing or troubleshooting basic CRM Analytics designs. Triggers: 'CRM Analytics', 'Einstein Analytics', 'Tableau CRM', 'lens', 'dataset', 'dataflow', 'analytics dashboard', 'license requirement'. NOT for a detailed CRM Analytics vs Tableau licensing and platform comparison — use architect/crm-analytics-vs-tableau-decision. NOT for building the app, lenses and datasets — use admin/crm-analytics-app-creation.
| File | Kind | Size |
|---|---|---|
| SKILL.md | skill md | 10.4 KB |
| references/examples.md | markdown | 5.6 KB |
| references/gotchas.md | markdown | 8.8 KB |
| references/llm-anti-patterns.md | markdown | 8.3 KB |
| references/well-architected.md | markdown | 2.6 KB |
| scripts/check_analytics_assets.py | script | 4.5 KB |
| templates/analytics-evaluation-template.md | markdown | 1.3 KB |
scripts/check_analytics_assets.py
View on GitHub#!/usr/bin/env python3
"""Audit CRM Analytics dashboard and planning files for common anti-patterns."""
from __future__ import annotations
import argparse
import json
import re
import sys
from pathlib import Path
TEXT_SUFFIXES = {".json", ".wdash", ".xmd", ".md", ".txt"}
HOSTNAME_PATTERN = re.compile(
r"https?://[A-Za-z0-9.-]*(salesforce|force)\.com|my\.salesforce\.com|lightning\.force\.com",
re.IGNORECASE,
)
SEVERITY_WEIGHTS = {"CRITICAL": 20, "HIGH": 10, "MEDIUM": 5, "LOW": 1, "REVIEW": 0}
def iter_files(paths: list[str]) -> list[Path]:
files: list[Path] = []
for raw in paths:
path = Path(raw)
if path.is_file():
files.append(path)
elif path.is_dir():
files.extend(candidate for candidate in path.rglob("*") if candidate.is_file())
else:
files.append(path)
return files
def normalize_finding(finding: str) -> dict[str, str]:
severity, _, remainder = finding.partition(" ")
location = ""
message = remainder
if ": " in remainder:
location, message = remainder.split(": ", 1)
return {"severity": severity or "INFO", "location": location, "message": message}
def emit_result(findings: list[str], summary: str) -> int:
normalized = [normalize_finding(finding) for finding in findings]
score = max(0, 100 - sum(SEVERITY_WEIGHTS.get(item["severity"], 0) for item in normalized))
print(json.dumps({"score": score, "findings": normalized, "summary": summary}, indent=2))
if normalized:
print(f"WARN: {len(normalized)} finding(s) detected", file=sys.stderr)
return 1 if normalized else 0
def count_widgets(payload: object) -> int:
total = 0
if isinstance(payload, dict):
for key, value in payload.items():
if key == "widgets":
if isinstance(value, dict):
total += len(value)
elif isinstance(value, list):
total += len(value)
total += count_widgets(value)
elif isinstance(payload, list):
for item in payload:
total += count_widgets(item)
return total
def has_filters(payload: object) -> bool:
if isinstance(payload, dict):
for key, value in payload.items():
if key in {"filters", "filterpanel", "filterPanel"} and value:
return True
if has_filters(value):
return True
elif isinstance(payload, list):
return any(has_filters(item) for item in payload)
return False
def audit_file(path: Path, max_widgets: int) -> list[str]:
findings: list[str] = []
if not path.exists():
return [f"HIGH {path}: file not found"]
if path.suffix.lower() not in TEXT_SUFFIXES:
return findings
text = path.read_text(encoding="utf-8", errors="ignore")
if HOSTNAME_PATTERN.search(text):
findings.append(f"MEDIUM {path}: hardcoded Salesforce hostname found; use environment-safe references")
if "TODO" in text:
findings.append(f"LOW {path}: unresolved TODO markers remain")
if path.suffix.lower() in {".json", ".wdash", ".xmd"}:
try:
payload = json.loads(text)
except json.JSONDecodeError as exc:
findings.append(f"MEDIUM {path}: invalid JSON ({exc.msg})")
return findings
widgets = count_widgets(payload)
if widgets > max_widgets:
findings.append(
f"MEDIUM {path}: dashboard appears to contain {widgets} widgets; trim to decision-focused views"
)
if widgets and not has_filters(payload):
findings.append(f"LOW {path}: dashboard has widgets but no obvious filter configuration")
return findings
def main() -> int:
parser = argparse.ArgumentParser(
description="Check CRM Analytics files for hardcoded hostnames, oversized dashboards, and unfinished planning docs."
)
parser.add_argument("paths", nargs="+", help="Files or directories to inspect")
parser.add_argument("--max-widgets", type=int, default=12, help="Warn if a dashboard exceeds this widget count")
args = parser.parse_args()
findings: list[str] = []
files = iter_files(args.paths)
for path in files:
findings.extend(audit_file(path, args.max_widgets))
if not files:
findings.append("HIGH no analytics asset files matched the provided paths")
summary = f"Scanned {len(files)} analytics asset file(s); {len(findings)} finding(s) detected."
return emit_result(findings, summary)
if __name__ == "__main__":
sys.exit(main())
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 |