Dispatches
Solutions · Data, Analytics & BI

Rebuild the analytics stack one dashboard at a time

Sub-second dashboards for thousands, included in Athena services, semantic models from your catalog, and agents that query with each user's governed permissions.

79 milliseconds on 2 million rows. Every user, their own permissions.

Store Operations · 100M+ rowsRegion: WestWeekCategory: PartsTotal Orders2M rowsAvg FulfillmentliveStock CoverageliveMonTueWedThuFriSatSunSub-second cross-filter
Fig. 01Lakehouse dashboard cross-filtering 100M+ rows in under a second, served to thousands of viewers, included in Athena services
  • BI import
  • Iceberg on your storage
  • Sub-second on 100M+ rows
  • Semantic model from a paragraph
  • Lineage on every chart
  • Per-user warehouse permissions
The problem

Refreshes in hours, throttling, and rationed compute

The warehouse and the BI layer monetize compute, so they ration it. Dashboards refresh in hours, capacity SKUs get bought and then throttled, and the analytics team spends its week defending a queue. Then agents arrive and ask a hundred questions where a human asked one.

Most groups have never had analytics and business documents in the same ecosystem, so every "why" becomes a ticket.

One governed layer. Fresh data. An engine you are allowed to floor.

Seven capacitiesOne Lakehouse7 BI capacitiesThrottled 31% of daysRefresh ~4 h500 licenses boughtQueue defended weeklyWarehouse and BI layer ration computeRefresh 4 sCross-filter 0.4 sthousands of viewersOne governed layer · fresh data
Fig. 02From seven throttled capacities with four-hour refreshes to one Lakehouse with sub-second cross-filter
How it works

Read. Model. Rebuild. Consolidate.

  1. Read what you have. Athena reads the existing BI semantic model, runs its measures, and browses reports. It queries Snowflake, Databricks, and BigQuery with each user's own permissions. Nothing moves on day one.

  2. Model once. From your warehouse catalog and a paragraph of context, Athena drafts dimensions, measures, and joins. Governance reviews it like a document. Everything downstream queries through it.

  3. Rebuild the slowest dashboard. Import the existing report, land the table in Iceberg on your storage, serve it sub-second as an Application to thousands, included in Athena services.

  4. Consolidate when it pays. Open Iceberg means the tables are yours. Move more when the numbers say so; keep what you must.

01Read existingsourcesBI tool · Snowflake· Databricks02Model onceSemantic modeldrafted from cataloga person approves03Rebuild toLakehouseIceberg on yourstorage04Lineage on everychartWhy this number?lineageSub-second dashboards for thousands, semantic model governs all queries
Fig. 03Read existing sources, model once from catalog and context, rebuild to Lakehouse, add lineage on every chart
Example workflow

Example workflow: Rebuild a four-hour legacy BI refresh

SURFACES INWHAT COMES INTHE PLATFORMWHAT GOES OUTDELIVERED BACKWebMobile · voiceText (SMS)EmailSlack · TeamsChromeOffice add-inMeeting botMeetingsWordPowerPointSheetsDataAgentsWorkflows (AOPs)AppsLibrarySessionsSpacesStudiosMeetingsDatabaseDashboardsWordPowerPointSheetsDashboardsData · APIsWebMobile · voiceText (SMS)EmailSlack · TeamsChromeOffice add-inMeeting botFiles · PDFs1Semantic models2Lakehouse3Apps · portals41 INData lead uploads one reportfile: 100M+ row store-operationstable refreshing in about four hours forthousands of concurrent users at aFortune 500 retailer.2 BUILDFrom three sentences aboutthe business,Athena inspects the raw warehousecatalog and drafts dimensions,measures3 RUNTable lands as Iceberg oncustomer storage. Dashboardrebuilt on Lakehouse: 79 mson 2M rows, cross-filter inSub-second on 100M+ rows.4 OUTDashboard served as Applicationto thousands of viewers, included inAthena services. Lineage cardopen on every chart.
Fig. 04The route on the system map: Files · PDFs → Semantic models → Lakehouse → Apps · portals. Connectors: BI tool · Snowflake · Lakehouse · Applications
Use cases

Replace your BI tool, or build on top of it.

A store-operations table with hundreds of millions of rows refreshed in about four hours for thousands of concurrent users at a Fortune 500 retailer. Rebuilt on the Lakehouse: sub-second cross-filter, included in Athena services. If you keep legacy BI, Athena reads its semantic layer from the same surface.

Store Operations · filter activeRegion: West ✓WeekCategory: PartsTotal OrdersfilteredAvg FulfillmentliveStock CoverageliveMonTueWedThuFriSatSunSub-second
Fig. 05Store operations dashboard filtering West region shows updated bar chart in sub-second time

Semantic model from three sentences.

A data lead typed three sentences about their business. Athena inspected the raw warehouse catalog and drafted dimensions, measures, and calculations with lineage. "That's the power of AI and LLMs today."

