Skip to content

borghei/Claude-Skills / data-analytics/analytics-engineer

analytics-engineer

Verified

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

FileKindSize
REFERENCE.mdmarkdown4.2 KB
SKILL.mdskill md13.4 KB
assets/dbt_project.ymlconfig1.1 KB
assets/macros.sqlother1.5 KB
assets/schema.ymlconfig1.4 KB
assets/source.ymlconfig1.0 KB
references/dbt_style_guide.mdmarkdown2.7 KB
references/modeling_patterns.mdmarkdown3.2 KB
references/optimization.mdmarkdown3.0 KB
references/testing_guide.mdmarkdown2.4 KB
scripts/doc_generator.pyexecutablescript3.2 KB
scripts/impact_analyzer.pyexecutablescript3.5 KB
scripts/quality_scorer.pyexecutablescript3.9 KB
scripts/schema_diff.pyexecutablescript4.0 KB

assets/schema.yml

View on GitHub
version: 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
finishing-a-development-branchobra/superpowersUse when implementation is complete, all tests pass, and you need to decide how to integrate the workStars: 322kUpdated Claude CodeCodexVerifiedInstall
systematic-debuggingobra/superpowersUse when encountering any bug, test failure, or unexpected behavior, before proposing fixesStars: 322kUpdated Claude CodeCodexVerifiedInstall
test-driven-developmentobra/superpowersUse when implementing any feature or bugfix, before writing implementation codeStars: 322kUpdated Claude CodeCodexVerifiedInstall
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: 198kUpdated Claude CodeCodexVerifiedInstall