Johnson & Timmis

Project Plan + Options

1. Data Strategy & Planning

   $0

   1. Discovery & Planning Session

      $2,000

      A structured intake session to understand your data sources, business goals, and reporting needs.

      Included:

      • Stakeholder interviews
      • Review of existing reports, tools, and pain points
      • High-level architecture plan

2. Data Warehouse Setup

   $0

   1. Warehouse Platform Setup

      $4,500

      We’ll provision your new data warehouse (e.g. Snowflake, Redshift, BigQuery) and establish the environment.
      

      Included:

      • Setup of staging, dev, and prod environments
      • Connection of storage and compute layers
      • User roles and access configured

   2. ETL Pipeline Development

      $3,500

      We’ll build the core data pipelines to connect and transform your most essential data sources.

      Included:

      • Integration with up to 3 standard, well-documented systems
      • Setup time per integration not to exceed 3 hours; excess billed at $150/hour
      • Transformation logic for business-critical tables
      • Basic logging and failure alerts

      Modifications

      1. Additional Data Source Integration

         $750 × 1 $750
      2. Custom Transformation Logic

         $1,000

   3. Data Modeling & Source of Truth

      $2,000

      We’ll define your core business metrics and model your data for consistent, scalable analysis.

      Included:

      • Up to 5 modeled tables (e.g. Customers, Revenue, Usage)
      • Metric definitions and business glossary
      • Basic validation rules

       Note: Additional tables or metric logic outside scope may require a custom quote. 

3. BI Dashboard Creation

   $0

   1. Dashboard Design & Build

      $4,000

      We’ll build 3 custom dashboards tailored to key stakeholders and use cases.

      Included:

      • Up to 3 dashboards (1 page each, max of 5 hours for implementation)
      • Common filters and drill-downs
      • Light theming / branding

       Note: Requests for additional dashboards, high-complexity visuals, or embedded tools may require a custom scope. 

   2. Dashboard Review & Revisions

      $1,500

      After delivery, we’ll meet with your team to review and refine the dashboards.

      Included:

      • One feedback call
      • Up to 2 rounds of minor revisions (≤3 hours total)

      Modifications

      1. Additional Dashboard

         $1,200 × 1 $1,200

         5 hours implementation max per dashboard

      2. Department Deep Dive

         $1,800

4. Optional Support & Training

   $0
   1. Stakeholder Training

      $1,200

      We’ll train your team on how to use, filter, and understand your new dashboards.

      Included:

      • 90-minute live Zoom training
      • 1-page quick reference guide
      • Recording provided
   2. Additional Dashboard Creation

      $850 × 2 $1,700/Month

      We'll create a new dashboard each month:

      • 5 hours max for implementation
      • Minimum 6-month term which gets you the discounted rate. $850 instead of $1,200.
   3. Monthly Data Maintenance

      $1,000/Month

      Ongoing monthly care for your data setup and dashboards.

      Included:

      • Light troubleshooting and bug fixes (≤3 hours/month)
      • Monthly warehouse checks
      • Slack/email analyst support

       Note: Larger requests will be quoted separately or billed hourly. 

   4. Performance Optimization

      $1,500

      We’ll tune your warehouse and dashboards to load faster and scale more efficiently.

      Included:

      • Query and dashboard performance tuning
      • Warehouse cost optimization
      • Usage analytics report