QlikView

2012

QlikView Business Discovery

The QlikView Business Discovery platform allows to analyze information on activity of the enterprise in different cuts and irrespective of in what accounting systems this information is stored. Use of QlikView on mobile devices gives to the management an opportunity to control business from any place in the world and to quickly make decisions.

An analytical system should be unrolled quickly even when using a large number of data sources, incorporate means of joint work, analytics in real time, "cloud" BI. Special attention was paid to opportunities of visualization and support of mobile platforms (iOS, Android, BlackBerry OS).

The solution QlikView provides to users of means for the analysis, forecasting, modeling of a situation, control of key indicators and company performance. QlikView is the cornerstone use of in-memory processing technology which allows to analyze business information at any level, avoiding laborious and expensive works on creation of storages and a multidimensional OLAP cubes. Any calculations are executed instantly even at very large volumes of information and simultaneous operation of a large number of users. Thus, this solution considerably increases efficiency of the enterprise.

On March 5, 2012 the Jet Infosystems company announced completion of the Russia's first stress testing of a system of the business analysis of QlikView – platforms of the class Business Discovery. According to the received results, the platform is applicable for creation of solutions of Enterprise-level.

QlikTech released the version of QlikView 11 which is positioned as the platform of Enterprise-level capable to solve major and complex analytical problems. Understanding potential benefits of QlikView, the Jet Infosystems company suggested to hold stress testing of the platform for evident demonstration of its work to potential customers.

"The projects of creation of BI systems implemented by us show that the effective and at the same time flexible tools capable quickly are necessary for the companies to analyze large volumes of data. We made the decision on conducting testing of QlikView, aiming to satisfy business needs of our customers, – Anna Kharitonova, the head of department of the business analysis of the Center of software solutions of Jet Infosystems company comments. – The research of the platform allowed us to study in detail features of the new version of a product and to provide the guaranteed result of implementation of QlikView as the Enterprise-solution".

Data for a research – the depersonalized database containing about 3 billion records, and examples of daily created analytical reports – were provided by one of customer companies which number of staff exceeds 5000 people. In the company about 500 competitive users at the same time work with the reporting. These numerical indicators meet standard for a segment of large business.

The load research was conducted on three versions of the QlikView server and three stands of different configurations. At the first stage specialists of Jet Infosystems company tested QlikView on virtual machines. Having convinced that the solution effectively works with large volumes of data in "cloud", experts of integrator continued testing of the platform on the physical server and a cluster. The used load scenarios were as close as possible to real working conditions of users. In total more than 20 load tests were carried out.

During testing it was succeeded to exceed more than twice the indicators meeting standard for a segment of large business: 500 competitive users, 7 billion records. Also during the research experts of the system integrator developed QlikView implementation methodology in the companies of an Enterprise-segment considering specifics of big corporate customers.

QlikView for iOS

In October, 2012 the QlikTech company announced expansion of opportunities QlikView on mobile devices, having released the new application for operating system iOS with ample opportunities as for on-line, and autonomous access from mobile devices. The QlikView for IOS application offered now for iPad tablets through app store of Apple App Store supports opportunities for work in a standalone mode which supplement possibilities of the on-line access to QlikView provided via the browser. QlikView developed together with the customer from the five of the largest international pharmaceutical companies, this application completely models work with the Accesspoint portal, implementing use support by analytical applications of QlikView of functions HTML5. Having connected to the portal, users can involve all powerful and flexible opportunities of the QlikView Business Discovery platform, and the new standalone mode of work provides access to lack of connection. The application can be loaded free of charge and works with any server license QlikView 11 without additional payment.

In the presence of application connection of QlikView can work with data in real time and provide all interactive functions of a business intelligence. Here the associative model of work with data, global search, functions of dynamic data visualization and joint work enter. When implementing these opportunities functions of data filtering, association management and accomplishment of real-time calculations of the QlikView server will be used. The unique combination of flexibility and power of the functionality allowing to receive answers to unpredictable questions which can arise during the mobile work is result of it.

The flexible, determined by the user representations for a standalone mode

In addition to the full range of functions of the Business Discovery platform available in the presence of connection, the new mode of independent operation allowing to get on iPad access to certain notions even in the absence of connection is provided in the QlikView for IOS application. Users can define a range of information which should be available independently, using different tabs and measurements of QlikView. After that the QlikView server generates a number of "cuts" for the application which are ciphered and loaded on iPad. In the absence of connection users have an opportunity to start applications of QlikView, to browse all tabs and objects and also to select different combinations of tabs and measurements by means of fixed functions of the interface. As users independently select tabs which should be available in offline, the dependence on developers of reports who should foresee their requirements almost completely is eliminated.

