Home
Search results “Excel data mining sql server”
Sales Forecasting with Excel and the SQL Server 2012 Data Mining Add-in Tutorial
 
04:30
Use the Excel Data Mining add-in for SQL 2012 Analysis Services. See how simple it is to build a predictive model that forecasts sales or other values based on historical data.
Views: 12663 Edward Kench
Forecast the Price of Gold with Excel and SQL Server - Data Mining Tutorial
 
06:15
Learn about data mining with SQL Server 2012 Analysis Services and Excel 2013, using historical gold pricing data, to predict future prices. To follow this tutorial, you should have SSAS and the Data Mining Add-in for Excel.
Views: 6410 Edward Kench
Creating Association Rules using the SQL Server Data Mining Addin for Excel
 
06:16
Association Rules are a quick and simple technique to identify groupings of products that are often sold together. This makes them useful for identifying products that could be grouped together in cross-sell campaigns. Association rules are also known as Market Basket Analysis, as they used to analyse a virtual shopping baskets. In this tutorial I will demonstrate how to create association rules with the Excel data mining addin that allows you to leverage the predictive modelling algorithms within SQL Server Analysis Services. Sample files that allow you follow along with the tutorial are available from my website at http://www.analyticsinaction.com/associationrules/ I also have a comprehensive 60 minute T-SQL course available at Udemy : https://www.udemy.com/t-sql-for-data-analysts/?couponCode=ANALYTICS50%25OFF
Views: 7714 Steve Fox
Data Mining in SQL Server Analysis Services
 
01:29:25
Presenter: Brian Knight
Views: 97807 PASStv
Introduction to Data Mining in SQL Server Analysis Services
 
01:27:07
Data mining is one of the key hidden gems inside of Analysis Services but has traditionally had a steep learning curve. In this session, you'll learn how to create a data mining model to predict who is the best customer for you and learn how to use other algorithms to spend your marketing model wisely. You'll also see how to use Time Series analysis for budget and forecast prediction. Finally, you'll learn how to integrate data mining into your application through SSIS or custom coding.
Views: 8967 PASStv
Creating Excel Reports with SQL Server or Analysis Server
 
08:16
A simple overview of how people use Excel to get reports from SSAS
Views: 3195 Randal Root
Creating Data Mining Structures & Predictive Models using the Excel Add-In  for SQL Server 2008
 
12:12
A demonstration of how to create Data Mining Structures & Predictive Models using the Excel Data mining Addin for SQL Server 2008. A data mining structure is created first and then a Microsoft Decision Tree & Neural Network are created. In the subsequent video I will create a lift chart (also known as an Accuracy Chart) to compare the effectiveness of the two models. The raw data used in the demonstration is available at http://www.analyticsinaction.com/creating-data-mining-structures-predictive-models-using-the-excel-add-in-for-sql-server-2008/ I also have a comprehensive 60 minute T-SQL course available at Udemy : https://www.udemy.com/t-sql-for-data-analysts/?couponCode=ANALYTICS50%25OFF
Views: 26063 Steve Fox
SiilatsFinancePart2 Stock Data into Excel.mp4
 
