What's New
Changelog - 5.1.2
Changelog - 5.1.1
Release 5.1
Changelog - 5.0.5
Changelog - 5.0.4
Changelog - 5.0.3
Changelog - 5.0.2
Changelog - 5.0.1
Release 5.0
Changelog - 4.3.4
Changelog - 4.3.3
Changelog - 4.3.2
Changelog - 4.3.1
Release 4.3 (Fall 2023)
Changelog - 4.2.7
Changelog - 4.2.6
Changelog - 4.2.5
Changelog - 4.2.4
Changelog - 4.2.3
Changelog - 4.2.1
Changelog - 4.2.2
Release 4.2
Changelog - 4.1.5
Changelog - 4.1.4
Changelog - 4.1.3
Changelog - 4.1.2
Changelog - 4.1.1
Release 4.1
Release 4.0
Release 3.9
Release 3.8
Release 3.7
Release 3.6
Release 3.5
Release 3.4
Release 3.3
Release 3.2
Release 3.1
Release 3.0
Release 2.4.1
Release 2.4
Free Cloud Trial
Release 1.8
Release 2.3
Release 2.2
Release 2.1
Release 2.0
Release 1.7
Release 1.6
Release 1.5
Getting Started
Quick Guide
Best Practices Guide
Search - Best Practices
Vizpads (Explore) - Best Practices
Insights (Discover) - Best Practices
Predict - Best Practices
Data - Best Practices
Glossary
Tellius 101
Navigating around Tellius
System requirements
Tellius Architecture
Installation steps for Tellius
Guided tours for quick onboarding
Customizing Tellius
Search (Natural Language)
Search in Tellius
Guide Me
How to Search
Business View List / Columns
Query
Query
Percentage Queries
Time Period Queries
Live Query
Generating Insights-based queries from Search
Search Result
Discover Insights
Interactions
Chart Operations
Add to Vizpad
Table View
Switch Chart type
Change Chart Config
Apply Filters
Change Formatting
Measure Aggregation - Market Share Change
View Raw Data
Download/ Export
Embed URL
Partial Data for Visualization
Best-fit visual
Add to Vizpad
Adding the chart to a Vizpad
Customize the auto-picked columns
Search Query Inspector
Teach Tellius
History
Guided Search
Add Guided Search Experience
Display Names in the Search Guide
Guided Search
Guided Search Syntax and Attributes
Deep Dive
Maps in Search
Search Keywords
Percentage Queries
Time Period Queries
Year-over-Year Analysis
Additional Filters
Pagination
List View In Search Results
Marketshare queries
Embed Search
Personalized Search
Search Cheat Sheet
Filters in Help Tellius Learn
Explore (Vizpads)
Dashboards in Tellius
Vizpad Creation
Create Interactive Content
Create Visualization Charts
List of Charts
Common Chart Types
Line Chart
Bar Chart
Pie Chart
Year-over-Year Functionality in Vizpad
Area Chart
Combo Chart
KPI Target Chart
Treemaps
Bubble Chart
Histogram
Heat-Map Charts
Scatter Chart
Other Charts
Cumulative line chart
Cohort Chart
Explainable AI Charts
For each chart
Create Visualization Charts
Global Filters
Embedded Filters
Other Content
Anomaly management for charts
Creating Interactive Content
Vizpad level Interactions
Viz level Interactions
Discover Insights
Drivers
Discover hidden insights - Genius Insights
How Genius Insights works
Discoveries in Insight
Anomalies on Trend
Interactions
Chart Operations
Switch Chart type
Change Chart Config
Apply Filters
Change Formatting
Add X/Y Axis Target Lines to Scatter Chart
Improvements to Conditional Formatting
Adding Annotations to Tables
Displaying query execution time
Embedding Vizpad
Vizpad Consumption
Collection of Interactive Content
Vizpad level Interactions
Global Filter on the fly
Global Resolutions
Refresh
Notifications / Alerts
Share
Download / Export
Unique name for Vizpads
Edit Column Width
Viz level Interactions
Importing bulk filter values
Multi-Business View Vizpads
Discover (Genius Insights)
Discoveries
What are discoveries
Type of Discoveries in Tellius
Create Discoveries
Kick-off Key Drivers
Edit Insights
Key Driver Insights
Components of Key Drivers
What are Key Drivers
Edit Key Driver Insights
Segment Drivers
Trend Drivers
Trend Insights (Why Insights)
Components of Trend Insights
WHAT: Top Contributors
WHY: Top Reasons
HOW: Top Recommendations
Seamlessly navigating to "Why" from "What"
Create Trend Insight
Edit Trend Insights
What are Trend Insights
Comparison Insights
Components of Comparison Insights
Create Comparison Insight
What are Comparison Insights
Edit Comparison Insights
Others Actions
Save
Refresh
Share Insights
Download
Adding Insights to Vizpad
Insights Enhancements
Embedding Insight
Impact Calculation for Top Contributors
Marketshare
Live Insights
Predict (Machine Learning)
Machine Learning
AutoML
How to create AutoML models
Leaderboard
Prediction
Others
What is AutoML
Point-n-Click Predict
Feed (Track Metrics)
Assistant (Conversations)
Tellius on Mobile devices
Data (Connect, Transform, Model)
Connectors
Connector Setup
Google BigQuery
Google Cloud SQL
Connecting to a PostgreSQL Cloud SQL Instance
Connecting to an MSSQL Cloud SQL Instance
Connecting to a MySQL Cloud SQL Instance
Snowflake
PrivateLink
Snowflake Best Practices
OAuth support for Snowflake
Integrating Snowflake with Azure AD via OAuth
Integrating Snowflake with Okta via OAuth
Edit Connector
Live Connect
Data Import
Cache
Direct Business View
JDBC connector for PrestoDB
Amazon S3
Time-to-Live (TTL) and Caching
Loading Excel sheets
Looker SQL Interface
Databricks
Connecting to an AlloyDB Cluster
List of Connectors by Type
Tables Connections
Custom SQL
Schedule Connector Refresh
Share Connections
Datasets
Load Datasets
Configure Datasets (Measure/Dimensions)
Transform Datasets
Create Business View
Share Datasets
Copy Datasets
Delete Datasets
Swapping datasources
Metadata migration
Data Prep
Datasets
Data Profiling / Statistics
Transformations
Dataset Transform
Aggregate Transforms
Calculated Columns
SQL Transform
Python Transform
Create Hierarchies
Filter Data
SQL Code Snippets
Multiple Datasets Scripting SQL
Column Transforms
Column Metadata
Column type
Feature type
Aggregation
Data type
Special Types
Synonym
Rename Column
Filter Column
Delete Column
Variable Display Names
Other Functions
Metadata View
Dataset Information
Dataset Preview
Alter Pipeline Stage
Edit / Publish Datasets
Data Pipeline (Visual)
Alerts
Partitioning for JDBC Datasets
Export Dataset
Write-back capabilities
Data Fusion
Schedule Refresh
Business Views
Create Business View
Create Business View
Datasets Preview & List
Add datasets to Model
Joins
Column selection
Column configuration
Primary Date
Geo-tagging state/country/city
Save to Fast Query Engine
Publish
Business View
What is Data Model
BV Visual Representation (Preview)
BV Data Sample
Learnings (from Teach Me)
Custom Calculations (Report-level Calc)
Predictions on BV
BV Refresh
Export/ Download Business View
Share Business View
URL in Business View
Request Edit Access
Projects (Organize Content)
Monitor Tellius
Embedding Tellius
Embedding
Settings
About Tellius
User Profile
Admin Settings
Manage Users
Team (Users)
Details & Role
Create a new user
Edit user details
Assigning the user data to another user
Restricting the dataset for a user
Deleting a user
Assign User Objects
User roles and permissions
Teammates (Groups)
Authentication & Authorization
Authentication
Authorization (Roles)
API Access (OAuth Access)
Audit Logs
Application & Advanced Settings
Data
Machine Learning
Genius Insights
Usage tracking & Support
CDN
Download Business View, Dataset, and Insights for Live BV
Customize Help
Impersonate
Data Size Estimation and Calculation
Miscellaneous Application Settings
Configuration for time/date-related results
Dataflow Access
Enable In-memory operations on Live sources
Language Support
Administration
Setup & Configuration
Installation Guide
AWS Marketplace
Autoscaling
Backup and Restore
Help & Support
FAQ
Data Preparation FAQs
Environment FAQs
Search FAQs
Vizpads FAQs
Data Caching
Security FAQs
Embedding FAQs
Insights FAQs
Tellius Product Roadmap
Help and Support System
Guided Tours
Product Videos
Articles & Docs
Provide Feedback
Connect with Tellius team
Support Process
Notifications
Tellius Kaiya
Say hello to Tellius Kaiya 👋
Automating the generation and validation of SQL/Python code
Kaiya Learnings
Automating the generation of metadata
Kaiya mode in Search
Chart and tab summaries
Getting Started Videos
Getting Started
Tellius Connect
Tellius Data Overview Video
Connecting to Flat Files Video
Connecting to Data Sources Video
Live Connections Video
Data Refresh and Scheduling Video
Tellius Prep
Getting Started with Tellius Prep Video
Transformations, Indicators, Signatures, Aggregations and Filters Video
SQL and Python Video
Working with Dates Video
Data Fusion Video
Business View Video
Business Mapping Video
Report Level Calculations Video
Writeback to DB
Natural Language Search
Getting Started with Search Video
How-To Search Video
Customizing Search Results Video
Search Interactions Video
Help Tellius Learn
Explore - Vizpads
Getting Started with Vizpads Video
Creating Vizpads Video
Creating and Configuring Visualizations Video
Viz-Level Interactions Video
Vizpad-Level Interactions Video
Auto Insights
Getting Started with Auto Insights Video
Discovery Insights Video
Segment Insights Video
Trend Insights Video
Comparison Insights Video
Iterate on Insights Video
Tellius Feed Video
Predict - ML Modeling
Getting Started with Predict Video
AutoML Configuration Video
AutoML Leaderboard Video
Point-n-Click Regression Video
Point-n-Click Classification Video
Point-n-Click Clustering Video
Point-n-Click Time Series Video
Point-n-Click PythonML Video
PredictAPI Video
Apply ML Model Video
ML Refresh and Schedule Video
Admin
Best Practices & FAQs
API Documentation
Vizpad APIs
User & user groups APIs
Machine Learning APIs
Fall 2023 (4.3)
- All Categories
- Monitor Tellius
- System Health
- Monitor Usage
- Usage Business Views
Usage Business Views
Usage Business Views (UBS)
Introduction
Users interact with Tellius and create resources within Tellius. Users' creation and consumption of these resources can be tracked to understand the usage patterns of users within a deployment instance.
Starting Tellius 3.7, we are implementing the automation of data collections from the infrastructure and application side in order to provide a holistic view of the resources that get consumed as well as the content that gets produced and viewed by the users. This will also help in better planning ahead as the usage patterns change over time.
Administrators will be able to ask usage questions like:
- Who is the most active user?
- When did a user interact with Tellius last?
- Which Tellius feature is used by maximum users?
- Which is the most used BusinessView(or Dataset or Datasource)?
..As well as questions about infrastructure resource usage like:
- How many concurrent users accessed Tellius in an hour?
- How does the CPU or memory percentage varied across different hours?
- In what timeframe is Tellius running most of the jobs?
- Is there any timeframe where Tellius can be paused or downscaled for cost savings?
Usage Reporting
Since Tellius has a comprehensive suite of visualization objects, users can build usage reports with the KPIs of interest per above. An example of a Usage Report is found below, including KPIs over multiple time periods, trend graphs and bar charts for category reporting.
Three Areas of Usage
There are three areas that we are organizing as multi-table schema business views (BVs) that get updated regularly from the infrastructure service and metadata repository of the Tellius application.
- Object Usage
This analysis is to understand the user's interaction pattern, which objects or object types are most used. This contains information about when an object is Created, Updated, Viewed, Deleted, Object’s metadata, and User performing the operation.
- Job Stats
This analysis is to understand the time spent by different users in running different asynchronous jobs within Tellius. This contains information about the jobs like Load, Publish, Insights, Model Training, Job time, and User performing the operation.
- Infrastructure Metrics
This analysis is to understand how the resources like RAM, CPU, and Disk Utilization over time. This contains information about the hardware resources over every minute, which can be used to analyze the efficient utilization of resources and evaluate any room for optimization.
Common Table: Instance details
Each deployment of Tellius will have a single entry in the instance data, which has a unique identification number to it and contains the details of the instance. All the Object usage, Job stats, and Infrastructure metrics will have the instance id in them.
Instance table schema
- id: Unique identification number for the instance.
- created_at: Timestamp when the instance was created.
- updated_at: Timestamp when the instance details were updated.
- account: Name of the account associated with the instance.
- instance: Name of the instance associated with this instance.
Object Usage
Each object type has its own dimension tables which contain information about the object and one fact table which has an entry for every interaction the user performs on the object. It can be create/update/view/delete operation.
Following would be the structure of the fact table tracking the application usage.
Usage Tracking
This table consists of an entry for every interaction the user performs on different objects within Tellius. The data can grow based on the number of users, frequency of using the platform, etc.
Schema:
- id: Unique identifier for each action.
- instance_id: Unique identifier of the instance.
- user_id: User id performing the operation.
- resource_type: Type of resources on which operations are performed. user if a user was created/updated/deleted/logged in. insight if an insight was created/updated/deleted/viewed etc.
- operation_type: Type of operation, depending on the resource type. created/updated/deleted/viewed/logged in etc.
- dataset_id: Dataset id on which the operation was performed, null if the operation was on other objects.
- business_view_id: BusinessView id on which the operation was performed, null if the operation was on other objects.
- vizpad_id: Vizpad id on which the operation was performed, null if the operation was on other objects.
- insight_id: Insight id on which the operation was performed, null if the operation was on other objects.
- model_id: Model id on which the operation was performed, null if the operation was on other objects.
- query_id: Query id, which was executed from Search, null if the operation was on other objects.
- action_at: Timestamp at which the operation was performed.
Following would be the structure of the dimension tables
Users
This dimension table contains the details of the users created within Tellius, this will be the master table that can be linked to the Usage Tracking data to understand which user is active, what time range they are active, etc.
Schema:
- id: Unique Identification for the user.
- username: Username of the user.
- first_name: First name of the user.
- last_name: Last name of the user.
- email: Email of the user.
- role: Role of the user.
- effective_role: Effective role of the user based on the group(s) the user is a part of.
- created_at: Timestamp when the user was created.
- updated_at: Timestamp when the user details were last updated.
- deleted_at: If the user was deleted, timestamp when the user was deleted. If not, null
Operations tracked for Users
- created
- updated
- deleted
- logged_in_with_success
- log_in_failure
Datasources
This dimension table contains the details of the data sources created within Tellius, this will be the master table that can be linked to the Usage Tracking data to understand which data source is most used, when it was deleted, which users accessed the datasource etc.
Schema:
- id: Unique Identification for the datasource.
- owner_id: User id of the owner of the datasource.
- name: Name of the dataset.
- source_type: Type of the datasource.
- created_at: Timestamp when the datasource was created.
- updated_at: Timestamp when the datasource was last updated.
- deleted_at: Timestamp when datasource was deleted else null if datasource not deleted.
Operations tracked for datasource.
- created
- updated
- viewed
- deleted
Datasets
This dimension table contains the details of the datasets created within Tellius, this will be the master table that can be linked to the Usage Tracking data to understand which dataset is most used, when it was deleted, which users accessed the dataset, etc.
Schema:
- id: Unique Identification for the dataset.
- owner_id: User id of the owner of the dataset.
- name: Name of the dataset.
- datasource_id: Id of the datasource, from which the dataset was loaded.
- size: Size of the dataset in bytes.
- created_at: Timestamp when the dataset was created.
- updated_at: Timestamp when the dataset was last updated.
- deleted_at: Timestamp when the dataset was deleted else null if the dataset was not deleted.
Operations tracked for datasets.
- created
- updated
- viewed
- deleted
BusinessViews
This dimension table contains the details of the Business Views created within Tellius, this will be the master table which can be linked to the Usage Tracking data to understand which BusinessView is most used, when it was deleted, which users accessed the BusinessView, It can also be linked to resources like Vizpads/Insights, etc to understand the usage pattern for those objects created from this BusinessView.
Schema:
- id: Unique Identification for the Business View.
- owner_id: User id of the owner of the Business View.
- name: Name of the Business View.
- created_at: Timestamp when the Business View was created.
- updated_at: Timestamp when the Business View was last updated.
- deleted_at: Timestamp when the Business View was deleted else null if the dataset is not deleted.
Operations tracked for Business Views.
- created
- updated
- viewed
- deleted
Vizpads
This dimension table contains the details of the Vizpads created within Tellius, this will be the master table that can be linked to the Usage Tracking data to understand which Vizpad is most used, when it was deleted, which users accessed them.
Schema:
- id: Unique Identification for the Vizpad.
- owner_id: User id of the owner of the Vizpad.
- name: Name of the Vizpad.
- business_view_id: Id of the Business View, Vizpad is associated with.
- workspace_id: Id of the Workspace, Vizpad is a part of.
- created_at: Timestamp when the Vizpad was created.
- updated_at: Timestamp when the Vizpad was last updated.
- deleted_at: Timestamp when the Vizpad was deleted else null if the dataset is not deleted.
Operations tracked for Vizpads.
- created
- updated
- viewed
- deleted
Insights
This dimension table contains the details of the Insights created within Tellius, this will be the master table that can be linked to the Usage Tracking data to understand which Insight is most used, when it was deleted, which users accessed them.
Schema:
- id: Unique Identification for the Insight.
- owner_id: User id of the owner of the Insight.
- name: Name of the Insight.
- type: Type of the Insight, where it is Discovery or Driver.
- driver_type: Type of the driver, where it is Trend Based or Segment Discovery or Cohort Driver.
- business_view_id: Id of the Business View, Insight is associated with.
- workspace_id: Id of the Workspace, Insight is a part of.
- created_at: Timestamp when the Insight was created.
- updated_at: Timestamp when the Insight was last updated.
- deleted_at: Timestamp when the Insight was deleted else null if the dataset is not deleted.
Operations tracked for Insights.
- created
- updated
- viewed
- deleted
Models
This dimension table contains the details of the Models created within Tellius, this will be the master table that can be linked to the Usage Tracking data to understand which Model is most used, When it was deleted, Which users accessed them.
Schema:
- id: Unique Identification for the Model.
- owner_id: User id of the owner of the Model.
- name: Name of the Model.
- algorithm: Name of the Algorithm, which the model is associated with.
- algorithm_type: Type of the Algorithm, which the model is associated with.
- persisted: Boolean flag representing if the model is saved by the user or not.
- auto_ml_name: Name of the AutoML model specified by the user. Can be used to check if the model was created using auto ml.
- business_view_id: Id of the Business View, Model is associated with.
- workspace_id: Id of the Workspace, Model is a part of.
- created_at: Timestamp when the Model was created.
- updated_at: Timestamp when the Model was last updated.
- deleted_at: Timestamp when the Model was deleted else null if the Model was not deleted.
Operations tracked for Models.
- created
- updated
- viewed
- deleted
Query
This dimension table contains the details of the Queries executed from Search within Tellius, this will be the master table which will mostly be of the same size as that of the Tracking table as we will create a new query object for each query executed and saved to History. This can be linked to the Usage Tracking data to understand which users are using Search more, what BusinessView was queried most, Which type of queries were run.
Schema
- id: Unique Identification for the Query.
- user_id: User id of the user who executed the Query.
- query: Exact query which was executed by the User.
- query_type: Type of the query, executed by the user.
- business_view_id: Id of the Business View, Model is associated with.
- query_time: Timestamp of when the query was executed.
- time_taken: Time taken in seconds for the query to be executed.
Job Stats
Details of each asynchronous job run within Tellius are captured in this and are linked to the users' dimension table to understand which users are running the jobs, how much time was spent, the status of the jobs, etc.
This table consists of an entry for every job triggered within Tellius. The data can grow based on the number of users performing asynchronous jobs within Tellius.
While the rest of the dimension tables are the same as the ones in the Object Usage BV, the one table that is different is the Job Stats fact table. The schema is below:
Schema:
- id: Unique Identification for the Job.
- instance_id: Unique identifier of the instance.
- user_id: User id of the user who triggered this job.
- type: Type of the Job. This has the specific Job type which is shown on the Notifications page.
- status: Status of the Job, if it is RUNNING, CANCELLED, SUCCESS, PARTIALSUCCESS, FAILURE
- started_at: Timestamp at which the job was started.
- completed_at: Timestamp at which the job was completed.
- duration: Duration of Job in seconds.
- no_of_resources: Number of resources created from this job.
- datasource_id: Datasource id of the object related to the job.
- dataset_id: Id of the dataset which was created/published/refreshed as a part of this job.
- business_view_id: Id of the business view which was created/published/refreshed as a part of this job.
- insight_id: Id of the insight which was created/updated as a part of this job.
- model_id: Id of the model which was trained/refreshed as a part of this job.
Infrastructure Metrics
Details of different metrics of the hardware resources like CPU, Disk, RAM, etc are captured on a regular basis (every minute) and saved. This data can be analyzed to get some insights on when the resources are most used, if the infrastructure running low on resources, or if there is a timeframe when the infrastructure can be scaled down to save costs.
While the Instance Table is the same as described above, the Infrastructure Metrics table schema can be viewed below:
Schema:
- instance_id: Unique identifier of the instance.
- available_cpu: Cores of CPU available for Tellius.
- used_cpu: Cores of CPU used by Tellius at this point in time.
- available_ram: Amount of RAM in GBs available for Tellius.
- used_ram: Amount of RAM in GBs used by Tellius at this point in time.
- available_disk: Amount of Disk in GBs available for Tellius.
- used_disk: Amount of Disk in GBs used by Tellius at this point in time.
- timestamp: Timestamp at which the resources were captured.