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: 34254 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: 9507 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: 5722 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: 21847 wowmsft
Data Mining Addin For Excel
 
08:17
Data Mining Addin For Excel using External Server
Views: 995 IntroToIS BYU
SIM-Excel Data MIning
 
01:08
Animated Video created using Animaker - https://www.animaker.com Tutorial data mining pada excel
Views: 43 UG-IA05(2016)
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: 1964 ExcelB2B
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: 74364 Steve Fox
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: 7794 Steve Fox
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: 6866 aguazzel
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: 8463 Steve Fox
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: 2015 Lucita287
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
Microsoft Data Mining Demo -- Fill from Example
 
03:35
Microsoft Data Mining Demo -- Fill from Example with SQL Server 2008 and Excel 2007
Views: 15591 MarkTabNet
Simple data cleansing in excel data mining
 
02:08
Simple data cleansing with excel
Views: 4269 Monica Tremblay
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: 21795 StatSlice Systems
Microsoft Excel Data Mining: Classification
 
06:49
Microsoft Excel Data Mining: Classification. For more visit here: www.dataminingtools.net
Microsoft Data Mining Demo -- Scenario Analysis
 
04:42
Microsoft Data Mining Demo -- Scenario Analysis with SQL Server 2008 and Excel 2007
Views: 16103 MarkTabNet
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: 18655 kjonge
Excel - Simple Linear Regression
 
07:56
Simple Linear Regression using Microsoft Excel
Views: 275336 Jalayer Academy
สอน 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: 6579 prasertcbs
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: 4809 sqlserver
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: 5159 Steve Fox
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: 18701 sqlserver
Microsoft Data Mining Demo -- Forecasting
 
02:16
Microsoft Data Mining Demo -- Forecasting with SQL Server 2008 and Excel 2007
Views: 8211 MarkTabNet
Scoring a datase with Excel data mining add-ins
 
01:41
Describes how to score a dataset using excel add ins
Views: 1110 Monica Tremblay
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: 109838 Deepak EduWorld
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: 1550861 ExcelIsFun
Deteccion de Categorias, Data Mining SQL Server 2008 y Office 2007
 
10:59
este video muestra un ejemplo simple del uso de la opcion de deteccion de categorias, del plugin de mineria de datos de sql server 2008 para office 2007. Rudy Alvarez 2004 13405
Views: 2818 Rudy Alvarez
Microsoft Data Mining Demo -- Analyze Key Influencers
 
03:10
Microsoft Data Mining Demo -- Analyze Key Influencers with SQL Server 2008 and Excel 2007
Views: 5322 MarkTabNet
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: 778 FrontlineSolvers
Prediction Calculator
 
11:45
DataMining en Microsoft Excel 2007 Video Tutorial
Views: 320 zjji
Microsoft Data Mining Demo -- Detect Categories
 
04:11
Microsoft Data Mining Demo -- Detect Categories with SQL Server 2008 and Excel 2007
Views: 5742 MarkTabNet
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: 26180 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: 6922 Steve Fox
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: 3007 frsql
Microsoft Data Mining Demo -- Highlight Exceptions
 
03:25
Microsoft Data Mining Demo -- Highlight Exceptions with SQL Server 2008 and Excel 2007
Views: 2028 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: 10235 sqlserver
Meterology Data Mining in Excel (How-to)
 
05:05
Quick tutorial on how to data mine here in Excel, from our Weatherbug site.
Views: 340 Scott Patterson
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: 1122 siilats
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: 4767 StatSlice Systems
Excel 2013 - Data Mining - Forecast What If Scenario
 
04:47
Apresentação de como usar a ferramenta de mineração de dados do Excel 2013 para previsão de Forecast. Para mais acesse: http://excelb2b.com/
Views: 361 ExcelB2B
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: 21886 My E-Lesson
SQL Server 2005 Data Mining Forecasting in Excel
 
04:47
SQL Server 2005 Data Mining Forecasting in Excel
Views: 6894 GarryEdser
Microsoft Excel Data Mining: Data Partition
 
08:45
Microsoft Excel Data Mining: Data Partition. For more visit: www.dataminingtools.net
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: 1170 StatSlice Systems
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: 2930 StatSlice Systems
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: 1940 sqlserver