11:40
Financial Data Mining, Part 1 -- Portfolio Management in Microsoft SQL, Data mining with Excel Keith Siilats, 2/4/2012 CS246 Mining of Massive Datasets 1. Download Microsoft VHD for Mac/Windows/Unix http://www.microsoft.com/download/en/details.aspx?id=26113 2. Download VirtualBox and configure it for HyperV http://dynamicsnavax.blogspot.com/2011/04/how-to-run-ax2012-hyperv-on-virtualbox.html 3. Start your VHD and log in with Username Administrator Password [email protected] 4. Install Guest additions from VirtualBox Menu 5. Install shared folders 6. When the 10 day trial period finishes you can rearm up to 4 times a. Click Start, and then click Command Prompt. b. To reset the activation period, type slmgr.vbs --rearm, and then press ENTER. 7. Install Office http://technet.microsoft.com/en-us/evalcenter/ee390818 8. Get some stock data. Key is to get both sector and market cap info, sp500 is the largest 500 companies a. http://www.stockmarketsreview.com/companies_sp500/ b. http://www.cboe.com/products/snp500.aspx 9. Sign up with www.tdameritrade.com It will take you 3 days to sign up and you will get $500. You will see in the video how to export sector data from tdameritrade, it's easier than using the links above. 10. Get an excel macro to download latest prices. You need excel to clean up all the junk prices. Going through text files is no fun. Hoping that machine learning algorithms know how to deal with rubbish data is optimistic. http://code.google.com/p/finance-data-to-excel/ 11. Install Analysis Server samples http://msftdbprodsamples.codeplex.com/wikipage?title=Installing%20SQL%20Server%202008R2%20Databases See how Microsoft does basket analysis, recommendations and all the other algorithms we have covered in class (hint, it's a lot of point and click and very little code). 12. Watch the video on how to create a VBA script to generate data and export it to SQL server (this is the Map step). In practice you will have multiple pricing servers running complex derivative pricing monte carlos and clustered sql server over several machines with hot backup. If you would like to build a machine like this instructions are http://www.tpc.org/tpcc/results/tpcc_price_perf_results.asp Microsoft Analysis server will work with any SQL source including Oracle. 13. In class we will create a custom portfolio management cube. This is the Reduce step, but its kind of a universal reduce. Once you have the cube you connect to it from Excel Pivot Table and can create any Reduce real time. Tutorial on PivotTables http://www.timeatlas.com/5_minute_tips/chunkers/learn_to_use_pivot_tables_in_excel_2007_to_organize_data 14. Here is a tutorial connecting excel to sql server http://newtech.about.com/od/tutorials/ss/How-To-Configure-Excel-2010-Pivot-Table-For-Business-Intelligence.htm 15. Here is a tutorial how to connect Excel to the Analysis Server http://blogs.office.com/b/microsoft-excel/archive/2008/08/28/using-excel-excel-services-with-sql-server-analysis-services-2008.aspx 16. In the second part I will show you how to create cubes on tick data (trades and quotes) and do high frequency trading.
Views: 1113 siilats
Data Mining using the Excel Data Mining Addin
 
08:16
The Excel Data Mining Addin can be used to build predictive models such as Decisions Trees within Excel. The Excel Data Mining Addin sends data to SQL Server Analysis Services (SSAS) where the models are built. The completed model is then rendered within Excel. I also have a comprehensive 60 minute T-SQL course available at Udemy : https://www.udemy.com/t-sql-for-data-analysts/?couponCode=ANALYTICS50%25OFF
Views: 73575 Steve Fox
Creating prediction queries using the SQL Server data mining add in for Excel
 
05:51
The Data Mining Query allows you to create predictions using a data mining model that you have already created. In this demonstration I show how you can use this tool to predict whether customers are likely to attend a marketing event.
Views: 6796 Steve Fox
What if Analysis with Excel 2007 and SQL Server Data Mining
 
05:53
Watch this how to video to learn about how to use SQL Server Data Mining add-in and Excel 2007 to do what-if analysis of your data. Get the data mining addin here http://www.microsoft.com/sqlserver/2008/en/us/data-mining-addins.aspx Get more information at http://blogs.msdn.com/bi
Views: 9503 wowmsft
Excel at Data Mining - Connecting to a SQL Server Data Source
 
04:43
In this video, Billy Decker of StatSlice Systems shows you how to connect to a SQL Server data source in less than 5 minutes with the Microsoft Excel data mining add-in*. In this example, we will connect to a SQL Server data source and create a Neural Network Model on the data. For the example, we will be using a tutorial spreadsheet that can be found on Codeplex at: https://dataminingaddins.codeplex.com/releases/view/87029 You will also need to attach the AdventureworksDW2012 data file to SQL Server which can be downloaded here: http://msftdbprodsamples.codeplex.com/releases/view/55330 *This tutorial assumes that you have already installed the data mining add-in for Excel and configured the add-in to be pointed at an instance of SQL Server to which you have access rights.
Views: 3331 StatSlice Systems
SSAS: Fill from Example - Data Mining Add-In
 
04:14
In this tutorial we will learn how to use the Fill From Example Table Analysis Tool for Excel. Read the video transcript: http://msdn.microsoft.com/en-us/library/dd299418.aspx
Views: 3257 sqlserver
SSAS: Getting Started with the Table Analysis Tools - Data Mining Add-Ins
 
06:03
This video will help you get started with the Data Mining Table Analysis Tools add-in for Excel 2007 by showing you how to open the tools, use the sample Excel data, and connect to an Analysis Services server. See the Video Transcript: http://msdn.microsoft.com/en-us/library/dd299412.aspx
Views: 10212 sqlserver
DATAMINING USANDO UN COMPLEMENTO DE SQL PARA EXCEL
 
