Visiology 3.12: Even more flexibility and capabilities

On April 15, Visiology 3.12 was released-an update uniting key requests of users, improvements to Self-Service ETL, new visualizations and a significant step forward towards AI-functionality. The focus is the development of tools based on artificial intelligence, increasing the flexibility of working with data and expanding opportunities for both analysts and administrators, and for business users, daily interacting with dashboard.

The AI-PROSS tool is integrated into the platform, which allows you to form a SQL code according to a textual description of the problem. The user introduces the task in a natural language, and the connected LLM model (locally or via API) converts it into a finished SQL request. The “AI-Caulus” function by default is disabled and activated manually.

Now numerical and temporary values ​​can be formatted in a couple of clicks - without additional transformations. Supported:

• rounding;
• display in percent;
• units of measurement;
• gaps between discharges;
• Various dates, including user.

Setting is possible both at the level of data set and at the level of a particular widget - priority is given to the widget settings. Formatting is preserved during export in Excel and CSV (with the exception of custom formats).

Added support for the transfer of data set between servers. At the same time, all connections, measures and structure are preserved, as well as SQL request. Data transfer is not carried out - it is necessary to manually recover the tables to the sources on the new server.

It is also now possible to change the data source in tables, for example, from the test Excel to the JDBC combat database.

The new version has the opportunity to create multiple connections between the tables. This allows you to use different analysis contexts, for example:

• order date;
• delivery date.

Only one connection can be active by default, the rest can be temporarily activated through the USERTIONSHIP function in DAX.

The platform now supports the loading of several Excel files with the same structure in one table. Mass download and auto updating from network folders is possible.

The long -awaited possibilities appeared:

• Data grouping (Group by) with functions: sum, average, minimum, maximum, median, quantity, unique;
• Combining tables (Append) - gluing tables (requests) with the same structure.

In version 3.12, the possibilities of interaction between widgets are significantly expanded: now the filter widget supports the filtering of values ​​according to the data of the related tables, the “Summary Table” can affect other elements of dashboard - a click on the line, cell or column displays the corresponding data in other widgets, and the author applied by the author, which will be visible to users with the role of the audience.

The new release expands the possibilities of setting up visualizations: a new indicator widget has appeared to display KPI with values, targets and trends, support of hierarchies in filters based on one or two related tables, and the settings of the results and summaries on the lines and columns in the consolidated table - including the display, color of the text and the background, the color of the text and the background, the color of the text and the background. formatting. Users can now configure the width of the columns in the table, hide them if necessary and use the icons in conditional formatting for a more visual data presentation.

There is a new widget “Regulatory Report”, with which you can add a button for quickly downloading a pre -prepared report to the dashboard. Also, data exports are also supported not only in Excel, but also to the CSV format - by default with a limit of up to 3 million lines, which can be increased by the platform administrator.

New access control opportunities have been added: now you can provide access to data sources within the working area without transferring logins and passwords. The option of disconnecting the export and sorting buttons for users with the spectator’s role also appeared, which allows flexibly adjusting the user interface and the level of interaction with the data.

Added options to increase the convenience of working with dashboard: now you can hide individual sheets from the audience, for example, during revision; The transition button to the designer will be automatically hidden among users without appropriate rights. In addition, transformations into Self-Service ETL have become independent of the starting tables-they can be safely removed without loss of settings.

The possibilities of the configuration and safety of the platform are expanded: now the administrator can include the dark theme of the default portal, set the non-standard launch path (instead of /v3) and use alternative ports.

Distributions are available on the link. The upgrade instructions can be found in the documentation.

You can find a full description of new functions in the official Visiology documentation.

We also suggest watching a video of the release presentation. In it you will find details and examples of the use of the new Visioology functionality.