What's New
Changelog - 5.1.3
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
Release 5.2
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
Tellius Engine: Comparison of In-Memory vs. Live Mode
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)
Table of Contents
- đ New features
- Kaiya conversational interface: A more interactive way to explore data
- Multi-task effectively with async validation
- Custom placement and orientation of data labels in graphs
- Upgrading our metadata migration
- Kaiyaâs summaries now available for Insights
- Level up your security with server-side sessions
- Advanced token management for embedded URLs
- All Categories
- What's New
- Release 5.2
Release 5.2
Updated by Ramya Priya
- đ New features
- Kaiya conversational interface: A more interactive way to explore data
- Multi-task effectively with async validation
- Custom placement and orientation of data labels in graphs
- Upgrading our metadata migration
- Kaiyaâs summaries now available for Insights
- Level up your security with server-side sessions
- Advanced token management for embedded URLs
Introducing Tellius 5.2! đĽđ Weâve been hard at work bringing you Kaiyaâs new conversational interfaceâa seamless, chat-based experience that makes exploring your data feel like a natural conversation (think ChatGPT style). Kaiya will guide you with suggested questions and follow-ups to uncover insights faster, even with complex, multi-part queries.
Kaiya doesnât just respond; it learns! With each correction and saved Learning, Kaiya adapts to your needs, delivering smarter, more tailored answers over time. With powerful security upgrades, including server-side sessions and full control over embedded content, your data is now more secure and future-proof. And thereâs moreâthis release is packed with exciting updates. Read on to see whatâs new!
đ New features
Kaiya conversational interface: A more interactive way to explore data
The Kaiya conversational interface transforms a simple query tool to an interactive chat-based experience that enables users to perform ad-hoc exploratory analysis and generate insights seamlessly. With the new interface, users can follow up on initial queries, ask multi-part questions, and visualize results in a more natural and efficient manner.
We've optimized every step of the query workflow and minimized the LLM response size to decrease time taken for processing queriesâso you can get your answers quicker than ever before. But thatâs not allâaccuracy got a major boost. Kaiya now processes queries holistically, improving its ability to handle complex queries. Kaiya can also give you accurate answers even when column names or keywords arenât quite right in search queries. Get ready for faster insights and sharper answers!
Exciting capabilities to look out for!
- The conversational interface allows users to communicate with Kaiya naturally, as they would with a colleague. Kaiya can now provide initial set of questions and suggest follow-up questions.
- Additionally, a feedback mechanism is introduced, allowing users to give explicit feedback (thumbs up/thumbs down) to improve query accuracy and help fine-tune Kaiyaâs search engine's responses over time.
- What more? The feedback that you provide can also be saved as Learnings so that Kaiya can remember your preferences and apply the same in the future.
Multi-task effectively with async validation
We know the frustration of waiting for a query or process to complete, only to be cut off by a timeout. Sometimes, processing times can exceed standard timeout limits. With asynchronous validation, Tellius ensures that your complex, time-consuming and resource-intensive operations can continue running in the background, without any timeout limits.
When performing the following operations, asynchronous validation is automatically triggered if the operation is expected to exceed the standard timeout limit. Tellius will continue processing the request in the background, ensuring that operations complete without disruption.
- SQL script validation
- Edit, load, and validate SQL
- PPT downloadÂ
- Dataset summary statisticsÂ
- Preview for custom SQL queries
This enhancement gives you the flexibility to run complex queries, download extensive reports, or generate dataset summaries without the fear of hitting a wall. Tellius processes your request asynchronously, so you won't experience timeouts or interruptions while it works in the background, and it will notify you on the same page when the results are ready.
Custom placement and orientation of data labels in graphs
A cluttered bar graph or line chart is frustrating. That's why weâve rolled out smart label positioning in Vizpads where you could customize the orientation and placement of data labels in high-density visualizations. Labels may be placed inside or outside the chart elements (e.g., bars) and horizontally or vertically as required.
Supported charts for dynamic label adjustment
- Position: Bar, Combo (Bar/Line), Histogram, Waterfall, Bar Conversion
- Orientation: Bar, Line, Combo (Bar/Line), Treemap, Histogram, Waterfall, Growth, Bar Conversion, Confidence Range, Year over Year
The goal is to prevent overlap and ensure all relevant data points are clearly visible, thus enhancing both the aesthetic presentation and the interpretability of the data. Because labels shouldn't be fighting for space.
Upgrading our metadata migration
Our latest metadata migration enhancements make it easier to import and export your datasets, Business Views (BVs), Insights, Vizpads, and Projectsâwithout the hassle. This functionality is no longer restricted to admin roles, offering broader access to user groups with the necessary permissions. Weâve also added a search feature to help you easily find the data sources you need.
Now, you can import/export the following objects through a simplified process using .zip files, ensuring quick migration and metadata management between instances.
Whether youâre backing up your work, restoring a project, or moving between instances, weâve taken the hassle out of the process.
Kaiyaâs summaries now available for Insights
Kaiyaâs summaries are now in Insights! Use this to quickly generate a customized summary of your trend Insights directly from the Insights results page.Â
Upon clicking the âGenerate Summaryâ button, you can enter the business context and focus areas for the summary. This enables you to customize the summaries based on your specific business scenarios or highlight particular aspects of the analysis. This feature simplifies the process of summarizing complex insights, reducing manual effort and improving the accuracy of data interpretation in reports. Whether you need to summarize performance trends or emphasize key changes, youâre in control of crafting clear, focused summaries that are perfect for reports or presentations.
Level up your security with server-side sessions
Security just got a major upgrade! With server-side session management, your sessions are now managed directly on Tellius servers. This shift mitigates vulnerabilities such as session hijacking and unauthorized access by ensuring that all session data is securely managed server-side (instead of relying on client-side storage like cookies or tokens stored in the browser).
Additionally, the "Remember Me" option has been removed, and you can customize your inactive session durations (from 15 minutes to 7 days). Two minutes before logging out, youâll get a heads-up to extend the session for uninterrupted access.
Advanced token management for embedded URLs
Our token management lets you configure every aspect of your embedded URLsâyou can control the expiration of URLs, gate the embedded content, and customize access types (read or edit). This enhancement puts you in the driverâs seat, ensuring that your shared data remains secure and under your full control.Â
This major feature includes the following capabilities:
- Control access to the embedded content: If this option is enabled under Settings, the generated URL will automatically redirect users to the intended page without requiring them to log in. If disabled, users will be redirected to the login page and must log in to view the content.
- Expiry time of URL: Set the validity of the embedded URL by choosing the number of hours, days, or months it should remain active. This allows you to control how long the embedded content should be accessible.
- Access to global filters (exclusive for Vizpads): Â This option allows you to apply or edit global filters in embedded Vizpads.
- Access type: Select the permissions for the generated URL by choosing between read-only or edit access, controlling how users can interact with the embedded content.
These options give you the flexibility to create URLs that suit different scenarios, whether for quick sharing or providing long-term access.
đ Enhancements
Flexible, open-ended date range selection
With this latest enhancement to the time/date filter, Tellius now supports creating custom time ranges with open-ended start or end dates in your Business View. Here's how it works:
- No Start Date: Select this option to include all data up to your specified end date. This means you don't have to manually input a start date, and the system will consider all available data from the earliest date up to the end date you choose.
- No End Date: Choose this option to include all data from your specified start date onward. This allows you to set a starting point without defining an end date, capturing all data from that point to the most recent data available.
This eliminates the need to manually input both start and end dates when they're not necessary for your analysis. It provides you with the flexibility to define time ranges that best suit your needs, whether you're looking at historical data up to a certain point or monitoring ongoing data from a specific start date.
Customize the alignment of table values
With the new enhancement, you can now customize the alignment of values within tabular charts (Tables, Detail Tables) in Vizpads. Previously, all values were left-aligned by default, which was not ideal for all data types. This new update provides you with the flexibility to choose between left, center, or right alignment for individual columns, allowing for better readability. Under Configuration â Formatting of any Vizpad in edit mode, you can set alignment at the column level or choose a default for each data type, making it easier to compare large figures, organize text, or neatly align dates. The same can be applied to all the charts globally from the Settings page.
Export pivot tables in .xlsx format
With this release, you can now export pivot tables created in Vizpad directly in XLSX format. Since the CSV files can't represent the complex layout of pivoted data, your pivot tables downloaded in XLSX format will retain their original structure.
The exported XLSX file mirrors exactly what you see in Vizpad, maintaining the combined columns and rows, row totals and subtotals. This makes sharing detailed reports with key stakeholders seamless and allows for further data refinement without losing any structural information.
Flexible file type selection for seamless imports
We have added a new dropdown feature that lets users to seamlessly select the file type when uploading data from file-based systems, such as S3, Azure Blob, HDFS, and FTP. The selected file type gets uploaded, ensuring smooth data loading without reliance on file extensions.
Effortless rearrangement of columns in Vizpad
In the Configuration pane of Vizpads, users can now easily drag and drop fields to any desired position within or across buckets. This rearrangement feature makes column management more intuitive and flexible.
â Deprecations
Backup & Restore tab
In light of the new metadata migration improvements, we have deprecated the older metadata-only backup and restore functionality, where metadata was primarily handled via a partial backup system. This older system required a full rebuild of data indexes during disaster recovery, which significantly delayed restoration times.
As a result, we are now focusing solely on a full backup and restore method for disaster recovery. This approach ensures that the entire system, including all metadata and data indexes, can be restored efficiently and reliably, enabling faster recovery and offering more granular control over data assets.
Tellius Assistant
Starting with the 5.2 release, the Tellius Assistant feature will be disabled by default for all customers as we transition to Kaiya, our conversational engine for advanced AI analytics. Kaiya offers a more powerful, intuitive experience designed to replace and improve upon the Assistant.
đĄď¸Security fixes
- We've fixed all the security issues identified during our recent penetration testing, making our system more secure than ever.
- We've resolved all high and critical security vulnerabilities in key components of our platform, including services like Elastic Search, Airflow, Feed, Bot Server, CDN, React, Zookeeper, Clickhouse, MongoDB, ChromaDB, AlertManager, Prometheus, RabbitMQ, ResourceTracker, and Clickhouse. This means we've reduced serious security risks to zero across these essential services.
- We've improved how user sessions are managed by implementing secure cookies. This change prevents unauthorized access to your login information, keeping your sessions safe from potential threats.
- We've upgraded our security tokens to use a more secure encryption method called RS512. This advanced encryption technique uses separate public and private keys, providing even better protection for your data.
- We've introduced special source tokens for embedded URLs. This means each embedded link is uniquely identified and securely managed without exposing any sensitive security tokens, giving you more control and peace of mind when sharing links.