Stocks & Commodities V. 27:10 (36-42): Data Mining And Cubes For Traders by Art Tennick

Data Mining And Cubes For Traders by Art Tennick

Here’s a technique you can apply that will show you what indicators and combination of indicators will be the most successful.

Business intelligence (BI) is a rapidly growing area of the software market. A major part of the Microsoft BI suite of software is Sql Server Analysis Services (Ssas), a powerful and fully featured application that is transforming how many companies work with and view their data. The aim of Ssas and the other BI tools is to convert raw data into information (that is, meaningful data) and then into intelligence (information that is easily visualized, easily found, and forms the basis for sound decision making). Ssas is ideally suited to the analysis of share and option price movement data, in particular how technical and fundamental and other indicators might predict such movements.

Ssas provides two major objects to assist you in price movement analysis and prediction. These two objects are:

- Multidimensional cubes

- Data mining models

Ssas is on your Sql Server Dvd and there is no cost, provided you install it on the same computer as Sql Server. Microsoft Excel 2007 provides interfaces to view cubes and data mining models built in Ssas. In addition, Excel 2007 can be used to develop temporary and permanent data mining models using Ssas in the background for the heavy lifting. Even if you don’t have Ssas, you can easily connect Excel to Sql Server Data Services (Sds) via an Internet connection — this is analyzing in the cloud. And for those without Excel 2007 or Ssas, it is also now possible to perform data mining in the cloud from Internet Explorer. This article is an overview that explores the potential of BI for traders and gives a few guidelines for getting started with data mining in particular: namely, that cubes require a bit more work.