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