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

Looker connects to Tallyfy’s workflow analytics data through Amazon Athena in about 15-20 minutes by installing a JDBC driver (for self-hosted instances) and configuring an Athena connection with AWS Access Key credentials to query Parquet-formatted process and task data stored in S3 and then build LookML models and dashboards for tracking process durations and team performance and SLA compliance.

Looker > Connecting Looker Studio to analytics data

Looker Studio can connect to Tallyfy Analytics workflow data through a third-party connector like CData or OWOX in about 10-15 minutes using AWS Access Key credentials to 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 that replicates your workflow data into a private Amazon Athena environment where you can run SQL queries and connect BI tools like Tableau or Power BI to build custom dashboards and track process trends over time.

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