Single user interface

QlikView for iOS provides the advanced functionality supplementing and expanding the standard opportunities for work of QlikTech offered on mobile devices thanks to support of HTML5. Now the organizations should not make the choice between use of QlikView on the mobile device via the Safari browser or through the new QlikView for IOS application. Irrespective of the used client of QlikView offers the identical interface and the principles of work on all platforms, and now also irrespective of existence or lack of connection. Besides, the QlikView Server server still provides the centralized operation and security aids necessary for the most exacting IT departments. Thanks to emergence of QlikView for IOS it is not necessary to make a compromise between autonomous functionality and means of Business Discovery – all opportunities are available to the organizations.

"In the market there is a set of mobile tools of a business intelligence, and even more they will appear in the nearest future. Many of these products move ahead using only one key aspect: excellent appearance, – Jeff Boehm, the vice president for global marketing of QlikTech company said. – However it is necessary to estimate them on the basis of that actual value which they are capable to provide for business users and IT departments due to providing functions of a business intelligence on mobile devices. To be useful to the solution of real tasks, some beautiful reports there is not enough. When using QlikView the Business Discovery tools remain visual and attractive, however at the same time offer dynamic functionality and an opportunity in any place to obtain the data which are beyond ready reports".

QlikView 11

The methods of collective work implemented in a system allow the staff of the enterprises to investigate jointly data and to make reasoned decisions. With a release of the new version of the QlikTech program expands scope of the products which provide all necessary tools for work with up-to-date data at any time and in any place now — as it is individual, and in a command.

In QlikView 11 development of key advantage of a system — a possibility of associative search is continued. Now it is complemented with means of contrastive analysis which allow to compare the data sets selected by the user visually. Besides, in the new version development process of applications became simpler and accelerated and also abilities to manage by a system and information security supports at implementation of QlikView on large enterprises are improved.

According to the survey results of BI Survey 10 which is carried out by the research center of programs for business of BARC and devoted to the systems of a business intelligence provided recently, clients highly appreciate the improvements entered to QlikView: this year the record number of respondents, and all companies where QlikView is set participated in poll, noted that they use the current version of a system (at that time — QlikView 10).

"Our concept of development of QlikView 11 is based on the fact that decisions are made not alone, and as a result of exchange of views and information in real time — Anthony Deighton, the executive technical director and the senior marketing vice president of QlikTech company tells. — Collective approach of QlikView 11 to work with data allows to investigate jointly information at any time, in any place and using any available device, so, to make the considered decisions quicker. Business users have ampler opportunities for cooperation and remote work using mobile devices, and IT heads will estimate the convenient administration system providing centralized operation and accurate control when preserving flexibility of use of a system on places".

"New changes in the market of BI systems are caused by need of employees for exchange of views, discussion of the deep sense hidden in the data studied by them that allows to make effective decisions as a result — Alice Vudvard, the programs manager in the field of a business intelligence of IDC Collaboration and Social Solutions says. — One of such changes — release of the systems of a business intelligence for mobile devices with the touch display which allow to get easily access to necessary information, to investigate data and to exchange them with other users. Besides, there was a possibility of collective data analysis: in the course of discussion of information users reach deeper understanding of the processes happening in their business and ways of further development".

QlikView 11 lifts advantages of the Business Discovery platform to new level. A system gives ampler opportunities for joint work of employees, supports large-scale implementations at the expense of the improved management tools and offers the advanced user interface for work on mobile devices.

QlikView 11 allows to execute data retrieval and to work with interactive dashboards on any device. Each user can independently ask questions and receive on them answers or investigate data together with the colleagues, finding new solutions and generating the fresh ideas. Now, when there is a need for refining of these or those data, users do not need to appeal to IT specialists about development of new requests and reports any more. When using the Business Discovery platform the role of IT department comes down to creation of such conditions for business users when they can be engaged in the business analysis independently. At the same time IT specialists are responsible for collecting and providing necessary data, security, scalabilities and high high-speed performance.

See complete history in data

Main innovations of QlikView 11

