What's New
Changelog - 5.2.2
Changelog - 5.2.1
Release 5.2
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
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
- All Categories
- What's New
- Release 4.2
Release 4.2
Updated by Ramya Priya
We are thrilled to announce the release of Tellius 4.2, which comes packed with powerful new features, enhancements, and critical security updates. With Tellius 4.2, users will enjoy greater flexibility, accelerated time to insights, broader connectivity, and improved performance across the platform.
🚀 New features
Customizable Search Guide
The Search Guide can now be customized to include relevant questions tailored to each Business View. Admins can edit entire search queries (including categories), distinguish between user-updated and auto-generated queries, and get suitable suggestions for the query being typed. Moreover, we have increased the number of queries per category from three to five and added the ability to hide or unhide queries. A dedicated section has been included for real-time query result previews, enabling admins to accept or discard queries based on the preview. The Search Guide is now personalized and informative, transforming the user experience and simplifying the onboarding process.
Feed for Live Data Sources
Now, users can set up metrics to be tracked from Feed or from charts for live datasets. Alert emails will be sent immediately as soon as any anomalies are detected in the tracked metric. Additionally, users can now choose whether they need the report to be sent as an Excel attachment in emails, providing them with more flexibility.
Redesigned Vizpad Control Filters
The Vizpad control filters under Explore → Add Charts have been redesigned to offer users an improved experience. With four filter types to choose from (multi-select, single-select, range slider, and dropdown lists), users can now search and sort filter values in ascending and descending order. These new features make it easier and faster for users to refine their data and create customized charts that meet their specific needs.
For all types of control filters,
- The selected values will be applied only after users click the "Apply" button. This avoids the unnecessary overhead of applying the filters each time a value is selected.
- An "Undo" button is available to reset filters to their previous state. Administrators can control the visibility of the "Apply" button through Settings.
For single-select, multi-select, and dropdown lists,
- To make the list more accessible and informative, two pairs of nested lists have been introduced: "Available" and "Selected," along with "Include" and "Exclude".
For slider range filters (applicable to measures), the Formatting section now offers additional customization options. Users can modify the font style, font size, and color for minimum and maximum values, as well as for newly selected values.
External Data Engine Query Performance
Tellius now provides users with enhanced visibility into the time required for executing each query and rendering the results, specifically when queries are run on live data sources. In Vizpads and Search, the platform actively tracks and displays the time consumed by both Tellius and any external data sources, giving users a clearer understanding of query performance. This feature is crucial for identifying bottlenecks in query performance, particularly when performance is impacted by queries being executed directly on sources like Snowflake, Redshift, Azure, and more.
Enriched Metadata for Calculated Columns
Users can now enhance their experience by adding synonyms and column descriptions for calculated columns created at the Business View level. This expedites and simplifies data analysis by allowing users to reference calculated columns using synonyms rather than the actual column names in search queries. Moreover, the inclusion of column descriptions provides context for calculated columns, enabling data experts to set up explanations that can disclose the underlying calculations to end users.
Support for marketshare changes in Search queries
In Search, Tellius now provides out-of-the-box support for "change in market share" queries with the following syntax:
Show me [change/percentage change] in market share <M1> for <V1> for <F1> [vs/compared to] <F2>
Show me [change/percentage change] in market share <M1> for <V1> for <F1> [vs/compared to] <F2> for X1 for X2
Where
- M1 represents the measure
- V1 represents the target variables
- F1 and F2 represent a list of filters for the target population, with multiple filters following "for" or "in"
- X1 and X2 represent a list of global filters, including dimension or date columns
Users can now execute queries such as:
- Show me [change/percentage change] in market share Sales for Nike for New York vs California
- Show me [change/percentage change] in market share Sales for GoPro for North America vs South America for 2022
- Show me [change/percentage change] in market share Sales for Nike for New York vs California for 2022 for First-class shipping
- Show market share of dollar sales for Advil for adult internals for retailers for the last 4 weeks vs the last 4 weeks a year ago
Connectivity with Microsoft Azure Synapse
Now, users can seamlessly connect with Azure Synapse from Tellius to import data tables, or connect live and query directly. Under the Data → Connect tab, Synapse has been added with standard and advanced options (that override default settings) to facilitate seamless data integration.
In-app Tellius Product Roadmap
Now, customers have the opportunity to submit ideas, view submissions from other users, and provide feedback on our planned features. The product updates can be found under Help → Tellius Product Roadmap. They are organized into four categories: Under Consideration, Planned, In-Progress, and Launched, offering a clear overview of our development progress. Customers can influence the roadmap by rating or voting on features. As a feature receives more votes, it climbs higher on the list, gaining increased visibility and consideration. This enhancement aims to foster greater collaboration between our product team and customers, allowing us to continuously improve Tellius based on valuable feedback and insights.
📈 Enhancements
Synchronized global filters and Vizpad control filters
Vizpads and control filters (multi-select, single-select, range slider, and dropdown) will now be consistently synchronized with the global filters. These improvements facilitate a more user-friendly experience for managing and applying filters in Vizpads.
The synchronization respects the following rules:
- Changes made to a global filter or control filter for a specific column will be reflected in both filters.
- If either the global filter or control filter is deleted, the other one will be deleted as well.
- When creating a control filter for a column with an existing global filter, the control filter will respect the global filter settings. For example, if “USA” is selected in the global filter, only states corresponding to “USA” will appear in the multi-select filter.
- Only one global filter or control filter can be created per column, with a single filter pill representing both filter types.
- In the case of multi-Business View Vizpads, users can create only one global filter per column for each Business View.
Streamlining interaction with Business Views
A series of improvements have been introduced across Tellius to enhance the overall interaction with Business Views, enabling quick access and easy navigation for users.
- The space for displaying Business Views has been increased to accommodate 30 characters.
- Lengthy Business View names will be displayed on hover in tooltips.
- Live Business Views will be indicated with green colored dots.
- The Business Views can be searched and sorted.
Instant code application
While creating or editing Python/SQL code, Tellius now provides the option to apply the code directly to the dataset without saving it to the code library first—thus accelerating time to insights.
Support for Snowflake with PrivateLink
Tellius now supports connecting with Snowflake using PrivateLink via Amazon Web Services (AWS) or Microsoft Azure. With Snowflake PrivateLink, users can connect to Snowflake using a private IP address rather than relying on a public IP address that is accessible over the internet. This enhances security by restricting traffic to users’ virtual private clouds (VPC) or on-premises networks, thus reducing the risk of unauthorized access or data breaches.
Additional metadata in audit logs
The audit logs (available in native JSON format) now include the source IP address, username, and timestamp to provide a comprehensive view of events. Also, the logs are refreshed every 15 minutes to ensure they are up-to-date.
🛠️ Minor fixes
- The display and sorting of fields in the Excel attachment for Feed have been updated.
- The data labels for area charts have been updated.
- In calculated columns, the actions for editing, formatting, and deleting have been added to the ellipses of each row.
- 100% stacked bar charts will now display percentages in their data labels by default.
- When users create a clone of an existing viz or add a new chart to a Vizpad, Tellius automatically scrolls down to the newly created clone/viz.
- In treemaps, 100% stacked bar charts, 100% stacked area charts, pie charts, and donut charts, users can now choose whether they want to display values, percentages, or both in the data labels.
- Users can now view both dimensions and measures as data labels in treemaps.
🛡️Security fixes
In this release, Tellius has addressed multiple vulnerabilities and implemented significant version upgrades to enhance the performance and stability of the platform.
The following version upgrades have been brought in:
- MongoDB version to 6.0.3
- Redis version to 7.0.7
- RabbitMQ version to 3.11
- Spark version to 3.3.1 (from 2.4)
- Scala version to 2.12 (from 2.11)
- HDFS version to 3.3.4 (from 2.10)
openssl and libssl-dev packages have been removed from the following images:
- Tellius-web
- Tellius-react-web
- Rasa-core
- Clickhouse
- Cdn
- Bot-server
- Data-loader
The vulnerabilities associated with log4j and jackson-databind jar have been addressed in the following images:
- Spark-restserver
- HDFS, Middleware
- SQE
- Resource-tracker
- Viz-engine
- Clickhouse-autoscaler
⛔ Deprecation
With this release, the capability to directly connect to BigQuery data tables using GCS buckets has been deprecated.