17:39
Curso: Inteligencia de Negocios. Docente: Brian Cesar Pando Soto Integrantes: - Taboada Arévalo, Evonny Kristhel -Nieto Collado, Frank Universidad Nacional Agraria de la Selva / Facultad de Ingeniería en Informática y Sistemas / FIIS / 2013 /
SQL Data Mining
 
05:02
SQL Data Mining & Visual Studio. A brief overview of data mining and the data mining algorithms.
Views: 2956 BrandonConsulting
SSAS: Scenario Analysis - Goal Seek Video Tutorial (Data Mining Add-in For Excel)
 
05:33
SQL Server Analysis Services: Data Mining Add-in For Excel See more info, and read the video transcript: http://msdn.microsoft.com/en-us/library/dd744748.aspx
Views: 3930 sqlserver
Data Mining Tools Overview for Excel and SQL Server
 
32:29
Data Mining Tools Overview for Excel and SQL Server
Views: 119 Sayed Ahmed
Shopping Basket Analysis with Excel 2007 and SQL Server Data Mining
 
04:39
Watch this short tutorial video to learn how to do basket analysis with Excel 2007 and the SQL Server Data Mining add-in. You can download the SQL Server Data Mining add-in here http://www.microsoft.com/sqlserver/2008/en/us/data-mining-addins.aspx Get more information at http://blogs.msdn.com/bi
Views: 21586 wowmsft
Excel at Data Mining - Your First Predictions
 
05:14
In this video, Billy Decker of StatSlice Systems shows you how to start data mining in 5 minutes with the Microsoft Excel data mining add-in*. In this example, we will create a set of predictions for new customers using a Logistic Regression models based upon old customers. For the example, we will be using a tutorial spreadsheet that can be found on Codeplex at: https://dataminingaddins.codeplex.com/releases/view/87029 *This tutorial assumes that you have already installed the data mining add-in for Excel and configured the add-in to be pointed at an instance of SQL Server to which you have access rights.
Views: 21291 StatSlice Systems
SSAS Data Mining Overview
 
19:20
Just an overview of SSAS Data Mining. Check out Microsoft's tutorial for more info: https://msdn.microsoft.com/en-us/library/ms167167(v=sql.120).aspx
Views: 1751 Randal Root
How Do I: Setup and Configure the Excel Data-Mining Add-in?
 
07:40
This video shows how configure to setup the Data Mining Client For Excel addin. This addin is part of the Microsoft SQL Server 2008 Data Mining Add-ins for Microsoft Office 2007 download available at: http://www.microsoft.com/DOWNLOADS/details.aspx?familyid=896A493A-2502-4795-94AE-E00632BA6DE7.
Views: 33974 DeveloperVideos
Goal Seek Analysis with Excel 2007 and SQL Server Data Mining
 
05:33
Watch this short video to learn how to use Excel 2007 and the SQL Server Data Mining add-in to do goal analysis. ie. how can you increase sales from 10 million to 30 million? Download the Data Mining add-in here: http://www.microsoft.com/sqlserver/2008/en/us/data-mining-addins.aspx Learn more about Microsoft BI here: http://blogs.msdn.com/bi
Views: 5689 wowmsft
SQL Server 2005 Data Mining Forecasting in Excel
 
04:47
SQL Server 2005 Data Mining Forecasting in Excel
Views: 6890 GarryEdser
MS SQL Server Data mining- decision tree
 
18:19
A quick example on how to do data mining using decision tree algorithm within MS SQL Server . We analyze patterns in data that is heavily skewed for specific cases so that we can validate the model.
Views: 4996 Jayanth Kurup
Introduction to Data Mining  (1/3)
 
13:34
http://www.creativecommit.com. This video gives a brief demo of the various data mining techniques. The demo mainly uses Microsoft SQL server 2008, BIDS 2008 and Excel for data mining
Views: 151120 creativecommIT
SSAS: Forecast Video Tutorial (Data Mining Table Analysis Tool)
 
04:47
In this tutorial we will learn how to use the Forecast Table Analysis Tool for Excel 2007. See the video transcript: http://msdn.microsoft.com/en-us/library/dd299423.aspx
Views: 18627 sqlserver
SSAS: Scenario Analysis - What-If Video Tutorial (Data Mining Add-in For Excel)
 
