Redash Analytics Guide

# Clone the Redash setup repository
git clone https://github.com/getredash/setup.git redash-setup
cd redash-setup

# Generate configuration
./setup.sh

# Or manually configure with Docker Compose

version: "3"
services:
  redash:
    image: redash/redash:latest
    command: server
    ports:
      - "5000:5000"
    environment:
      REDASH_DATABASE_URL: postgresql://${POSTGRES_USER}:${POSTGRES_PASSWORD}@postgres/redash
      REDASH_REDIS_URL: redis://redis:6379/0
      REDASH_SECRET_KEY: ${REDASH_SECRET_KEY}
      REDASH_MAIL_SERVER: smtp.university.edu
      REDASH_MAIL_PORT: 587
      REDASH_MAIL_USERNAME: ${MAIL_USERNAME}
      REDASH_MAIL_PASSWORD: ${MAIL_PASSWORD}
    depends_on:
      - postgres
      - redis

  worker:
    image: redash/redash:latest
    command: worker
    environment:
      REDASH_DATABASE_URL: postgresql://${POSTGRES_USER}:${POSTGRES_PASSWORD}@postgres/redash
      REDASH_REDIS_URL: redis://redis:6379/0
    depends_on:
      - redash

  scheduler:
    image: redash/redash:latest
    command: scheduler
    environment:
      REDASH_DATABASE_URL: postgresql://${POSTGRES_USER}:${POSTGRES_PASSWORD}@postgres/redash
      REDASH_REDIS_URL: redis://redis:6379/0
    depends_on:
      - redash

  postgres:
    image: postgres:16
    environment:
      POSTGRES_DB: redash
      POSTGRES_USER: ${POSTGRES_USER}
      POSTGRES_PASSWORD: ${POSTGRES_PASSWORD}
    volumes:
      - pg-data:/var/lib/postgresql/data

  redis:
    image: redis:7-alpine
    volumes:
      - redis-data:/data

volumes:
  pg-data:
  redis-data:

-- Aggregate experiment results by condition and time period
SELECT
    e.condition_name,
    DATE_TRUNC('month', e.run_date) AS month,
    COUNT(*) AS num_runs,
    ROUND(AVG(e.primary_outcome)::NUMERIC, 4) AS mean_outcome,
    ROUND(STDDEV(e.primary_outcome)::NUMERIC, 4) AS std_outcome,
    ROUND(AVG(e.primary_outcome)::NUMERIC - 1.96 * STDDEV(e.primary_outcome)::NUMERIC / SQRT(COUNT(*)), 4) AS ci_lower,
    ROUND(AVG(e.primary_outcome)::NUMERIC + 1.96 * STDDEV(e.primary_outcome)::NUMERIC / SQRT(COUNT(*)), 4) AS ci_upper
FROM experiments e
WHERE e.project_id = {{project_id}}
  AND e.run_date >= {{start_date}}
GROUP BY e.condition_name, DATE_TRUNC('month', e.run_date)
ORDER BY month, condition_name;

-- Track literature search and screening progress
SELECT
    r.review_name,
    r.search_database,
    COUNT(DISTINCT a.article_id) AS total_found,
    COUNT(DISTINCT CASE WHEN s.decision = 'include' THEN a.article_id END) AS included,
    COUNT(DISTINCT CASE WHEN s.decision = 'exclude' THEN a.article_id END) AS excluded,
    COUNT(DISTINCT CASE WHEN s.decision IS NULL THEN a.article_id END) AS pending,
    ROUND(
        COUNT(DISTINCT CASE WHEN s.decision IS NOT NULL THEN a.article_id END)::NUMERIC /
        NULLIF(COUNT(DISTINCT a.article_id), 0) * 100, 1
    ) AS screening_progress_pct
FROM systematic_reviews r
JOIN articles a ON a.review_id = r.id
LEFT JOIN screening_decisions s ON s.article_id = a.article_id
WHERE r.review_name = {{review_name}}
GROUP BY r.review_name, r.search_database
ORDER BY total_found DESC;

-- Monitor research grant expenditures
SELECT
    g.grant_name,
    g.funding_agency,
    g.total_budget,
    SUM(t.amount) AS total_spent,
    g.total_budget - SUM(t.amount) AS remaining,
    ROUND(SUM(t.amount)::NUMERIC / g.total_budget * 100, 1) AS pct_spent,
    g.end_date,
    (g.end_date - CURRENT_DATE) AS days_remaining,
    ROUND(
        (g.total_budget - SUM(t.amount))::NUMERIC /
        NULLIF((g.end_date - CURRENT_DATE), 0), 2
    ) AS daily_burn_budget
FROM grants g
JOIN transactions t ON t.grant_id = g.id
WHERE g.status = 'active'
GROUP BY g.grant_name, g.funding_agency, g.total_budget, g.end_date
ORDER BY pct_spent DESC;