This section describes data models in Sisense, how to connect to data sources, and how to avoid common mistakes when preparing your schemas.
In Sisense, there are two types of data models, ElastiCube models and live models. ElastiCubes are Sisense’s proprietary, high-performance analytical database specifically designed to withstand extensive querying typically required for your business intelligence application. With ElastiCube models, you import data from a variety of data sources into a Sisense ElastiCube, which becomes the database that supports your dashboard. These models then need to be updated as the data in your sources changes.
Unlike ElastiCube models, live models run queries directly against the data source. Sisense performs no additional caching on the data. This provides you with near real-time data updates in your dashboard, though live connections rely on the source database for all queries. This means the queries are only as fast the data source.
In Sisense, Designers create data and live models to represent how data is brought into Sisense and how should it be used when supporting your dashboards. Which model you choose is determined by what you want to do with your dashboard. ElastiCube models tend to be faster when you are working with complex dashboards with large data sets while live models are preferred when you need near real-time updates. ElastiCube models and live models can be used together in a single dashboard to support both use-cases.
From the Data page, you can see a list of all the data models that you have created or that were shared with you.
With ElastiCubes, you connect to your data sources and import your data. Once your data is in Sisense, you can then design your ElastiCube model in the Model Editor.
After you have designed your schema, it's time to build the ElastiCube. Building an ElastiCube takes all your data from all your sources, and imports it into the ElastiCube.
The topics below describe ElastiCubes and how to model them.
- Creating ElastiCubes
- Navigating the Model Editor
- Introduction to Data Sources
- Working with Data
- Transforming and Enriching Data
- Functions Overview
- Building ElastiCubes
- Build Settings and Data Accumulation Behavior
- Elasticubes for Advanced Business Scenarios
To create dashboards built on live connections to a data source, you create live models. These data models include connection and credential details to the data sources. After you have created your live model, you publish it. Publishing the live model adds it to your list of data models from which you can select when working with dashboards.
The topics below describe live models, and how to create and publish them.