Home
Search results “Data mining for excel 2007”
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: 33962 DeveloperVideos
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
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
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: 21577 wowmsft
How to use the Free SofTutor for Excel 2007 2010 Data Mining Demo
 
04:26
Getting the most out of the free SofTutor for Excel 2007 / 2010 for Data Mining at http://nvsi.com/excel. There are several different ways to use SofTutor to learn about 13 different topics in excel within a few minutes.
Views: 449 SofTutor
DETECCIÓN DE CATEGORIAS - Data mining en Excel 2007
 
08:33
Esta herramienta esta incluida en el plugin de data mining de sql server 2008 para office 2007. En una tabla que contiene una serie de datos, con ella podremos identificar a los grupos que contienen perfiles similares y bajo estas características nos muestra categorías.
Views: 1995 Lucita287
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
Using datamining with PowerPivot in Excel
 
09:30
In this screencast we see how to use the excel 2007 data mining add-ins on PowerPivot data in Excel 2010. For more information see http://business-intelligence.kdejonge.net.
Views: 18636 kjonge
Meterology Data Mining in Excel (How-to)
 
05:05
Quick tutorial on how to data mine here in Excel, from our Weatherbug site.
Views: 330 Scott Patterson
(Connection to a SQL Server Table) Microsoft Office Excel 2007
 
02:59
Create a connection to a SQL server table Import data into excel as a table or pivot table report Microsoft Office Excel 2007
Views: 10804 Study Island
Microsoft Data Mining Demo -- Scenario Analysis
 
04:42
Microsoft Data Mining Demo -- Scenario Analysis with SQL Server 2008 and Excel 2007
Views: 16066 MarkTabNet
SIM-Excel Data MIning
 
01:08
Animated Video created using Animaker - https://www.animaker.com Tutorial data mining pada excel
Views: 42 UG-IA05(2016)
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: 26061 Steve Fox
Simple data cleansing in excel data mining
 
02:08
Simple data cleansing with excel
Views: 4227 Monica Tremblay
Microsoft Data Mining Demo -- Highlight Exceptions
 
03:25
Microsoft Data Mining Demo -- Highlight Exceptions with SQL Server 2008 and Excel 2007
Views: 2026 MarkTabNet
Microsoft Data Mining Demo -- Forecasting
 
02:16
Microsoft Data Mining Demo -- Forecasting with SQL Server 2008 and Excel 2007
Views: 8197 MarkTabNet
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: 10210 sqlserver
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 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: 73563 Steve Fox
Data Validation in Excel [ Hindi ] - Best Ever Explanation
 
