As we saw in the previous sections, the Denodo Information Self-Service tool has a way to:
But this tool still provides even more options, and one of the most important capabilities is executing queries directly on the sources where the data is stored. To achieve that, Denodo Information Self-Service Tool provides an Advanced Query Wizard for users to create ad-hoc queries.
You already know how to search within the data, but now you are going to work with fresh data coming directly from the sources. For example, the user Peter Bradley (the Chief Sales Officer of the company) wants to know the sales data during the second quarter (Q2) of year 2014.
In the previous step, Peter discovered that the view
sales_marketing includes a sale_date field, so he needs
to execute that view over that field.
Getting the Q2 2014 sales data is as simple as follows:
Clicking on the icon it is possible to open the
advanced editor where it is possible specify different filters, aggregations and selections to customize the query (only needed for
advanced Denodo users).
As you can see, is it possible to include as many filters as desired using the filter conditions.
Maybe one of the best features of the Information Self-Service Tool is the ability of save queries for reuse. Let's see how to do this:
Save Query asfield. Give this query a name like 2014 Q2 Sales.
Now you are probably wondering where to find the saved queries. They are in the left pane of the Information Self-Service Tool below the Databases list (you can click the blue Databases tab along the left side to view the lists):
From here, you can select any query of the list for loading in the workspace!
This is very useful because now Peter can work with this query. For example, tomorrow he needs to report the number of products sold during Q2 grouped by Country. After loading the query...:
Group byusing the
Looking at the results, Peter knows that Italy is his favorite country:
What's next? We suggest you try the button. YES! you can export the results to data tools like Tableau!
With this section, you have just finished the Denodo Data Discovery Tutorial set.
Great work and thank you!