Visual Analytics 

Aqua Data Studio

Welcome to an overview video. Aqua Data Studio. Visual Analytics. Inside Aqua Data Studio is a main menu and a floating window, right? Here you can see an example of some visual analytics files I have opened. This introduces the concept of separating your data sets into dimensions and measures, and then the ability to build worksheets and dashboards and then perform analysis and tell a story through my data visualization. Okay, so let’s look at some examples. You really have unlimited features here in terms of variations and types of visualizations, but let’s look at a few examples. 

Visual Analytics

Under visual analytics, new connected data will allow me to point to existing data sets. Or you’ll see the icon above, different data sets, and that would bring that data set into the visual analytics. Here if I click on Connect to Data, I can point to an existing business intelligence data set. 

Right away I can see a separation of my data sets into measures. My numerical fields and dimensions, pretty standard in a visual analytics tool. Now I have the ability to drag and drop and build all types of data visualizations.

Data Visualization

Let’s look at some examples, right, maybe a quick example is a comparison data visualization. Here I can drag and drop some revenue values per product. Here I’m seeing a comparison of sales revenue per product category. I have different ways of sorting or customizing this view of this data set. This is one example of comparison data visualization. There’s built in intelligence where the visual analytics will choose what type of visualization it thinks is helpful for those fields, but you can customize or change those as well. Here if I wanted to build a different type of visualization, perhaps a pie chart example, and then drag and drop certain values, right?

Dashboards

Okay, so very easy to use, right? Click menus or you can drive from the toolbars as well. To introduce the concept of dashboards, here, I could click on new dashboard or dashboard.. Notice I see the available charts that I’ve already created. I could just double-click or drag and drop and start creating a dashboard, which is a combination of charts. I have the ability to save or name this, right, it’s called. 

Lots of flexibility here in terms of how you’d like to document or name your data visualization. Okay, so you have the ability to dive into the data here, right? I could click within the fields here. Notice view data would allow me to slice and dice the data and look at the data that’s building this data visualization.

Export Data

I have the ability to export this in different ways. File export, I could export this to an image, HTML or PDF, but then you also have the concept of shaving this or sharing this with other Aqua Data Studio users. File save would allow me to save this as a visual analytics workbook. Or you have the ability to create a data extract and so file export package workbook would allow me to save an extract and share the data set with this visual analytics file. So different flexibility there. Lots of other variations and chart properties boxes that might be of interest here.

View Data

Perhaps if we look at a different example here, I could build, say, a geographical view, right? Perhaps I’d like to see a geographical view of sales, right? Here I could say drag and drop a profit value into my geography box and start building a data visualization that way. Or perhaps I’d like to see a global view of sales and create a map or global view and then perhaps isolate this to a certain portion of my global view and perhaps turn this into a regional view, right?

So here I could isolate data sets and say keep only and just show me a certain region, then drag and drop into certain chart properties boxes from here and isolate and start to tell a different story here. So lots of flexibility and customization capabilities.

Multiple Data Sets

You can also work on multiple datasets at once. If I clicked on data set connected to data, I could see other available data sets, right? Here was a data set from a business intelligence data set I had here. I could point to, say, an oracle result set and then easily start building a story or dragging and dropping and telling a story with this data set, right? You have different capabilities here to be working with multiple data sets at the same time. Also here if you have data in an external file. Here for example, I could just copy and paste to bring a data set into my data visualization.

Aqua Data Studio Visual Analytics

Here I could click on Data Paste and then notice I have the ability to cut and paste data from a tab which are limited file into my data visualizations. Here’s an example of data brought from an Excel spreadsheet from an Oracle SQL statement and then just a cut and paste from memory and clipboard. Okay, Aqua Data Studio Visual Analytics is included in all licenses and then you can drill down into more details here on the visual analytics page from the Aqua Data Studio homepage on Aquafold.com. We encourage you to download and explore the visual analytics and start having fun building data visualizations and slicing and dicing your data with Aqua data Studio Visual Analytics. Thank you.