Visual Analytics in Aqua Data Studio

Welcome to an overview video of Aqua Data Studio visual analytics. Visual analytics inside of 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. 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 clicked on Connect to Data, I can point to an existing business intelligence data set and right away I can see a separation of my data sets into measures.

Data Visualization

By 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. 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 a comparison data visualization there’s built 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? Again, maybe I’ll stick with this profit measure and drag and drop that and create a pie chart.

Perhaps mouse over the chart properties boxes and I see drag dimensions and measures here. I can drag and drop a dimension into a chart properties box and start building a visualization that way. Lots of different variations here. We can look at a few more examples here. Perhaps if I wanted to look at a calendar value, right? Here I can see ship date dimension, and I see a calendar and clock, so I can drag and drop that. And then you can perhaps customize this. If I right click here, I’m showing year values. Maybe I’d like to isolate that to weekly values and then perhaps look at my weekly sales and then perhaps customize this into a different look and feel or different type of data visualization. Here are just some examples that might apply to what you’re trying to do with data visualizations. So these are examples of worksheets.

I could right click on these, rename these. So maybe I’ll call this product profit. Save that notice that names it in the worksheet. So I can rename a number of. These worksheets, maybe all this profit by state. Here, maybe I’ll rename this one weekly sales.

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, new dashboard. Notice I see the available charts that I’ve already created. I could just double click or drag and drop and start creating the dashboard, which is a combination of charts. I have the ability to save or name this, right? I could call this profit by state and product.

Okay, so 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. 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, extract, and share the data set with this visual analytics file. So, different flexibility there.

Geographical Data Visualization

Lots of other variations and chart properties boxes that might be of interest here. 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 can isolate a data.

Set and say keep only, and just show me a certain regional, 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. You, Dan, also work on multiple data sets at once. If I clicked on data set connect 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 results set and then easily start building the 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.

Visual Analytics

Here I could click on Data Paste and then notice I have the ability to cut and paste data from a tab with a limited file into my data visualizations. Here’s an example of data brought from a 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. You can drill down into more details here on the visual analytics page from the Aqua Data Studio homepage page on 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.