stores_rawparts_rawvehicles_rawONE DEFINITIONTotal OrdersSUM(ordersDashboard KPIliveWeekly reportlivesame number, both places
Fig. 06Total Orders measure defined from raw tables flows to dashboard KPI and report with full lineage

Consolidating the Wild West.

Several ungoverned capacities, each with its own refresh schedule and throttling, collapsed onto one governed platform with fresher data.

AthenaBI capacity 1BI capacity 2BI capacity 3BI capacity 4BI capacity 5BI capacity 6BI capacity 7Several ungoverned capacities collapsed onto one governed platform with fresher data
Fig. 07Several ungoverned capacities with separate refresh schedules and throttling, collapsed to one governed platform with fresher data

Democratizing reports without warehouse permissions.

Publish a dashboard to users who have no Snowflake account. Row-level security per viewer; the agent still queries with the publisher's governed model.

Field managerOpen dashboard Sales by RegionCHECKED AGAINST THE SOURCESnowflake accountPublisher modelRow-level securityDashboard servedAgent queries withpublisher's governedmodel permissions
Fig. 08Field manager without Snowflake account opens dashboard through publisher model with row-level security

Data science without a second vendor.

Notebooks with isolated compute and per-user volumes on billion-row datasets. Ephemeral Postgres to 1 TB. The tooling you were paying another vendor for.

Second vendorShared computeShared volumesNOTEBOOKS ON BILLION-ROW DATASETSIsolated computeper userPer-user volumesEphemeral Postgresto 1 TBBillion-rowdatasetsNo additionalvendorThe tooling you were paying another vendor for, now in Athena
Fig. 09Notebooks with isolated compute and per-user volumes on billion-row datasets, no second vendor

Pipeline health that tells the business first.

Stale, failed, or over-complex pipelines and sync gaps surfaced with root cause and a plain-language summary posted to Slack. "We get no notification whatsoever that there's an outage with [our data sync]" was the brief.

SESSIONPipeline health alert: Data sync outagedetected, 3 dashboards affected. Rootcause: sync failed at 06:14.Store operationsstale 8hRegional salesstale 8hInventory summarystale 8hPosted to Slack · 06:22
Fig. 10Data sync outage alert posted to Slack showing three affected dashboards stale for eight hours

Portability, proven.

Open Iceberg format made a warehouse migration a non-event for the dashboards at one retailer.

01Dashboards on SnowflakeOpen Iceberg format on retailerstorage02Iceberg tables movedSnowflake to BigQuery migration03Dashboards unchangedNo Report rebuild, same queriesWarehouse swap was a non-event for dashboards at one retailer
Fig. 11Dashboards on Snowflake using open Iceberg format moved to BigQuery with no dashboard changes
What customers say
“Lets us get a lot more out of our data than [...] We can sit on top of all of the data in [our data warehouse] as opposed to just, like, our little ingested, you know, three gigabytes semantic models. I think we have a lot of power here.”
Analytics lead · A Fortune 500 retailer
“Gave Athena the spreadsheet, explained which column I was trying to figure out, and then ten secs it told me... exactly how the calculation was based on the other data.”
Analyst · A global manufacturer
“One workspace. All different, let's say, avatars of their output data. Right? Suddenly, it's dashboard. Excel is here. PowerPoint is when it's all together. It's very impressive.”
Global Sustainability lead · A global manufacturer
“This combination is a winning combination for us, and this is where we see maximum traction, which is how do you apply all the intelligence that you have within [our data platform] and not worry about how you render that output.”
Analytics lead · A global CPG provider
“This is super cool. So in the future, our data will be sitting in [a cloud data warehouse]... How is this running so quickly?”
Analytics lead · A Fortune 500 retailer
“You guys are functioning better because the harness is tested for a longer period of time against enterprise customers.”
Analytics lead · A Fortune 500 retailer
“The developer platform that Athena comes up with [...] basically unlocks the next level engineering productivity.”
VP-level AI leader · A Fortune 500 retailer
“It's like I'm running analysis that would have taken us, like, maybe a week, two. And thirty, forty minutes.”
Sales intelligence analyst · A global CPG provider
“I envision Athena and [our data platform] as the combination... that's the stack for me.”
Analytics lead · A global CPG provider
“Everything in Athena, it basically is you choose which weapon you wanna use.”
Analyst · A global manufacturer

Verbatim from customer calls. Customers anonymized.

The bet

Coexistence first. Consolidation as the outcome.

Any customer with real spend on BI, warehouse, or lakehouse tools: we want that business. Not to rip it out on day one. To sit on top with your users' own permissions and let the numbers make the argument. Coexistence first. Consolidation as the outcome.

Integrations

Works with the stack you have

Snowflake, Databricks, BigQuery, Redshift, SQL Server, Oracle, Prometheus, dbt-style catalogs. Agents query with each user's warehouse permissions. Nothing is copied unless you migrate it, and then it is Iceberg, so it is still yours.

What to plan for

Exotic Custom BI visuals do not always round-trip. Standard visuals, measures, and relationships do; the import lists what did not and you rebuild those once.

FAQ

What can AI agents do for a data team?

Take on report requests, build and maintain data models, monitor pipelines, and answer business questions from governed definitions, so analysts spend time on analysis.

How do we keep AI answers consistent with our reports?

Agents answer from the same governed metric definitions as your dashboards.

Do we need to replace our data stack?

No. Start on top of what you have and modernize one piece at a time.

Where should we start?

With the report or question the business asks for most often.

One platform underneath

AGS · Athena Governance System

Records every change by a person or an agent, rolls back one contributor's edits without losing anyone else's, and keeps the model, instructions, and sources behind each agent action.

Palladium · deployment

How the platform is deployed: Athena's managed cloud, your cloud on AWS, GCP, or Azure, on-prem, air-gapped, or GovCloud. Same platform in every option.

How it fits together

Build, Work, and Data on top; 150+ connectors and every surface in and out; one map of the whole platform.

Related

Related products and stories

Bring one report and one ugly table.

We will import the dashboard, land the table, and let you click the filter.