(1) Qlikview overview

The contents of this article to learn from the two partners:

I. What is Qlikview

Ii. advantages and disadvantages of QlikView

1.1 What is QlikView1.1 what is Qlikview

Qlikview is a tool that is a tool for business intelligence Analysis (businessintelligence, abbreviated as BI).

Qlikview was developed by Qliktech. Qliktech was founded in 1993. Lund, Sweden. Today, her research and development center is still located in Longde. The U.S. and international headquarters are located in Radnor County and Pennsylvania, respectively. Qliktech has offices and partners all over the world. The purpose of Qliktech is to provide a conduit for enterprises to obtain information that keeps the enterprise alive. Qliktech can provide fast, powerful, low-cost data analysis and reporting solutions that can improve the overall enterprise insight and enhance the decision-making ability of the enterprise. By constantly innovating technology and unparalleled service, customers will be described to fulfill their wishes.

Qlikview files can be deployed on corporate networks or through advanced portal sites to users and can be viewed in many different file types. A variety of client files including Java objects, IE plugins, AJAX zero-footprint and windows-based analyzers can be applied to qlikview files. QlikView analyzes files and can also send e-mail messages like Word or Excel files. can also be safely transferred in different ways.

Qlikview manages information in much the same way that the human brain works. Just like the human brain, Qlikview is a combination of Lenovo and the process of information processing, in which the user decides the question to ask rather than the database, and the user simply chooses an object of interest to get a lot of other relevant information. The general information retrieval system is often the top-down query method. Qlikview allows you to start querying at any point in the data structure.

Traditional data query, often a complex task, requires extensive database knowledge and the ability to use a certain query language, and users are often limited to scheduled search routines. QlikView changes the situation by allowing it to freely select the data displayed on the page by clicking the mouse.

Qlikview can be used in many fields. Qlikview will make you the first to decide how the plan will be implemented

Households.

Qlikview can help you get data from different sources and databases, both locally and through a network-connected data source. Qlikview is almost able to be used with no database or data source.

With Qlikview, you can

L Create a flexible and finally user interface for the information base

L Get a snapshot of the data relationship

L based on your data for presentation

L Create a dynamic graph diagram

L Perform statistical analysis

L Link description and multimedia user data

L set up your own proprietary system

L Consolidate information from multiple data sources. Create a new table

L Build your own business intelligence system

The Qlikview cases used today are widely used in financial systems, human resource management, market analysis, customer support, project management, production control, inventory and procurement.

Users can combine applications in different fields to get new information.

Each Qlikview file does not create a fully-meaningful database on its own, and each file can apply its own stored procedures. Updates from data sources as they are updated. will be described in the following context:

Qlikview provides a revolutionary tool for everyone to simplify analysis. can provide high-speed, dynamic,

And can extract data from a variety of data sources, where the data source can be multiple data sources and can be a single Excel file or text file.

1.2 Qlikview's strengths and weaknesses

Through the introduction of the first section. We already know that Qlikview is a bi tool, and since it is a tool there are pros and cons.

Just like we're "nobody's perfect." No matter what a tool is not omnipotent. can solve a certain problem. Here's a brief look at the pros and cons of the BI tool.

For convenience, we know the usual traditional bi manufacturers Microsoft, IBM ... The available bi approach becomes the traditional bi tool.

1.2.1 The structure and disadvantage of traditional bi

The structure of traditional bi is for example with:

watermark/2/text/ahr0cdovl2jsb2cuy3nkbi5uzxqveglhbjgynzk5mtawng==/font/5a6l5l2t/fontsize/400/fill/i0jbqkfcma== /dissolve/70/gravity/center ">

The key to the success of traditional bi lies in modeling, from which it can be seen that the data taken from the database and modeling are applied at different levels in different technologies, very complex.

and the traditional BI implementation time period is long, the cost is big ... The most important is the success rate is not high, only about 35%.

? Risk degree: Data modeling takes a lot of time, resulting in longer project cycles. And because the modeling problem caused by the unreasonable data warehouse, thus affecting the effect of front-end analysis can not meet the needs of users. Added risk level for the project

? Resource consumption: Data I/O throughput is very large, from ETL, Cube generation to report data generation requires a lot of data processing, which requires a lot of system resources and time

? Flexibility: Once the user wants to add, adjust the requirements of multidimensional analysis. You must submit their needs to the IT staff, which is modeled from the data by the IT staff, and the cube is produced until it is presented. This process was built again

? Performance: As concurrent users add, the content of reports and OLAP increases, and the system responds slower. Even adding multiple application servers makes it difficult to fundamentally address performance issues

? High cost: Hardware and software costs, maintenance costs, training costs, very high cost of use

1.2.2QlikView structure and features

? In- memory bi: Qlikview leads the transformation of BI systems, data is loaded in memory, in real-time response to the user's analysis needs, fast computing speed (can return 4 million records in one second query results);

? the full bi architecture: Qlikview is a set of ETL, OLAP analysis and display in one of the BI tools;

? Click drive: Qlikview's Click -To-drive and visual interface allow users to access metrics, specific record levels, and show some non-measurable properties hidden in the business system.

? Data Access questions: AQL patented technology. Set data directly from the user's business system and perform multidimensional analysis. Eliminated the shortcomings of traditional BI based on Data Warehouse (bazaar) talent implementation.

? fully supports 64-bit systems;

