.net version of Detect Anomalies in Excel

Hot Topic

sorting problem
DTS Code works only with VS 2003 but not with VS 2005 ?
slowly changing dimension aggregation?
2005Express trying to enable Full text indexing.
SSIS XML Configuration updating at runtime
Database import error...
Determine status of processing cube
RPC Connection error
Global variable value lost during insertion in a table
SQL Backup: Failed to Pause Catalog

SQL Server

Database Integrity Check
Delete files older than 3 days using SSIS tasks
REport definitions
delete with IN clause
how to make new database sql server 2005!
Changing the schema ownership on subscriber
Percentage/Proportion
Migration from SQL 2000 Enterprise Server to the SQL 2005 Enterprise Server (64 bit-Itanium Server)
SQL Server 2000 and 2005 - Application Role - sp_setapprole
How to set douplicate id in sql server 2005?

.net version of Detect Anomalies in Excel

Is there an equivalent or similar .net sample for detecting data Anomalies

Detect Anomalies in Excel

http://zones.advisor.com/doc/14413



Answer this question

.net version of Detect Anomalies in Excel

  • IXOYE333

    This tip http://www.sqlserverdatamining.com/DMCommunity/TipsNTricks/861.aspx gives the basic idea. You can also check out the live sample at http://www.sqlserverdatamining.com/DMCommunity/LiveSamples/46.aspx that shows anomaly detection in a web application - source code is provided. The Excel Addin adds the automatic creation of a mining model with some nice heuristics for column selection, and the visualization part. Those are mostly dependent on your application and the Excel code wouldn't really help I believe.

    The two sources above should give you everything you need. I once presented the implementation of the above web application at TechEd, so it should be in the TechEd archives (although I forget which year it was)

    -Jamie



  • Julio Diaz C.

    Please check out the Data Mining Addins for Office 2007. There's a task "Detect Outliers" which might work for you. More details about the addins are available at http://www.sqlserverdatamining.com

    Thanks



  • irohan_fernando

    I can say that I've never even tried it ... but I would need to obtain the Add-in source code and alter it for my purposes. Office/Excel will not suffice. I need to expose this functionality via a web interface and so it must also be a highly scalable solution. C# preferable.
  • .net version of Detect Anomalies in Excel
Answer this question