BeyeBLOGS | BeyeBLOGS Home | Get Your Own Blog

« March 2010 | Main | May 2010 »

April 27, 2010

BI Solutions for Small and Medium Sized Business

I came across a story on SearchCIO-Midmarket.com that interested me because it was about affordable BI solutions for SMBs:
click here to read it.

Strangely, it focused almost solely on using Microsoft products for affordable BI, particularly focusing on Excel & PowerPivot.

What was missing? Any mention of open-source solutions.

So, for those of you who want a truly enterprise-ready BI solution that goes beyond spreadsheets, take a look at these 2 top-notch open-source BI vendors which is a great way to reap the benefits of enterprise BI, data warehouses, business analytics and predictive analytics without breaking the bank: Jaspersoft & Pentaho.

Posted by Mark Kromer at 2:30 PM | Comments (0)

April 11, 2010

Metadata Driven ETL

Time for a short posting off the beaten path of my focus for this blog, which is BI for project portfolio performance.

I spent a few hours last week speaking with both Oracle & Microsoft ETL PMs about one my favorite topics in the BIDW world, metadata-driven ETL.

What is metadata-driven ETL? IMO, it is ETL that can be derived partially automatically from an analysis of source & target, preconfigured transformations and historical metadata. The intent is to make ETL generation quicker, easier and more flexible. How often do you find ETL routines that break because something changed on a source?

I found a very nice description of metadata driven ETL here on this blog from Aditi. If you are interested in metdata driven ETL, I highly recommend reading it.

It is nice to see that Microsoft has set-up a council to maintain CodePlex which is where you can find a metadata driven ETL framework for SSIS that I used and participated in when I was a PM @ Microsoft called MDDE. It is on CodePlex and maintained by a former colleague of mine, David Reed. It is a pretty decent (still several shortcomings) framework for metadata driven ETL for SQL Server.

Posted by Mark Kromer at 5:15 PM | Comments (2)