Skip to main content

Featured post

Golf Solutions Designed at Barnham Broom Golf Club in Norfolk

 Many sports tend to be biassed towards one sex or another. For example, football is a sport dominated by men and does not become much more masculine than rugby! On the other side of the fence, netball definitely falls into the women's category. However, there are some sports that share gender gracefully, which appeal to both men and women. Reddit live streaming Golf is undoubtedly one of these sports and has no age limits. Spread across courses in the UK you will find some unlikely groups of people bound by their love for this great outdoor sport. Some will play every day, while others will only play on the weekends, perhaps as a way to relieve the stress of a difficult week at the office. No golfer tends to join a club and membership packages vary widely in price. Most golf clubs simply offer standard packages with the assumption that one size fits all and offers a bit of flexibility. However, some offer more realistic membership packages, considering how much you will be playing...

Qlikview to Tableau Migration

Tableau is one of the most popular Business Intelligence software in the market today. Many organizations are adapting Tableau recently and trying to migrate from their old Business Intelligence platform to Tableau. In this post, we will focus on QlikView to Tableau migration.

Effort needed to migrate from QlikView to Tableau depends on the way your QlikView software is implemented. In some cases, the data needed for QlikView Dashboard is completely prepared in a 3rd party tool so when migrating to Tableau, you do not need to convert ETL (extraction - transformation - load) code. But in most cases, ETL for QlikView is implemented using Qlik's own query language, AQL (QlikView is based upon patented technology called Associative Query Logic (AQL)).

Tableau does not provide a native ETL functionality so when migrating from QlikView to Tableau, you will probably need a 3rd solution to implement ETL for Tableau.

The exception above is of course keeping QlikView for ETL and just converting QlikView in-memory data to Tableau's native data set, TDE. But this usually involves, keeping two software licenses under maintenance.
Qlikview to Tableau Migration
QlikView to Tableau Migration
So usually, Qlikview to Tableau migration requires :
1 - Selecting an ETL tool to migrate QlikView AQL code to
2 - Migrating QlikView AQL code to new ETL logic
3 - Reimplementing the dashboards

Yes, there is no product/tool that does automatic migration from Qlikview to Tableau dashboards. You need to manually implement the dashboards in Tableau. Traditionally, QlikView scripting language is richer than Tableau's own expression language so you will also need to handle some in dashboard calculations in ETL when migrating to Tableau.

Though looks difficult, the task is achievable, especially if you outsource the Qlikview to Tableau migration work to a company who knows both QlikView and Tableau. Here is one such company.

Comments

Popular posts from this blog

What is JEDOX?

Jedox is a Self Service Business Intelligence, Analytics and Performance Management platform developed by Jedox AG based in Freiburg im Breisgau/Germany. With a modular structure, JEDOX platform uses Microsoft Excel as its user interface on the one hand and a Jedox-specific spreadsheet on the other, both of which can be used in all common browsers. Jedox is unique in a sense that while most business intelligence solutions try to replace MS Excel based analysis and planning process entirely with their platform (and usually fails to do so because at one point things are exported to Excel), Jedox puts the powerful MS Excel sheet in the heart of their solution. By doing this they provide a familiar interface to users while enhancing business intelligence capabilities far beyond MS Excel. This is actually what JEDOX offers in a nutshell : Excel Plus. The modular architecture of JEDOX has a cell-oriented, multi-dimensional in-memory OLAP server that has been especially designed for...

The Black Death and how it changed Europe

 In the dark ages, religious dogma is the law, science is a cult that can be executed, and technology is considered the devil's masterpiece. History and public consciousness bear in mind the aforementioned features of the Dark Ages and the Crusades, which were only examples of the goals of European imperialism. However, there was another major event in the Dark Ages that greatly influenced modern culture in its own right. In fact, a widespread bacterial infection could be said to have a greater impact than most other events at the time. A small bacterial infection wiped out nearly half of Europe, setting off the invasion of the Mongol tribes of Genghis Khan. The same pandemic has left Europe in such a weakened state that it took almost a century for most major nations to recover. A small bacterial infection turned into a large-scale epidemic, spawning many heretical Christian groups, and indirectly leading to the formation of the Inquisition, which paralyzed the old world for deca...

QlikView Pricing and Cost

Business Intelligence cost can vary from scope to scope. More, it can vary for the same company and the same scope due to the approach, special prices, etc. Unfortunately most vendors do not publish their business intelligence software licensing and pricing publicly. You need to engage with them to get prices and you have almost noway to know exact pricing. These vendors usually sign a non-disclosure agreement with their existing customers so you cannot even get an answer for the cost and pricing by detailed investigation. QlikView, one of the most innovative business intelligence solutions in the market, is one of the few business intelligence solution provider whose licensing and pricing options and prices are publicly available. QlikTech (the developer of QlikView) is not only transparent on the pricing and licensing but also provides many options for its customers to have optimum license mix. This is great news if you are looking forward for a business intelligence solutions and Ql...