Sisense Architecture

The Sisense system is comprised of the following components.

basicarch

ElastiCube Manager

The ElastiCube Manager is a visual environment in which you create ElastiCubes. The ElastiCube Manager enables you to structure and import multiple data sources, create relationships between data, and perform ETL (Extract, Transform, and Load) processes to prepare data for analysis and visualization. For more information, see ElastiCube Manager.

ElastiCube Server

The ElastiCube Server is installed locally on your computer and enables access to ElastiCubes. Both the Sisense Web Application and the ElastiCube Manager query the ElastiCube Server and receive results.

Sisense Server Console

The Sisense Server Console provides administration functions for managing ElastiCubes on the ElastiCube Server.

Sisense Web Application

The Sisense Web application is an interactive web application that provides the user interface in which users can design, share, view and explore dashboards. The Sisense Web application runs in popular web browsers and enables access to the Sisense server.  Dashboards can also be viewed on mobile devices.

Sisense Web Server

The Sisense Web Server is installed locally on your computer and hosts the Sisense Web application.

Designers and Viewers

Note: In previous versions, Designers and Viewers were known as Contributors and Consumers.

Sisense Administrators can access the management settings. Administrators can create and manage users and user groups, manage connected ElastiCubes, define the web configuration, connect to Active Directory, and more.

Sisense Designers can create, design, edit and share dashboards. Sisense designers determine whether the user with who they share a dashboard has editing rights (is a designer) or only viewing rights (viewer).

Sisense Viewers can view, explore, drill down, make selections and filter the dashboards that designers share with them. Viewers only require a standard web browser; no plugins or downloads. They cannot create new dashboards or edit existing ones.

Feature Admin Designer Viewer
Server and User Management Yes No No
Create New Dashboard Yes Yes No
Share Dashboard Yes Yes No
Create New Widget Yes Yes No
Edit, Modify, Export Widget Yes Yes No
Add Dashboard Filters Yes Yes No
Create and Manage Folders Yes Yes No
Drill in Dashboards Yes Yes Yes
Access Dashboards on Mobile Yes Yes Yes
Receive Email Reports Yes Yes Yes
Export Dashboard to PDF Yes Yes Yes

ElastiCubes

ElastiCubes are Sisense’s proprietary super-fast data stores. ElastiCubes are specifically designed to withstand the extensive querying typically required by business intelligence applications.

ElastiCubes enables you to mash up terabytes of data from a variety of sources, for example:

  • Traditional relational databases, such as SQL Server, MySQL or Oracle.
  • File-based data sources, such as spreadsheets (Excel) and CSV files.
  • Online web services, such as Salesforce.com, Google AdWords, Google Analytics, Zendesk and more.

ElastiCubes are based on Sisense’s proprietary In-Chip technology, which leverages the Sisense engine. Read more about the technology behind ElastiCube in Sisense’s technology section.

ElastiCubes are created and managed in the Sisense ElastiCube Manager.

ElastiCube Sets

Sisense ElastiCube Sets are collections of ElastiCubes with identical schemas that support high availability by allowing you to query running ElastiCubes within the ElastiCube Set while other ElastiCubes are in a building state.

For more information see ElastiCube Sets.

Widgets

Each widget is a dynamic visualization of data. You pick the type of data to appear in a widget and you pick the type of visualization (chart type). A few examples of widgets are displayed below:

Column Chart Widget

Column

Indicator Widget

Indicator

Pie Widget

Pie

Pivot Widget

Pivot

Scatter Chart Widget

Scatter

 

To learn more about the different widget types, click here.

Dashboards

A dashboard is a collection of one or more widgets that visualize the data that you select and design.

Dashboard

You define which widgets appear in the dashboard, their design, how they are organized and the filtering of the data that appears.

You can access your own dashboards and dashboards others shared with you.

Sisense allows you to create as many dashboards as you need. No limitations! When you create a dashboard, you are the dashboard’s owner. Owners can share dashboards that they have created with other Sisense users (Viewers and Designers).

Sisense provides a variety of built-in automatic dashboard sharing features. You can easily share a dashboard with others in the Sisense environment or have a dashboard automatically delivered to your chosen recipients by email (on a scheduled basis or upon each data update).

Fields

Widgets are composed of fields that represent the data in your data sources. You create widgets by simply selecting from the fields displayed in a Data Browser, which appears in various places across the product. Each field represents a column of data in the ElastiCube.

DataBrowser

When designing widgets, fields can be categorized into two groups:

  • Numeric Fields: Numbers (quantified data), such as salaries, sales, scores, number of clicks and so on. This is data that you may want to aggregate or calculate. For example, the sum of sales or the average of costs.
  • Descriptive Fields: Items used to label and categorize, such as Products, Locations, Categories and so on.

Generally, widgets combine both these types of fields.

For example, to show the sales of a product over time, Sales is the numeric data and both Products and Time are descriptive data.

 

Descriptive data can be considered as numeric when it is simply a count of the number of items. For example, Activities can be considered numeric when it is a count of the number of Activities. A number can be considered as descriptive when it is an actual entity. For example, an identification ID or phone number.

For information regarding Sisense internals and a more advanced explanation of the Sisense architecture, click here.