One of the key innovations of Holistics is our SQL-based data modeling layer, where it allows data teams to use familiar SQL language to define a central definition of metrics, then let business users perform self-service analytics on top.
Most other BI platforms are designed either favoring the business users or the data teams:
- Favor data teams: Pure SQL approach with no visual drag-and-drop interface, which makes it difficult for business users to work with.
- Favor business users: Provide visual report builder interface with a custom-built modeling layer (not exposing SQL interface behind), making it less flexible for data teams to manage.
Holistics strikes the balance by making it both intuitive for business users to get data (self-service), and powerful/friendly for data analysts to work with (SQL-based modeling).