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

Twitter Analysis Dashboard demo

Twitter is one of the most influential and important social media site on the planet today. Most companies want to know (or should want to know) what people are talking about them, their products and competitors. Which companies get tweeted about most? Us or competitors? How does the sentiment trend over time for us and competition? It is obviously impossible to manually track hundreds and thousands of tweets about your company and competition to get a sense of market sentiment. You need an automated twitter analysis tool to help. Like a Twitter Data Analysis Dashboard. Here in this post, we will introduce a sample Twitter Analysis Dashboard which nicely summarizes publicly available data. The Business Intelligence platform used here is Qlik Sense. The application uses  Qlik Web Connectors  to extract Twitter data and automatically loads and visualizes the data for you. You can access the application using this link : Twitter Analysis Dashboard . The dashboard is availab...

Advanced Aero MRO Planning and Scheduling

The global aviation fleet is set to grow steadily over the coming decade, with global CAGR at 3.4%, and areas such as Asia-Pacific, seeing CAGR of 4.2%. This will significantly increase the demand for aircraft Maintenance Repair and Overhaul in the following years. Increased demand will introduce new competitive forces and an increasingly demanding customer base. MRO companies will respond by capacity increase, overtime or hardware technology updates to accommodate the increase but this wont be enough or even if it would be enough the constraints on resources and the sheer cost of increasing capacity will be prohibitive. A more intelligent way to handle the growth will be using game changer IT Technologies. Using advanced data analytics, predictive maintenance, data visualization and algorithmic supply chain planning and scheduling will enable companies to significantly increase the productivity and predictability of their MRO operations. You may have heard the first 3 IT Technologies ...

Improve customer retention and reduce customer churn by self service data analytics

To boom in today’s competitive world, a business must know its customers inside out. To understand your customers is to understand their motivations, their desires, and their fears. Your customer data can make you discover a lot about your customers if you can use proper customer data analysis tools. With such a tool, you can know why do people buy your products and services and what motivates them and what drives them away. Customer Retention & Churn The most precious assets for a business are it’s customers. However, the most important customers are not the ones that a business gains, but the ones who stay longer. It is one thing to count how many people have signed up or walked into store for the first time and quite another to understand what makes them coming back or leave. Customer retention refers to the ability of a company or product to retain its customers over some specified period. High customer retention means customers of the product or business tend to return to, con...