Sisense BI Sisense BI Data Modeling & Analytics 1

Question 1

What is a Sisense 'ElastiCube'?

Accepted Answer

A proprietary in-memory columnar data store optimized for analytics queries

Answer

ElastiCube is Sisense's in-memory columnar database engine designed to store and rapidly query large analytical datasets.

Question 2

In Sisense ElastiCube, what is the purpose of defining a 'relationship' between two tables?

Accepted Answer

To join tables so that data from both can be used together in queries and widgets

Answer

Relationships in Sisense ElastiCube define how tables are joined, enabling widgets to query across multiple related tables simultaneously.

Question 3

Which join type is supported in Sisense ElastiCube table relationships?

Accepted Answer

Left join (many-to-one)

Answer

Sisense ElastiCube uses left join semantics (many-to-one) when connecting fact tables to dimension tables in its data model.

Question 4

What is a 'custom formula' (calculated field) in Sisense?

Accepted Answer

A user-defined expression that computes a new metric from existing fields using Sisense formula syntax

Answer

Custom formulas in Sisense let users create new calculated metrics by writing expressions using Sisense's formula language within the ElastiCube or widget.

Question 5

What does the 'ElastiCube build' process do in Sisense?

Accepted Answer

Imports, processes, and indexes source data into the ElastiCube in-memory store

Answer

The ElastiCube build process extracts data from connected sources, applies transformations, and loads it into the compressed in-memory columnar store.

Sisense BI Practice Test

Sisense BI Practice Test

Sisense BI Sisense BI Data Modeling & Analytics 1