Step 2 - 3.0 Data Models For Modeling Your Analytics Codebase With SQL

Holistics Data Models takes away the pain of rewriting and troubleshooting SQL queries, by letting you build reusable models on SQL. A Data Model is basically a set of fields & measures which presents an abstract, virtual version of a data table.

Built for data analysts and developers, Data Models lets you easily manage multiple data sources and their relationships, for a consistent single source of truth. Version control your data systems, and centralize definitions of key business measures and calculated fields.

A Data Model can be generated from

  • Database Table
  • A Data Table from 3rd Party Sources (Google Analytics, Facebook Ads...)
  • Result of Custom SQL Queries

Automatically generate a database diagram: Allow your data users to easily get the full picture of your data relationships with one glance.

Easily generate database ER diagrams automatically

Easily maintain definitions of business measures, dimensions and queries: Have a single centrally defined version of your key business metrics and measurements, for the company to use. No more in-fighting over how to define the same formula, by different departments!

Centrally defined business measures for overall consistency

Simple error handling for automated data ingestion and transformation jobs: Have a single data ingestion and transformation flow with linked job dependencies, so you know that your end data results are accurate and updated.

Trigger ingestion jobs to load data, from a single view of your sources

Holistics' Data Modeling functions as the hub of your cumulative business logic, as the single source of truth containing the consistent data definitions for your organization. Every single metric and dimension of your business will be defined in this modeling layer, and can be easily updated from a single point.

Please have a look at our supporting documentation on Data Models for additional details, or reach out to our team for more information.