When providing analytic reports to Senior Management, there are many approaches that can be taken to create these necessary building blocks for Business Intelligence. Before we show you suggested building blocks, let’s break down the terminology. The term Business Intelligence (BI) refers to technologies, applications, and practices for the collection, integration, analysis, and presentation of business information. The purpose of Business Intelligence is to support better business decision making. Aqua Data Studio helps the user get to the collections of data no matter where these collections are stored. This data could exist in the cloud, in relational databases, in document stores, or applications like Excel spreadsheets. These collections can then be analyzed in a clear and concise manner. These presentations of the business information can then be saved or shared. This blog’s approach assumes the user is a Data Analyst and does not know much about the data or Aqua Data Studio.
In order to get started, there are a few questions that need to be answered in preparation for building these blocks.
In this example, sales data for a bike shop is used. We would like to see the profit by product data and present these results in a bar chart to be shared in an image, using Aqua Data Studio. At the end of the building blocks, I have attached a video for this example along with more ideas and an execution for building these blocks using Aqua Data Studio.
Note: dragging or right clicking is for users unfamiliar with writing queries and is used in our example because, as stated previously, this user is not familiar with Aqua Data Studio and writing queries.
Notice the data is now populated with the data grid at the bottom of the screen shown in Figure 2. We can now verify the data again here if necessary.
Now that we have the data we are going to work with, we will select Aqua Data Studio’s Visual Analytics feature. There are a few ways of doing this:
The great thing about Aqua Data Studio’s Visual Analytics is that it automatically reads the data and classifies it in dimensions and measures. Because the data is parsed and ready, we just need to select the graphical representation of our choosing for Visual Analytics.
Visual Analytics supports many different chart types, such as Pie chart, Line chart, and Area chart just to name a few, and provides extensive configuration options so that you can present the reports exactly the way you want them. You can also combine several worksheets into a dashboard. See Figure 4 for different views; this is directly from the link to the Demo provided.
We have now created a worksheet with Profit by Product data that can be used in a nice presentation to our management team. If you would like to learn more about these building blocks and more, please watch this Visual Analytics Demo video for a walk through of Visual Analytics using Aqua Data Studio.