Hello Users!

We're are back with a fresh set of updates and enhancements to make data analysis faster and more insightful. Take a quick look at what’s new and see how these updates can power up your reports and dashboards.

Explore What's New!

Extreme Value Insights in Key Driver Analysis 

We've taken Key Driver Analysis a step further with Extreme Value Insights, a smarter way to detect outliers that drive significant changes in the target metric.

Feature Highlights

• Identify Outlier Impact: Detects unusually high or low values in key drivers that strongly influence the target metric.
• Spot Performance Deviations: Highlights sharp deviations from expected trends, revealing abnormal spikes or drops.
• Enable Deeper Diagnosis: Helps uncover thresholds and understand the factors driving extreme variations in performance.

Learn more

Create Tabular View using Multiple Tables 

With this enhancement, all tables linked via lookup columns are now available when creating a tabular view. This allows you to build reports that include multiple key metrics and dimensions. Previously, tabular views could be created from a single table only.

Learn more

Conditional Formatting for Data Bars 

Turn static data bars into dynamic ones by applying conditional formatting. Now, you can instantly highlight metrics that meet, exceed, or fall short of defined targets, making it easier to spot trends, outliers, and performance deviations quickly and clearly.

Feature Highlights

• Visualize Trends: See patterns and performance variations directly in Data Bars.
• Dynamic Updates: Data Bars respond automatically when underlying data changes.
• Customizable Appearance: Choose colors, scaling, and direction to match your reporting needs.

Learn more

For a detailed walkthrough of the new dynamic data bars, read our Conditional Formatting in Data Bars blog post.

Geo Spatial Functions 

We've now introduced a set of geo spatial functions in Zoho Analytics enabling advanced location-based analysis. The newly added functions include:

• ST Makepoint
• ST Makeline
• ST Buffer
• ST Area
• ST Distance
• ST Intersect
• ST_Centroid

These functions help you perform spatial computations such as measuring distances, creating geometries, and analyzing spatial relationships between locations.

Learn more

Export Dashboard as CSV Files 

Export dashboards directly as CSV files, making it easier to share, analyze, or archive your data outside the platform. This enhancement allows you to retain the underlying data from your reports and widgets, enabling seamless offline access and further analysis.

Learn more

Database Connectivity

We’ve expanded our support to help you bring in data from more sources, more flexibly.

Azure Managed SQL Instance 

Import data from Azure Managed SQL Instance into Zoho Analytics. This allows you to seamlessly integrate cloud-hosted SQL Server data without manual exports.

Learn more

Query Table support in Live Connect - Google BigQuery 

Zoho Analytics now supports Query Tables for Google BigQuery Live Connect, allowing you to perform complex data preparation and transformation tasks directly on your live BigQuery data. This feature is currently enabled on request.

Learn more