Following version 8 of BiX Analytics, which offered connection to relational data sources, the release of version 8.1 is a game changer for BiX Software customers.
A daily challenge for business users is to bring together and use data from multiple varied sources. Faced with an absence of suitable software or, on the contrary, the numerous tools to be mastered, this work is most often carried out using formulas or macros, within the everyday environment of Microsoft Excel.
Thanks to BiX Analytics 8.1, users can now, within their preferred environment, easily create and manage analyses and dashboards that mix data of different types, using previously reserved specialist’s tools.
The new graphic wizards in BiX Analytics 8.1 hide the technical complexity, to let the user focus on managing data extraction, filtering, and calculations. Thus, with a simple “drag and drop”, the user selects the columns from various tables and lets the links be created automatically. Data consistency is transparent and guaranteed by the integrated query synchronisation capabilities, issues such as complex formulas, formula errors and outdated data become history!
Faithful to the BiX Software ethos, which aims above all else to understand the needs of users through collaboration at the field level, business constraints and desires were taken into account throughout the development cycle from the design phase to the release.
Thanks to the involvement of several customers, such as SeLoger, EOL or Caisse d’Epargne, the architecture, technical choices, and user interface continuously evolved, in order to meet real business needs.
On top of the ability to easily build complex relational queries, certain features enhance user comfort. For example: the automatic management of links between tables, the management of a personal query library, the instant generation of standard filters or the large gallery of personalised filters which make the use intuitive for the end user.
The new “InfoQuery” object, used for rendering queries on “flat” data sources, benefits from the same capabilities as the “InfoSet” object well known to users. Among these particularly appreciated highlights are the complete integration with Excel formulas and formatting as well as labels despite changes in the table size.