20:43
data validation in excel - Learn how to use Data Validation tools in Excel 2007 2010 2013 2016 Hindi to improve the accuracy of the data in your spreadsheets. ignore invalid data using data validation Full detailed explanation for data validation Data Validation Part 1: https://youtu.be/U3XdCUmNaBg * Data Validation to allow only whole numbers between an upper and lower limit * Data Validation to allow only decimal numbers below or equal to an upper limit * Create an Input Message for your Data Validation * Error alert Message with "Stop" * Error alert Message with "Warning" * Error alert Message with "Information" ____________________________________________ Data Validation Part 2: https://youtu.be/-IDqfwby5MM * Data Validation drop down list using a range of cells * Data Validation drop down list using a Defined Name * Make data validation list from another worksheet in excel 2007 ____________________________________________ Data Validation Part 3: https://youtu.be/VjVpMVO8Jq0 * Data Validation to allow only dates between an upper and lower limit * Data Validation to allow only times above or equal to a lower limit * Data Validation to allow a certain text length ____________________________________________ Data Validation Part 4 : https://youtu.be/ZTlymO0uug4 * Allow only numbers in cell & Set limit of digits to accept. * Allow only text in cell & set character limit to accept. * Allow only 10 digit mobile number in cell ____________________________________________ Data Validation Part 5 :https://youtu.be/vzeWlggal88 * Prevent Duplicate Entries In Column * Allow Only Unique Entries - Avoid duplicate entries in excel using custom data validation. ____________________________________________ Data Validation Part 6: https://youtu.be/EX2ZahZ3pHo Auto Updating DropDown List In Excel Hindi || Dynamic DropDown List ____________________________________________ Data Validation Part 7:https://youtu.be/Ig245IO7lPs How To Create Data Validation Dependent Drop Down List In Excel || Best Video || Hindi || HD ____________________________________________ Data Validation Part 8:https://youtu.be/tn4ShvcvBls EXCEL ये विडियो जरूर देखें - Allow Only Entries Starting With Specific Alphabet / Text /Number ____________________________________________ Data Validation Part 9:https:https://youtu.be/WULhnIsKguU Custom Data Validation- To Allow only Uppercase Text Entries In Excel ____________________________________________ Data Validation Part 10:https:https://youtu.be/HwVbH_x6nMk How To Create Searchable Drop Down List In Excel || Hindi || HD ____________________________________________ Data Validation Part 11:https:https://youtu.be/-IDqfwby5MM how to create drop down list from another sheet in excel || Hindi | using data validation ____________________________________________ Data Validation Part 12:https://youtu.be/EX2ZahZ3pHo Data Validation Auto Updating DropDown List In Excel Hindi || Dynamic DropDown List Hope you will like the video. Thanks for watching. Deepak EduWorld के दुआरा publish की हुई playlist इस प्रकार हैं _____________________________________________________________ ADVANCED MS EXCEL के लिए ये playlists देखे: https://goo.gl/A6LdZA ADVANCED MS EXCEL FORMULAS के लिए ये playlists देखे: https://goo.gl/bbHYu2 MS WORD के लिए ये playlist देखे: https://goo.gl/B4TeSA HTML5 & CSS3 के लिए ये playlist देखे: https://goo.gl/2PFgs8 COMPUTER के TECHNICAL videos के लिए ये playlist देखे: https://goo.gl/paZmpn ------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------- Subscribe to my channel: https://www.youtube.com/deepakeduworld Like my Facebook page: https://www.facebook.com/deepakeduworld Follow on LinkedIn: https://www.linkedin.com/in/deepakedu... Facebook Group : https://www.facebook.com/groups/cse92/ *********************************************************** Thanks for Watching Happy Learning DEEPAK NEHRA ***********************************************************
Views: 98140 Deepak EduWorld
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
Microsoft Data Mining Demo -- Analyze Key Influencers
 
03:10
Microsoft Data Mining Demo -- Analyze Key Influencers with SQL Server 2008 and Excel 2007
Views: 5319 MarkTabNet
Excel Data Analysis: Sort, Filter, PivotTable, Formulas (25 Examples): HCC Professional Day 2012
 
55:13
Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm Learn the basics of Data Analysis at Highline Community College Professional Development Day 2012: Topics in Video: 1. What is Data Analysis? ( 00:53 min mark) 2. How Data Must Be Setup ( 02:53 min mark) Sort: 3. Sort with 1 criteria ( 04:35 min mark) 4. Sort with 2 criteria or more ( 06:27 min mark) 5. Sort by color ( 10:01 min mark) Filter: 6. Filter with 1 criteria ( 11:26 min mark) 7. Filter with 2 criteria or more ( 15:14 min mark) 8. Filter by color ( 16:28 min mark) 9. Filter Text, Numbers, Dates ( 16:50 min mark) 10. Filter by Partial Text ( 20:16 min mark) Pivot Tables: 11. What is a PivotTable? ( 21:05 min mark) 12. Easy 3 step method, Cross Tabulation ( 23:07 min mark) 13. Change the calculation ( 26:52 min mark) 14. More than one calculation ( 28:45 min mark) 15. Value Field Settings (32:36 min mark) 16. Grouping Numbers ( 33:24 min mark) 17. Filter in a Pivot Table ( 35:45 min mark) 18. Slicers ( 37:09 min mark) Charts: 19. Column Charts from Pivot Tables ( 38:37 min mark) Formulas: 20. SUMIFS ( 42:17 min mark) 21. Data Analysis Formula or PivotTables? ( 45:11 min mark) 22. COUNTIF ( 46:12 min mark) 23. Formula to Compare Two Lists: ISNA and MATCH functions ( 47:00 min mark) Getting Data Into Excel 24. Import from CSV file ( 51:21 min mark) 25. Import from Access ( 54:00 min mark) Highline Community College Professional Development Day 2012 Buy excelisfun products: https://teespring.com/stores/excelisfun-store
Views: 1515289 ExcelIsFun
Microsoft Data Mining Demo -- Detect Categories
 
