Advanced Analytics using QlikView and R

A walkthrough of how to integrate QlikView with R to enable advanced statistical analysis directly in QlikView.

Transcript

1. Even Vinge Capgemini Business Information Management 07.06.2012 Advanced Analytics using QlikView and R
2. Agenda Why integrate QlikView and R? Recommended architecture Demo of solution
3. What is Analytics? Customer Analytics • Churn Analysis, Upsell, Cross Sell • Wallet Size Analysis Market Analytics • Market Segmentation • Social Network Analysis Fraud Management • Credit Card Fraud Detection • Tax and Welfare Fraud Detection Risk Analytics • Scoring • Capital at Risk Enterprise Performance Analytics • Trends and Forecasting • Profitability Analysis Planning & Scheduling • Workforce Optimization • Supply Chain Planning
4. Traditional deployment DM S S S Reports Staging DWH DM DM Analytical models
5. Real time usage S S S Staging DWH Analytical models
6. Instant Analytics Forecasting with what-if Dynamical clustering
7. Why R? Open source programming language Created for statistics Library of more than 2500 add ons • Linear and nonlinear modeling, prediction, testing, clustering, graphs > a <- 5 > a*3 [1] 15
8. Architecture
9. Service Based Architecture HTTP Input Output Analytical model QlikView Server Input Output R Server HTTP Input + Model Output Analytical service Input + Model Output QlikView Server R Server Alt. 1 Alt. 2
10. Example: Forecasting of monthly sales revenue
11. The case
12. Analytical model as-a-service Random Noise Seasonal Pattern Trend Sales
13. QlikView Macro is the Client
14. Modeling and forecasting Modellering Holt Winters Forecasting
15. The result is inserted into the QlikView data model
16. Demo
17. Rapid Analytical App Platform Prototype Review Deploy Feedback Improve
18. Further Possibilities Permanent storage Manual forecasts, comments Queries against web services Updated currency rates, stocks, weather Google Predict Sentiment analysis, machine learning
19. www.capgemini.com Even Vinge Senior Consultant even.vinge@capgemini.com