05:53
SQL Server Analysis Services: Data Mining Add-in For Excel See the video transcript: http://msdn.microsoft.com/en-us/library/dd744749.aspx
Views: 8714 sqlserver
Predicting Stock Prices with SSAS Mining Models
 
05:37
Predictive analytics and supervised machine learning with SSAS and C#. In this demo I use MS Time Series Mining structure within SSAS to predict stock prices using the Auto Regressive Integrated Moving Average (ARIMA) method. This is a bit of supervised machine learning with analysis services. I then query the mining model with SSMS and run a prediction query from a C# applications
Views: 2993 sackdeezle
SQL Server 2008/R2 Analysis Services Data Mining: An Intro
 
12:20
This video is part of LearnItFirst's SQL Server 2008/R2 Analysis Services course. More information on this video and course is available here: http://www.learnitfirst.com/Course165 Now, Scott will talk about putting Analysis Services and data mining together. He explains that there are really two parts to Analysis Services: the multidimensional part, and the data mining part, although most people just work with the multidimensional part. You will see the many uses for data mining, and get more comfortable with the basics before learning some terms in videos later in the chapter. Highlights from this video: - What can you do with SSAS and data mining? - Do you need anything other than SSAS to do data mining? - The data mining language - Example data mining reports - How much work is data mining? and much more...
Views: 5273 LearnItFirst.com
SSAS: Detect Categories Video Tutorial (Data Mining Table Analysis Tool)
 
06:41
SQL Server Analysis Services: Data Mining Table Analysis Tool Read the entire video transcript here: http://msdn.microsoft.com/en-us/library/dd299419.aspx
Views: 6133 sqlserver
DATAMINING SQL SERVER 2005
 
08:29
Data mining con sql server 2005
Views: 4523 Alice
Microsoft Data Mining Demo -- Scenario Analysis
 
04:42
Microsoft Data Mining Demo -- Scenario Analysis with SQL Server 2008 and Excel 2007
Views: 16066 MarkTabNet
SSAS: Shopping Basket Analysis Tool - Data Mining Add-In
 
04:39
SQL Server Analysis Services (SSAS): Table Analysis Tools Add-In for Microsoft Excel Video transcript here: http://msdn.microsoft.com/en-us/library/dd299410.aspx
Views: 6531 sqlserver
How to quickly generate connection string using Excel for SQL Server or Analysis Services
 
03:08
In this video you will learn how to create connection string for SQL Server or Analysis services in Excel and then you can use in Applications or such as Microsoft Dynamics to make connection to Analysis services. You can visit our blog http://sqlage.blogspot.com/ Twitter https://twitter.com/AamirSh48904922 Facebook https://www.facebook.com/SqlAge
Views: 16005 TechBrothersIT
SSAS: Highlight Exceptions  - Data Mining Add-In
 
04:29
SQL Server Analysis Services: Highlight Exceptions Table Analysis Tool for Microsoft Excel See the video transcript here: http://msdn.microsoft.com/en-us/library/dd299409.aspx
Views: 1935 sqlserver
SSAS: Prediction Calculator - Data Mining Add-In
 
07:12
In this tutorial we will learn how to use the Prediction Calculator Table Analysis Tool for Excel 2007. Go to http://msdn.microsoft.com/en-us/library/dd299414.aspx for the full transcript
Views: 4789 sqlserver
Data Mining in the Cloud Installation et prevision
 
03:37
Video exemple du blog l'Echo Pilote : http://blogs.technet.com/echopilote illustrant comment installer l'add-in Microsoft Datamining in the cloud pour MS Excel. Une fois l'installation effectuée, un exemple de prévision (forecast) est réalisé. Cet add-in permet d'effectuer directement depuis Excel 2007 sans même avoir à installer SQL Server 2008 - différentes opérations d'analyse prédictives : forecast, segmentation, analyse de panier ... Il s'agit d'une version Beta. En revanche, un add-in complet est disponible dès lors que vous avez sql server 2008, vous pouvez le télécharger sur http://www.sqlserverdatamining.com
Views: 3004 frsql
Excel at Data Mining – How to Detect Categories in Your Data
 
