Skip to content
Tallyfy

Looker

Connecting Looker to Tallyfy Analytics

Looker connects to Tallyfy Analytics through Amazon Athena, letting you build interactive dashboards from your workflow data. Your whole team can click, filter, and drill into process performance - no SQL required.

What you can build

  • Interactive exploration - Filter and drill down through workflow data without writing queries
  • Embedded dashboards - Share live analytics with stakeholders who don’t need full BI access
  • Real-time monitoring - Watch processes unfold with dashboards that update as work happens
  • Executive overviews - Give leadership a high-level view with drill-down into details
  • Bottleneck detection - Spot slowdowns in your processes before they become problems
  • Compliance reporting - Prove SLA compliance with timestamp evidence

How the connection works

LayerRole
Tallyfy AnalyticsYour process data stored in Amazon S3
Amazon Athena1Query engine that runs SQL on your data lake
Simba JDBC driverConnects Looker to Athena
LookerBuild models, create visualizations, embed dashboards

Authentication

When Tallyfy provisions your Analytics account, you’ll get two credential sets:

  • AWS IAM Login (username/password) - For AWS web console access only
  • Access Key and Secret Access Key - What Looker actually needs for the connection

Performance tips

  • Result streaming - Enable streaming for large result sets to improve extraction speed
  • Persistent derived tables - Cache complex calculations in S3 for faster dashboard loading
  • Connection pooling - Increase concurrent connections if Looker is your primary analytics tool
  • Aggregate awareness - Pre-calculate common metrics so dashboards load faster

Getting started

Looker (enterprise) - takes about 15-20 minutes:

  1. Confirm you have an active Tallyfy Analytics subscription
  2. Verify you have Looker access (self-hosted or Looker Cloud)
  3. Gather your Access Key and Secret Access Key from Tallyfy
  4. Follow the connection guide below

Looker Studio (free) - takes about 10-15 minutes:

  1. Confirm you have an active Tallyfy Analytics subscription
  2. Sign up for a free Looker Studio account
  3. Choose a third-party connector (CData or OWOX)
  4. Configure the connector with your Athena credentials

Looker > Connecting Looker to analytics data

This guide demonstrates how to connect Looker to Tallyfy workflow data through Amazon Athena in 15-20 minutes using Access Key authentication driver installation connection configuration and LookML modeling to create interactive dashboards and visualizations from processes steps form fields and user data.

Looker > Connecting Looker Studio to analytics data

Looker Studio can connect to Tallyfy Analytics workflow data through third-party connectors like CData or OWOX in about 10-15 minutes using AWS Access Key credentials to query Amazon Athena and build free shareable dashboards that visualize process volumes and task durations and completion rates without needing an enterprise BI license.

Integrations > Tallyfy Analytics

Tallyfy Analytics is an add-on service that copies workflow data to a dedicated Amazon Athena infrastructure where users can connect BI tools like Tableau and Power BI to build custom reports and perform deep analysis on process performance trends and task completion metrics.

Analytics > Power BI

Tallyfy’s Power BI integration connects your workflow data through Amazon Athena so you can build interactive dashboards for process optimization, team performance analysis and executive reporting.

Footnotes

  1. AWS serverless query service using standard SQL on S3 data lakes, no infrastructure management needed ↩

Get in touch
About Tallyfy