DATA & BI
BI tool integration: prepare once, feed the tools you already use
BI tool integration with TIMi uses Anatella to prepare data once and deliver it to the tools your teams already use: Tableau Hyper files, Qlik QVX files, Kibella or any database.
Your tools stay
Keep the BI tools your teams already know.
Automated updates
Files and databases are created or refreshed by the flow.
Any database
ODBC and OLEDB connectors for relational databases.
HOW IT WORKS
How BI tool integration works.
Three steps, in one engine, on a standard server with no cluster.
1. Prepare the data
Anatella gathers, joins and aggregates data from your sources into the tables a BI tool needs.
2. Write to the target
Dedicated actions create Tableau Hyper files, Qlik QVX files or Kibella data, or write to a database.
3. Publish and refresh
A Tableau file can be published to a Tableau server, and the flow can be scheduled to refresh every target.
AnatellaGETTING IT RIGHT
Choices that shape a BI integration.
Centralize the preparation, and let each BI tool do what it does best.
One preparation, many tools
Computing the figures once in Anatella gives every tool the same numbers, instead of each tool recalculating them.
Choose the refresh rhythm
Daily, hourly or incremental depends on the data volumes and on how fresh the figures must be.
Check your versions
Connector availability depends on the version of each BI tool. Confirm the target versions during scoping.
TRANSPARENCY
One definition per figure.
When all BI tools are fed by the same flow, a number means the same thing everywhere, and the flow documents how it was computed.
For consistency
The same figure in every tool.
For analysts
Trace a number back to the flow that produced it.
For IT
One scheduled flow instead of several extractions.
DATA
What can be delivered to BI tools.
Anatella connects to more than 80 sources, so this data can be gathered without prior custom development.
KPIs and aggregates
Indicators computed from detailed data.
Model scores
Predictions computed with Modeler models.
Segments
Customer segments created with Stardust.
Detailed tables
Prepared datasets for exploration.
PROOF
Feeding BI at scale.
We do not have a published case study dedicated to BI tool integration. The reference below is indirect: it shows the data volumes Anatella prepares upstream of any BI tool.
150 billion transactions per month, on one server
Not a BI integration case. It shows the volume Anatella processes upstream, on a single standard server.
FAQ
Common questions.
Which BI tools can Anatella feed?
Tableau through Hyper files, Qlik through QVX files, Kibella, and any relational database through ODBC and OLEDB. Power BI appears as an output in our platform overview, and the exact connector should be confirmed for your version.
Do we need to replace our BI tool?
No. Anatella works alongside your existing tools. Kibella is available if you want a native option.
Can the refresh be automatic?
Yes. The flow can be scheduled, and Tableau files can be published to a Tableau server.
Can scores from predictive models be included?
Yes. Anatella applies Modeler models to your data and the scores can be exported like any other column.
RELATED USE CASES
Keep exploring.
SEE FOR YOURSELF
Test it on your own data.
Run TIMi on your own data with a free trial, or talk to us about your case.
