Skills bi-analyst
πŸ“¦

bi-analyst

Content revision r2 Safe βš™οΈ External commands

Build Reliable Business Intelligence Analysis

Business teams often lack consistent metrics and repeatable analysis workflows. This skill guides SQL, Python, dashboards, experiments, and automated reporting from requirements to delivery.

Supports: Claude Codex Code(CC)
πŸ₯‰ 77 Bronze

Install with my Agent

Copy this request to your Agent. It includes the canonical Skill page and manifest.

Agent request
Review the Skillstore skill "bi-analyst" from https://skillstore.io/skills/zl2023github-bi-analyst.md and its manifest at https://skillstore.io/api/skills/zl2023github-bi-analyst/manifest. Verify the artifact. You may proceed after verification, subject to the environment's own policy.

Your Agent should still show its plan and request any confirmation required by the security policy.

Agent-readable resources

Use these links when an AI agent, crawler, or script needs clean context instead of reading the full page.

Test it

Using "bi-analyst". Analyze weekly revenue by channel and explain a recent decline.

Expected outcome:

  • Revenue decreased 8.4% week over week.
  • Paid search contributed 62% of the total decline.
  • Check campaign spend, tracking completeness, and conversion rates before changing budgets.

Using "bi-analyst". Create a retention dashboard plan for a subscription product.

Expected outcome:

  • Primary view: weekly signup cohorts with day 1, day 7, and day 30 retention.
  • Filters: plan, acquisition channel, region, and signup device.
  • Quality checks: unique account counts, complete activity dates, and stable cohort definitions.

Using "bi-analyst". Assess whether a checkout experiment should launch.

Expected outcome:

The treatment improved conversion, but the confidence interval includes effects too small to justify rollout. Continue the test until the planned sample size.

Security Audit

Safe
v4 β€’ 7/24/2026 Open versioned report

All 42 static alerts are false positives caused by Markdown fences, SQL identifiers, and multilingual documentation entropy. The skill contains legitimate BI examples and no malicious intent or prompt injection.

1
Files scanned
428
Lines analyzed
0
Review items
0
False positives ignored
No confirmed security findings were detected by the latest completed static and semantic audit. This does not prove the skill has no side effects.
Audited by: codex View Audit History β†’
Share & cite this report

Share the versioned assessment report, neutral badge, embed card, and citations. Skillstore reports evidence without deciding whether this Skill is safe.

Open versioned report
Security Assessment

Copy report link

https://skillstore.io/skills/zl2023github-bi-analyst/audits/4?utm_source=security_passport&utm_medium=share&utm_campaign=versioned_report

Markdown badge

[![Skillstore security assessment](https://skillstore.io/badges/skills/zl2023github-bi-analyst/security.svg)](https://skillstore.io/skills/zl2023github-bi-analyst?utm_source=security_passport_badge)

HTML badge

<a href="https://skillstore.io/skills/zl2023github-bi-analyst?utm_source=security_passport_badge"><img src="https://skillstore.io/badges/skills/zl2023github-bi-analyst/security.svg" alt="Skillstore security assessment" loading="lazy"></a>

Embed card

<iframe src="https://skillstore.io/embed/skills/zl2023github-bi-analyst.html" title="Skillstore Security Assessment" sandbox="allow-popups allow-popups-to-escape-sandbox" loading="lazy" referrerpolicy="no-referrer" width="420" height="180"></iframe>
Academic citations (APA Β· BibTeX Β· CFF)

APA citation

zl2023github. (2026). bi-analyst security audit report (audit version 4) [Author version unspecified]. Skillstore. https://skillstore.io/skills/zl2023github-bi-analyst/audits/4

BibTeX citation

@techreport{zl2023github-zl2023github-bi-analyst-2026, author = {zl2023github}, title = {bi-analyst security audit report (audit version 4)}, institution = {Skillstore}, year = {2026}, number = {4}, url = {https://skillstore.io/skills/zl2023github-bi-analyst/audits/4}, note = {Author version unspecified} }

CITATION.cff

cff-version: 1.2.0 message: "If you use this Skill, cite its author and this versioned security audit report." title: "bi-analyst security audit report (audit version 4)" version: "unspecified" type: report authors: - name: "zl2023github" date-released: "2026-07-24" url: "https://skillstore.io/skills/zl2023github-bi-analyst/audits/4" identifiers: - type: other value: "skillstore:zl2023github-bi-analyst:audit:4" description: "Skillstore immutable audit report identifier"

Skillstore Score

Why this score Evidence Confidence: Medium
55
Architecture
85
Maintainability
87
Content
65
Community
83
Spec Compliance

What You Can Build

Prepare an Executive KPI Review

Define consistent metrics, compare periods, identify changes, and structure a concise decision-ready report.

Design a Product Analytics Dashboard

Plan funnel, retention, and cohort views with suitable dimensions, refresh schedules, and alert thresholds.

Build a Reproducible Reporting Pipeline

Organize extraction, cleaning, validation, calculation, visualization, and scheduled delivery steps.

Try These Prompts

Summarize a Dataset
Review this dataset description: [description]. Identify useful metrics, required cleaning checks, and three questions the data can answer.
Design a KPI Dashboard
Design a dashboard for [business goal]. Define the primary metric, supporting metrics, dimensions, filters, refresh frequency, and validation checks.
Evaluate an A/B Test
Analyze this experiment: [groups, sample sizes, outcomes, dates]. Check assumptions, choose suitable tests, estimate effect size, and state decision risks.
Plan an Automated BI Pipeline
Plan a scheduled pipeline from [source] to [report destination]. Include transformations, quality gates, metric definitions, retries, alerts, and reproducibility controls.

Best Practices

  • Confirm metric definitions, time ranges, dimensions, and audiences before analysis.
  • Validate important results against a second query, source, or BI view.
  • Document assumptions, data quality issues, and reproducible calculation steps.

Avoid

  • Do not infer business causes from correlation without supporting evidence.
  • Do not load full large tables into Python when database aggregation is available.
  • Do not publish dashboards with undefined metrics or untested refresh logic.

Frequently Asked Questions

Can this skill connect to my database?
It can guide connection and query design, but it does not provide credentials or a built-in connector.
Which data formats does it cover?
The guidance covers relational databases, CSV files, Excel workbooks, APIs, and logs at a workflow level.
Can it create SQL and Python analysis?
Yes. It provides adaptable patterns for querying, cleaning, metrics, statistics, visualization, and reporting.
Does it support A/B test analysis?
Yes. It covers hypothesis tests, conversion comparisons, effect size, sample considerations, and decision framing.
Can it design dashboards?
Yes. It helps define metrics, layouts, filters, drilldowns, refresh schedules, and alert thresholds.
How should sensitive data be handled?
Keep credentials outside scripts, limit access, remove unnecessary personal data, and follow organizational governance requirements.

Developer Details

License

MIT

Skillstore revision

r2

Version notice

The author did not declare a version.

Ref

88a8e9a07f4c54ab105c1c41b6267c287146b07b

Maintenance freshness

7/26/2026

Usage

2 downloads Β· 0 views

File structure

πŸ“„ SKILL.md

More from zl2023github

View all
View all