QlikView 11 helps users to take useful data from traditional data sources, from other people and from a surrounding situation. Make decisions "on places", working with QlikView by means of mobile devices. Discuss problems with colleagues, using tools to collective work. Make reasoned decisions on the basis of up-to-date data, using the improved QlikView systems capabilities. QlikView passes into a rank of the actual standard of solutions of the class Business Discovery thanks to the improvements entered in five main directions:

• tools for joint work (Social Business Discovery);
• contrastive analysis;
• the business analysis using mobile devices (Mobile Business Discovery);
• rapid development of analytical applications;
• management of large-scale implementations.

Tools for joint work (Social Business Discovery)

QlikView 11 puts in the forefront communication and collective work. Tools for joint work as a part of QlikView help employees to interact in the course of the research of data. Users can discuss the issues interesting them as a part of formal or informal groups with their help, in real time or asynchronously. Working jointly, users find new methods of data analysis and quicker make the correct decisions.

The new tools for joint work implemented in QlikView 11 supplement already available functionality of the QlikView platform, including shared objects and tabs, mechanisms of integration into Microsoft Office applications and the web parts of QlikView held for use with Microsoft SharePoint.

Joint discussions integrate users

The users who are in other offices or working by means of mobile devices can analyze together data and accept business solutions during the collective discussions. Interaction happens in real time: users together study selections and test different scenarios, trying to get more deeply into a key part of the problem and to find an optimal solution. The document QlikView can be transferred even to those to employees who have no license QlikView — that they could be connected to a session of joint work by it enough to send the URL link disposable. It is important that during such joint discussion participants work with the QlikView application at the same time, but do not transfer access to it each other in turn. It is possible to take part in such collective discussions as by means of normal desktop computers or notebooks, and using tablets or smartphones.

Comments help is more complete to save a context and to trace decision making process

In QlikView 11 users can conduct discussions using new subject of comments. The user can leave the comment on any object of QlikView, his colleagues can add to it own comments. Discussion of a problem can be separated into several "branches". Users can create the tabs illustrating the discussed selections and to include them in discussions that later, reading these comments, it was possible to recover completely Wednesday relevant at that time. QlikView remembers a status of the object (selection of the user) and also the author and time of creation of each comment. Thus in a system the detailed protocol of decision making process remains.

Contrastive analysis

QlikView 11 of function of the associative analysis are lifted to qualitatively new level.

Contrastive analysis promotes deeper understanding

Users of QlikView are not limited to the predetermined algorithm of actions. They can ask any questions and investigate data from the different points of view. In addition to it in QlikView 11 there was an opportunity to compare among themselves data sets.

Now in the QlikView application it is possible to select data on several criteria, to create on the basis of these selections of graphics and table, and then to compare them. On one chart or in one document it is possible to display several selections at once — it simplifies identification of distinctions, trends and abnormal values and allows to understand the existing opportunities and risks better.

Contrastive analysis is applied to comparison of big and difficult data sets: so, it will be interesting to retail stores to compare structure of the made purchases, and financial service — portfolio return of actions. For example, to compare cost efficiency of two or more groups of goods, users just need to select the goods for each group interesting them, and QlikView will automatically compare these data on different parameters (such as region, the operation period, etc.) and will display results in an evident form.

Work with QlikView on mobile devices (Mobile Business Discovery)

QlikView is capable to work on many mobile devices that allows users to take the necessary data from the situation surrounding them and to use all advantages of free movement. The mobile QlikView option implements all opportunities of the Business Discovery platform during the work on portable devices.

The mobile client of QlikView 11 supports the full analytical interface, including the interactive analysis, the developed visualization tools, associative search and also an opportunity to exchange applications, data and all context of decision making with other users. At the same time the IT service ensures the centralized administration and information security.

Support of different mobile platforms increases convenience of application of the QlikView system and accelerates its payback

The organizations can create for the employees more convenient working conditions with QlikView and reduce a system payback period, providing mobile access to applications of QlikView. Using browsers with support of HTML5, users can work equally effectively with QlikView and use all functionality of a system both on desktop computers and notebooks, and using tablets. At the same time developers should not create separate versions applications for each mobile platform. QlikView 11 supports a full-fledged work on tablets on the platform Apple iOS, Android and BlackBerry.

QlikView 11 optimum uses the small area of touch screens

