How to Build a Dashboard in Sisense: Step-by-Step Guide for 2026

What You’ll Learn

This guide walks you through creating business dashboards in Sisense from scratch. You’ll connect data sources, build interactive visualizations, add filters, and deploy dashboards for your team.

Time required: 60-90 minutes
Skill level: Intermediate (some technical knowledge helpful)
What you need: Sisense account (trial or paid), data in databases/cloud apps/files

Step 1: Set Up Your Sisense Environment

Sisense is an enterprise BI platform — there’s no free desktop version.

Getting started:
1. Sign up for a free trial at sisense.com
2. Choose deployment:
– Sisense Cloud: Hosted by Sisense (easier, recommended)
– Sisense On-Premise: Install on your own servers (more control)
3. Log in to the Sisense web application
4. You’ll land on the Home screen

Note: Sisense pricing starts around $2,000-5,000/month depending on data volume. It’s designed for mid-to-large enterprises, not small businesses.

Step 2: Create an ElastiCube (Data Model)

Sisense uses ElastiCubes — proprietary data engines that aggregate and compress your data for fast querying.

Create a new ElastiCube:

1. Click Data in the top navigation
2. Click + ElastiCube
3. Name your ElastiCube (e.g., “Sales Data”)
4. Click Create

You’re now in the ElastiCube Manager — Sisense’s data modeling interface.

Step 3: Connect Your Data Sources

Sisense supports 100+ native connectors plus custom connections.

Add a database connection:

1. In ElastiCube Manager, click + Add Data
2. Select your data source:
3. Databases: SQL Server, MySQL, PostgreSQL, Oracle, Redshift, Snowflake
4. Cloud apps: Salesforce, Google Analytics, Shopify, HubSpot
5. Files: Excel, CSV (upload or connect via FTP/S3)
6. Enter connection credentials:
7. Server/host address
8. Database name
9. Username and password
10. Click Connect

Select tables to import:

1. Browse the list of available tables
2. Check the boxes for tables you need
3. Click Add
4. Tables appear in the ElastiCube data model canvas

Join tables:

1. Drag from one table’s column to another table’s matching column
2. Sisense creates a relationship line
3. Choose join type: Inner, Left, Right, or Full Outer
4. Repeat for all table relationships

Pro tip: Preview your data before building: Right-click any table → Preview Data to verify columns and values.

Step 4: Transform and Prepare Your Data

Clean and shape data before building dashboards.

Add calculated columns:

1. Right-click a table → Add Column → Custom
2. Use SQL-like syntax to create calculations:
3. Revenue - Cost (Profit)
4. YEAR([OrderDate]) (Extract year from date)
5. CASE WHEN [Amount] > 1000 THEN 'High' ELSE 'Low' END (Conditional logic)
6. Name the column and click OK

Filter data at source:

1. Right-click a table → Filters
2. Add conditions (e.g., OrderDate >= '2024-01-01')
3. Reduces data volume and improves performance

Change data types:

1. Click a column header in the table
2. Select data type from dropdown: Text, Numeric, Date, Boolean

Step 5: Build the ElastiCube

Once your data model is ready, you need to build (process) the ElastiCube.

1. Click Build button (top-right)
2. Choose build type:
3. Full Build: Processes all data from scratch
4. Incremental Build: Only adds new/changed data (faster, but requires configuration)
5. Click Build
6. Sisense processes and compresses your data
7. Build time depends on data volume (minutes to hours for large datasets)

Build status: Monitor progress in the Build History panel.

Step 6: Create Your First Dashboard

With your ElastiCube built, you can now create dashboards.

1. Click Analytics in the top navigation
2. Click + Dashboard
3. Name your dashboard (e.g., “Sales Overview”)
4. Select the ElastiCube you just built as the data source
5. Click Create

You’re now in the Dashboard Designer — a drag-and-drop canvas for building visualizations.

Step 7: Add Your First Widget (Visualization)

Sisense calls charts “widgets.”

Create an indicator (single number KPI):

1. Click + Widget in the toolbar
2. Select Indicator
3. Configure the widget:
4. Value: Drag your metric field (Revenue, Orders, etc.) → it aggregates as SUM automatically
5. Title: Click to edit (e.g., “Total Revenue”)
6. Widget displays instantly on the dashboard

Enhance the indicator:
– Add a Target: Drag a field or enter a static number → Secondary Value
– Conditional coloring: Click widget → Design → Color → Conditional formatting

Create a column chart:

1. Click + Widget → Column
2. Configure:
3. Category (X-axis): Drag your dimension field (Product, Month, Region)
4. Value (Y-axis): Drag your metric field (Revenue, Quantity)
5. Chart renders automatically

Customization:
– Sort: Click widget → More Options (three dots) → Sort → By value descending
– Limit bars: More Options → Limit → Top 10
– Colors: Design tab → Colors → choose palette or custom colors

Step 8: Build a Line Chart (Trend Analysis)

1. + Widget → Line
2. Configure:
3. Category (X-axis): Drag your date field
4. Value (Y-axis): Drag your metric (Revenue, Sessions, etc.)
5. Sisense groups dates by month automatically

Advanced options:
– Multiple lines: Drag a second metric to Break By
– Date grouping: Click date dimension → choose Day/Week/Month/Quarter/Year
– Trend line: Design → Trend Line → Enable

Step 9: Create a Pivot Table

Pivot tables show data summarized by multiple dimensions.

1. + Widget → Pivot
2. Configure:
3. Rows: Drag dimension fields (Product, Region, etc.)
4. Columns: Drag another dimension for column headers (Date, Category)
5. Values: Drag metrics (Revenue, Profit, Units)
6. Table populates with aggregated data