04:22
In this video, Billy Decker of StatSlice Systems shows you how to detect categories in your data in 5 minutes with the Microsoft Excel data mining add-in.* In this example, we will uncover hidden categories or clusterings in our data. For the example, we will be using a tutorial spreadsheet that can be found on Codeplex at: https://dataminingaddins.codeplex.com/releases/view/87029 You will also need to attach the AdventureworksDW2012 data file to SQL Server which can be downloaded here: http://msftdbprodsamples.codeplex.com/releases/view/55330 *This tutorial assumes that you have already installed the data mining add-in for Excel and configured the add-in to be pointed at an instance of SQL Server to which you have access rights.
Views: 2894 StatSlice Systems
Excel at Data Mining – Creating and Reading a Profit Chart
 
04:33
In this video, Billy Decker of StatSlice Systems shows you how to create and read a Profit Chart in less than 5 minutes with the Microsoft Excel data mining add-in*. In this example, we will create a profit chart based on a mining structure with all of its associated models that we have created previously. For the example, we will be using a tutorial spreadsheet that can be found on Codeplex at: https://dataminingaddins.codeplex.com/releases/view/87029 You will also need to attach the AdventureworksDW2012 data file to SQL Server which can be downloaded here: http://msftdbprodsamples.codeplex.com/releases/view/55330 *This tutorial assumes that you have already installed the data mining add-in for Excel and configured the add-in to be pointed at an instance of SQL Server to which you have access rights.
Views: 1135 StatSlice Systems
SQL Server 2008/R2 Analysis Services Data Mining: An Intro
 
12:20
This video is part of LearnItFirst's SQL Server 2008/R2 Analysis Services course. More information on this video and course is available here: http://www.learnitfirst.com/Course165 Now, Scott will talk about putting Analysis Services and data mining together. He explains that there are really two parts to Analysis Services: the multidimensional part, and the data mining part, although most people just work with the multidimensional part. You will see the many uses for data mining, and get more comfortable with the basics before learning some terms in videos later in the chapter. Highlights from this video: - What can you do with SSAS and data mining? - Do you need anything other than SSAS to do data mining? - The data mining language - Example data mining reports - How much work is data mining? and much more...
Views: 28747 LearnItFirst.com
Creating a Cluster Model using the Excel Addin for SQL Server
 
13:34
Clustering is the classification of similar objects into different groups, or more precisely, the partitioning of a data set into subsets (clusters), so that the data in each subset (ideally) share some common trait - often proximity according to some defined distance measure. This tutorial demonstrates how to create a clustering model using the Excel Addin for SQL Server 2008. I also have a comprehensive 60 minute T-SQL course available at Udemy : https://www.udemy.com/t-sql-for-data-analysts/?couponCode=ANALYTICS50%25OFF
Views: 8416 Steve Fox
Microsoft SQL Server Data Mining for the Cloud
 
05:55
This project experiments with data mining as a service, providing a collection of cloud-based data-mining services based on the same capabilities that are currently available in SQL Server Analysis Services.
Views: 722 MicrosoftBI
Import Excel file data into SQL Server
 
02:55
See how to import excel file data into SQL server
Views: 46373 Mamta D
Microsoft Visio Data Mining  Add in for Excel  Demonstration
 
09:03
The Visio Data Mining Add In for Excel provides a very flexible template to visualize & format data mining models produced in the Excel Data Mining Addin. This demonstration covers 4 topics - 1) what is the Microsoft Visio Data Mining Add in? 2) Why use it? 3) How to produce a data mining model in Visio using the Visio data mining wizard 4) additional 4) additional sources for information on data mining and analytics. For more videos on Data Mining using the Excel Data Mining Add In, and business intelligence Visit http://www.analyticsinaction.com/category/modeling/ I also have a comprehensive 60 minute T-SQL course available at Udemy : https://www.udemy.com/t-sql-for-data-analysts/?couponCode=ANALYTICS50%25OFF
Views: 3743 Steve Fox
Data Mining with SQL Server 2012 (Part I)
 
14:50
This is a part of SQL Server Dataming videos, this the part I. Introduction to the concepts.
Views: 13935 Rodrigo Ramos Dornel
Embedding SQL Server 2008 R2 Analysis Services Data Mining in a Custom Application
 
05:18
This demo shows how to embed a SQL Server 2008 R2 Services data mining model in a custom application to flag possible data anomalies during data entry. Presenter: Peter Myers, Mentor, Solid Quality Mentors.-Courtsey MSDN Channel9 An
Microsoft Data Mining Demo -- Fill from Example
 
03:35
Microsoft Data Mining Demo -- Fill from Example with SQL Server 2008 and Excel 2007
Views: 15341 MarkTabNet