Skip to content

create-query-data-mining-models-dmx-tutorials.md

Latest commit

 

History

History
56 lines (38 loc) · 3.64 KB

create-query-data-mining-models-dmx-tutorials.md

File metadata and controls

56 lines (38 loc) · 3.64 KB
title Creating and Querying Data Mining Models with DMX: Tutorials (Analysis Services - Data Mining) | Microsoft Docs
ms.custom
ms.date 06/13/2017
ms.prod sql-server-2014
ms.reviewer
ms.technology
analysis-services
ms.topic conceptual
helpviewer_keywords
content queries [DMX]
ms.assetid 145b81a7-c0c3-4ca3-bb32-0b482423b9a0
author minewiskan
ms.author owend
manager craigg

Creating and Querying Data Mining Models with DMX: Tutorials (Analysis Services - Data Mining)

After you have created a data mining solution by using [!INCLUDEmsCoName] [!INCLUDEssNoVersion] [!INCLUDEssASnoversion], you can create queries against the data mining models to predict trends, retrieve patterns in the data, and measure the accuracy of the mining models.

The step-by-step tutorials in the following list will help you learn how to build and run data mining queries by using [!INCLUDEssASnoversion] so that you can get the most from your data.

In This Section

  • Bike Buyer DMX Tutorial

    This tutorial walks you through the creation of a new mining structure and mining models by using the Data Mining Extensions (DMX) language, and explains how to create DMX prediction queries.

  • Market Basket DMX Tutorial

    This tutorial uses a typical market basket scenario, where you find associations between the products that customers purchase together. This tutorial also demonstrates how to use nested tables when you create a mining structure. You build and train a model based on this structure, and then create predictions using DMX.

  • Time Series Prediction DMX Tutorial

    This tutorial creates a forecasting model to illustrate the use of the CREATE MODEL (DMX) statement. You then add related models and customize the behavior of each by changing the parameters of the Microsoft Time Series algorithm. Finally you create predictions and update the predictions with new data. The ability to update a time series while making predictions was added in [!INCLUDEssKatmai].

Reference

Data Mining Algorithms (Analysis Services - Data Mining)

Data Mining Extensions (DMX) Reference

Related Sections

  • Basic Data Mining Tutorial

    This tutorial introduces basic concepts, such as how to create a project and how to build mining structures and mining models.

  • Intermediate Data Mining Tutorial (Analysis Services - Data Mining)

    This tutorial contains a number of independent lessons, each introducing you to a different model type. Each lesson walks you through the process of creating a model, exploring the model, and then customizing the model and creating prediction queries.

See Also

Data Mining Solutions
Data Mining Tools
Data Mining Projects