04:11
Microsoft Data Mining Demo -- Detect Categories with SQL Server 2008 and Excel 2007
Views: 5737 MarkTabNet
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: 8709 sqlserver
Data Mining Addin For Excel
 
08:17
Data Mining Addin For Excel using External Server
Views: 952 IntroToIS BYU
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
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
Human Genome Data Mining in Excel
 
14:50
Steps importing the Human Genome into excel Pivot Tables - more to come in 2014
Views: 257 Excel Sprapps
Data Analysis In Excel Max Min Mode Median Hindi
 
08:06
Data Analysis in Excel Course- learn the basics of Data Analysis by understanding the Min formula, Max formula, Median Formula and Mode.sngl formulain Excel . The 4 formulas allow you to analysis data for basic traits like lowest value, highest value, the value in middle and the most commonly occurring value. At the end of the video there's a simple and effective chart tutorial also. To watch more videos and download the files visit http://www.myelesson.org To Buy a Excel Course DVD visit . https://www.instamojo.com/Devika/combo-pack-all-in-one-ms-excel-course-cd-in-/ 10 Most Used Formulas MS Excel https://www.youtube.com/watch?v=KyMj8HEBNAk Learn Basic Excel Skills For Beginners || Part 1 https://www.youtube.com/watch?v=3kNEv3s8TuA 10 Most Used Excel Formula https://www.youtube.com/watch?v=2t3FDi98GBk **Most Imporant Excel Formuls Tutorials** Learn Vlookup Formula For Beginners in Excel https://www.youtube.com/watch?v=vomClevScJQ 5 Excel Questions Asked in Job Interviews https://www.youtube.com/watch?v=7Iwx4AMdij8 Create Speedometer Chart In Excel https://www.youtube.com/watch?v=f6c93-fQlCs Learn the Basic of Excel for Beginners || Part 2 https://www.youtube.com/watch?v=qeMSV9T1PoI Create Pareto Chart In Excel https://www.youtube.com/watch?v=2UdajrDMjRE How to Create Dashboard in Excel https://www.youtube.com/watch?v=RM8T1eYBjQY Excel Interview Questions & Answers https://www.youtube.com/watch?v=Zjv1If63nGU
Views: 20270 My E-Lesson
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 /
Excel at Data Mining - Time Series Forecasting
 
05:44
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 forecasting model that will predict the trend of bikes sales in different regions. 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: 4682 StatSlice Systems
forecasting ms excel 2007
 
07:02
Data mining, predicciones
Views: 1183 Josue Perez
Excel 2013 - Data Mining - Analyze Key Influencers
 
04:49
Apresentação de como usar a ferramenta de mineração de dados do Excel 2013. Analise de Principais Influenciadores Para uma tabela com dados de compra de bicicletas, este video mostra como usar a ferramenta de mineração de dados para descobrir principais perfis que compraram mediante variaveis declaradas ( estado civil, genero, região, etc). Para mais acesse: http://excelb2b.com/
Views: 1936 ExcelB2B
สอน Data Mining: การติดตั้ง Data Mining Add-ins สำหรับ Excel 2013
 
