Getting Started with Sisense

Data Preparation

Step 1
Create a New Data Model

Learn how to easily model your data using an intuitive graphical interface.
This playlist will explain how to:

• Create a schema
• Drag-and-join multiple data sources
• Work with tables and fields
• Add custom tables and fields

Step 2
Connect to Data

Learn how to add data to an existing or new schema.
This playlist will explain how to:

• Import flat files (CSV, Excel)
• Connect to database servers
• Connect to web services
• Generate and modify Elasticube builds

Data Visualization

Step 3
Get Started with Data Visualizations

Learn how to access and display your data in the browser interface.
This playlist will explain how to:

• Use Sisense dashboards to explore your data
• Add data visualization widgets
• Create pivot tables, charts and maps
• Edit widgets and formatting

Step 4
Filter Dashboard Data

Learn how to adjust the data displayed in your dashboard by using filters.
This playlist will explain how to:

• Incorporate filters in your dashboard
• Add text filters
• Add widget filters
• Add numeric filters
• Add date filters

Step 5
Customize Dashboard Layout

Learn how to create clean and polished dashboards without any design experience.
This video will demonstrate:

• The mobile-responsive visual environment
• Changing dashboard layout
• Adding columns to your dashboard
• Rearranging widgets and adjusting their size

AdvancedFunctionality

Step 6
Clean and Prepare Data

Learn how to use Sisense for data preparation and ETL.
This playlist will explain how to cleanse your raw data using:

• Time functions
• Text functions
• The Lookup function
• Mathematical functions

Step 7
Advanced Query with SQL

Learn how to use standard SQL to augment the ElastiCube and create new tables.
This playlist will demonstrate:

• Creating custom tables with SQL
• Performing a left join using SQL
• Implementing a case statement
• Mathematical functions

Step 8
Build Custom Calculations and Formulas

Learn how to use the formula wizard to create custom calculations within the data browser.
This playlist will demonstrate:

• Adding mathematical formulas to widgets
• Simple formula usage example
• Advanced formulas usage examples

Step 9
Manage and Upload Data

Learn how to maintain and update your ElastiCubes and server.
This playlist will explain how to:

• Access and use the server console
• Manage existing ElastiCubes in the console
• Adjust performance and resources settings
• Update the data structure in ElastiCube