Brainforge Knowledge

dbt-audit-one-pager

5 min read

One-Pager: dbt Audit Service

Top Section: Visual Storytelling

Headline: Cut Your dbt Runtime 50%+. Fix DAG Cycles. Rebuild Trust.

Subheadline: We audit your dbt project—models, tests, dependencies, architecture—and deliver a prioritized roadmap in 3-4 weeks. Fix what’s broken. Scale with confidence.

Key Stats (Display Prominently):

  • 50%+ faster runtime - Cut 4-hour runs to 2 hours or less
  • 3-4 weeks to clarity - Complete audit and prioritized roadmap
  • 600-line files → 100-line modules - Transform chaos into maintainable code

Primary Visual Suggestion:

  • Type: Before/After Split Visual
  • Description: Split-screen showing chaotic dbt dependency graph (left, messy, red tones) transforming into clean, organized infrastructure (right, structured, green/blue tones)
  • Purpose: Immediately communicate the transformation from chaos to clarity
  • Placement: Top section, full width or prominent left/right split
  • Size: Large/dominant, takes up top 1/3 of page

Stat Visualizations:

  • 50%+ faster runtime: Large number display with gauge chart showing improvement
  • 3-4 weeks to clarity: Timeline icon with number, showing speed
  • 600 → 100 lines: Before/after bar chart or number comparison

Layout Notes:

  • Top 1/3 of page should be visual storytelling zone
  • Primary visual (before/after) on left or full width
  • Key stats displayed prominently on right or below visual
  • Use large, scannable numbers with short labels
  • Visual hierarchy: Most important stat (50% faster) should be most prominent

Value Proposition

Copy: We audit your dbt project—models, tests, dependencies, documentation, architecture. Identify what’s broken. Deliver prioritized roadmap: what to fix first, what’s working, how to scale. Clarity in 3-4 weeks.

Visual Suggestion:

  • Transformation Arrow: Visual arrow showing progression from audit → roadmap → implementation
  • Supporting Icon: Magnifying glass or assessment icon
  • Placement: Small icon or illustration supporting the copy

Benefits

Copy:

  • 50%+ runtime reduction - 4-hour runs → 2 hours or less
  • Overnight completion - Data ready before business hours
  • Modular code - 600-line models → 100-line blocks, easier to debug
  • Faster onboarding - Clear docs, naming conventions, modular structure
  • Working tests - Fix broken tests, establish data quality standards
  • Scale confidently - Add sources, increase refresh cadence

Visual Suggestions:

  • Cut runtime: Speed/clock icon - Fast-forward or clock with checkmark
  • Reports ready: Calendar/clock icon - Overnight timeline visual
  • Easier debugging: Debug/magnifying glass icon - Code blocks with checkmark
  • Knowledge transfer: Team/people icon - Team collaboration visual
  • Rebuild trust: Shield/checkmark icon - Trust badge or quality seal
  • Scale with confidence: Growth/arrow icon - Upward trending arrow

Layout:

  • 2x3 grid or 3x2 grid layout
  • Icon + benefit text for each
  • Consistent icon style
  • Scannable, not text-dense

Audience

Copy: For VP/Head of Data, Analytics Engineers, CTOs with data backgrounds at growth-stage companies (100M ARR) with existing dbt projects. Frustrated with slow runs, unmaintainable code, lack of documentation.

Visual Suggestion:

  • Persona Illustration: Professional illustration of data engineer/CTO persona
  • Target Audience Icons: Icons representing CTO, analytics engineer, data team
  • Placement: Small illustration or icon set supporting the copy

Deliverables

Copy:

  • Infrastructure assessment (models, tests, dependencies, docs)
  • Prioritized fix list (ranked by impact)
  • Architecture recommendations (DRY, DAG cycles, modularity)
  • Performance analysis (bottlenecks, optimization strategies)
  • Documentation & testing plan
  • Implementation roadmap (phased by data mart)

Visual Suggestions:

  • Complete Assessment: Checklist icon - Document with checkmarks
  • Prioritized Fix List: Priority/ranking icon - Numbered list or priority badge
  • Architecture Recommendations: Architecture/building icon - Structure or blueprint
  • Performance Analysis: Speed/gauge icon - Performance meter or chart
  • Documentation Plan: Document/book icon - Document with text
  • Implementation Roadmap: Roadmap/map icon - Road with milestones

Layout:

  • Compact list with icons
  • 2 columns or single column with icons
  • Consistent icon style
  • Easy to scan

CTA + Plan

CTA: “Get Your Free dbt Audit Roadmap”

Brief Plan:

  1. Diagnose (Weeks 1-3): Audit models, tests, dependencies, documentation, architecture
  2. Design (Week 4): Prioritized roadmap with specific recommendations
  3. Deploy (Optional): Implement fixes in parallel infrastructure, keep daily ops running

Visual Suggestions:

  • CTA: Prominent button mockup with “Get Your Free Roadmap” text
  • Process: Simple 3-step flow diagram with numbered steps (1 → 2 → 3)
  • Step Icons:
    • Step 1: Magnifying glass or assessment icon
    • Step 2: Roadmap or document icon
    • Step 3: Rocket or implementation icon
  • Layout: CTA button prominent, process flow below or to the side

Notes for Designer

Overall Design Direction:

  • Top section should tell story visually (stats + visuals dominate top 1/3)
  • Maintain scannability throughout
  • Use whitespace effectively
  • Keep text concise (one-pager format)
  • Professional, technical, but approachable

Visual Hierarchy:

  • Top section = most visual impact
  • Stats should be immediately scannable (large numbers, clear labels)
  • Icons enhance but don’t clutter
  • Clear section breaks with visual separation

Brand Guidelines:

  • Follow existing brand guidelines
  • Use brand colors and fonts
  • Maintain visual consistency with other Brainforge materials

Key Design Principles:

  • Visual Storytelling First: Top section must communicate value immediately through visuals
  • Scannable: Use icons, bullets, short text blocks
  • Stats Prominent: Key metrics should be large and clear
  • Consistent Icons: Use consistent icon style throughout
  • Whitespace: Don’t overcrowd—one-pager should breathe

Color Usage:

  • Red/orange tones for problems (in before/after visual)
  • Green/blue tones for solutions (in before/after visual)
  • Brand colors for primary elements
  • High contrast for stats and CTAs

Layout Considerations:

  • Single page, portrait or landscape orientation
  • Clear section breaks
  • Visual flow from top to bottom
  • CTA should be prominent at bottom
  • Mobile-responsive if digital version

Graph View