« No More eMailHappy Birthday to Dave »

Open Source BI

We [Clarise and I] met with Bernard Golden, The CEO of Navica, again. One of the topics of conversation brought together our work in Business Intelligence and Open Source. Bernard's background includes Informix and our's includes Oracle :) [No rivalry though] All three of us have worked on large system integration projects requiring strict data modeling and centered around the RDBMS, ETL, EAI, OLTP and OLAP tools selected to best meet the business needs. Clarise and I have worked with Jetstream [ETL & EAI], Mondrian with JPivot [OLAP].

One of the most important aspects of a BI project is the implementing the business process and best practices for the users. Determining what that really means is key to the success of such projects. Do the current business processes implement best practices for that industry, giving the organization a competitive edge, but needing better implementation from IT? Are the best practices implemented in a COTS BI suite better than the organization's current business processes? This is at the heart of most "build versus buy" decisions.

And this is one advantage that open source packages may have over buying a proprietary solution that implements the vendor's version of BI best practices for a given industry or vertical. Open Source can be more cost effectively customized to implement those processes and practices that your organization views as giving a competitive advantage.

By the way, Bernard gave us a copy of his book, Succeeding with Open SourceBook Cover Image for Succedding with Open Source.

3 feedbacks »



Did you already had a look at BIRT? (http://www.eclipse.org/birt/)

07/25/05 @ 06:42

Mondrian is a nice program with support for MDX and if run on a RDMS such as oracle which supports materialised view can really fly in speed terms.

I recommend you have a look at PALO (www.palo.net or www.opensourceolap.com)
an open source olap server.
Palo is RAM based (but obviously load data into memory at startup and writes data back to files for persistency) so performance is good. Palo should work on 64 bit windows and Linux machines (so large amounts of data can be held in memory).
A major advantage of PALO is that it can write values directly to memory, ideal for planning and “what if” alalysis and calculations are performed in real time. Real time OLAP systems tend to have smaller models (since every combination in the cube doesn’t need to be calculated - therefore you tend not to have problems such as “database explosion")
I recommend any business intelligence practitioner or end user download it have a go.

10/28/05 @ 14:19
Comment from: lawuit

Wenfengli touted his BIRT a lot. Let’s look at the background behind that…

Wenfeng li incured a huge lawsuit with his previous employer and brought a huge lose in lawsuit money to Actuate. Actuate has to layoff several times.

Then wenfeng li pushed to China. BIRT is his last desperate resort to build his force in Actuate. However, wenfeng li( PMC lead as he named himself )
doesn’t really have much experience in Java technology.

Essentially Wenfeng li is wasting Actuate’s money and resources to gain huge benefits for himself. At the same time to develop a very inferior product and call it a “massive success” and continue to add version number to that…

09/13/06 @ 13:42
January 2020
Mon Tue Wed Thu Fri Sat Sun
    1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30 31    
 << <   > >>

I'm Joseph A. di Paolantonio and this blog has two main foci: my interest in food, and my interest in the future. This provides a look into my personal life, and is separate from my consulting work…though there will be overlap. I am an independent researcher, working as a strategic consultant and I'm an executive with over 20 years of commercial experience with a technical interest in the intersection of Internet of Things, with advanced data management and analysis methods. I view data science as a team activity, and I feel that the IoT must be viewed as a system. I am leveraging my past activities to understand the adoption and impact of the IoT; first, as a system engineer in aerospace, where I developed Bayesian risk assessment methods for systems within the Space Transportation System (including the Space Shuttle), Extreme Ultraviolet Explorer, Gravity Probe B, and many more, and second, as a enterprise data warehousing, business intelligence and analytics professional. Between my aerospace and IT careers, I indulged my hobby of cooking by starting a food company, Montara Magic, centered around my chocolate sauces. My education combined chemistry, mathematics and philosophy. I performed research into molten salt fuel cells in graduate school, and in photovoltaic materials for a short time in industry. The lure of bringing the human race into space was strong, and when I was offered the chance to combine my chemistry and mathematics skills to develop new risk assessment and system engineering methods for space launch and propulsion systems – I couldn't resist. I perform independent research and strategic consulting to bring value from the Internet of Things, Sensor Analytics Ecosystems and data science teams.I am a caregiver, a lover of science fiction and speculative fantasy, and my passion to learn has led me to a pilot's license, an assistant instructor in SCUBA, nordic and alpine skiing, sea kayaking, and reading everything I can, in as many topics as I can.

View Joseph di Paolantonio's profile on LinkedIn

37.652951177164 -122.490877706959


  XML Feeds

Free blog engine