? High-Speed modeling

? Data warehousing and third-party databases are not required, and data is pumped directly from the business system without the need for a traditional bi modeling process. Data is loaded into memory, using the patented AQL query engine. You can instantly query the relevant data for a given condition by the user.

? on-demand high-speed computing

? All charts are capable of multidimensional analysis. The basic difference between the other products is that QlikView's multidimensional analysis is when the user clicks and then runs the real-time calculation. Never use a pre-calculated good. is the fastest-computing bi product.

? intuitive, interactive user interface

? Provides a wide variety of chart types and variations. Each UI component can click Query.

The interface expressive force, adopt the elimination method to filter the data, accord with the human brain decision-making habit. Can use VB Script, Java script to do two times development.

? Easy to use

? The product architecture is simple. Get started easy--3 minutes to install, 30 minutes to master the basic use.

? Flexibility

No dimension limits, no matter what fields can be combined, analyzed and drilled as a management viewpoint. Compute dimensions and calculated measures are supported.

Randomly combine fields into new charts and cubes. Very flexible.

Can adjust the analysis model, interface layout and analysis object at any time on demand. Rapid adaptation to demand changes, easy to promote the use of

Comparison of 1.2.3 Qlikview and traditional bi

Disadvantages of 1.2.4QlikView

? Qlikview has no data warehouse, ETL, meta data Management and other parts:

Qlikview despite It is also known to have ETL function, is only relative to the other ETL tool, even if it is SSIS , are weaker on too many too much. There is no graphical interface, no good script management and version number control methods, timing scheduling wait aspects, is indeed its shortcomings.

However, as a front-end tool, the included ETL function is garbage. It's not the point. The lack of metadata management, and indeed exist, this can be based on the needs of enterprises to choose, some industries, not yet to this stage. Some enterprises, positioning Qlikview for desktop-level analysis tools. Or the announcement of an enterprise dashboard. There is also a limited natural requirement for metadata management.

? Qlikview No multidimensional database (OLAP) Technology :

but Qlikview in the "group" concept, combined with filtering properties, cross-table components, etc., can be partially implemented "drill", "Drill Down", "slice", "cut", "rotation" and other operations. It is also possible to implement a report style transformation to achieve the requirements of several business requirements reports by manipulating the data set in memory.

Mention this, incidentally, because unlike tradition, there are two points that will be special:

I. processing the same period, the prophase, the annual cumulative, and so on, is different from the other tools calculation method. It is very difficult to simply apply the concepts of other tools.

II. because of a QVW is a large collection of data. Then the data of all the pages in the same QVW will be linked with the selection, filtering and other actions, which is good, but also adds control difficulty to the data display.

? The application file developed by Qlikview is a number of QVW files. QVW files are stored data, the analysis is to be loaded into memory, the various QVW file Data cross-use situation. is poor, and is expected to be extremely difficult to achieve.

In this way, nature will give people a feeling that these QVW are "isolated". If this situation is to be improved. You can also consider QVW data from a data Warehouse / data mart. In the development of the front-end, a variety of formulas, the caliber must strictly abide by the norms, unity, to avoid the same indicators appear different caliber to calculate different values of the situation.

? permissions control. In this regard is weaker, defined in the LOAD script. According to the field to set, a little biased "hard", less flexible.

? Integrated with external WEB platform, does not support FLASH maps (Google maps is not too nice to use ) and so on;

? only for WINDOWS platforms, which is also a limited point.

? for the total generation. Qlikview is also considered a small-audience BI tool. Less resources and less communication are a big problem.

? integration with external WEB platform systems, such as PORTAL,OA and other systems, the key is SSO . Under the version number. The implementation of SSO is a very difficult task.

? in the report development time, to be responsible for the report support, not too good, not too standardized reports very difficult to implement.

As for the Chinese-style report, let alone.

? the data of the report are linkage, When the data linkage is realized when all the pages in a QVW are not needed. It's more of a hassle.

? false assumption for the already formed QVW application switch style, manual workload is too large, the theme of the production and application function is not easy to use.

Not to mention one-click Switch Application theme, this is not achievable.

? Development of the separate rate of design, there is no self-adaptive such a function, some rigid.

? Less learning resources. It is difficult to solve the problem in use. Note: This is one of the reasons why I am writing this series of blogs. Add some learning materials in Chinese.

? What you can see: it means that the deep information of the data allows our users to see through a glance. This is one of the advertising words that qliktech used for Qlikview , and you see qlikview The chart is also similar to a mere eye. What you see.

1.3 Summary

This article aims to let you know: what is Qlikview. and its advantages and disadvantages.

The advent and popularity of a tool always makes sense.

Using Qlikview can help us perform very fast bi analytics, providing a faster basis for leadership resolution.

As for its shortcomings that is unavoidable, because there is no perfect tool, we can use the process to avoid weaknesses. It is possible to produce the best results at the lowest cost.

Finally, let's talk about the advantages of using Qlikview:

? The shortest project implementation cycle, WYSIWYG. No project risk;

? The simplest system architecture, stable and reliable;

? The fastest report calculation speed;

? Minimum use of training time;

? Minimum maintenance cost;

? The most flexible requirements adaptability;

? The degree of happiness of the best customer;

Copyright notice: This article Bo Master original articles, blogs, without consent may not be reproduced.

(1) Qlikview overview