Sub-second BI dashboards (customer story)
A store-operations dashboard that took four hours to refresh now cross-filters hundreds of millions of rows in under a second, included in Athena services.
- Before
A store-operations dashboard at a Fortune 500 retailer refreshed in about four hours. Thousands of managers opened it Monday morning. Capacity was frequently throttled, so queries queued or failed.
- What we did
Imported the existing report. Rebuilt the semantic model on Athena Lakehouse, Iceberg tables in the retailer's own object storage. Pointed it at the same 100M+ row table.
- After
Cross-filter in under a second. Everyone at once on Monday. Included in Athena services.
Two custom visuals did not round-trip. They were rebuilt once.
Athena Lakehouse gives you BI-class speed on hundreds of millions of rows, included in Athena services.
Importing a existing BI semantic model to Athena Lakehouse
“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.”
“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.”
“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.”
“I think a good replacement for the BI. Correct? I don't really need a BI help here. I can develop my own dashboards.”
“I envision Athena and [our data platform] as the combination... that's the stack for me.”
“This is where the puck's going and this is where the moat is for an enterprise.”
“So you gave her three sentences. And she spit out that.”
“It's good to understand the capability of the platform. That how far, and how quickly you guys can get these things going [...] that has been impressive overall.”
“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.”
“He wrote the entire stuff. By itself. And I was there, and I was thinking, alright. If I had to write all this stuff, I mean, I would've spent days, days, days.”
Verbatim from customer calls. Customers anonymized.
Related products and stories
See this on your own work
Bring one recurring task, a sample input, and an example of work you would accept.