Jaspersoft Business Intelligence Suite Reporting, Analysis, and Data ...
Building Smarter BI Through Data Quality Access number: dial +44 (0) 121 368 0265 enter access code 460-980-089 followed by #
Guillaume Autier Jaspersoft Senior Sales Engineer Cédric Fauvet Talend Consultant Manager
© Talend 2010
1
Webinar Logistics A few logistical points… All participants are muted You may ask questions using the Q&A panel, located on the right hand side of your screen, at the bottom of the GoToWebinar applet •
Answers will be provided after the demonstration • If time is too short to address all questions, you will receive an answer via email
2
If you are having connection problems, please use also the Q&A panel
Agenda Jaspersoft Introduction Company & Products Overview Data Quality, a Critical Piece to BI
Talend Introduction Why practical data management is crucial to accurate business intelligence Company Overview How you can track and control the ever-moving target of good data quality What low-cost resources to profile, track, and cleanse data How to map your data management strategy, now, and in the foreseeable future
Demonstration Q&A 3
Agenda Jaspersoft Introduction Company & Products Overview Data Quality, a Critical Piece to BI
4
Jaspersoft Overview An Open Source BI Provider that is … Cost Effective
80% of traditional BI providers*
Powerful
Reporting, Dashboards, Analysis, Data Integration
Pervasive
Worlds Largest & Fastest Growing Open Source BI company
Modern
Modular, 100% Java, Lightweight
* Leading Analyst Research Firm: 7 April 2010 BI Platform Licensing Models and Negotiating Strategies – R.Sallam
5 ©2010 JasperSoft Corporation.
Industry Recognition Jaspersoft identified as „highest growth vendor in BI software from 2008-2009‟ - Market Share: Business Intellgience, Analytics and Performance Manage Software Woldwide, 2009
Jaspersoft scored stronger in value, technology, and support than Business Objects/SAP, Cognos/IBM, and Oracle - Wisdom of Crowds, May 2010 Jaspersoft ranked best in overall TCO against Microsoft, SAP, and QlikView - Assessing Total Cost of Ownership for BI, Lyndsay Wise, Jan 2010
©2010 JasperSoft Corporation.
Jaspersoft Corporate Summary Headquartered in San Francisco, approx. ~100 employees worldwide
Recognized by industry analysts and journalists
Funded by venture capital / private equity firms and strategic partners: Morgenthaler Ventures, DCM, Partech International, Scale Venture Partners, SAP Ventures, Adams Street Partners & Red Hat
~60% 2009- 2010: Year-over-Year sales growth
More than 40 global partners including:
©2010 Jaspersoft Corporation. Proprietary and Confidential
7
Open Source Momentum “What % of software purchases will be OSS?”
50% or more on OSS
2008-2013
2009-2014
2010-2015
North Bridge Venture Partners: 2010 Future of Open Source surveyed 500 IT professionals http://futureofopensource.drupalgardens.com/ ©2010 Jaspersoft Corporation. Proprietary and Confidential
Jaspersoft Business Intelligence Suite Reporting, Analysis, and Data Integration iReport
Report and Dashboard Designer
Ad Hoc Reports, Integrated Analysis, and Dashboards
Interactive OLAP Data Analysis
Developers
World’s Most Widely Deployed Reporting Library Developers
High Performance Data Integration
Business Users
Business Users
Developers & DBAs
© 2010 Jaspersoft Corporation. Proprietary and Confidential
Sample Jaspersoft Customers Public Sector
Software & Technology
Manufacturing
Financial Services Telecommunications
Travel & Transportation
10 ©2010 Jaspersoft Corporation. Proprietary and Confidential
Jaspersoft Product Advantages Reporting Print-ready production reports Web 2.0 drag & drop ad hoc query and reporting Access to any data source: relational, XML, Hibernate, EJB, POJO, custom Connect directly or via rich business metadata layer
Dashboards Web 2.0 drag & drop dashboard designer Live component-level refresh Mash-ups with external content ©2010 Jaspersoft Corporation. 11 Proprietary and Confidential
Jaspersoft Product Advantages Analysis
Integrated In-memory analysis Standards-based and scalable ROLAP Excel connector
Data Integration
Wide range of connectors & transforms Intuitive graphical user interface High performance generated code
Business Intelligence Suite
Modular, shared services On-premise, Virtualized, SaaS multi-tenancy, Cloud Scalable, small-footprint, 100% pure Java Designed for integration / embedding Open Web standards Internationalized and localized Extensible and modifiable source code ©2010 Jaspersoft Corporation. Proprietary and Confidential
Web 2.0 Ad Hoc Query & Reporting Domains
© 2009Jaspersoft Corporation. Proprietary and Confidential
13
Web 2.0 Dashboarding Self-Service Dashboard Builder for Business Users
Set business users free to assemble and publish Dashboards
Multiple key performance indicators “Mash-ups” with any URLaddressable content
Drag & drop reports onto Dashboard
Dynamic resize & layout
“Twinkling” live dashboard elements
Dynamic near real-time individual frame refresh
Global or local controls
Input parameters Other report controls
©2009 Jaspersoft Corporation. Proprietary and Confidential
8/15/2010
14
Jaspersoft BI Suite Architecture
15 ©2010 Jaspersoft Corporation.
What Makes Business Users Crazy? What is our top selling beverage?
Number 1
Number 3
“Coke”
“Coca Cola”
Examples of Data Quality Challenges
• Business Intelligence use cases: – – – – –
Foreclose mortgages Issue credit or credit line Preferred customer status with preferred pricing Value of company prior to acquisition Many other purposes
Your Data Quality Pain: – Abnormal ends with exceptions – Confusion about meaning of data – Non-sharable data – Hours to reconcile inconsistent reports
Agenda
Talend Introduction Why practical data management is crucial to accurate business intelligence Company Overview
18
Blocks to Accurate BI
Roadblocks
Business Impact
Lack of standards Platforms
Language Efficiency Competing information quality processes Revenue
Code pages Governance, Risk and Compliance Data Age & Reliability
“Dummy” Values Unstructured “Freeform” Values
© Talend 2010
19
Who Needs Data Quality?
“Anytime data crosses an organizational boundary, it should be governed, whether you‟re sharing data among business units internally or publishing data to customers, partners, auditors, and regulatory bodies externally.” - TDWI, “Data Governance Strategies” report 2006
© Talend 2010
20
Corporate Overview Leading provider of open source data management software Venture-backed
Worldwide operations and users San Francisco (Los Altos) Corporate
London (Maidenhead) Business Tech Support
Orange County (Irvine) Business R&D Tech Support
Nuremberg Business Tech Support Tokyo Business Tech Support
New York (Tarrytown) Business Tech Support Paris (Suresnes) Corporate Business R&D Tech Support © Talend 2010
Utrecht Business
Milan (Curno) Business Tech Support
Beijing R&D Tech Support
21
Business Highlights A high adoption rate 10 million downloads 450,000 users 1,500 customers
1 download of Talend Open Studio per minute © Talend 2010
100 new customers per month 22
Market Positioning
MDM
Data Quality
Reference data management
Data profiling & data cleansing
Data Integration Analytics (ETL) Extract, Transform & Load for decision support systems © Talend 2010
Operational Integration Data replication & synchronization, data migration & capture, application upgrade, etc.
23
Selected Talend Customers Finance & Insurance
Services
Manufacturing & Retail
Public Sector & Education
© Talend 2010
24
Agenda
How you can track and control the ever-moving target of good data quality
25
Track and Control • Scope - Conduct Preliminary Analysis • Plan - Design Processes and Procedures • Stage - Adjust processes and procedures • Implement - Compare initial and follow-up analysis • Maintain - Regular monitoring of DQ metrics
Scope
© Talend 2010
Plan
Stage
Implement (go live)
Maintain
26
Agenda
What low-cost resources to profile, track, and cleanse data
27
Talend’s Data Quality Offerings
Talend Open Profiler Identify data quality problems - Free, GPL, no limitations - Custom indicators
Talend Data Quality Cleanse & track - Specific components - Reports - Data Quality Portal
© Talend 2010
28
Talend Data Quality Major Features
Analysis & Statistics
Data Standardization
Matching & De-duplication
Finds Outliers Nulls, Blanks, Unique, Duplicates Regular Expressions Informative Charts and Graphs
Define shapes and sets of data
Find duplicates
Leverage public domain and commercial data Built-in data integration
Talend Open Profiler
© Talend 2010
Leverage latest algorithms and matching methods Deterministic with SoundEx, Metaphones, Jaro-Winkler, Levenshtein
Talend Data Quality
29
Enrichment Sources
© Talend 2010
30
Agenda
How to map your data management strategy, now, and in the foreseeable future
31
Functions
Data Integration
Data Quality
Master Data Management
Few vendors have continuity across these functional areas to deliver end-to-end data management.
© Talend 2010
32
When to Choose Jaspersoft or Talend Business Intelligence
Reporting
X
Dashboarding
X
When to choose Jaspersoft:
Data Analysis (In-Memory or OLAP)
X
Single vendor for end-to-end BI Optimized ETL for Jaspersoft
Basic Analytic ETL
X
When to choose Talend:
(DM, DW, ODS)
Data Integration
© Talend 2010
Analytic ETL (DM, DW, ODS)
X
X
Operational ETL
X
Data Quality
X
Higher Scalability Options
X
Data Integration is the main focus Data Quality Higher Scalability options
33
Show Time!
© Talend 2010
34
Thank you for your attention! Please ask you questions now Using the Q&A panel Jaspersoft Contact E-mail: Phone: Web:
EMEA: [email protected] +353 4434700 www.jaspersoft.com
Talend Contact [email protected] • TEST DRIVE: http://www.talend.com/download.php
• TUTORIALS: http://www.talendforge.org/tutorials/menu.php • Cédric Fauvet: [email protected]
© Talend 2010
35
Thank You!
© Talend 2010
36
Guillaume Autier Jaspersoft Senior Sales Engineer Cédric Fauvet Talend Consultant Manager
© Talend 2010
1
Webinar Logistics A few logistical points… All participants are muted You may ask questions using the Q&A panel, located on the right hand side of your screen, at the bottom of the GoToWebinar applet •
Answers will be provided after the demonstration • If time is too short to address all questions, you will receive an answer via email
2
If you are having connection problems, please use also the Q&A panel
Agenda Jaspersoft Introduction Company & Products Overview Data Quality, a Critical Piece to BI
Talend Introduction Why practical data management is crucial to accurate business intelligence Company Overview How you can track and control the ever-moving target of good data quality What low-cost resources to profile, track, and cleanse data How to map your data management strategy, now, and in the foreseeable future
Demonstration Q&A 3
Agenda Jaspersoft Introduction Company & Products Overview Data Quality, a Critical Piece to BI
4
Jaspersoft Overview An Open Source BI Provider that is … Cost Effective
80% of traditional BI providers*
Powerful
Reporting, Dashboards, Analysis, Data Integration
Pervasive
Worlds Largest & Fastest Growing Open Source BI company
Modern
Modular, 100% Java, Lightweight
* Leading Analyst Research Firm: 7 April 2010 BI Platform Licensing Models and Negotiating Strategies – R.Sallam
5 ©2010 JasperSoft Corporation.
Industry Recognition Jaspersoft identified as „highest growth vendor in BI software from 2008-2009‟ - Market Share: Business Intellgience, Analytics and Performance Manage Software Woldwide, 2009
Jaspersoft scored stronger in value, technology, and support than Business Objects/SAP, Cognos/IBM, and Oracle - Wisdom of Crowds, May 2010 Jaspersoft ranked best in overall TCO against Microsoft, SAP, and QlikView - Assessing Total Cost of Ownership for BI, Lyndsay Wise, Jan 2010
©2010 JasperSoft Corporation.
Jaspersoft Corporate Summary Headquartered in San Francisco, approx. ~100 employees worldwide
Recognized by industry analysts and journalists
Funded by venture capital / private equity firms and strategic partners: Morgenthaler Ventures, DCM, Partech International, Scale Venture Partners, SAP Ventures, Adams Street Partners & Red Hat
~60% 2009- 2010: Year-over-Year sales growth
More than 40 global partners including:
©2010 Jaspersoft Corporation. Proprietary and Confidential
7
Open Source Momentum “What % of software purchases will be OSS?”
50% or more on OSS
2008-2013
2009-2014
2010-2015
North Bridge Venture Partners: 2010 Future of Open Source surveyed 500 IT professionals http://futureofopensource.drupalgardens.com/ ©2010 Jaspersoft Corporation. Proprietary and Confidential
Jaspersoft Business Intelligence Suite Reporting, Analysis, and Data Integration iReport
Report and Dashboard Designer
Ad Hoc Reports, Integrated Analysis, and Dashboards
Interactive OLAP Data Analysis
Developers
World’s Most Widely Deployed Reporting Library Developers
High Performance Data Integration
Business Users
Business Users
Developers & DBAs
© 2010 Jaspersoft Corporation. Proprietary and Confidential
Sample Jaspersoft Customers Public Sector
Software & Technology
Manufacturing
Financial Services Telecommunications
Travel & Transportation
10 ©2010 Jaspersoft Corporation. Proprietary and Confidential
Jaspersoft Product Advantages Reporting Print-ready production reports Web 2.0 drag & drop ad hoc query and reporting Access to any data source: relational, XML, Hibernate, EJB, POJO, custom Connect directly or via rich business metadata layer
Dashboards Web 2.0 drag & drop dashboard designer Live component-level refresh Mash-ups with external content ©2010 Jaspersoft Corporation. 11 Proprietary and Confidential
Jaspersoft Product Advantages Analysis
Integrated In-memory analysis Standards-based and scalable ROLAP Excel connector
Data Integration
Wide range of connectors & transforms Intuitive graphical user interface High performance generated code
Business Intelligence Suite
Modular, shared services On-premise, Virtualized, SaaS multi-tenancy, Cloud Scalable, small-footprint, 100% pure Java Designed for integration / embedding Open Web standards Internationalized and localized Extensible and modifiable source code ©2010 Jaspersoft Corporation. Proprietary and Confidential
Web 2.0 Ad Hoc Query & Reporting Domains
© 2009Jaspersoft Corporation. Proprietary and Confidential
13
Web 2.0 Dashboarding Self-Service Dashboard Builder for Business Users
Set business users free to assemble and publish Dashboards
Multiple key performance indicators “Mash-ups” with any URLaddressable content
Drag & drop reports onto Dashboard
Dynamic resize & layout
“Twinkling” live dashboard elements
Dynamic near real-time individual frame refresh
Global or local controls
Input parameters Other report controls
©2009 Jaspersoft Corporation. Proprietary and Confidential
8/15/2010
14
Jaspersoft BI Suite Architecture
15 ©2010 Jaspersoft Corporation.
What Makes Business Users Crazy? What is our top selling beverage?
Number 1
Number 3
“Coke”
“Coca Cola”
Examples of Data Quality Challenges
• Business Intelligence use cases: – – – – –
Foreclose mortgages Issue credit or credit line Preferred customer status with preferred pricing Value of company prior to acquisition Many other purposes
Your Data Quality Pain: – Abnormal ends with exceptions – Confusion about meaning of data – Non-sharable data – Hours to reconcile inconsistent reports
Agenda
Talend Introduction Why practical data management is crucial to accurate business intelligence Company Overview
18
Blocks to Accurate BI
Roadblocks
Business Impact
Lack of standards Platforms
Language Efficiency Competing information quality processes Revenue
Code pages Governance, Risk and Compliance Data Age & Reliability
“Dummy” Values Unstructured “Freeform” Values
© Talend 2010
19
Who Needs Data Quality?
“Anytime data crosses an organizational boundary, it should be governed, whether you‟re sharing data among business units internally or publishing data to customers, partners, auditors, and regulatory bodies externally.” - TDWI, “Data Governance Strategies” report 2006
© Talend 2010
20
Corporate Overview Leading provider of open source data management software Venture-backed
Worldwide operations and users San Francisco (Los Altos) Corporate
London (Maidenhead) Business Tech Support
Orange County (Irvine) Business R&D Tech Support
Nuremberg Business Tech Support Tokyo Business Tech Support
New York (Tarrytown) Business Tech Support Paris (Suresnes) Corporate Business R&D Tech Support © Talend 2010
Utrecht Business
Milan (Curno) Business Tech Support
Beijing R&D Tech Support
21
Business Highlights A high adoption rate 10 million downloads 450,000 users 1,500 customers
1 download of Talend Open Studio per minute © Talend 2010
100 new customers per month 22
Market Positioning
MDM
Data Quality
Reference data management
Data profiling & data cleansing
Data Integration Analytics (ETL) Extract, Transform & Load for decision support systems © Talend 2010
Operational Integration Data replication & synchronization, data migration & capture, application upgrade, etc.
23
Selected Talend Customers Finance & Insurance
Services
Manufacturing & Retail
Public Sector & Education
© Talend 2010
24
Agenda
How you can track and control the ever-moving target of good data quality
25
Track and Control • Scope - Conduct Preliminary Analysis • Plan - Design Processes and Procedures • Stage - Adjust processes and procedures • Implement - Compare initial and follow-up analysis • Maintain - Regular monitoring of DQ metrics
Scope
© Talend 2010
Plan
Stage
Implement (go live)
Maintain
26
Agenda
What low-cost resources to profile, track, and cleanse data
27
Talend’s Data Quality Offerings
Talend Open Profiler Identify data quality problems - Free, GPL, no limitations - Custom indicators
Talend Data Quality Cleanse & track - Specific components - Reports - Data Quality Portal
© Talend 2010
28
Talend Data Quality Major Features
Analysis & Statistics
Data Standardization
Matching & De-duplication
Finds Outliers Nulls, Blanks, Unique, Duplicates Regular Expressions Informative Charts and Graphs
Define shapes and sets of data
Find duplicates
Leverage public domain and commercial data Built-in data integration
Talend Open Profiler
© Talend 2010
Leverage latest algorithms and matching methods Deterministic with SoundEx, Metaphones, Jaro-Winkler, Levenshtein
Talend Data Quality
29
Enrichment Sources
© Talend 2010
30
Agenda
How to map your data management strategy, now, and in the foreseeable future
31
Functions
Data Integration
Data Quality
Master Data Management
Few vendors have continuity across these functional areas to deliver end-to-end data management.
© Talend 2010
32
When to Choose Jaspersoft or Talend Business Intelligence
Reporting
X
Dashboarding
X
When to choose Jaspersoft:
Data Analysis (In-Memory or OLAP)
X
Single vendor for end-to-end BI Optimized ETL for Jaspersoft
Basic Analytic ETL
X
When to choose Talend:
(DM, DW, ODS)
Data Integration
© Talend 2010
Analytic ETL (DM, DW, ODS)
X
X
Operational ETL
X
Data Quality
X
Higher Scalability Options
X
Data Integration is the main focus Data Quality Higher Scalability options
33
Show Time!
© Talend 2010
34
Thank you for your attention! Please ask you questions now Using the Q&A panel Jaspersoft Contact E-mail: Phone: Web:
EMEA: [email protected] +353 4434700 www.jaspersoft.com
Talend Contact [email protected] • TEST DRIVE: http://www.talend.com/download.php
• TUTORIALS: http://www.talendforge.org/tutorials/menu.php • Cédric Fauvet: [email protected]
© Talend 2010
35
Thank You!
© Talend 2010
36