11:52
การติดตั้ง Data Mining Add-ins สำหรับ Excel 2013 เพื่อให้ Excel สามารถเรียกใช้บริการ Analysis Services ของ SQL Server 2014 ในการทำ data mining ==ดาวน์โหลด Data Mining Add-ins สำหรับ Excel 2013 ได้ที่ http://www.microsoft.com/en-us/download/details.aspx?id=35578
Views: 6173 prasertcbs
Microsoft Excel Data Mining: Classification
 
06:49
Microsoft Excel Data Mining: Classification. For more visit here: www.dataminingtools.net
Prediction Calculator
 
11:45
DataMining en Microsoft Excel 2007 Video Tutorial
Views: 319 zjji
Microsoft Excel Data Mining: Data Partition
 
08:45
Microsoft Excel Data Mining: Data Partition. For more visit: www.dataminingtools.net
Excel - Simple Linear Regression
 
07:56
Simple Linear Regression using Microsoft Excel
Views: 247211 Jalayer Academy
Excel at Data Mining – How to Randomly Sample Your Data
 
04:51
In this video, Billy Decker of StatSlice Systems shows you how to randomly sample and oversample data in less than 5 minutes with the Microsoft Excel data mining add-in*. In this example, we will create a random sample and oversample the bike buyer source 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: 1465 StatSlice Systems
Excel Statistics 08: Install Excel 2007 Data Analysis Add-in
 
02:44
Download Excel Files: Start File: https://people.highline.edu/mgirvin/AllClasses/210M/Content/ch00/Busn210Ch00IntroToExcel.xlsm Finished File: https://people.highline.edu/mgirvin/AllClasses/210M/Content/ch00/Busn210Ch00IntroToExcelFinished.xlsm Full Page With All File Links: http://people.highline.edu/mgirvin/excelisfun.htm See how to Install Data Analysis Add-in using Excel Options and the Add-in Feature. This is a beginning to end video series for the Business & Economics Statistics/Excel class, Busn 210 at Highline Community College taught by Michael Gel ExcelIsFun Girvin
Views: 224015 ExcelIsFun
ADAPA Add-in for Excel 2007 - Demo
 
06:21
Everyone has data in Microsoft Office Excel and knows how to use it. So far so good, but how to score this data using predictive analytics? The answer: by using the new Excel add-in developed by Zementis. With the ADAPA Add-in for Microsoft Office Excel available in our website (www.zementis.com), anyone can access the power of predictive analytics directly from their desktop. Predictions are now literally at your fingertips. ADAPA is a standards-based decision engine that executes predictive models expressed in PMML on-demand. The ADAPA Add-in allows users to score data and execute models from inside Microsoft Office Excel 2007. This is remarkable, since it frees users from having to deal with all the technology required for deploying and executing predictive models. With the Excel add-in, all one has to do is to select the data for scoring (or the columns containing the relevant data) and pressing on the "Score" button in Microsoft Office Excel ... et voila' ... scores are generated automatically for every single data row. It does not get easier than this.
Views: 6852 aguazzel
Analyze Key Influencers Tool.  Excel Data Mining Add in
 
15:20
Demonstration of how to use the "Analyze Key Influencer Tool" using the Excel Data Mining Add in. The video covers 1) What is the "Key Influencer Tool"? 2) What sort of business problems can it help answer? 3) A practical example. 4) A Comparison to "Decision Tree" classification models. Visit : http://www.analyticsinaction.com/category/modeling/ for more videos in Analytics, Data mining & 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: 5137 Steve Fox
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 Data Mining Software from Frontline Systems
 
01:17
This is Part 7 of 7. Frontline Systems' advanced data mining software add-in for Microsoft Excel. Use XLMiner Platform/Pro tools to get the most from your data. Go here to see the full playlist http://youtu.be/ehe2RYnBcXs?list=PLTMrxZeq4dutOgKhXw8ZcYf7oRzbKYe1p
Views: 761 FrontlineSolvers
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
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