borghei/Claude-Skills / data-analytics/analytics-engineer
analytics-engineer
VerifiedAnalytics engineering across data modeling, dbt, transformation, and semantic layers. Use when building dbt models, designing star schemas, writing staging or mart SQL, configuring data tests, or optimizing warehouse queries.
| File | Kind | Size |
|---|---|---|
| REFERENCE.md | markdown | 4.2 KB |
| SKILL.md | skill md | 13.4 KB |
| assets/dbt_project.yml | config | 1.1 KB |
| assets/macros.sql | other | 1.5 KB |
| assets/schema.yml | config | 1.4 KB |
| assets/source.yml | config | 1.0 KB |
| references/dbt_style_guide.md | markdown | 2.7 KB |
| references/modeling_patterns.md | markdown | 3.2 KB |
| references/optimization.md | markdown | 3.0 KB |
| references/testing_guide.md | markdown | 2.4 KB |
| scripts/doc_generator.pyexecutable | script | 3.2 KB |
| scripts/impact_analyzer.pyexecutable | script | 3.5 KB |
| scripts/quality_scorer.pyexecutable | script | 3.9 KB |
| scripts/schema_diff.pyexecutable | script | 4.0 KB |
assets/schema.yml
View on GitHubversion: 2
models:
- name: fct_orders
description: "{{ doc('fct_orders_doc') }}" # Points to corresponding .md file
config:
materialized: incremental
unique_key: order_id
cluster_by: ['order_date']
columns:
- name: order_id
description: "Surrogate PK for the order."
tests:
- unique
- not_null
- name: customer_id
description: "FK routing back to dim_customers."
tests:
- not_null
- relationships:
to: ref('dim_customers')
field: customer_id
- name: order_status
description: "Current progression state."
tests:
- accepted_values:
values: ['pending', 'shipped', 'cancelled', 'returned']
- name: total_amount
description: "Gross revenue of the order in USD."
tests:
- not_null
# Requires: dbt-utils in packages.yml
- dbt_utils.expression_is_true:
expression: ">= 0"
# Sample Semantic Layer Configuration
metrics:
- name: gross_revenue
label: Gross Revenue
model: ref('fct_orders')
description: "Total gross amount driven by closed-won sales."
calculation_method: sum
expression: total_amount
timestamp: order_date
time_grains: [day, week, month, quarter]
dimensions:
- order_status
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| finishing-a-development-branchobra/superpowersUse when implementation is complete, all tests pass, and you need to decide how to integrate the work | Stars: 322k | Updated | Claude CodeCodex | Verified | Install |
| systematic-debuggingobra/superpowersUse when encountering any bug, test failure, or unexpected behavior, before proposing fixes | Stars: 322k | Updated | Claude CodeCodex | Verified | Install |
| test-driven-developmentobra/superpowersUse when implementing any feature or bugfix, before writing implementation code | Stars: 322k | Updated | Claude CodeCodex | Verified | Install |
| skill-creatoranthropics/skillsCreate new skills, modify and improve existing skills, and measure skill performance. Use when users want to create a skill from scratch, edit, or optimize an existing skill, run evals to test a skill, benchmark skill performance with variance analysis, or optimize a skill's description for better triggering accuracy. | Stars: 198k | Updated | Claude CodeCodex | Verified | Install |