QuickSight Setup

Access TimeBack analytics data through AWS QuickSight by getting invited to TimeBack's QuickSight account. You can create custom analyses and dashboards using TimeBack's pre-configured data sources.

Prerequisites

QuickSight access requires approval from the TimeBack team.

Email timeback@trilogy.com with:

• Your email address
• Environment needed (staging, production, or both)
• Use case description

You'll be invited to TimeBack's QuickSight account within 1-2 business days.

Data Sources

Once invited, you can create analyses and dashboards directly in TimeBack's QuickSight account. The account has these data sources already configured:

Staging:

• Data source: timeback-dashboards-staging-analytics
• Schema: analytics_staging
• Use for development and testing

Production:

• Data source: timeback-dashboards-production-analytics
• Schema: analytics_production
• Use for live reporting and production dashboards

Both data sources expose the same views and schema structure. See Analytical Entities for complete field documentation.

Creating Datasets

Create datasets by combining views from the analytics data sources:

1. Navigate to Datasets in TimeBack's QuickSight account
2. Create new dataset from timeback-dashboards-staging-analytics or timeback-dashboards-production-analytics
3. Select views to include (e.g., students, sessions, attempts)
4. Define joins using the documented join keys
5. Build visualizations from your dataset

Reference the Join Keys section in each entity's documentation to connect related data correctly.

Automated Dashboard Exports

TimeBack can automatically export QuickSight table visuals to your S3 bucket on a recurring schedule. This service is available for production dashboards only.

Important: Only table visuals can be exported. Charts and other visualization types cannot be converted to CSV format.

Request an Export

Email timeback@trilogy.com with:

1. Dashboard URL from TimeBack's production QuickSight account
2. Sheet name (tab) and visual names you want exported (must be table visuals)
3. Export cadence: daily (default) or every X hours (e.g., every 6 hours, hourly)
4. Target S3 bucket in your AWS account where exports should be stored
5. Target S3 prefix for organizing exports (e.g., timeback-exports/dashboard-name)

S3 Bucket Setup

Your S3 bucket must have this policy to allow TimeBack's QuickSight exports:

{
  "Version": "2012-10-17",
  "Statement": [
    {
      "Effect": "Allow",
      "Principal": {
        "Service": "quicksight.amazonaws.com"
      },
      "Action": "s3:PutObject",
      "Resource": "arn:aws:s3:::<your-bucket>/*",
      "Condition": {
        "StringEquals": {
          "aws:SourceAccount": "597088035919"
        }
      }
    },
    {
      "Effect": "Allow",
      "Principal": {
        "AWS": "arn:aws:iam::597088035919:root"
      },
      "Action": ["s3:PutObject", "s3:PutObjectAcl", "s3:GetObject"],
      "Resource": "arn:aws:s3:::<your-bucket>/*"
    }
  ]
}

Replace <your-bucket> with your actual bucket name.

Export File Structure

Exports are uploaded to your specified S3 prefix with this structure:

s3://<your-bucket>/<prefix>/<visual-id>_<timestamp>.csv

CSV format: Each table visual's columns become CSV columns. For example, a QuickSight table with columns student_name, session_count, total_duration produces a CSV with those exact columns. Each visual generates a separate CSV file with a timestamp indicating when the export was created.

Related Docs

Analytical Entities

Complete catalog of analytics entities with join keys and field descriptions.

MCP Tools

AI-driven alternative for querying the same analytics views.

Getting Started

Overview of TimeBack analytics capabilities and data architecture.