analysis-artifacts
Generate reproducible analysis artifacts — SQL queries, Python visualizations, and summary tables — as you work through a BigQuery data analysis. Use when asked to conduct a deep dive, exploratory analysis, or investigation that goes beyond a simple data lookup.
- License 许可
- MIT
- 所属仓库
- agisota/old-one
- 最近更新
- 2026-07-04
- Stars
- ★ 3
- Forks
- 1
01 前言 Front Matter
- name
- analysis-artifacts
- description
- Generate reproducible analysis artifacts — SQL queries, Python visualizations, and summary tables — as you work through a BigQuery data analysis. Use when asked to conduct a deep dive, exploratory analysis, or investigation that goes beyond a simple data lookup.
03 SKILL.md 正文
Analysis Artifacts
When to Use
- When asked to do a "deep dive" or "analysis" on a question with a non-obvious answer
- When the analysis requires exploratory querying in BigQuery
- When the output should be reproducible and shareable (not just a one-off answer)
Workflow
1. Scaffold the analysis directory
At the start of every analysis:
- Create a new directory in the
analysesfolder, named according to the existing pattern there - Create subdirectories:
/assets/queriesand/assets/visualizations - Create a
README.mdat the root of the new directory — this is the main readable document for the analysis
2. Plan the analysis
Always create a plan before starting, whether or not the user asked for one. Steps in the plan should map to the logical sub-questions or sub-areas you've deemed important to explore. Present the plan and wait for a go-ahead before proceeding.
3. Set up the README
Once the plan is approved:
-
Add a title, author, and date to the top of the README
-
Add a Problem Statement section summarizing the analysis question and the sub-pieces you'll explore
-
Add a Cohorts Definition section. This must be extremely explicit about the groups being compared. If comparing two groups (e.g., free vs. paid, new vs. old, before vs. after a milestone), define cohorts in a way that controls for confounding factors. Consider:
- Signup/activation time (as defined by your product — e.g., first login, first meaningful action); this relates to user tenure
- Plan type or subscription tier (e.g., free vs. paid)
- Controlling for observation time window length across cohorts
- Product-specific usage propensity metrics relevant to the analysis question
Once defined, respect these cohort definitions in all queries throughout the analysis.
4. Create artifacts as you go
For every material step in the analysis:
- SQL query artifact: For any BigQuery query that powers a visualization, summary, or key insight, save a
.sqlfile in/assets/queries/with a descriptive name and a comment block explaining the query's purpose. Only create the file after you're satisfied with the results. Skip trivial or one-off lookup queries. - Visualization or table artifact: For each key insight, assess whether it's best conveyed through a chart or a table. Lean toward visualizations. If a visualization, write a Python script to generate it and save both the script and the output image to
/assets/visualizations/with descriptive names. If a table, save it as a.csvin/assets/visualizations/.
5. Overwriting artifacts
If you need to redo part of the analysis (due to a methodology correction or user feedback), overwrite all associated artifacts:
- Replace the
.sqlquery file - Replace the visualization script and regenerate the image
- Replace the
.csvtable file
Note the change to the user when you do this.
6. Summarize the analysis
When the analysis is complete (either at the end of the plan or when the user asks), write the full README:
- Summarize each step and sub-question in logical document sections
- Be crisp and concise — avoid unnecessary verbosity
- Embed saved viz images from
/assets/visualizations/where appropriate - Generate markdown tables from
.csvfiles in/assets/visualizations/ - Include a small reference hyperlink to the associated query file in each section
- Add a TL;DR section near the top (after Problem Statement, before Cohorts Definition)
- Add a Key Takeaways section at the end
Examples
analyses/
└── 2024-01-user-retention/
├── README.md
└── assets/
├── queries/
│ ├── cohort_retention_by_week.sql
│ └── retention_by_plan_type.sql
└── visualizations/
├── retention_curve.py
├── retention_curve.png
└── plan_type_summary.csv
04 同仓库更多 Skills
zoom-out
Tell the agent to zoom out and give broader context or a higher-level perspective. Use when you're unfamiliar with a section of code or need to understand how it fits into the bigger picture.
zeroize-audit
Detects missing zeroization of sensitive data in source code and identifies zeroization removed by compiler optimizations, with assembly-level analysis, and control-flow verification. Use for auditing C/C++/Rust code handling secrets, keys, passwords, or other sensitive data.
yeet
Use only when the user explicitly asks to stage, commit, push, and open a GitHub pull request in one flow using the GitHub CLI (`gh`).
yara-rule-authoring
Guides authoring of high-quality YARA-X detection rules for malware identification. Use when writing, reviewing, or optimizing YARA rules. Covers naming conventions, string selection, performance optimization, migration from legacy YARA, and false positive reduction. Triggers on: YARA, YARA-X, malware detection, threat hunting, IOC, signature, crx module, dex module.
x-twitter-growth
X/Twitter growth engine for building audience, crafting viral content, and analyzing engagement. Use when the user wants to grow on X/Twitter, write tweets or threads, analyze their X profile, research competitors on X, plan a posting strategy, or optimize engagement. Complements social-content (generic multi-platform) with X-specific depth: algorithm mechanics, thread engineering, reply strategy, profile optimization, and competitive intelligence via web search.
x-api
X/Twitter API integration for posting tweets, threads, reading timelines, search, and analytics. Covers OAuth auth patterns, rate limits, and platform-native content posting. Use when the user wants to interact with X programmatically.