Groups | Blog | Home
all groups > sql server data mining > august 2004 >

sql server data mining : Datamining financial data


Michael Vardinghus
8/16/2004 7:28:17 PM
Does anybody have examples of mining agaist
finance ledger / budget ?

The examples I have seen have been against
customers.

If not a specific example then a hint to what mining
could be used for related to this area.

--Michael V.

Jamie MacLennan (MS)
8/17/2004 4:40:09 PM
This is kind of an open ended question, but here are some ideas.

Forecasting is an obvious application - spot trends in data and forecast
future values
Anomaly Detection across time - e.g. flag values that don't "look right"
across all columns by date
Time Clustering - cluster dates by all column values - this gives an
interesting picture of your data by finding groupings of dates with similar
behavior - for instance you may find a specific behavior exitsts at a
certain time every month.

You should look at the data mining faq
http://groups.msn.com/AnalysisServicesDataMining or at
http://msdn.microsoft.com/SQL/sqlwarehouse/AnalysisServices/default.aspx


When modeling this kind of data you have many options. For example, you may
get a better picture when mining the derivatives of your data rather than
the raw data.

Also at http://groups.msn.com/AnalysisServicesDataMining there is a Excel
add-in sample that you could use to try some of these ideas out with little
cost.

--

-Jamie MacLennan
SQL Server Data Mining
This posting is provided "AS IS" with no warranties, and confers no rights.
[quoted text, click to view]

AddThis Social Bookmark Button