Using a BI tool

Finally, the only thing that is left is to access the views we created in the Denodo Platform from a client tool. In this specific example we will use Tableau but any standard tool will be able to access Denodo through either the JDBC, ODBC or Web Services interface.

Creating a report in Tableau

Connecting to Denodo

Tableau provides a Denodo Connector using which views from Virtual DataPort are accessed and reports are generated. To connect to Denodo - just follow these steps

  1. Create a new data source using the Denodo Connector.

  2. Provide the server details and user credentials to connect to the database

  3. Click Sign in.

  4. Select the view: drag and drop in to the work space. We have two, monthly_sales_country and monthly_sales_area

Creating the report

Once the data connection is live, we can use the standard features from Tableau to create a dashboard that highlights the performance of the marketing promotions over time, split by country, split by area and total across all regions:

With this report at hand, that highlights the promotion-driven sales in orange versus the organic sales in blue, we can measure the performance of each marketing campaign per country and per month, so we can realize at a glance that the campaigns in Germany have low performance when compared to the rest of countries, or that the end of the year has been a great performer in Canada, like the outstanding performance of the first marketing promotion of the year in the UK. All of this thanks to the straightforward way of bringing data together that Denodo provides you.

Closing words

In this tutorial we have seen how a business question that traditionally has been difficult to answer can be solved with Denodo in a fast and easy manner. Not only that, but implementing a solution using Data Virtualization allows us to have a live report - as we have not imported any data, but retrieved in real time, in the future when our sales database grows and new marketing data becomes available, the report will be always up to date at any point.

On top of that, as we have created semantically relevant business entities within our virtualization layer, we are in a position where deriving new reports or entities is trivial, so we can continue building views and adding value based on disparate data; the fact that the data sources are physically distributed and have a variety of formats does not impact the ease of building new analysis infrastructure on top of them, so we can have an intelligent framework that is centralized, so it prevents duplication of business logic and brings out the real value of the data within your organization.

This concludes the Agile BI tutorial - if you want to continue exploring what the Denodo Platform can do for you, take a look at the official documentation and play with your own use cases.