Analysis & statistics
BI workflow: turn raw tables into a model — without SQL
Working with operational and BI data from your databases? Define measures in a form, understand your joins in a read-only data model view, and define drill paths from coarse to fine — without a line of SQL.
DataLion turns raw database tables into a BI model — without SQL. You define measures (sum, count, average) in a form, promote raw columns to questions in one click, see your table joins in a read-only data model view, group raw data by a time grain, and define coarse-to-fine drill paths — the groundwork drill-down builds on.
- 🇩🇪 Made in Munich
- GDPR-compliant
- DPA included
- Hosted in Germany
- 🌐 Interface in EN, DE, FR & NL
Trusted by research institutes, brands & insights teams
- 50+ interactive chart types
- 20+ statistical methods
- SPSS · Excel · CSV import without data loss
- ISO 27001 certified data centers (Germany)
Measures as named aggregations
Define measures as named aggregations over the columns of your data tables — sum, count and average, for example "Total revenue = SUM(revenue)". You do this in a form, without writing any SQL.
Each measure is stored as a codebook entry, so it works immediately with the existing chart, filter, crosstab and export stack. The Global Market Tracker demo ships with measures like this already prepared.
- Sum, count and average over table columns
- Defined in a form, no hand-written SQL
- Stored as a codebook entry — instantly usable in charts and export
- Example: "Total revenue = SUM(revenue)"
A governed data model: raw columns and joins
The raw-columns panel shows which physical table columns have no codebook entry yet — with their detected type. "Promote to question" turns a single column into a regular codebook question in one click.
Your project's existing table joins render as a read-only data model view: each physical table is a card (the main table highlighted), each join is a table.column ⟷ table.column edge. When tables exist but no joins are defined yet, a hint points that out. You can also group any raw date by a time grain — minute, hour, day, week, month, quarter or year — via a column@grain reference (e.g. order_date@month), with no codebook entry. This works on MySQL and Exasol.
- Raw-columns panel: unmapped columns with detected type
- "Promote to question" turns a column into a question in one click
- Read-only data model: table cards and join edges at a glance
- Time grain via column@grain (minute to year), on MySQL and Exasol
Drill paths as hierarchy metadata
Define named, ordered hierarchies from coarse to fine in the codebook — for example Country → Region → City. DataLion validates the paths: the questions must exist, there need to be at least two distinct levels, and names are unique.
This is the hierarchy metadata layer that drill-down builds on. The Global Market Tracker demo ships drill paths alongside the matching measures and lookup tables, so you can see the whole thing work end to end.
- Named, ordered hierarchies from coarse to fine
- Example: Country → Region → City
- Validated: existing questions, ≥ 2 levels, unique names
- The groundwork drill-down builds on
See DataLion with your own data
Start free with your own raw data. Or book a personal demo of the path to a finished dashboard.
What users say about DataLion
- via G2
Very professional company, attentive to the customer needs, provider of a great software and service.
Generoso M. · CRM Analyst, Automotive - via G2
The contacts at DataLion are very committed. If you have problems, you can count on help. DataLion reacts quickly to requests for new functions.
Robert Q. · Managing Director - via G2
User-friendliness, especially for market research topics. Structured backend with many customization options.
Verified user · Market Research - via G2
The embedding function allows us to generate insights of our data for our audience and customers by far less than half of the usual time needed before.
Verified user · Leisure, Travel & Tourism
We now work much more efficiently, giving us more time to take care of the derivations and insights from the data for the customers.
More data features
Common questions about the BI workflow
Do I have to write SQL for measures?
Which aggregations are available?
Can I edit the table joins visually?
How do I group raw data by time?
Are drill paths already a finished dashboard drill-down?
Turn raw tables into a BI model
Try DataLion free: measures in a form, a governed data model and drill paths — without SQL. Or get a demo of the Global Market Tracker end to end.