Now it is convenient to QlikView to use on the smartphones having browsers with support of HTML5. The QlikView server displays on the smartphone screen only one application object (for example, the chart, the diagram, the list or the map). An object for viewing is selected by means of the "tiled" interface. Such approach increases convenience of work to the users having mobile devices with small screens, such as iPhone or smartphones based on Android. The operation mode adapted for small screens joins automatically and does not require making changes in applications.

Rapid development of analytical applications

The Business Discovery platform allows to refuse the concept "end users". Each employee gives rise to unique process of information analysis. Operation algorithms are not regulated on a centralized basis any more and are not obligatory and uniform for all. The possibilities of fast creation of analytical applications implemented in the QlikView platform allow each user to make the contribution to decision making process and data analysis, without the address to IT specialists.

The improved possibilities of QlikView meet requirements of software developers and those business users who want to create analytical applications independently. The version of QlikView 11 is improved in terms of functionality and expansibility.

Expansibility QlikView 11 simplifies process of expansion of the platform.

Expansions of documents allow to perform any code

The browser Ajax-client implements simpler and intuitive user interface for work with the data arriving from external systems — now the user can work with such data directly in QlikView, without opening the systems sources. Like the objects of expansions implemented in QlikView 10, each expansion of the document can be used in many documents of QlikView.

Expansions of documents allow to perform any code and to use API interfaces of QlikView for Ajax and JavaScript. For example, the developer can reveal the most popular modes of work with the document QlikView by means of the expansion interacting with the Google Analytics system. Using expansion it is possible to perform the code which is not tied to a specific object, to create any dashboard or group of tabs.

The template for object of the QlikView Workbench expansion accelerates development

The QlikView Workbench component simplifies and accelerates creation of objects of the QlikView expansions in Microsoft Visual Studio®. The new template of the Visual Studio projects contains the files necessary for creation of an operable object of the QlikView expansions and its publication on the QlikView server. Are also included in structure of a template:

• recommendations about work with objects of the QlikView expansions;
• the user interface for creation of any property bar of objects of expansions;
• the mechanism of testing of objects of expansions in the Visual Studio.

Advanced building tools of applications In QlikView 11 the functions facilitating to users and developers QlikView creating applications process are improved and expanded.

Integration into mechanisms of control of versions simplifies development The developers and administrators managing large-scale implementations of QlikView can increase efficiency of application development due to use directly on "desktop" of QlikView of any centralized control system of source codes now (for example, Microsoft Team Foundation Server).

Connection of the document QlikView to such system is executed by means of new point in the File menu. The management system allows to trace and cancel the made changes and also to integrate the changes made by several developers. All elements of the document QlikView, such as scripts, properties and descriptions of objects of the user interface, are stored separately from each other and therefore the changes made to each of them are monitored irrespective of the others.

The improved Ajax dialog boxes facilitate creation of objects of QlikView

It became even simpler to create QlikView objects (charts, diagrams and windows of lists) in the browser client on the basis of Ajax, especially for the users who do not have special technical knowledge. Now users and application developers QlikView can create normal objects or objects of expansions (and also to open them for joint work) using advanced dialog boxes, by drag and drop (drag and drop) and method of evident "assembly". QlikView places the menu items used more often than others on the most top level, and what address less often move down.

Detailed control of measurements helps to build evident charts

Developers can emphasize differences between data, visually selecting the smallest, greatest or first values on the chart. In the previous versions of QlikView for this purpose it was necessary to use macroes and composite functions of aggregation.

Improvements in metadata simplify work of users

During creation or change of applications of QlikView developers can add the comments explaining their contents to elements of charts. For example, when the cursor of a mouse passes over a x axis, the user sees comments about measurements (categories), and over a y axis — concerning the calculated values. It expands the possibilities of comments and tags implemented earlier in QlikView 10.

The improved means of prototyping facilitate QlikView creating applications

The changes directed to decrease in labor input at QlikView creating applications are made to QlikView 11:

• containers allow to use screen space optimum. Using containers developers can compactly provide in a uniform object the same set of the facts under different points of view. QlikView 11 allows to create more effective and user-friendly interfaces thanks to a possibility of placement on one tab of several objects connected with each other. As a result the user sees the data in wider context;
• support of conditions is added to objects. Now objects of QlikView can change depending on actions of the user, his role, the made selection or from values of data. Developers can set the conditions defining use in the chart or in the table of these or those measurements (categories) and settlement expressions;
• the improved navigation on tabs helps to find the necessary element quicker. In the Ajax-client process of switching between sheets (tabs) of the document QlikView is changed. Now the user can or "scroll" tabs to find necessary, or to select the necessary sheet from a drop-down menu. Besides, process of adding of new sheets became simpler.

