OpenI (“open-eye”) : Open Source Business Intelligence Gets

OpenI (“open-eye”) : Open Source Business Intelligence Gets Real Sandeep Giri Project Lead, openi.org CTO, Loyalty Matrix, Inc. MySQL User Conference 2006

Speaker and Company BIO Sandeep Giri – – – – Project Lead, openi.org CTO, Loyalty Matrix, Inc. Tech Focus: Databases, OLAP, J2EE, Open Source Biz Focus: Marketing data analytics Loyalty Matrix, Inc. – Sponsors openi.org – Business: OnDemand marketing data analytics – Product: Software-as-a-Service (SaaS) platform – MatrixOptimizer – San Francisco-based firm with offshore center in Nepal -2- Copyright (c) 2006, openi.org

Agenda -3- Why Business Intelligence? BI Components and Open Source OpenI: Open Source BI Application Demo Q&A Copyright (c) 2006, openi.org

BI is about turning data into actionable insights What? Why? How? Business Intelligence Software Need: Turn data into actionable insights Challenge: Unnecessarily complex process for Insight-building Business Users BI is more about process than software Good BI software facilitates a good process -4- Copyright (c) 2006, openi.org

Four fundamental technologies for BI Database/ ETL Purpose / Feature s Data consolidation Dimensional data model Facts & dimensions Data Mining & Statistics OLAP Visualization Discover patterns and trends in data Predict Plots & Models Prepare summaries of data and queries Ad hoc analysis Cubes, dimensions, & measures “See the numbers” Create, view, and interact with analyses Charts & Graphs Standar ds SQL JDBC ODBC Available at model or algorithm level No equivalents of jdbc/xmla XMLA MDX (looks like SQL, but is NOT) JOLAP Interface to multiple data source types: RDBMS OLAP Data mining models Open Source Options MySQL Kettle CloverETL R Project Weka Mondrian Components: JPivot, JasperReports Applications: OpenI -5- Copyright (c) 2006, openi.org

Visualization is key to business intelligence Getting information from a table is like extracting sunlight from a cucumber. – Farquhar & Farquhar, 1891. You can see a lot, just by looking. – Yogi Berra If I can’t picture it, I can’t understand it. – Albert Einstein A good user interface is key to end user adoption of BI software -6- Copyright (c) 2006, openi.org

What is OpenI? Visualization Component of the BI stack – J2EE (JavaEE) web application – Consolidates various open source BI components – Reports from OLAP, data mining models, & RDBMS Open Source – Published on SourceForge on July 1, 2005 – Finalist for Best Open Source Enterprise Software (SourceForge Community Choice Awards 2006) – 5,000 downloads to-date – Based on Mozilla Public License MPL 1.1 Ready for end-users – Completely installable package, no extra downloads – Point to your existing data sources, and start publishing – No coding required: no SQL, no MDX, no XML configuration files! -7- Copyright (c) 2006, openi.org

OpenI Architecture Demo: demo.openi.org -8- Copyright (c) 2006, openi.org

Key OpenI Features Completely thin client UI to create and publish analysis off: – OLAP (Mondrian and Microsoft Analysis Services) – RDBMS (JasperReports) – Data mining models (Project R) Powerful analyst tools – – – – Drill-up, drill-down, and drillthrough Auto generation of analyses off an OLAP cube Personalized dashboards Export to excel and PDF Security – Directly integrates with backend security schema – Restrict access at module, analysis or data-level Browser independent Free! -9- Copyright (c) 2006, openi.org

Case Study: OpenI in action with MatrixOptimizer -10- Copyright (c) 2006, openi.org

Summary BI is about turning data into actionable insights – BI is more about process than software – Good UI is key to end user adoption OpenI provides visualization by leveraging open source BI components – Create and publish analyses without writing code – Easily build web-based BI applications Go to http://www.openi.org today and see it for yourself: Eventually it is the community that will determine the success of OpenI -11- Copyright (c) 2006, openi.org

Questions, Comments? Now would be the time My email is [email protected] -12- Copyright (c) 2006, openi.org