# 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.

## Install

```bash
npx skillstore add zl2023github/bi-analyst
```

## Metadata

- Status: approved
- Slug: zl2023github-bi-analyst
- Skillstore revision: r2
- Version status: missing
- Tree hash: 3c2b4c42eeffc87247b0ee0fe3345a59b8d8aedc40ac5d363c3cf76a4bb9f7e0
- Author: zl2023github
- GitHub username: zl2023github
- License: MIT
- Repository: https://github.com/zl2023github/software-engineer-skills/tree/main/software-engineering/bi-analyst
- Ref: 88a8e9a07f4c54ab105c1c41b6267c287146b07b
- Supported tools: Claude, Codex, Claude Code
- Audit status: complete
- Agent install advisory: allowed
- Manual install advisory: allowed
- Artifact signature: available
- Audit attestation: unavailable
- Human verification: not\_verified
- Risk factors: external\_commands
- Quality score: 77
- Quality tier: bronze
- Public page: https://skillstore.pages.dev/skills/zl2023github-bi-analyst
- Manifest: https://skillstore.pages.dev/api/skills/zl2023github-bi-analyst/manifest

## Capabilities

- Clarifies data sources, business questions, time ranges, audiences, and delivery formats.
- Drafts SQL for retention analysis, aggregation, and star schema design.
- Provides Python patterns for cleaning, metric calculation, visualization, and quality checks.
- Structures funnel, cohort, anomaly, and A/B test analyses.
- Outlines automated Excel reports, cron schedules, and Airflow workflows.
- Creates report and dashboard structures with metrics, findings, and recommendations.

## Use Cases

- 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.

## Prompt Templates

### 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.
```

## Limitations

- Does not include live database connectors, credentials, or BI platform configuration.
- Example queries and scripts require adaptation to the actual schema and environment.
- Statistical examples do not replace validation of assumptions, sample design, or business context.
- Generated conclusions depend on the quality and completeness of supplied data.

## 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.

## Anti Patterns

- 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.

## Security Audit

- Audited at: 2026-07-24T02:16:30.083\+00:00
- Summary: 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.

## Stats

- Views: 0
- Downloads: 5
- Favorites: 0
- Popularity score: 0