Platform of the corporate level

Platforms of the class Business Discovery are created to give to business users opportunities of a fast research of data, to provide mobile access and to support tools for joint work. But it is not enough for implementation of large-scale projects. Such platforms should correspond also to a number of requirements imposed to corporate IT systems among which — existence of the mechanisms of security protecting confidential data; fast processing of large volumes of data; support of powerful, but simple administrative tools in application. In QlikView 11 the new opportunities designed to increase efficiency of large-scale system implementations and to provide simpler and reliable managements with them are implemented.

The improved high-speed performance A number of the improvements aimed at system operation fall forward is entered to QlikView 11.

High performance of Publisher promotes receiving up-to-date information

In QlikView 11 the QlikView Publisher component which is used for reset of documents of QlikView and distribution of updated applications of QlikView is improved. In the new version of Publisher the speed of execution of operations of data loading and their conversion to the necessary format significantly increased. In comparison with QlikView 10 high-speed performance of work of QlikView Publisher increased approximately by 40%.

The advanced mechanism of balancing of loading simplifies management and cuts down operating costs

Thanks to a new algorithm of balancing of loading for systems using the QlikView Web server, it became simpler to administrators to manage QlikView server cluster. Now the QlikView Web server can distribute traffic in several ways — randomly, depending on the level of the consumed RAM or from loading of the processor. For example, administrators can configure the QlikView environment so that large applications did not move to the server having the large volume of free disk space, but computing resources of which are overloaded.

More detailed management of a clustering allows to use available computing resources optimum

The clustering in QlikView is controlled in more detail now. As a result there is a possibility of optimal use of available resources, process of operation of the QlikView system is facilitated and reduced the price, especially during the work with large volumes of data. Administrators can independently specify what documents will be processed by these or those nodes in a cluster. For example, larger documents of QlikView can be transferred to the jurisdiction of the most powerful servers, and small tasks to distribute between the servers deployed on the basis of normal equipment thereby providing more effective use of resources.

Simplicity of administration

QlikView 11 contains a number of the improvements facilitating administration process.

The management console of QlikView saves working time of administrators The integrated management console of QlikView 11 is significantly improved in terms of the speed of task performance and ease of use. Changes are made to interfaces of search and selection of tasks, viewing history of their execution on the page displaying current statuses of tasks in templates of tasks and "master" for their creation and also in notifications on events (for example, about a stop of services).

The updated AccessPoint helps IT specialists to perform support of business users AccessPoint is the QlikView portal through which users get access to applications according to the powers which are available for them. In QlikView 11 the AccessPoint interface became visually more attractive, and access to the applications placed on the QlikView server became more convenient. Among improvements documents can note modern design of the interface, its improved high-speed performance, a possibility of assignment of characteristics/attributes for simplicity of their search and classification, formation of the list of the chosen applications, the simplified sorting of applications in the mode of detailed display and also supply of documents with the descriptions available through a search mechanism.

The API control interface of QlikView improves administration automation

The advanced API interface for a call of control functions of QlikView allows to automate the QlikView environment, programming different processes of administration of QlikView Server and QlikView Publisher.

In QlikView 11 there were more than 50 new addressing the API interface which can be used for automation of different problems of object management for joint work, import of tasks and setup of the connector for directory services. Besides, in new API remote administration, access to the transaction journal, management of licenses for QlikView Server and QlikView Publisher and also access control to sections are supported.

Security management In QlikView 11 means for security management are improved and expanded.

Control at the level of documents increases the accuracy of audit and reduces risks So far as concerns confidential corporate data, tasks of risk management and ensuring compliance to security requirements are essential. Using new settings in the management console of QlikView Management Console administrators can control work of users more effectively. An opportunity to trace what documents this or that user addresses or addressed earlier, simplifies and increases quality of audit of use of QlikView. Administrators can execute such audit not only at the level of a system, but also at the level of separate documents.

Detailed control over loadings and export improves controllability Administrators of QlikView can raise degree of controllability of a system due to purpose of privileges to loading of documents and/or export of data. Now it is possible to appoint such privileges both for documents, and for users.

The possibility of the centralized creation of QVD files using Publisher facilitates data management

