Open Source Analytics

Let’s begin with what Acme Financial Services (AFS), our fictitious Consumer Finance company, does. Because this will tell us the critical pieces of information AFS deals with, and that in turn will give us the required insights for building its data model. (more…)

MySQL makes an obvious and affordable choice for data warehousing. Its traditional weaknesses (from OLTP system point of view) are actually its strengths when it comes to Data warehousing and OLAP.

If you look at the requirements from a DW, you’d see that unlike OLTP systems, transactions are not required, and 60×24x7 uptimes are not really needed. On the contrary the system should be able to handle queries most efficiently and should provide capabilities for high-speed bulk loading in batch jobs. This is where MySQL shines over competition. (more…)

Over the next one month, we will do some cutting edge analytics using entirely free open-source software (so that you dont have to approach your boss for that million dollar analytics budget).

Yes, you guessed it right. This blog is for people who, like me, are tired of all the hype created around analytics by commercial BI vendors and the exorbitant prices they charge for bad software products. This blog is for people and organizations who want to discover the world of analytics and use advanced data-mining for actualizing their highest potential, but haven’t been able to do it so far. (more…)

If you are doing business intelligence/analytics/data-mining today and are satisfied with your results, this blog may not be for you.

This blog is about doing the best of that stuff in an accessible (here) and affordable (free) way. Its about Open Source Analytics.