2011 01 06 11-15 kristian raue

Kommerzielles Open-Source BI: Mehr Leistung für weniger Geld

Kristian Raue, CEO Jedox AG

Business Intelligence

Open-Source und Premium

Planning, Analysis and Reporting

Financial Data Consolidation

Sales Forecasting

KPI Office of Finance

Balanced Scorecards

Cockpits

Excel or Web-Based

DashboardsGPU Acceleration

Software as a Service

Cloud

Online-Spreadsheet Performance Management

Mobile BI

&Familiar cell-based Spreadsheet-UI

Easy to adjust and maintainNone or little IT envolvement

All-in One: Plan, Analyse & Report

Quick to install and implementIn-memory GPU technologyVRAM support (50-100x faster)Write-back functionality

EASY We make the most used

BI-tool the most useful

FASTWe deliver the fastestIn-memory BI technology

Jedox Palo: Fast & Easy

78 Jedoxians (23 new in 2011)

Jedox Locations

THE SQUAIRE: Frankfurt FlughafenParis, Boulevard Haussmann

Hamburg, Steinstraße 12

Hauptsitz Freiburg/Brsg


Data About: Channel - 69 active Partners worldwide


Data About: International Cooperations

Technology

32 Universities from

Australia

Austria

Germany

Poland

Switzerland

Content

R&D, Education


Jedox Produkt Komponenten

Palo OLAP

Palo for Excel

Palo Web

Palo Mobile

Palo ETL


Mobile Device & Plattform Support

• Available for iOS (iPhone and iPad App)• Available for Android (App and Widget)

Jedox Palo Platform

Jedox Best Practices

Jedox

Best

Practices

Demo(sample

implementaion)

Modelling-concept

(Industry-specific)

Consultant(industry specialist)


Roadmap Jedox Palo

2011 2012 20132010

Q2Q4 Q1 Q2 Q3 Q4 Q1 Q3 Q4 Q3Q1 Q2 Q4

Palo Open Source Update

Palo Suite 3.3 – Release date Q4 2011

Palo Suite 3.3 - Service Release 1



Palo Open Source Update

Palo Suite 4 – Release date Q4 2011


Leistung dank GPU Technologie


„Turbo-Charger“


Theoretical computing power (GFLOP/s)

2007 2008 2009 2010 2011 20120

100

200

300

400

500

600

700Peak Double Precision FP

GFLOP/s

Nehalem3 GHz

Westmere3 GHz

Fermi

M2070

Fermi+

M2090

M1060

8-coreSandy Bridge

3 GHz

Double Precision: NVIDIA GPU

Double Precision: x86 CPU


Graphics Processing Unit

• … is a co-processor• hundreds of extra processing units for special calculations

(traditionally graphics)• often more powerful than CPU

• … also provides „co-memory“• up to 6 GB RAM on one card• high memory throughput


Memory bandwidth

2007 2008 2009 2010 2011 20120

50

100

150

200Peak Memory Bandwidth

GBytes/s

M1060

Nehalem 3 GHz

Westmere3 GHz

8-core Sandy Bridge3 GHz

FermiM2070

Fermi+

M2090

NVIDIA GPU (ECC off)

x86 CPU


VRAM

Thread Manager1 2 3

Core 1 Core 2

Level 2 Cache

Core 3 Core 4

RAM

Core 1 Core 2

Level 2 Cache

Core 3 Core 4

RAM

Disk

8 x 64 Bit 200 GB /s64 Bit 26 GB /s64 Bit (26 GB /s)

100 MB /s

Disk-based In-Memory “In-GPU-Memory”

In-Memory Turbobooster: Data management and memory types


In-Memory Turbobooster: Performance benchmark

1 Mio 2 Mio 4 Mio 8 Mio 16 Mio 32 Mio 64 Mio

IBM Cognos TM1 3.82 5.55 8.83 18.17 32.27 50.8 90.34

Infor PM 10 0.51 1.03 2.13 4.33 8.91 18.51 38.54

Palo 0.43 0.72 1.1 2.14 4.07 8.6 18.13

Palo GPU 0.1 0.12 0.13 0.14 0.17 0.22 0.36

5.00

15.00

25.00

35.00

45.00

55.00

65.00

75.00

85.00

95.00

Calculation time / datasets

Tota

l tim

e in

ms

Attention: lower values

are the better

Test results courtesy of C. Kolodziej

In-Memory GPU

Disk-based In-Memory In-Memory GPU

Perf

orm

ance

Scenario 3

Ergebnis

Mengen

Preise

CostsUmsatz

Wechselkurse

Je Region, Produkt, Gesellschaft,…

… Scenario 2

Result

Mengen

Preise

CostsUmsatz

Wechselkurse


… Plan

Complex Planning Models and Scenarios

Result

Units

Prices

