Those of you who have been using MySQL for sometime now would know that the MySQL 5.0 Online Reference Manual is not just a manual but also a repository of user comments exploring and solving common and/or deeper problems. If you are stuck with a particular problem that you find unable to frame a SQL for, the comments on the manual pages would usually have a solution.
(more…)
July 2006
Monthly Archive
Sat 29 Jul 2006
Mon 24 Jul 2006
KETL ETL tool Training Document
Posted by Nishith under Data Warehousing , Open Source Analytics[7] Comments
KETL is an open source ETL tool by Kinetic Networks that is gaining mindshare of late. It is currently downloadable as part of Bizgres BI project, but can be setup for other databases with a little tweaking.
KETL is different from Kettle, another open source ETL tool. You can read more about the similar names here at Nicholas Goodman’s blog. While Kettle is GUI oriented, KETL is scripted and probably more robust.
Read the KETL training doc to know more about its architecture and usage.
Mon 17 Jul 2006
Embracing Simplicity Can Reap Huge BI Benefits
Posted by Nishith under BI, Data Mining, Analytics[3] Comments
A simple point that most BI vendors and consultants seem to miss is that for BI to deliver upon its promise, it first has to be adopted by the end users. BI has to become simple and usable for the broad based adoption that is needed in today’s hypercompetitive world. It is the hidden Cost of Complexity that turns off end users and results in the fact that most BI projects fail.
(more…)