Browse by Tags

Tagged Content List
  • Wiki Page: The Nine DataMining Algorithms in SSAS

    SQL Server Analysis services includes nine algorithms. In addition, SSIS includes two text mining transformations. the list below summarize the nine SSAS algorithms and their commun usage. Decision Trees: is the most popular DM algorithm, it is used to predict discrete and continuous variables...
  • Wiki Page: SQL Server Analysis Services (SSAS) (pt-BR)

    Esse artigo foi originalmente escrito em: http://social.technet.microsoft.com/wiki/contents/articles/1175.sql-server-analysis-services-ssas.aspx Table of Contents Visão geral Análise serviços Wiki artigos 101 Modelagem Dimensional Segurança Desempenho Administração...
  • Wiki Page: How to Use the SQL Server Data Mining Add-ins with PowerPivot for Excel

    Table of Contents Introduction Overview of Data Mining with the Add-Ins Installation Prerequisites Installing the Data Mining Add-ins Installing PowerPivot for Excel Performance and Memory Considerations for 32-bit vs. 64-bit Versions Technical Considerations Data Stores for the PowerPivot and Data Mining...
  • Wiki Page: Problem Processing Mining Structure When DataSource is OLAP Cube

    Table of Contents Background Explanation Workarounds Discussion Background A customer recently experienced a problem when processing a data mining structure that is based on a cube: that is, the data source for the clustering model was queried from the Analysis Services cube rather than the underlying...
  • Wiki Page: Data Mining and Predictive Analytics

    This page is in progress. Please hold off on making edits till I can add more content and clean it up a bit! Table of Contents Overview Examples of Articles for this DM Wiki Predictive Modeling 101 I am new to data mining; what should I read to get started? (books) Where can I find videos...
  • Wiki Page: SSAS: Explaining the State Transitions Viewer for Sequence Clustering

    Original article (before edits) by Allan Mitchell , SQL Server MVP and principal consultant at Konesans Limited in the UK. You can find Allan’s website at www.SQLIS.com . NOTE : Alternatively, you can download a Word file of this whitepaper at TechNet Gallery . This is for several potential...
  • Wiki Page: SSAS: Explaining the GetClusterCharacteristics Stored Procedure for Sequence Clustering Models

    Original content by Allan Mitchell , SQL Server MVP and principal consultant at Konesans Limited in the UK. You can find Allan’s website at www.SQLIS.com . NOTE : Alternatively, you can download a Word file of this whitepaper at TechNet Gallery . This is for several potential reasons: (1...
  • Wiki Page: Business Intelligence

    Microsoft business intelligence (BI) expands the reach of your investments in the Microsoft productivity platform, data infrastructure, and collaboration tools you already own. Our solution delivers business intelligence by integrating the strengths of these products on a single platform to empower informed...
  • Wiki Page: Predictive Analytics (Data Mining): Advanced Topics

    This page is in progress. Please hold off on making edits till I can add more content and clean it up a bit! Table of Contents Overview Examples of Articles for this DM Wiki Other Modeling Tools and Methods Microsoft Solver Foundation Drawbacks and Requirements TimeSeries Foundation Where...
  • Wiki Page: Using the SQL Server Data Mining Algorithms: Tips and Resources

    Work in progress **** This article is a list of frequently asked questions about each of the data mining algorithms provided by SQL Server Data Mining. Resources are also provided, where available, to help you understand how these algorithms compare or align...
  • Wiki Page: SQL Server Analysis Services (SSAS)

    Table of Contents Overview Analysis Services Wiki Articles Dimensional Modeling 101 Security Performance Administration and Monitoring Tools Query and DDL Languages Data Mining See Also Other Languages Brazilian Portuguese (pt-BR) German (de-DE) Overview SQL Server Analysis Services (SSAS) is...
  • Wiki Page: 数据挖掘简介

    数据挖掘经常被描述为在数据中发现有意义的模式的过程。数据挖掘可以处理大量数据,并派生以其他方式可能发现不了的模式和趋势。这些模式和趋势可以集中起来,以挖掘模型形式存储。然后,可以将挖掘模型应用于特定的商业应用场景,如下所示: 预测销售额。 向特定客户发送邮件。 确定可能需要搭售的产品。 查找客户将产品放入购物车的顺序序列。 数据挖掘也称为预测分析,面对当今世界的海量数据以及快速变化的业务需求,这一功能日显重要。现在仅靠人力已无法一一查看和理解这些海量数据并筛选出有用的信息,而数据挖掘可以查找模式,使用户专注于对自己最重要的趋势和相关性,因此它的重要性不言而喻...
  • Wiki Page: A Guide to the (Undocumented) System Stored Procedures for Data Mining

    Jump to the list of stored procedures for each mining model type What are the data mining stored procedures? The system stored procedures for data mining that are provided in Analysis Services were created for internal use, in order to efficiently work with mining model content and mining model...
  • Wiki Page: 使用 Excel 数据挖外接程序执行购物篮分析 (zh-CN)

    什么是购物篮分析(Excel 表分析工具) [this page is under construction] 购物篮分析 工具可帮助您在数据中查找 关联 。关联可以指出哪些商品经常被一起购买。在数据挖掘中,这项技术是一种被称为“市场篮分析”的广为人知的方法,用于在非常庞大的数据集中分析客户的购买行为。商家可以使用该信息向客户推荐相关产品,并通过将这些产品置于网页、目录或货架中的临近位置来进行推销。 若要使用购物篮分析,要分析的项必须通过事务 ID 进行关联。例如,如果要分析通过某个网站接收的所有订单,则每个订单都会有一个订单 ID 或交易 ID,它与一个或多个购买项相关联...
  • Wiki Page: System Stored Procedures for Association Models (Data Mining)

    This article is a continuation of the following article that introduces the system stored procedures for SQL Server Data Mining. http://social.technet.microsoft.com/wiki/contents/articles/7566.a-guide-to-the-undocumented-system-stored-procedures-for-data-mining.aspx Table of Contents Association...
  • Wiki Page: System Stored Procedures for Decision Tree and Linear Regression Models (Data Mining)

    This article is a continuation of the following article that introduces the system stored procedures for SQL Server Data Mining. http://social.technet.microsoft.com/wiki/contents/articles/7566.a-guide-to-the-undocumented-system-stored-procedures-for-data-mining.aspx The following stored procedures...
  • Wiki Page: SQL Server Analysis Services (SSAS) (de-DE)

    Table of Contents Überblick Analysis Services Wiki Artikel Multidimensionale Modellierung Performance Administration und Monitoring Tools Abfrage und DDL Sprachen Data Mining Siehe auch Andere Sprachen English Português Überblick SQL Server Analysis Services (SSAS) ist Microsoft's...
  • Wiki Page: System Stored Procedures for Neural Network and Logistic Regression Models (Data Mining)

    This article is a continuation of the following article that introduces the system stored procedures for SQL Server Data Mining. http://social.technet.microsoft.com/wiki/contents/articles/7566.a-guide-to-the-undocumented-system-stored-procedures-for-data-mining.aspx Neural Network and Logistic...
  • Wiki Page: System Stored Procedures for Naive Bayes Models (Data Mining)

    This article is a continuation of the following article that introduces the system stored procedures for SQL Server Data Mining. http://social.technet.microsoft.com/wiki/contents/articles/7566.a-guide-to-the-undocumented-system-stored-procedures-for-data-mining.aspx Naïve Bayes Models...
  • Wiki Page: System Stored Procedures for All Model Types (Data Mining)

    This article is a continuation of the following article that introduces the system stored procedures for SQL Server Data Mining. http://social.technet.microsoft.com/wiki/contents/articles/7566.a-guide-to-the-undocumented-system-stored-procedures-for-data-mining.aspx These data mining stored...
  • Wiki Page: System Stored Procedures for Clustering Models (Data Mining)

    Clustering Models This article is part of a series. http://social.technet.microsoft.com/wiki/contents/articles/7566.a-guide-to-the-undocumented-system-stored-procedures-for-data-mining.aspx Most of the stored procedures used for clustering models have the same names as the stored procedures...
  • Wiki Page: System Stored Procedures for Sequence Clustering Models (Data Mining)

    This article is a continuation of the following article that introduces the system stored procedures for SQL Server Data Mining. http://social.technet.microsoft.com/wiki/contents/articles/7566.a-guide-to-the-undocumented-system-stored-procedures-for-data-mining.aspx These data mining stored procedures...
  • Wiki Page: How to Find the Storage Size of a Data Mining Model or Data Mining Structure

    Data mining models are pretty lightweight in comparison to cubes or tabular models. Typically, after processing, you have a cache of processed structure data, which you can clear to eliminate if necessary. There is also a small set of metadata and statistics stored as the model content. But if you have...
  • Wiki Page: Differencing in the ARIMA formula for the Microsoft Time Series algorithm

    Recently a customer discovered an issue with the ARIMA formula used in the Microsoft Time Series algorithm for data mining . She was trying to back-test the results by computing the formula and couldn't get the results to match. This can be maddening, especially when the formulas are so complex,...
  • Wiki Page: Processing Analysis Services Objects Dynamically by using Integration Services

    Processing Analysis Services Objects Dynamically by using Integration Services Users often ask how you can use the Analysis Services Processing task in Integration Services to process new objects. The problem is that the task UI forces you to choose the items to process, so if they don't...
Page 1 of 1 (25 items)
Can't find it? Write it!