Data Analysis Help

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 convert...

Qlik has finally released the new version of its business intelligence platform, QlikView 12. The major change in the QlikView 12 compared to QlikView 11 (which was released in 2011) is the data engine. QlikView now uses the same QIX Associative Data Indexing Engine (QIX) that powers Qlik Sense . Other than the data engine improvement, QlikView also has enhancements in its security and mobile experience. All functions on web client are now available on touch devices without limitations.  Other changes are improved clustering, native connectors to web services and accessibility of Data Market to QlikView. Qlik has released a new platform, Qlik Sense, in September 2014, after two years without any major release and the release date of QlikView 12 was since awaited by existing users of the platform. The last major release of QlikView was QlikView 11 released in 2011. Since the company was releasing a new version in every year the expectation was that Qlik (then called QlikTech...

Qlik has recently released a new version and more mature version of Qlik Sense, Qlik Sense 2.0, and also a brand new concept / platform named Qlik Analytics Platform. Besides, Qlik Sense now also has a cloud version where you can use this cutting edge data visualization software as SaaS. There will be a QlikView / Qlik Sense introduction event at 9am - 11am on 16th September 2015 in Singapore Management University. In this event, you will not only have a chance to learn about Qlik product and platform family, you will also have chance to see the newest features of Qlik Sense and QlikView. This event is a free and for registration and details you can visit  Free Qlik workshop for Business Users and IT professionals: Interactive Business Reporting and Analysis with QlikView & Qlik Sense page. Qlik Sense Qlik Sense Imagine analytics so intuitive, anyone in your company could easily create personalized reports and dynamic dashboards to explore vast amounts of data and find meaning...

Retail Store Performance dashboard demo is a free, online QlikView demo which showcases how an interactive business intelligence platform can be used to analyze the performance of stores from a regional level all the way down to the individual store level. The user can analyze sales versus budget, sales versu target, customer satisfaction, Year to date scorecard for regions, as well as detailed sales trends and numbers. The application also has an integrated map chart where the user can perform geospatial analysis. The Retail Store Performance dashboard ties corporate strategy to store level execution at all levels of the store operations hierarchy.  Timely and accurate store performance metrics can be analyzed in the corporate office, in a store, or through a mobile device for traveling store operations and field management. You can access the application by filing  Data Analytics with Qlik Demo/App Request Form  (select "Retail Store Performance Dashboard Demo" in the ...

Overall Equipment Effectiveness (OEE) provides an overall measure of performance for a process. Developed by Seiichi Nakajima in the 1960s to evaluate how effectively a manufacturing operation is utilized, OEE is commonly used as a key performance indicator (KPI) in conjunction with lean manufacturing efforts to provide an indicator of success. OEE Analysis Dashboard by QlikView is a rare freely available business intelligence example which provides a performance overview for manufacturing, provide diagnostic capabilities in order to improve performance over time to understand the current level of performance: What is it getting better or worse?  Why is my performance at its current level?  What are the drivers behind the performance?  By machine, By cell, By time period?  What resources do I invest where to have the biggest impact? The application sits on top of a shop floor data collection system and would contains information about the performance of shop floor...

The core feature of QlikView is an in-memory, associative data model which feeds the visualization in a very unique way. In a traditional business intelligence application, the data visualization layer interacts with data through queries which are basically scripts executed by the platform. So if you for example select a country to drill-down to the sales numbers in that country, the data visualization layer runs a script, queries the data, retrieves the data from the data layer and updates the charts and reports in the screen. QlikView on the other hand do not use this query mechanism. Application and data layer are tightly integrated in QlikView and data relationships are handled in engine level not application level. This means the QlikView charts and reports are integrated with in-memory data model and they know how to filter themselves when user drills down. The mechanism above help QlikView developers to write significantly less software scripts which shortens the development an...

Business and risk have always been seen to go hand-in-hand and the need for banks to strengthen their risk management framework is vital. Exposing the true risk profile to the users has been a challenging business problem due to multiple data sources and differences in operational processes and metric definitions. To mitigate this situation, a financial institution should provide a holistic view of the risks faced by the organization at any point in time. When up-to-date information on risks can be analyzed and put at the users fingertips, firms will inevitably find it easier to maximize profit AND reduce risk. The purpose of the Credit Risk Management demo is to illustrate how QlikView can be used by a financial institution to manage credit risk. By providing a unified picture to the entire business, QlikView helps everyone have the same, up to date, picture of their risk exposure instead of disparate spreadsheets floating around the business. Credit Risk data is also interesting to t...

Salesforce is the of the most popular cloud based Customer Relationships Management (CRM) product available in the market today. Organizations today invested in Salesforce.com today can also enjoy the business intelligence interfaces provided for them to make sense of Salesforce data. But leaving CRM functionality in Salesforce.com while integrating the data from Salesforce into a more flexible but third party BI platform has definite advantages. For example, you can blend data from Salesforce and other in-house systems to analyze it together. QlikView provides a Salesforce connector which can extract data into QlikView to develop powerful analysis, reports and dashboards and empower users with rich and interactive visualization. These dashboards in return will help you to improve key CRM KPIs like sales forecast accuracy, pinpoint cross-sell and up-sell opportunities and achieve more customer centric service and support delivery. You can instantly try out how a QlikView dashboard for...

QlikView is one of the most popular business intelligence platform today. Its popularity is not an accident. With its super fast and user-friendly data discovery interface, rapid development cycle, fast response time, it provides a very capable platform to extract the hidden value in the enterprise data. SAP is on the other hand one of the most popular ERP solutions in the market today. Although it also provides BI capabilities, many customers choose QlikView as their BI platform to extract data from SAP. With QlikView, you can consolidate information from SAP BI, SAP R/3 or any other data source easily and then search and analyze this data with Google-like ease and speed. QlikView also provides a QlikView Connector for SAP Netweaver which enables SAP customers to get easy and quick access to all the data hidden in different SAP systems in QlikView. KMS , an authorized QlikView partner in Singapore is having a free event named "QlikView for SAP: How to unlock the value of your da...

QlikView is one of the most powerful and popular business intelligence platform in the market today. It has a really powerful interactive interface, data massaging module and rich set of charts, reports and graphs which can help you to create almost all types of business intelligence dashboards you need. Although complex QlikView dashboards may require some experience and IT skills, one do not need these two to benefit QlikView. With a very short learning curve, you can easily start to create powerful dashboards on your own. To do this, you can follow online QlikView videos, free QlikView training modules as well as regular QlikView classroom trainings in your area. You can also join a hands on QlikView workshop to kick start your QlikView experience. Avensys Consulting, a QlikView partner based in Singapore is regularly conducting Qlik hands on workshops in Singapore to introduce QlikView to business users. Open to every business executive who are struggling to make sense of their ...

QlikView is one of the most popular and powerful business intelligence platform in the market today. QlikView's distruptive technology makes it a key player in business intelligence industry. With its flexible and powerful analytics environment, building QlikView apps can be mastered by both developers and business users. Qlik (the company behind QlikView) provides two basic courses for those who wish to learn QlikView : QlikView Designer Training courses for business users and QlikView Developer Training for advanced developers. QlikView Designer course is 2 days and QlikView Developer Training is 3 days. Those who wish to take 3 days developer training needs to take the 2 days designer training. These two courses are what you can find when you take training from Qlik or some partners of Qlik. But there are alternatives. There is for example a QlikView 11 for Developers material, which covers a more hands-on approach then the standard training. In this course, some powerful and co...

Tableau Desktop has been rated as the best business intelligence platform by business software reviews site G2 Crowd users.  Tableau, the long time category winner, was followed by QlikView, TIBCO Spotfire, SAS BI and Oracle BI. The Grid for Business Intelligence by G2 Crowd rates and profiles business intelligence products. Products shown on the Grid for Business Intelligence have received a minimum of 10 reviews in data gathered by September 19th, 2014. Products are ranked by customer satisfaction (based on user reviews) and market presence (based on market share, vendor size, and social impact) and placed into four categories on the Grid : Leaders, Contenders, Niche and High Performers. Leaders offer Business Intelligence products that are rated highly by G2 Crowd users and have substantial scale, market share, and global support and service resources. According to G2 Crowd Grid for Business Intelligence, Tableau Desktop, QlikView, TIBCO Sportfire, SAS BI and Oracle BI we...

Asset Under Management analysis is an important part of any financial institution in asset management, private banking and wealth management business. The data can be quite huge and data from many different sources need to be combined to get the big picture. Unfortunately, this process is quite manual in many organizations where plain old MS Excel is used  to perform analysis with usually poor results. We have seen that a powerful business intelligence platform can be leveraged for wealth management, asset management and private banking institutions to increase analyis productivity greatly. But what is developed is usually not public (even dashboard layouts are protected) so you can not see a lot of nice asset management business intelligence dashboards. This rare Asset Management demo provides an analysis of assets under management by various dimensions such as asset class, investor, fund type and region. Users can look up funds and their performance and analyze fund details. The...

Retailer POS Data Analysis Dashboard demo is designed to give visibility into the Retail environment for Consumer Products companies. The source of data is the Retailer who makes information available from their store EPOS and depot systems to the Consumer Goods company. This demo gives any retailers a picture of product stock levels in store, depot and in transit, as well as sales analysis. The app supports you in you efforts to deliver improved product availability through allowing your organization to reduce out-of-stocks and lost sales potential, as well as identifying potential alternative sources of replenishment. The POS Data Analysis is developed on powerful QlikView Business Intelligence platform and utilizes its associative features as well as state-of-the-art GUI. Over 3,000 Retail and Wholesale Distribution companies globally rely on QlikView to empower business users and decision-makers today, by providing access to on-demand analysis, insights and business discovery. ...

Qlik has finally released its long awaited Qlik Sense platform on 17th September 2014. Qlik Sense is a next-generation self-service data visualization application from Qlik (see more here What is Qlik Sense? ). According to Qlik, Qlik Sense is built on the QIX Associative Data Indexing engine , the second generation of Qlik’s proven and patented engine technology. It has some dramatic changes compared to QlikView , such as drag-and-drop visualization, server side dashboard development and distribution, a token based pricing ( Qlik Sense pricing ), overhauled data extraction, integrated maps, new charts, etc. Is Qlik Sense new QlikView or QlikView 12? The answer is no. Qlik started the project as QlikView,Next which was implying that the next product will be the new version of QlikView which is on version 11 released in 2011. But Qlik has changed the name to Qlik Sense. It makes sense because this product is different. Not entirely but different. Conceptually, Qlik Sense and QlikVie...

Qlik Sense is a next-generation self-service data visualization application from Qlik, a leading data discovery platform provider. Launched on September 17th 2014 , Qlik Sense empowers everyone to easily create a range of flexible, interactive visualizations that drive exploration and discovery through intuition. Qlik Sense is a new product and is not QlikView 12 . So now basically Qlik offers two BI platforms: Qlik Sense and QlikView. You can read more about the difference between Qlik Sense and Qlik View : Qlik Sense vs Qlik View . Qlik Sense is built on the QIX Associative Data Indexing engine , the second generation of Qlik’s proven and patented engine technology. Associative Data Indexing allows people to explore data relationships across many sources that would otherwise be hidden in hierarchical or query-based approaches. Qlik Sense drives faster time to insight with intuitive exploration, smart search, and smart visualizations. It broadens knowledge sharing with data storytell...

Helsana Group, a leading health and accident insurer in Switzerland, will use uses QlikView Business Intelligence platform to consolidate and analyze data from Teradata, Microsoft and Oracle data warehouses. QlikView will enable Helsana users to perform quick and easy data analysis in the areas of sales, management control and information management. Helsana required a dynamic analysis tool which is alternative to their existing and cumbersome reporting. Traditional business intelligence solutions are too complex and creates a lot of extra work for the IT department so the company turned to an easy to use and flexible QlikView. QlikView enables business users to assemble data from multiple sources, explore it, make discoveries, and uncover insights that enable them to solve business problems in new ways. QlikView works the way the mind works. Users conduct searches and interact with dynamic dashboards and analytics from any device. They ask and answer streams of question...

Insurance data analysis  can help all types of insurance firms (including property & casualty, life, health, etc) to improve profitability across the board. But to make it happen, insurance companies also need to have the right tool. This rare Insurance data analysis dashboard ( Insurance dashboard in short) is a business and profitability management application for the insurance industry developed on powerful QlikView Business Intelligence reporting platform. The application covers a range of business areas, and presents a compelling story for how a powerful Business Discovery tool can help companies improve profitability across the board. This application contains the transaction level details of insurance claims and policies. The sample data is on customers, policies, and claims from a midsize insurance carrier. The dashboard allows its users to analyze this year’s performance based on the number of claims and policies as well as loss ratio. Customer mix is captured using ...

QlikView is a fantastic business intelligence platform but it does have some limitations when it comes to security management. Although the application is quite secure (it is used in a lot of banks where security is extremely important) but setting up security is cumbersome. QlikView platform by default lacks a single, easy manageable and scalable security module. The built-in security framework is highly manual and script based to setup. Although it is manageable for 50-100 users, security management becomes a real burden for a few hundred to few thousand users. In addition to manageability issues, QlikView default security framework lacks the following: Role based security setup assignment – Every users security configuration is done separately even a large group of users share the same security configuration where role based security assignment is crucial. GUI based security configuration – Security configuration in QlikView is script based. Although QlikView Publisher (an...

QlikView is the world’s first associative, in-memory Business Discovery platform which delivers true self-service BI that empowers business users by driving innovative decision-making. QlikView enables business users to assemble data from multiple sources, explore it, make discoveries, and uncover insights that enable them to solve business problems in new ways. QlikView works the way the mind works. Users conduct searches and interact with dynamic dashboards and analytics from any device. They ask and answer streams of questions on their own and in groups and teams. They forge new paths to insight and decision. QlikView is a single product that has multiple components for use by people in various roles: business users, business analysts / BI application developers, and IT professionals. QlikView simplifies analysis for everyone. Qlik’s patented technology allows instant, in memory, manipulation of massive datasets on low cost hardware, allowing affordable widespread deployment of soph...