CostsRevenue

Exchangerates


…

What-if Analysis & Scenario Planning

… but what if Requirements are changing faster than your Solution is implemented?

2,2

Average Project Duration (in Months)

Source: BARC The BI Survey 9, September 2010

BI-Survey 2011

Analyst Comment about Jedox:

“The strong results were

spread over a wide range of

measures, including cost,

innovation, quality and agility.”


BI-Survey 10 - Median license fees (in thousand $)

Jedox


QLIK TECHNOLOGIES INC - FORM S-1


Kosten und Umsatzstruktur im Vergleich (in %)

Qlikte

ch U

msa

tz

Qlikte

ch K

oste

n

Jedo

x Um

satz

Jedo

x Ko

sten

0%10%20%30%40%50%60%70%80%90%

100%

AdminServicesR&DSales & MarketingSonst. UmsatzLizenzumsatz


Effizienz des Open-Source Modells im Vertrieb

PRMarketin

gTelesales Presales Sales

PRMarketin

gTelesales Presales SalesOS Community


2006 2007 2008 2009 2010 2011 2012

41%

55%15%

35%

>50%

Jedox Growth in Revenue


Customers: Many New Premium Customers

Q4/2010 Q1/2011 Q2/2011 Q3/2011

37

24

55

63


InstallationCompany• German Media Group issuing one of the three important german speaking Newspapers

as well as 12 other daily newspapers and over 130 Magazines• > 1 bn. € turnover

Project• Enterprise wide Reporting, Analysis and Plan Data Collection

(Finance Controlling, HR Controlling, new: Marketing Controlling)• 300 Users in 100 Entities• Source Systems : 5 ERP Systems: SAP CO/FI, SD, Interface to Lucanet

Jedox Solution• ETL: Palo ETL incl. SAP Connectivity• Data Management : Palo OLAP• Front End: Palo for Excel; Reporting: Palo WEB

Status• Project Start 2008, live since 2009, Marketingcontrolling currently in realisation


Installation

Company• Biotech/Pharmacytical daughter of sanofi-aventis Group• > 10.000 Employees; 3,4 bn. € turnover

Project• EMEA wide solution for Forecasting, Budgeting, and Planning covering 60 countries

(driver based Revenue-, FTE-, HR-, Marketing- & Sales, Cost- KPI-Planning; Multicurrency, Allocation Process)

• Ca. 150 User in 60 Entities• Source Systems: MFG/PRO, Oracle, Hyperion HFM

Jedox Solution• ETL: Palo ETL• Data Management : Palo OLAP• Front End: Palo for Excel & Palo WEB

Status• Northern Europa (ca. 12 countries) live, currently Rollout for Rest of EMEA

New Customer CaseInternal Use Only


InstallationCompany• Ground Service Provider for Airports• > 35.000 Employees; 1,3 bn. € turnover

Project• Planning & Budgeting for Cargo Devision & (Phase 1)• Budgeting- and Reporting Solution for Swiss Companies (Phase 2)

(Cost- & Profit-Center Planning, incl. Simulation, Intercompany-Planning, Workflow, etc.)• > 160 User• Source Systems: SAP CO/FI, HR, Interface: MPC

Jedox Solution• ETL: Palo ETL• Data Management : Palo OLAP• Front End: Palo for Excel & Palo WEB

Status• Phase 1 live; Phase 2: started April 2011, Go-live : September 2011


Installation

Company• Biggest Mutual Operator of Hospitals in Germany (Berlin)• > 13.500 Employees; 837 Mio. € turnover

Project (Phase 1)• Driver based Enterprise Planning:

(Cases, Rates, Revenue, Costs, HR,…)• > 120 Planner• Source Systems: SAP (ca. 9.000 KST, 16.000 KOA,…)

Jedox Solution• ETL: Palo ETL incl. SAP Connectivity• Data Management : Palo OLAP• Front End: Palo WEB• Analysis & Szenario Planning (Poweruser): Palo for Excel

Status• Project Start: June 2011, planned Go-live: September 2011

New Customer CaseInternal Use Only


Installation

Company• Retailer in Electronic Parts with over 100 locations• > 2.200 Employees; 958 Mio. € turnover

Project• Ad-hoc Analysis & Standard Reporting for Stock & Sales Controlling

with Stock List >1 Mio. Elements• Centralised web-based Planning Solution • Integration of 6 different ERP Systems

Jedox Solution• ETL: Palo ETL • Data Management: Palo OLAP & Palo Accelerator (GPU) • Front End: Palo WEB & Palo for Excel

Status• Planning Solution live with Palo OLAP Accelerator

Vielen Dank!

www.jedox.com

Kristian Raue, CEO Jedox AG

2011 01 06 11-15 kristian raue

Technology

Transcript of 2011 01 06 11-15 kristian raue