Back to Sisense.com
  • Introduction
  • Introduction
  • Prism Overview
  • ElastiCubes - Technical Overview
  • Prism Installation Guide
    • Capacity and System Requirements
  • Getting Started Guide
    • Introduction
    • Step 1: Connect to Data in Prism ElastiCube Manager
    • Step 2: Create a dashboard in BI Studio
    • Step 3: Publish to Prism Web
  • Prism ElastiCube Manager
    • Introduction to ElastiCube Manager
    • ElastiCube Manager Menu
    • Connecting to Source Data
      • Introduction to Data Sources
      • Connect via OLEDB Drivers
      • Connect via ODBC Drivers
      • Connect to SQL Server
      • Connect to QuickBooks
      • Connect to QuickBase
      • Connect to Google Spreadsheets
      • Connect to Microsoft Access
      • Connect to CSV
      • Connect to Microsoft Excel
      • Connect to Google Analytics
      • Connect to Google Adwords
      • Connect to MySQL
      • Connect to Oracle
      • Connect to SalesForce
      • Connect to ZenDesk
      • Connect to PostgreSQL
      • Change the Data Source Connectivity Settings
      • Google Analytics and Adwords Tables and Customization
      • Connect to Hadoop Hive
      • Connect to Amazon RedShift
      • Connect to Heroku Postgres
    • Working With Data
      • Search for Tables and Fields
      • Create \ Remove Relationship between Tables
      • Preview the Data in a Table
      • Rename, Delete and Duplicate Tables
      • Handling Relationship Cycles
    • Transforming and Enriching Data
      • Function Reference
        • Mathematical Functions
        • Date and Time Functions
        • String and Text Functions
        • Logical Functions
        • Web Functions
        • Miscellaneous Functions
      • SQL Reference
      • Defining and Editing Field Formula
      • Adding a New Field
      • Preview Results
      • Defining and Editing SQL Statements
      • Adding a New Custom Table
    • Importing Data into a Data Model
      • Importing Data into a new Elasticube
      • Making Changes to an Existing ElastiCube
      • Build Settings
  • Prism BI Studio
    • Introduction to BI Studio
    • Defining the Dashboard's Data Source
      • Connecting to Existing ElastiCubes
      • Connecting Directly to Database Servers
      • Changing an ElastiCube IP in BI Studio
    • Browsing and Managing Metadata
    • Binding Metadata to Widgets
    • Calculations and Formulas
      • Custom Measures
        • Introduction to Custom Measures
        • Types
          • Measured Value
          • Simple Arithmetic
          • Aggregations
          • The ALL Function
          • The PREV, NEXT and PARALLEL Functions
          • Running To-Date Totals and Averages
          • Rolling Totals and Averages
          • Growth from Previous/Parallel Periods
          • The PastYear, PastQuarter and PastMonth Functions
          • Date Difference Functions
          • Contribution Calculations
        • Dynamic Input and Placeholders
      • Quick Formulas
    • Filtering
      • Create and Apply a Filter
      • Filter Types
        • Value and Label Filters and Criteria
        • Attribute Filters and Criteria
        • Measure Filters and Criteria
        • Top\ Bottom Ranking Filter
        • Top Percentile and Bottom Percentile Filters
        • Exclude
        • Groups
      • Question Composition
    • Publish Dashboard to the Interactive HTML
    • Dashboard View Mode
    • Conditional Formatting & Exception Highlighting
      • Usage and Application of Conditional Formatting
      • Conditional Formatting Types
        • Cell Format
        • Cell Highlight
        • Icon Set
        • Data Bars, Squares & Circles
      • Editing Expressions
    • Widgets
      • Data Analysis and Visualization Widgets
        • Pivot
        • Charts
          • Formatting Charts
          • Formatting Chart Axes
        • Gauges & Indicators
          • Indicator Preference Menu
        • Selection & Input Widgets
      • Formatting (Look & Feel) Widgets
        • Widget Ordering
        • Widget Alignment and Spacing
    • Exporting Data and Dashboards
      • Export Widget Data to Excel
      • Export Dashboard to PDF
    • Actions
      • Refresh Document\Sheet\Widget
      • Clear Selection
      • Jump To Page
      • Apply Scope
      • Drill To Sheet
      • Drill to New Sheet
      • Browse To
      • Export to Excel
    • Creating and Editing Data Hierarchies
    • Widget Interconnectivity
  • Prism Web
    • Introduction to Prism Web
    • Re-arrange Widgets
    • Share Dashboards with Others
    • Download Widget Data as Excel
    • Manage your Profile
    • Adding and Removing Fields
    • Manage Users Accounts
    • Prism Web Folder Management
    • Manual Configuration for Prism Web
    • Adjust Pivot Column Width and Row Numbers
    • Download, Embed and Share Dashboard Data and Widgets
  • Management and Administration
    • Introduction to Prism Server Console
    • Data Management
      • ElastiCube Server Console
      • Schedule Data Loads
      • Start/Stop/Restart Elasticube Service
      • Import/Export Elasticube Data
      • Attach/Detach Elasticube Directories
      • Data Context
      • Storing ElastiCube Data
    • Licensing
      • Web Licensing
      • Prism Activation
    • Error and Troubleshooting
      • Troubleshooting ElastiCube Server Connections
      • Increase the Timeout Period for Queries
    • Prism Web Management
      • Prism Web Security Settings
      • Custom Email Templates
      • Manual Configuration for Prism Web
      • Embed a Dashboard into Another Application
      • Making a Dashboard Public
      • Single Sign-on (SSO)
      • Re-Branding Prism Web
      • Adding Google Analytics Tracking to a SiSense Dashboard
      • Active Directory Management
  • Extending Prism
    • Introduction to JavaScript Extension
    • Extending Widgets
    • Custom Widgets
      • Custom Widget Example - Create a Scatter Chart
      • Custom Widget Example - World Map Widget
      • Custom Widget Example - Create a Bullet Chart
      • Custom Widget Example - Google Heat Map
      • Custom Widget Example - States Map
      • Custom Widget Example - Icon Set
    • Extending the Dashboard
      • Align Dashboard to the Center of the Browser
      • Automatically Refresh a Dashboard
      • Add a Welcome Screen with your Company Logo
      • Adjusting Column Width in a Pivot
    • Prism Studio Model
    • Pre & Post Build Plugins
    • Prism Shell (PSM.EXE)
  • Release Notes

Introduction

SiSense Prism is a product suite for building business intellgence solutions.  Prism is a single integrated environment providing an extensive toolset to accomplish the following:  

  • Analyzing data: Formulate complex business queries using an intuitive visual interface, add custom calculations
  • Visualizing data: Use a wide range of data visualization widgets to visualize data
  • Preparing the data for analysis: Merge data from disparate sources, manipulate and cleanse data, full ETL capabilities.
  • Support for large data volumes: Powered by ElastiCube technology, queries millions of rows of data in seconds
  • Data Exploration and Ad Hoc Analysis: Get insight into your data using a wide range of data exploration features

 For first time users, it is recommended to go over this documentation in the order it is presented.  Later you can come back to specific sections as you require.  
rss