Getting Started with Sisense

Check out these video playlists that will get you up running with a full Business Intelligence solution from mashing up multiple data sources to building dazzling dashboards in days. Walk through these short video tutorials to get you up and running quickly and easily. You can always skip ahead and get up going even faster!

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

Advanced Functionality

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 Querying 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 Update 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