ATK QlikView R Connector

ATC of QlikView R the Connector developed by ATK consulting group allows to expand possibilities of QlikView with professional predictive analytics of R project. Seamless integration of QlikView and R project allows to carry out difficult calculations for planning and forecasting and also to reveal the hidden patterns in the analyzed data directly in QlikView.

In QlikView there are functions of statistical analysis. But in a number of their cases it is not enough for the solution of business challenges on forecasting as:

• Forecasting of time series is a separate class of algorithms which is selected by the expert depending on the analyzed data domain
• In the market for these purposes exists specialized statistical packets on statistical analysis and forecasting of time series. For example, Statistica, ForecastPro, SPSS and also widely uses OpenSource the R-Project project.

Development of ATK consulting group, ATC of QlikView R the Connector, is used for seamless integration of QlikView and R project allowing to carry out difficult calculations for planning and forecasting and also to reveal the hidden patterns in the analyzed data directly in QlikView.

Libraries of the applied R Project expansions include forecasting packets for a broad spectrum of models:

• econometric,
• regression,
• Boksa-Dzhekinsa methods,
• neural networks with the general regression,

GRNN and others.

Results of calculation of R-Project which are transmitted to QlikView are a set of a large number of statistics:

• smoothed historical data
• forecast
• confidential points
• root mean square error

The linking of QlikView and R-Project through ATC of QlikView R of the Connector allows to build quickly and quickly forecasts for a hierarchical structure of goods, using methodologies of Bottom-up forecasting and top-down forecasting.

For ergonomics of work, the analytics on forecasting of time series is possible in two modes:

• batch mode of creation of the forecast in the course of the general reset of data which is executed according to the schedule on QlikView Server
• interactive mode of creation of the forecast. This mode allows the analyst most to select available forecasting methods, to set necessary parameters and to carry out the quantitative and quality assessment of results online

In what advantages of ATC of QlikView R of the Connector?

Advantages of ATC of QlikView R of the Connector to the user:

• The strengthened analytics. R Project strengthens analytics of QlikView professional functions of forecasting. With ATC of QlikView R the Connector you will be able to use any type of statistical analysis – factor, descriptive, regressive, etc.
• Single interface. Analytics of QlikView and forecasts of R Project are displayed in the single QlikView ergonomic interface
• Built in or on-demand forecasts. With ATC of QlikView R the Connector users can select such approach to forecasting which is suitable for them – forecast calculation will be embedded in the QlikView application and calculated automatically; or the user himself will make the necessary selection and will receive the forecast from a R-system directly in QlikView, having only pressed one button "receive the forecast"
• Reactive forecasts. The computing power of a matrix algebra and multilevel calculations are expedited very much, due to in-memory technology

Advantages of ATC of QlikView R of the Connector to technical specialists:

• Seamless integration of the QlikView systems and R-system
• Existence of the built-in means for simple and effective dynamic updating of documents of QlikView
• Existence of debugging tools and recording. Means of recording become especially important in a R-connector usage mode in the modes of automatic loading of documents on the party of the QlikView-server
• An opportunity to develop macroes in QlikView both by means of VBS scripts, and in R-language (A Computer Language for Statistical Data Analysis)
• Allows to involve power of applied libraries from different areas (time series analysis and forecasting, regression and cluster analysis, econometrics, etc.)
• High high-speed performance and performance.