Pro tips:
– Totals: Design → Show totals → Enable row and column totals
– Conditional formatting: Highlight high/low values → Design → Conditional formatting
– Drill-down: Enable hierarchical drill (Year → Quarter → Month)

Step 10: Add Filters and Interactivity

Filters let users explore data dynamically.

Add a dashboard-level filter:

1. Click + Widget → Filter
2. Select filter type:
3. List: Shows all unique values as checkboxes
4. Dropdown: Saves space
5. Date Range: Calendar picker
6. Numeric Range: Slider
7. Configure:
8. Field: Select dimension to filter by (Region, Product, Sales Rep)
9. Place filter at top of dashboard

Filter applies to all widgets on the dashboard.

Widget-specific filters:

1. Select a widget
2. Click More Options → Filters
3. Add filter condition (e.g., Revenue > 1000)
4. Applies only to that widget

Step 11: Design and Style Your Dashboard

Make your dashboard visually cohesive and on-brand.

Apply a dashboard theme:

1. Click Design (top toolbar)
2. Choose from preset themes OR
3. Custom theme:
4. Background: Set color or upload image
5. Font: Choose font family and sizes
6. Widget styles: Border, shadow, spacing

Brand colors:

1. Click Design → Colors
2. Create a custom color palette
3. Enter HEX codes for your brand colors
4. Apply to all widgets

Add text and images:

• Text widget: Click + Widget → Text → type title or explanation
• Image widget: + Widget → Image → upload your logo or background image

Layout best practices:

• Grid alignment: Drag widgets to snap to grid
• Visual hierarchy: Place most important metrics at top
• White space: Don’t overcrowd — leave breathing room between widgets

Step 12: Share and Publish Your Dashboard

Share with users:

1. Click Share button (top-right)
2. Enter email addresses or select user groups
3. Set permissions:
4. Viewer: Can view and interact
5. Designer: Can edit the dashboard
6. Owner: Full control
7. Click Share

Embed in a website or app:

1. Click Share → Embed
2. Copy the embed code (iframe)
3. Paste into your website HTML

Security: Set access rules to control who can see the dashboard:
– Click Security → Data Security → define row-level rules

Schedule email delivery:

1. Click More Options → Schedule
2. Choose frequency: Daily, weekly, monthly
3. Select recipients
4. Format: PDF snapshot or interactive link
5. Save schedule

Step 13: Set Up Data Refresh

Keep dashboards current with automatic ElastiCube rebuilds.

1. Go to Data → select your ElastiCube
2. Click Schedule Build
3. Choose frequency:
4. Incremental: Hourly or more frequent (only adds new data)
5. Full rebuild: Daily or weekly (processes all data)
6. Set time: Off-peak hours recommended
7. Save schedule

Monitor builds: Check Build History for errors or delays.

Common Issues and Fixes

ElastiCube build failed:
– Check database connectivity (firewall/credentials)
– Look for errors in Build Log
– Reduce data volume if memory issues occur

Widgets showing incorrect data:
– Verify aggregation: Click widget → check that metrics use SUM (not COUNT or AVG)
– Check filters: Dashboard-level filters override widget filters

Dashboard loading slowly:
– Optimize ElastiCube: Remove unused tables/columns
– Use incremental builds instead of full rebuilds
– Cache dashboard: Settings → Performance → Enable caching

Can’t connect to Salesforce/API:
– Check API credentials and permissions
– Some connectors require OAuth setup in Sisense admin panel

Sisense vs Other BI Tools

Sisense’s unique strength: Built for embedding analytics into SaaS products. If you need white-label dashboards inside your app, Sisense is a top choice.

What to Do Next

Level up your Sisense dashboards:
1. Use Sisense Pulse alerts: Get notified when KPIs hit thresholds
– Widget → More Options → Pulse alert → set conditions
2. Create custom plugins: Extend Sisense with JavaScript
– Go to Admin → Plugins → upload custom visualization code
3. Implement row-level security: Restrict data by user/group
– Data Security → define rules (e.g., salespeople see only their region)

Explore alternatives if Sisense isn’t working:
– Too expensive? Power BI or Looker Studio offer lower-cost options
– Too complex? Pulse AI automates dashboard creation with AI
– Need faster setup? Cloud BI tools like Metabase or Redash require less configuration

Frequently Asked Questions

How much does Sisense cost?

Sisense pricing is not publicly listed but typically starts at $2,000-5,000/month for small deployments. Enterprise contracts can reach $50,000+/year depending on data volume and features.

Is Sisense suitable for small businesses?

No. Sisense is designed for mid-to-large enterprises with complex analytics needs. Small businesses should consider Power BI, Looker Studio, or Pulse AI (all more affordable and easier to use).

What is an ElastiCube?

Sisense’s proprietary in-memory data engine. It compresses and indexes your data for fast query performance. Think of it as Sisense’s version of a data warehouse.

Can Sisense handle real-time data?

Yes, but with limitations. Use Live Connect mode to query databases in real-time without ElastiCubes. Or configure frequent incremental ElastiCube builds (every 15-30 minutes).

How does Sisense compare to Tableau for embedded analytics?

Sisense is better for embedding: white-label branding, multi-tenant architecture, and API-first design. Tableau is better for visual flexibility and ad-hoc analysis. Choose Sisense if you’re embedding BI into your SaaS product.

Can non-technical users use Sisense?

Partially. Dashboard viewers can interact with widgets and filters easily. But building dashboards and managing ElastiCubes requires training — expect a 1-2 week learning curve minimum.

What happens if an ElastiCube build fails?

Check the Build Log for error details (usually connectivity or data quality issues). Fix the issue and retry. Set up build failure alerts so you’re notified immediately.

Related guides:
– How to Build a Sales Dashboard in Power BI
– Sisense vs Tableau: Which BI Platform is Better for Your Business?
– Best Sisense Alternatives in 2026