In the last few weeks we have seen new products launched by IT majors that have the potential to greatly influence the fortunes of the Analytics and Insights business. IBM’s Watson Analytics and Oracle’s Cloud based Analytics are just two new solutions/ platforms that have hit the market.  We can rest assured that many more such offerings will be launched in the coming weeks. As the products keep coming, they raise some important question for the analytics industry. What impact they will…

After many years spent working with businesses of various sizes, we’ve begun to notice patterns around the successful use of data and analytics. Many businesses tell us they want to be “data-driven” or use analytics to achieve their goals. One aspect that is often overlooked when it comes to using analytics is the role of team culture, or business culture, in actually making use of the insights generated by analytics.

All of the effort that goes into…

The join statements of the database can be used conveniently to perform the operation of alignment join. But sometimes the data is stored in the text files, and to compute it in Java alone we need to write a large number of loop statements. This makes the code cumbersome. Using esProc to help with programming in Java can solve the problem easily and quickly. Let’s look at how this works…

What exactly is big data to an asset managers? It actually means more than sucking up social media data or spying on the satellite data. These are good data collection methodology - but realistically when you have a limited budget but you want to start something from ground zero, what should you do first? If you are to start it, what different elements you have to consider? I have some thinking about it - I wish that we can share more ideas here.

Consider supply…

Cross-row and group computation often involves computing link relative ratio and year-on-year comparison. Link relative ratio refers to comparison between the current data and data of the previous period. Generally, it takes month as the time interval. For example, compare the sales amount of April with that of March, and the growth rate we get is the link relative ratio of April. Hour, day, week and quarter can also be used as the time…

Program development for data process often involves cross-database relational operations. The following example will illustrate Java’s method of handling these operations. sales table is in db2 database, employee table is in mysql database. The task is to join sales with employee through sellerid of sales table and eid of employee table, and filter out the data insales and employeethat…

For full blog post, click here.

In the mid-1980's I worked as an information analyst / data manager in a police station in a small town in New England (northeast U.S. - for international readers).  It was a strange but exciting experience for a young man, chosen simply as I was identified as the local ‘computer geek’ at the town high school (a small…