In the new version of QlikView it became simpler to architects and administrators to exercise centralized operation of data. Now they can create QVD files (data files of QlikView) on the server with QlikView Publisher irrespective of creation of the QVW files (files of QlikView), including using scripts. Besides, QVD attribute files of access of the NTFS file system can use this mechanism to appointment.

Data analysis in the pharmaceutical companies

In the QlikView system the combination of three crucial elements – an associative data model thanks to which work of the analyst is built under laws of a human thought, the in-memory technology allowing to increase system operation speed in comparison with the traditional Business Intelligence systems, and the intuitive user interface is implemented. At the same time a system consolidates information from all diverse data sources (from the transaction systems (Oracle, SAP, salesforce.com), the traditional BI systems (Business Objects, Cognos, Hyperion), data warehouses, the applied systems using different databases (SQL Server, Oracle, MySQL), but also, from local files of Excel and simple text files) in a uniform information field".

More than one hundred pharmaceutical companies selected from the world for the analysis of corporate data the QlikView system. So, for example, the QlikView system is already used by such companies as GlaxoSmithKline, Merck Sharp & Dohme, Actavis, B/Braun, Alk Abello, FFF Enterprises, Lundbek, Radiometer, Solvay, Novartis, Sanofi-aventis and others.

According to IDC, in the pharmaceutical companies which implemented QlikView, information analysis accelerated for 40%, labor productivity of employees increased by 38% at reduction of operating expenses on 24%, income increased by 20%, at growth of customer satisfaction by 43%.

Integration of the QlikView Business Discovery platform and Salesforce Chatter system

On September 8, 2011 the QlikTech company announced expansion of social opportunities of the QlikTech Business Discovery platform: now, thanks to Chatter Connect support, finding solutions can be performed within collective work — the Salesforce Chatter service facilitates interaction with colleagues within department or a project team and supports information exchange directly in applications of QlikView. The openness of the QlikView Business Discovery platform allows to integrate freely it with other software products and thus to expand functionality of a system.

"Thanks to integration of QlikView and Chatter employees have an opportunity to conduct joint finding solutions, being based on the real data — Anthony Deighton, the senior vice president for the products QlikView explains. — The tools implemented by the platform for internal communication allow to increase audience of users of means of ‘the social business analysis’. Those who work with QlikView will be able to apply functions of social interaction Chatter, and users of Chatter — to use the data provided to QlikView. It is possible to tell that the best is selected from two worlds and it is provided in single solution".

Staff of the companies, where QlikView and Salesforce Chatter are applied, is offered to analyze jointly data and to exchange views by means of the news feeds, comments and other Chatter tools embedded directly in applications and the QlikView dashboards. At the same time observance of requirements of confidentiality and information security is guaranteed. Users can discuss the acquired information, share knowledge and the ideas — such method of collective work provides the greatest effect by search of the correct solution. Chatter helps to save data together with a context, fixing the factors which influenced adoption of these or those solutions. Besides, Chatter notifies users of QlikView on important updates, helping them to be connected quickly to discussions and to answer timely questions.

"It is pleasant to see that the leading software providers 'chatterizut' the applications and supplement the concept of the social enterprise with the innovation ideas — Kendell Collins, the senior vice president and the general product Chatter manager of salesforce.com says. — Thanks to integration of QlikView and Chatter users of our system can communicate, without leaving applications of QlikView. It improves process of joint search of the ideas and allows to make optimal solutions at a 'social' speed".

The project of integration Chatter and QlikView was implemented with the assistance of Centerstance company, the supplier of the advanced innovation services and solutions intended for all levels of model of cloud computing: the infrastructure provided in the form of service (IaaS); the platform provided in the form of service (PaaS); the software provided in the form of service (SaaS). The video showing use of Chatter in the QlikView application is available on the website QlikView: www.qlikview.com/chatter.

Program of certification on QlikView 11

The program of certification on QlikView 11 for customers will expand the program of certification for partners announced earlier. The program of certification which customers and participants of the affiliate program of Qonnect will be able to use since fall of 2012 allows to confirm knowledge and skills of users of QlikView and also to quantitatively estimate the level of understanding and skills of work with the QlikView Business Discovery platform.

