Visual Analytics

Visual Analytics allows you to pull query results into worksheets to create beautiful visualizations of your data, you can create dashboards by dragging in visualizations from many worksheets and you can save and share them in workbooks with colleagues and customers allowing them to easily navigate and interact with your data.

Visual Analytics features include:

Datasets, Pivot Tables and Charts Enhanced in 17.0

Aggregate multiple datasets and build pivot tables and chart visualizations of your data in worksheets. Execute queries on your database servers and pull them into your workbooks, then easily drag and drop to create custom visualizations with filters, calculations and interactive controls.screenshots Visual Analytics Chart | Visual Analytics Pivot Table

Calculated Fields and Parameters Enhanced in 17.0

Augment your datasets with calculated fields and parameters. Users may add calculated fields which are new fields in your dataset where the values are based on user defined expressions of formulas, column values and constants. Parameters allow for controls to the calculated values that allow for users to quickly change content displayed in worksheets and workbooks.screenshots Calculated Fields | Parameters

Table Calculations

Table calculations allow you to add data to your worksheet with formulas that work on the data of your visualization. You may create calculations of moving averages, running totals, percent of total and other custom calculations to better analyze your data and make more accurate decisions.screenshots Table Calculations

Combination Charts

Users can create combination charts within one worksheet representation of a dataset. By pivoting on multiple measure fields, you may choose to display different chart types for each series of data, whether it be as individual or merged charts to provide a combination within one graph.screenshots Combination Charts

Trend Lines, Reference Lines and Box Plots Enhanced in 17.0

Random looking plots resulting from granular data can be better interpreted by using trend lines, reference lines and box plots. Trend lines fit a line that best represents the pattern contained within detailed data plots. Reference lines, bands, distributions and box plots offer a quick and convenient way to compare multiple data sets against a central theme and to assess the impact of groups of data points within a single set.screenshots Trend Lines | Reference Lines and Box plots

R Integration New in 17.0

R integration provides the ability to use Visual Analytics as your front end tool to rapidly create complex and meaningful visualizations of your statistical data analysis that is run using R. You create calculated fields in Visual Analytics to invoke R commands and the resulting data is plotted similar to any other field. screenshots R Integration


Worksheets are individual pages in a Workbook used to design pivot tables or visualizations of your datasets. An easy to use drag and drop interface allows you to quickly pivot and aggregate your datasets and visualize your aggregations in different visual representations.screenshots Worksheets

Dashboards Enhanced in 17.0

Dashboards provide a workspace for placing individual worksheets within a single view with a custom layout and enables the resulting view to become interactive with custom filters and visualizations. Use dashboards as a summary view of all your worksheets which allows you to quickly drill down into your data.screenshots Dashboards

Packaged Workbooks

Save your workbooks and data extracts to disk for later use or to share with colleagues. Save your full design, metadata and data extracts, or only your design, metadata and server connection information. screenshots Packaged Workbooks


  1. ^ Visual Analytics Wikipedia article. Visual analytics is an outgrowth of the fields of information visualization and scientific visualization that focuses on analytical reasoning facilitated by interactive visual interfaces.
  2. ^ R (programming language) R is a programming language and software environment for statistical computing and graphics.

Home Aqua Data Studio Aqua Data Server AquaClusters Support Buy Company Privacy

Copyright © 2001–2016 AquaFold, Inc. All Rights Reserved.