Contact us at +1.415.901.7500 or contact@itconvergence.com

Know Your BI Tool: Your Questions on Qlik and Tableau Answered

Know Your BI Tool: Your Questions on Qlik and Tableau Answered
Qlik Tableau

Last week we had our webcast “Best Strategies for BI: Unleashing the power of Real-time Analytics”, where we dived into the world of Qlik and Tableau, two revolutionary BI tools that can change the way any organization leverages data. If you missed it, you can always download the recording here.

We had some interesting questions from the audience, so today we’re bringing you the transcript.

I liked your demos. How can I implement those solutions on top of my E-Business Suite Applications?
Implementing these self-service BI tools is very simple. A typical implementation projects include a first phase where your project goals are defined, and the information available your database related to the goals you wish to achieve is mapped from the BI tool.
In the case of Qlik, the product creates the links between data elements with the same name – so for example, if you’re mapping information from Order entry tables and inventory tables those are immediately associated by the different IDs in the application. As you know, virtually every piece of information in Oracle EBS is linked to other entities through different IDs, so this makes the navigation we showed on the demo completely viable without any specific manually defined associations. The tool with automatically create additional drill paths based on the information.

Basically the implementation is about defining goals, defining the data to be explored by the BI tool and laying it out in a canvas that users can work with and navigate easily.

I have a data warehouse that was designed some time ago and that’s currently only used to generate a few reports. I want to keep those reports but also do BI from it. How can I do that?
That’s a common problem; we see many organizations who implemented a data warehouse some time ago with the final goal of implementing a BI tool. Some began the process but didn’t finish it successfully, others achieved the goals they set out but didn’t do much updating afterwards, so they can only run a few reports from there.

In case you have a data warehouse environment, you can keep working with the reports you currently have and mend the functionality by plugging in any of these tools. This will lead to the ability of combining information from your data warehouse with your transactional database or any other source of information you have. This way you will be able to analyze and drill down your data, getting more reach and results that with the plain reports. You can keep them, but upend the functionality.

How are Tableau and Qlik different to Power BI in terms of functionality? 
Qlik and tableau are very modern tools in terms of technology, and according to a recent Garner report, lead the self-service BI market. They were design with a different paradigm in mind, which doesn’t involve long implementation times. The cost of the licenses and the software service model is minimal, only a few hundred per year, so they are really inexpensive. And the paradigm is to provide information to your users and allow them to navigate the data any way they want – users have that freedom without the need of involving the IT team to design dashboards, queries, etc. It’s like laying the data on a table and letting users access it anyway they want.

Can Tableau be used against an OLAP data source like Oracle Essbase?
Yes, both Qlik and Tableau provide different connectors to databases, including Excel spreadsheets, and they can access data from data warehouses and transactional databases. That’s the value: you don’t need to pre-summarize or pre-aggregate data; you can run it against the database directly. Since these tools upload information in-memory and calculate all the information from compressed storage in-memory, it’s incredibly fast. Running reports, queries, dashboards, creating graphics, it’s all done on the fly, without pre-aggregating data – they are very different tools from what we are used to seeing.

Can Qlik and Tablaeu be integrated with Sharepoint?
Yes, they can publish information in Sharepoint.

For more information on these tools, do not hesitate to contact our expert team.