"Partners and customers of QlikTech locate all necessary to use those tremendous possibilities of development which are opened for them by use of the Business Discovery systems, – Kim Peretti, the vice president of the direction of the international services in training of QlikTech company noted. – The certified employees show the high level of technical knowledge, skill and productivity that increases the value of their professional qualification. The organizations incorporating the certified specialists have ampler opportunities to improve project implementation, to increase efficiency of divisions of IT in general and to increase an investment payback in QlikView".

The program of certification on QlikView 11 offers three directions – certification of designers QlikView, certification of QlikView developers and certification of administrators of the QlikView systems, requiring passing of the recommended cycle of classroom occupations and existence of practical experience of work on real projects. Each of examinations allows specialists of QlikTech to estimate knowledge and skills of work with a product which are available for customers and also gives to customers the chance to compare the skills to the set competence level.

With the purpose to increase availability and to expand a scope of the program of certification on QlikView 11 the QlikTech company signed the agreement with Pearson VUE company, the world leader in the field of services of computer testing at acceptance in educational institutions, obtaining licenses and certificates. Now certification examinations for designers and QlikView developers are carried out in eight languages – the English, Brazilian option of Portuguese, Spanish, Chinese (for the simplified letter), German, Russian, French and Japanese.

2011: Associative architecture of QlikView

The majority of types of OLAP systems is based on requests and cubes. The similar architecture of BI systems separates data from an initial context, and the lack of communications between requests in addition increases this gap. With respect thereto, users obtain incomplete information and cannot reach the necessary level of justification of business solutions.

The associative architecture of QlikView, on the contrary, allows to manage interrelations between data not at the application layer, and at the level of internal mechanisms of the platform. QlikView stores in RAM separate data tables and associative communications between them where each value of each field is connected with all other values in associative model. At the same time during creation of new selections, the user sees, both the data connected with his request and data which do not enter selection. It allows the user to work most comfortably, answering new questions independently, without the aid of IT department.

2010: QlikView 10

At the beginning of October, 2010 the QlikTech Company released the new version of the QlikView 10 BI system. In release the new types of visualization simplifying studying of data and understanding of the happening processes are provided. For example, histograms of Mekko allow to represent interrelations and to set ratios between dimensional values. Function of associative search in QlikView 10 relies on the data processing mechanism completely in RAM. As in service of instant search Google results are issued in process of input of a request, and the user interface selects important interrelations between data. Thanks to an asynchronous mode of contact of the AJAX client with the QlikView 10 server objects of data visualization are updated in real time. Improvements of the mechanism of calculations and the system of multithreaded reset of objects rely on opportunities of multi-core processors. During beta testing data loading speed during the work on multinuclear computers increased by 200-1000%. Available mechanisms of integration provide ample opportunities of use of methods of visualization and other additional functions. Centralized operation by a system supports balancing of loading, administration and planning of updates.

Main innovations of QlikView 10

• Fall forward of data loading for 200 – 1000%. Incremental data loading is replaced with the parallelized loading on several flows. Within beta testing of QlikView 10, fall forward of data loading for 200 – 1000% on multi-core processors was reached.
• Associative search, new on convenience level
• Optimization of use of the existing hardware infrastructure for 80%
• Improvement of functionality of the AJAX client
• New opportunities for visualization (new objects, for example, the charts Mekko and also an opportunity to create and use the customized data visualization modules)
• Centralized operation by accounts of users
• Possibility of simple consolidation of data from any sources.

Implementation and use of BI of the QlikView system will provide high-quality and timely information support to the management in creation of thought more over and viable corporate strategies. All employees will get access to necessary complex information for fruitful work and ensuring permanent growth of profitability of the organization. Providing an information access to customers, suppliers and partners will increase the general loyalty and will provide the company with space for advance. QlikView which cornerstone the associative data model is and data processing is performed in RAM, differs as her developers say, in speed of work and ease of use and also lack of need for continued support of users from IT department.

2009

In January, 2009 the Aberdeen Group company called QlikView by the unconditional champion among developers of BI systems. According to the recent report of IDC, company users of the QlikView system receive:

• return of investments (ROI) - 186%;
• increase in income for 16%;
• reduction of time spent for information analysis for 48%;
• increase in productivity for 34%.

Comparison of QlikView and Tableau

Read Also

• QlikView: Simplifying analytics for everyone
• QlikView: the innovation BI for business users
• Alexander Triguba: A BI system can be simple
• Analytics for TD "Kopek": The ATK consulting group completed implementation of the QlikView BI system in retail network
• AF Consult: QlikView is a business intelligence for consultants

Notes