Open Data Investigation Analyst
Uncover hidden stories in open datasets with rapid pattern analysis
What You Can Do
Analyze open datasets at scale to surface newsworthy patterns, validate data quality, and generate structured findings. You'll identify anomalies, correlations, and trends that often go unnoticed, then transform raw numbers into compelling narratives backed by rigorous analysis.
Features
Rapidly scan datasets to identify statistically significant patterns, correlations, and outliers that may signal important stories
Validate dataset integrity, flag missing values, inconsistencies, and potential data entry errors before analysis
Transform findings into structured data stories with clear headlines, supporting evidence, and implications
Process CSV, JSON, Excel, and other structured formats; handles messy real-world data cleaning automatically
Verify that claims are statistically sound, calculate confidence levels, and flag overreaching conclusions
Pinpoint unusual data points that warrant investigation or represent potential story angles
Maintain clear citations to original data sources and government agencies; verify dataset provenance
Generate structured reports with visualizable metrics, methodology notes, and data download links
Example Output
Analysis Report: Housing Affordability Crisis Accelerating
Finding: Median rent-to-income ratio exceeded 35% in 247 US counties for the first time in 5 years (HUD open dataset, 2025).
Pattern Identified: Fastest growth in tier-2 cities (Austin +18%, Raleigh +16%) previously known for affordability.
Data Quality: 3 counties excluded due to incomplete reporting; methodology note included.
Story Angle: "The Affordability Paradox: Why Tech Hubs Are Pricing Out Their Own Workers"
Second Example: Environmental Violations Spike Before Inspections
Analyzing EPA enforcement data reveals facilities report 42% MORE violations after regulatory announcements. Statistical confidence: 94%. Hypothesis: increased reporting vs. actual behavior change pending further investigation.
What's Included
- Dataset Analysis Framework: Structured workflow for ingesting, cleaning, exploring, and validating public datasets
- Data Validation Checklist: Comprehensive quality checks: missing data, duplicates, outliers, format inconsistencies, temporal gaps
- Story Structure Template: Proven narrative format for data journalism: finding → evidence → implications → next steps
- Statistical Methods Guide: Reference for appropriate tests, confidence intervals, and significance thresholds for different data types
- Findings Report Generator: Markdown-based template that auto-generates formatted reports with sources, methodology, and caveats
- Public Data Source Directory: Curated list of vetted open datasets (government, NGO, academic) organized by topic and quality
Who It's For
- Data Journalists
- Investigative Reporters
- Policy Researchers & Analysts
- NGO & Nonprofit Program Officers
- Academic Researchers
Best For
- Discovering newsworthy trends in government datasets
- Validating data integrity before publication
- Structuring raw data findings into narrative stories
- Identifying anomalies that warrant deeper investigation
- Building databases of multi-year patterns for longitudinal analysis
You might also like
You can rapidly accelerate every stage of photojournalism—from initial story research and competitive analysis to comprehensive shot lists, optimized captions, and polished editorial submissions. The workflow guides you through breaking news scenarios, helping you research context, plan coverage angles, write SEO-optimized captions, and format submissions for maximum editorial impact. Save hours on administrative work and focus on capturing the story.
by manwithstyle
Analyze Docker container logs instantly to identify root causes of failures, crashes, and resource bottlenecks. Get actionable recommendations for resource allocation, network configuration, and architectural improvements that eliminate production issues before they cascade.
by manwithstyle
Quickly architect scalable, reusable Terraform modules that follow HashiCorp best practices and organizational standards. Get automated reviews that catch common pitfalls—variable naming, provider configuration, resource dependencies—before they reach production. Standardize your infrastructure-as-code across teams with instant feedback on module quality, security posture, and cost optimization opportunities.
by manwithstyle
Manage your entire story development pipeline—from assignment briefs and source research guidance to fact-checking verification and copy editing—all within Claude's context. You'll generate assignment templates, receive real-time editorial feedback, identify verification gaps, and receive copyediting suggestions with tracked changes. The skill handles complex multi-source stories, deadline pressure, and maintains editorial standards across your publication.
by manwithstyle
This skill transforms raw news stories, breaking news updates, or news briefs into professionally structured podcast scripts ready for immediate recording. It verifies sources, organizes content into logical segments with host delivery notes, and ensures smooth pacing and listener engagement. You get a complete, production-ready script with no rewriting needed—just download, review, and record.
by manwithstyle
You'll design comprehensive Datadog monitoring architectures centered on service-level objectives (SLOs) and error budgets, eliminating alert fatigue while improving incident detection. Claude helps you structure alerts by severity, define intelligent suppression rules, and create role-based dashboards that enable faster triage and response. You'll get actionable monitoring strategies tailored to your specific services, dependencies, and on-call workflows.
by manwithstyle
Create production-ready Grafana dashboards that visualize your metrics effectively and perform efficiently. Claude helps you write optimized PromQL and other database queries, configure smart alerts with custom thresholds, and design intuitive layouts that surface the metrics that matter most. You get dashboard JSON, query recommendations, and alert configurations ready to deploy.
by manwithstyle
Transform breaking news briefs into compelling visual story frameworks that guide photographers toward impactful coverage. You'll receive multiple narrative angles, detailed shot lists organized by scene and purpose, and complete assignment briefs with sourcing guidance. Each output ensures comprehensive emotional and contextual storytelling from first frame to final edit.
by manwithstyle