SQLServerCentral.com / Data Warehousing / Data Mining InstantForum.NET v99.99.99SQLServerCentral.comhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 09 Dec 2016 10:38:37 GMT20Need Help in finding data within rangehttp://www.sqlservercentral.com/Forums/Topic1822565-2797-1.aspxThanks for all support here.I have a table which has quantity,price ,item,date. I am trying to develop a stored procedure where I pass the quantity and item name and fetch the price applicable for the quantity range for the date. The data in this table can be any number of records for an item.Exampleitem price quantity dateaaa 5 300 2016/9aaa 10 200 2016/9aaa 15 100 2016/9aaa 6 250 2015/5aaa 15 50 2015/5bbb 50 100 2016/9 bbb 30 300 2016/9ccc 40 150 2016/8ccc 80 50 2016/8ccc 100 30 2016/8Now if I pass item aaa and quantity 50, it should give me price of 15 as a result. It should ignore all data that is for year 2015 as we now have latest data for the item for year 2016.The search should work as a range for quantity fetching its corresponding price.like for item a qty 0-100 price 15qty 100 to 200 price 10 qty 200 to 300 price 5and &gt; 300 price 5I am not sure how to approach to the solution. Did lots of research and brain crunching...but no good solution.I appreciate your help.Thanks,shruthy Fri, 30 Sep 2016 16:57:06 GMTshruthyIs SQL Server data mining still an option?http://www.sqlservercentral.com/Forums/Topic1680181-2797-1.aspxI just saw a (new?) book entitled "[url=http://www.amazon.co.uk/Mastering-Server-2014-Data-Mining/dp/184968894X/ref=sr_1_1?ie=UTF8&qid=1429982127&sr=8-1&keywords=Mastering+SQL+Server+2014+Data+Mining]Mastering SQL Server 2014 Data Mining[/url]"...Following Microsoft BI developments, I was under the impression that "on Premise" SQL Server data mining was a dying bread and that it was simply getting replaced by Machine Learning (cloud based)...Did I get that wrong? :doze:Is there still a point starting using SQL Server (on premise) data mining, or should we skip this and head straight for the clouds?ThanksEricSat, 25 Apr 2015 11:23:16 GMTEric MametNeed help on Sorting...http://www.sqlservercentral.com/Forums/Topic1785523-2797-1.aspxCan Any one help me on below query?_________________select WES.CUSTOMER_ORDER_LINE.ORDER_NO, WES.CUSTOMER_ORDER_LINE.STATE, WES.CUSTOMER_ORDER_API.get_ORDER_ID(ORDER_NO)TYPE, WES.CUSTOMER_ORDER_LINE.CUSTOMER_NO, WES.CUSTOMER_INFO_API.Get_Name(CUSTOMER_No), WES.CUSTOMER_ORDER_LINE.CATALOG_NO, WES.CUSTOMER_ORDER_LINE.CATALOG_DESC, WES.CUSTOMER_ORDER_LINE.REVISED_QTY_DUE, TO_CHAR(WES.CUSTOMER_ORDER_LINE.PROMISED_DELIVERY_DATE,'IW')UGE, DECODE(WES.CUSTOMER_ORDER_API.get_ORDER_ID(ORDER_NO),'MNO',1,'KNO',1,0)NON_W, DECODE(WES.CUSTOMER_ORDER_API.get_ORDER_ID(ORDER_NO),'RNO',1,0)RES, WES.CUSTOMER_ORDER_LINE.WANTED_DELIVERY_DATE, WES.CUSTOMER_ORDER_LINE.PROMISED_DELIVERY_DATE, WES.CUSTOMER_ORDER_LINE.PLANNED_DELIVERY_DATE, WES.CUSTOMER_ORDER_LINE.DATE_ENTERED, LINE_NO, WES.CUSTOMER_ORDER_API.get_STATE(ORDER_NO) STATE, DECODE(WES.sales_part_API.Get_catalog_group(contract,part_no), '10',1,0)SALES_GROUP From WES.CUSTOMER_ORDER_LINE Where (UPPER(WES.CUSTOMER_ORDER_LINE.STATE) like UPPER('Frigivet') or UPPER(WES.CUSTOMER_ORDER_LINE.STATE) like UPPER('Released') or UPPER(WES.CUSTOMER_ORDER_LINE.STATE) like UPPER('Reserveret') ) and WES.CUSTOMER_ORDER_LINE.CATALOG_NO not in ('1','4','8','248','251','252','VF','XXXXX','3000','%SERVICE%','DI%','249') and WES.CUSTOMER_ORDER_LINE.CATALOG_NO not like 'DI%' and WES.CUSTOMER_ORDER_LINE.CATALOG_NO not like '%SERVICE%' and WES.CUSTOMER_ORDER_LINE.CATALOG_NO not like 'FRAGT%' and WES.CUSTOMER_ORDER_LINE.CATALOG_NO not like 'CONT%' and WES.CUSTOMER_ORDER_LINE.CATALOG_DESC not like '%FREIGHT%' and WES.CUSTOMER_ORDER_LINE.CATALOG_DESC not like '%FRACHT%' and UPPER(WES.CUSTOMER_ORDER_LINE.CATALOG_DESC )not like UPPER('%Ordretilgang%') and WES.CUSTOMER_ORDER_API.get_STATE(ORDER_NO) not in ('Planlagt','Spærret') order by to_char(WES.CUSTOMER_ORDER_LINE.PLANNED_DELIVERY_DATE,'YYYY-IW') [ASC], DECODE(WES.CUSTOMER_ORDER_API.get_ORDER_ID(ORDER_NO),'MNO',1,'KNO',1,0) [ASC]______________________________I am not getting desired result for above.I want to sort the data first by "Planned Delivery Data" and than by "Order No".Thanks in advance.Regards,Viral PandyaThu, 12 May 2016 02:03:54 GMTviralbpandyaNetezzahttp://www.sqlservercentral.com/Forums/Topic1675014-2797-1.aspxCan SSAS access data stored in Netezza?Tue, 07 Apr 2015 09:30:14 GMTkbattaData mining toolhttp://www.sqlservercentral.com/Forums/Topic1622273-2797-1.aspxHi FolksIs there any data mining tool that can be used in sql server analysis services to result better?ThanksAndrewFri, 03 Oct 2014 04:12:23 GMTJasonClarkUnable to dynamically add multiple excel files into SQL Server 2008http://www.sqlservercentral.com/Forums/Topic1630948-2797-1.aspxDear forum members,I have several hundreds of excel files that I must transfer data to SQL Server 2008 with service pack 1. So i created a Integration Services Project in BIDS 2008. Am using a For each loop container and needless to mention it works successfully when I simply use a single excel file and write it dynamically to SQL server but when I add multiple excel file in the source folder, on executing the package, I get the following error[center][OLE DB Destination [20]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "The statement has been terminated.".An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "Violation of PRIMARY KEY constraint 'PK__BasicDat__E43AF61B58D1301D'. Cannot insert duplicate key in object 'dbo.BasicData'. The duplicate key value is (01010100102).". [/center]All the excel files have the same structure. I have created a SQL Task that creates the table at run time.I use a For each loop container and have used two package level user defined variables fileName that stores the first excel file name and file path that stores the absolute path to the directory that holds the excel files. I have already disabled Validate 64 bit runtime to FalseMy understanding is that each time the for loop run it will pick up a new file and append its contents to the SQL table. My question therefore is what am i doing wrong? Thank you for your time in helping me understand what am I missing.Cheers,AshishTue, 04 Nov 2014 23:48:21 GMTAshish Duttitemsets in association algorithmhttp://www.sqlservercentral.com/Forums/Topic1630600-2797-1.aspxI have created a mining model using association rules. I see a list of itemsets after running the model. How can i bring that list of itemsets into a SQL table?it would be great if each item in an itemset is put into a separate columnMon, 03 Nov 2014 12:43:50 GMTvatsal01Error processing Mining Model...http://www.sqlservercentral.com/Forums/Topic1592849-2797-1.aspxHi everyone, I'm new in this of DM, and started reading a series of articles from here, but in the first one I got some problems when I tried process mining model, when I started to process got this message:TITLE: Microsoft Visual Studio------------------------------The tree graph cannot be created because of the following error:'Error (Data mining): The 'DTModel' referenced model has not been processed.Query (1, 6) Execution of the managed stored procedure GetTreeScores failed with the following error: Exception has been thrown by the target of an invocation..'.------------------------------ADDITIONAL INFORMATION:Error (Data mining): The 'DTModel' referenced model has not been processed.Query (1, 6) Execution of the managed stored procedure GetTreeScores failed with the following error: Exception has been thrown by the target of an invocation.. (Microsoft OLE DB Provider for SQL Server 2012 Analysis Services.)------------------------------BUTTONS:OK------------------------------thanks for your help...Tue, 15 Jul 2014 16:23:09 GMTJuan de la cosadata mining using SSAS design questionhttp://www.sqlservercentral.com/Forums/Topic1216664-2797-1.aspxHello -I have a design question and want to understand whether my problem could be solved using SSAS data mining and if yes, which algorithm will be useful.I have a revenue fact table with dimension keys for say, dim A, dim B, dim C and dim D along with date dim. ( I have already built a cube for this) I want to predict my revenue for dim A and also simultaneously see effect of dim B, dim C and dim D on the behavior of this prediction. so, for example I want to see prediction of my revenue by region. But then I should be able to select a product and see the prediction by region for that product and so on for other dimensions.I tried time series algorithm but found that i can have one time series with one date dim and one other dimension only. I can't have dim A and dim B simultaneously on time series along with dim date. (Is it true? or I'm missing something).What other possible algorithms i can use for this kind of scenario and how to model that in SSAS?Any help is appreciated.Thanks,AmeyMon, 05 Dec 2011 13:31:20 GMTamy3672Sigma Value of each tree node in Decision Tree algorithm of SSAShttp://www.sqlservercentral.com/Forums/Topic1590709-2797-1.aspxHello All,I am trying to get the sigma value of each tree node in decision tree. Please let me know if any one has any idea.Regards,Mahesh BalshetwarWed, 09 Jul 2014 06:51:20 GMTmahesh balshetwarDoes anyone know how to show output of MS_Time_Series output on SSRS reports?http://www.sqlservercentral.com/Forums/Topic1580791-2797-1.aspxI have requirement where in I need to show the output of MS Time Series (Data Mining using SSAS) on SSRS report? Is it posible and if yes, is there some sample available which I can use it for my understanding?Regards,Mahesh BalshetwarFri, 13 Jun 2014 23:24:23 GMTmahesh balshetwarDoes anyone know how to show output of MS_Time_Series output on SSRS reports?http://www.sqlservercentral.com/Forums/Topic1580792-2797-1.aspxI have requirement where in I need to show the output of MS Time Series (Data Mining using SSAS) on SSRS report? Is it posible and if yes, is there some sample available which I can use it for my understanding?Regards,Mahesh BalshetwarFri, 13 Jun 2014 23:24:23 GMTmahesh balshetwarPredictive Analysis and Forecastinghttp://www.sqlservercentral.com/Forums/Topic1539020-2797-1.aspxHi,I am new to Data Mining. Please help me for my new assignment which i am going to start.1) Can we do prediction without time series algorithm.For example I am having University Past Data and I want to predict and forecast about below points.a) Predict Analysis Marital Status wise whether student will join the course or Not?b) Forecast whether student will pass or fail or drop the course by using his prev education data etc.I am new to Data Mining. Can somebody help me how can i start?ThanksAbhas.Fri, 07 Feb 2014 00:00:26 GMTabhasError Time Series algorithmhttp://www.sqlservercentral.com/Forums/Topic1537459-2797-1.aspxI'm doing the tutorial from msdn for Serial Time algorithm. To process it I get the following error:Error 1 Error (Data mining): Usage of all non-key columns in the 'Forecasting' mining model must be set to PredictOnly. Someone may guide me. thanksMon, 03 Feb 2014 12:07:18 GMTcbugari 89990Need to find date of Nth crash for every car_make in every countryhttp://www.sqlservercentral.com/Forums/Topic1531366-2797-1.aspxI have a table similar to the one below. I need to find: date of Nth crash for every Car_Make in every countryAny thoughts? ThanksCountry Crash_Date Car_MakeUS 10/19/2012 ToyotaUS 10/18/2012 RoverUS 10/17/2012 HondaUS 10/16/2012 RoverUS 10/11/2012 ToyotaJP 11/09/2010 HondaJP 11/08/2010 RoverJP 11/05/2010 HondaJP 11/04/2010 RoverJP 11/03/2010 HondaJP 10/01/2010 HondaGB 05/01/2011 RoverGB 05/05/2011 HondaGB 05/03/2011 RoverGB 05/05/2011 HondaGB 03/05/2011 HondaGB 07/05/2011 RoverGB 05/07/2011 HondaGB 05/09/2011 RoverGB 01/01/2011 RoverWed, 15 Jan 2014 18:43:52 GMTgoodfaithuserData crossing/intersectionhttp://www.sqlservercentral.com/Forums/Topic1503928-2797-1.aspxHello,I need an intelligent system to do some data crossing. The amount of data is very big and it is stored on MSSQL. All the records from different servers should be compared and linked if similarities are found, based on different criterias.My question would be, which is the best way, based on performance, to do this and what tools should be used? Maybe NoSQL structures to store all the data? And what algorithms may provide the most adequate results?Every solution/idea would be greatly appreciated ! :)Thank you !Fri, 11 Oct 2013 03:39:38 GMTralu_k_17Opening existing package - Data Mining query is missing! Cryptographic errorhttp://www.sqlservercentral.com/Forums/Topic1497008-2797-1.aspxI am opening an existing SSIS package at a new job and when I do that, the encryptSensitiveWithUserKey setting was saved (default) and I get a cryptographic error. When I try to open the data mining task, the query is gone completely. I did not save the package. Is there any way to recover this query? I do not know where to begin to re-create it.Fri, 20 Sep 2013 13:04:00 GMTjshoveruse of different datamining algorithmshttp://www.sqlservercentral.com/Forums/Topic1480100-2797-1.aspxI would like to know which algorithms is considered best for doing data mining.In which scenario clustering should be used or Neutral network should be used how to decide on that for data mining in real life data predictions.Thu, 01 Aug 2013 12:54:38 GMTsej2008Datamining Training and Testing setshttp://www.sqlservercentral.com/Forums/Topic1479506-2797-1.aspxI am working on data mining need to understand difference between testing and training sets when you require to specify while creating datamining structure in sql2008Wed, 31 Jul 2013 08:23:00 GMTsej2008Understanding mining model viewer for different algorithmhttp://www.sqlservercentral.com/Forums/Topic1457502-2797-1.aspxHi,I am new to Data Mining and would like to understand the output thet gets generated with different data mining model structure such as Decision Tree orClustering or Naive Bayes.Not getting how to analyze the data in model viewer.I used AdventureworksDW2008 data base.Can anybody explain in detail.Tue, 28 May 2013 13:55:09 GMTsej2008Simple (I think!) Clustering Question (Please help!)http://www.sqlservercentral.com/Forums/Topic1455313-2797-1.aspxHello All,Long time reader, first time writer!!I am having some trouble with SSAS and data mining - specifically the Microsoft Clustering package.I intend to ultimately do my work in AMO and MDX, but for now, just happy to understand how it works in the BIDS via Visual Studio. One step at a time!The whole problem is around clustering both "vertically" and "horizontally" (separately) from a table that is organized vertically. My main source data table in my OLTP database looks like =&gt;[b]ID_NUM[/b][i]{numbers 1 - 20,000}[/i][b]TECK_ID[/b][i]{numbers 1-500, {for each ID_NUM}}[/i][size="1"](though just grabbed a few of these for playing around with the data in the screencaps)[/size][b]TECK_VALUE[/b][i]{a double, the 'fact' bit}[/i]So- 10 million rows, of two ints and a double.Which looks like this- [url=http://i.imgur.com/KG1LhaJ.jpg]http://i.imgur.com/KG1LhaJ.jpg[/url]So I create a new Analysis Services project in Visual Studio, set up a Data Source, and bring in the above table, as well as two "dimension tables" (identity of what id_num is, names of what each teck_id is) into a Data Source View and link it up, matching up the appropriate keys.Which looks like this- [url=http://i.imgur.com/Q0vgwIc.jpg]http://i.imgur.com/Q0vgwIc.jpg[/url]Next I want to manipulate how my data is represented, so I go to set up a cube from this Data Source View. I create dimensions based on my two "dimension" tables (the above "id_num" primary key one, and the "teck_id" primary key one), and create a single measure (as sum) of the teck_value column from my main table. This all seems to compile successfully.Which looks like this- [url=http://i.imgur.com/y5pUSjh.jpg]http://i.imgur.com/y5pUSjh.jpg[/url]The reason I think everything has worked well is I can arrange my data how I want by browsing the cube. I am able to define my "rows" as both the id_num, or as the "teck_id", with the other one filling up the columns. The measure "Teck_value" always makes up the dataset of the table. This is exactly how I want it, the flexibility to arrange my data both ways. Which looks like this- [url=http://i.imgur.com/ugLUkgg.jpg]http://i.imgur.com/ugLUkgg.jpg[/url]And this- [url=http://i.imgur.com/RwQgj58.jpg]http://i.imgur.com/RwQgj58.jpg[/url]Beautiful! Now I wish to do some mining on this basis!I wish to, quite simply, using Microsoft Clustering to (separately) - - Assign each TECK_ID a cluster number based on how it varies on each ID_NUM - Assign each ID_NUM a cluster based on how it varies on each TECK_IDSeemingly a simple requirement - just changing what is represented as "rows" and what as "columns" - which I already appear to be able to do through the cube browser. This seems to be one of the main points of OLAP rather than OLTP from my uneducated perspective!Yet when I try to set this up I fail utterly!The Clustering Wizard leaves me confounded and I come up with nonsense results. I am given the option of selecting a key (for which I can choose either of the above), but no option to parse by the other dimension. Indeed, the only thing I can choose to mine on is TECK_VALUE, which isn't any good as that doesn't separate out the different fields!My wizard looks like this- [url=http://i.imgur.com/lHfasv0.jpg]http://i.imgur.com/lHfasv0.jpg[/url]So, I am left in a pickle. I really don't want to go back and line up my OLTP databases horizontally because 1) this would mean having 20k columns when I try to categorize my TECK_IDs. and 2) I was hoping SSAS and OLAP can give me the flexibility I need to mine the fields that I want - isn't that part of the reason you set up a cube "chop up the data how you like" ?SQL Server Central - Please help an OLAP noob make his first steps into this dangerous new world!!:arrow:Tue, 21 May 2013 23:51:07 GMThardcore.ninjaData Mining Interview Questions & Answershttp://www.sqlservercentral.com/Forums/Topic1410429-2797-1.aspxWhat is Spatial data mining?For more Data Mining Interview Questions & Answers visit http://www.coolinterview.com/type.asp?iType=811Wed, 23 Jan 2013 02:51:00 GMTsajisharmaCan we display Future year sales forcating using SSAS with predictions?http://www.sqlservercentral.com/Forums/Topic1373061-2797-1.aspxCoz Its analyzing only what we pushed data and shows diagrammatically.. not for Future year , If possible can any one suggest me to do...Tue, 16 Oct 2012 01:15:45 GMTSaravanan_tvrData mining on a single tablehttp://www.sqlservercentral.com/Forums/Topic1391380-2797-1.aspxHello everyone,I am wondering, is it possible to have data mining on a single table with a large amount of data?The given table is about sales and contains all the needed info (SellerType, ShopLocation, ItemCategory, ItemCondition, Sold, Price, ShippingCost).I tried to create a data cube but I can only get one dimension.What I want to exam is the affect shipping cost has on sales based on category, or the price based on condition and category, etc.Any thoughts?Thank you in advance.Fri, 30 Nov 2012 08:46:02 GMTChriz L.Need Adventureworks2008R2DW BAK filehttp://www.sqlservercentral.com/Forums/Topic1387485-2797-1.aspxI am working through 70-448 book and am now in the Data Mining chapters. I think I must have modified some data along the way because some of the citical built in views return no rows. I am looking for a clean BAK file to restore. Does anyone know where I can get one?Wed, 21 Nov 2012 09:28:00 GMTrmatthias001Very new to Data Mininghttp://www.sqlservercentral.com/Forums/Topic1000386-2797-1.aspx Hi All As I am very new to Data Mining. I like to know 1. What is Data Mining. 2. How it is different from Business Intelligence. 3. What are way's to implement it. 4. How is market (Job) for the same. ThanksThu, 07 Oct 2010 06:47:10 GMTsaurabh.deshpandeOnline Data Mining Degree Programs?http://www.sqlservercentral.com/Forums/Topic1269585-2797-1.aspxHi all, I'm looking for more education in data mining / predictive analytics, and am considering the online MS in Predictive Analytics at Northwestern University. Does anyone have any experience with this program, and care to share their thoughts on it? It's fairly expensive, and so I'm looking to gather as much info on it before committing to it. I did take an online course in data mining at Central Connecticut State, which wasn't that bad, but I'm considering other programs. Any info appreciated. If there's a better place to post this question, please let me know.Thanks, SteveTue, 20 Mar 2012 08:13:16 GMTzintpwhat is meant by "Dataware Admin.?"http://www.sqlservercentral.com/Forums/Topic1323426-2797-1.aspxI want to know exactly what does data ware administrator do,what is the role of their job and what i need to study for that , I had studied a subject called "Data ware housing and data mining" still i have no idea about this position please do reply your valuable comments:-)Sat, 30 Jun 2012 03:02:21 GMTzaid4elinear regression "simple" dmxhttp://www.sqlservercentral.com/Forums/Topic1313509-2797-1.aspxI am trying to build and run a dmx linear regression to predict some data. data is in the format: key_id, 1979,1980 - 2010, sales2010, sales2011 example 1,100,200, ... , 500,600 (many rows of this). the x values are 1979 - 2010 numbers. the y value would be sales2010 How would you write this in dmx language? (how do you designate x and y value data?)Sat, 09 Jun 2012 10:32:44 GMTfoxjazzGDMX Errorhttp://www.sqlservercentral.com/Forums/Topic1276362-2797-1.aspxI have a data base (testmining) with 2 tables in my engine service,these 2 table are connected with customer_id column as a primary key in customer and foreign key in purchaseand i have a database (mining) in my analyses service on my sql server 2008 ,so i create a mining model in my mining database on analyses services :Create mining model MarketBasketModel(CustomerId long key,Gender text discrete,Income long continuous,MemberCard text discrete,Purchases table Predict_Only (ProductName text key,Quantity long continuous))Using Microsoft_Decision_Treesso when i want to execute this command :Insert into MarketBasketModel_Structure( CustomerId, Gender, Income, MemberCard,Purchases( ProductName, Quantity) )OpenRowset('SQLOLEDB', 'Server=EHSAN-PC;Integrated Security=SSPI','Shape{ Select Customer_id, Gender, Income, member_cart From testmining.dbo.Customer }Append ({ Select Product_Name, Quantity From testmining.dbo.Purchase }Relate testmining.dbo.Customer.Customer_Id to testmining.dbo.Purchase.Customer_id ) as Purchase')i got this error :OLE DB error: OLE DB or ODBC error: Syntax error or access violation; 42000Sun, 01 Apr 2012 08:36:32 GMTLarry Page(Ehsan.Akbar)Help with Data-Mining \ Clustering questionhttp://www.sqlservercentral.com/Forums/Topic1268741-2797-1.aspxI am totally new to this data-mining business. I would like for someone to point me in the right direction, plese. In my business - I will have a database with several tables (let's assume MS SQL Server). For the sake of example, I have a 'person' table and an 'purchases' table (each person can make several different purchases).Here is an example of the 'person' table:* ID* First Name* Last Name* Address*Date of BirthHere is an example of the 'purchase' table:* Date of Purchase* Time of Purchase* Store Location* Number of Items Purchased* Total Purchase AmountWhat I would like to do is:I would like to perform 'data-mining' in order to find out the "categories", or "clusters" of characteristics, that define each [b]'purchase amount'[/b].Meaning - my target 'column' is the 'purchase amount' column.Now I want to know all the different clusters of fields that produce each 'amount' in this column.For example - I would like to know what is common for all the people who bought between 2,000$ and 2,500$ ?Maybe they all came from the same neighbourhood ?Maybe all of them were young & came from the same neighbourhood?Maybe there are 2 distinct different groups that fit the '2000$-2500$' spending group ?I am almost sure there are different categories (or distinct clusters) that match each price group...one might be old people that come to buy at night, another might be middle-aged people who buy more than 10 items, and another might be middle-aged people who buy one Sundays.From what I understand, this falls under the 'data-mining' region ([b]clustering maybe?[/b])Is this true ? and if so, what are the tools I must use in order to find out these set of parameters that define the different groups for each pricing category?As you can see, I have no idea which tools \ applications I should use.Someone recommended installing an add-in for Excel that could do the trick, but this seems rather too simple.Someone else mentioned BI (don't know what exactly to do there)...I know there is also the 'Microsoft Analysis Services'. Does that help me in any way ?Thank you very much !JohnSun, 18 Mar 2012 10:47:52 GMTjsminer2011Mining System logshttp://www.sqlservercentral.com/Forums/Topic1265906-2797-1.aspxAny of you guys tried mining system logs pushed to a DB to correlate events across a network? I hoping to find someone who has tried this as to learn from their mistakes. Let me know if you guys have any ideas.ThanksTue, 13 Mar 2012 07:40:51 GMTcw.izattThings you wish you would have found about Data Mininghttp://www.sqlservercentral.com/Forums/Topic1253974-2797-1.aspxI basically want this thread to be a good way for the newbs like me to get up to speed with some of the knowledge the veterans have. For example did you guys find books or web posts that when you read them helped you understand data mining better than before? If so post them up. I am trying to get myself up to speed on Data mining because i think the business is going to want it in the future. Any help in that process from you guys would be awesome and i thank you ahead of time. ChrisFri, 17 Feb 2012 09:14:57 GMTcw.izattSSAS Drillthought action to a queryhttp://www.sqlservercentral.com/Forums/Topic1253479-2797-1.aspxI'm still fairly new with drillthrough actions. I want to create an action that runs a query and extracts columns from a table which is related by key but for which it's not practical to create a dimension. Is there a way to have a drillthrough query? Say, for example, I have a location dimension and user dimension and I aggregate and show that I have 1500 people living in my region and I want to right-click and drillthrough to a query that takes those associated userID's and pulls back the associated addresses and phone numbers (which is NOT in it's own dimension).Ideas?DonalithThu, 16 Feb 2012 14:55:43 GMTErin Ramsayis primary key compulsary in clustering?http://www.sqlservercentral.com/Forums/Topic1235426-2797-1.aspxCan we fing clusters of following data?Id P1 P2x 5.6 4.5x 1.6 4.5y 5.6 4.5having 2 clusters?Fri, 13 Jan 2012 01:28:45 GMTvnjExcel 2007 Add-in for Data Mining suddenly failshttp://www.sqlservercentral.com/Forums/Topic1176943-2797-1.aspxI have a Virtual Machine withServer 2003SQL Server 2008 R2Office 2007Visual Studio 2008... which worked fine for a while...Like a knucklehead, I installed 2010 on it, and the data mining extensions for Excel failed. (Big surprise!)Uninstalled 2010, reinstalled 2007, but still no joy. It seems that the 2010 install overwrote something and now the Data Mining Extensions in Excel no longer work.Right now I'm thinking my best option is to rebuild the VM.Sorry if this is more an Excel question... I'm just kind of baffled! Any pointers would help!ThanksSat, 17 Sep 2011 19:26:03 GMTpietlindenIs any one know about Clustering methods..?http://www.sqlservercentral.com/Forums/Topic1176209-2797-1.aspxIs any one know about Clustering methods.. 1.Scalable EM 2.Non-Scalable EM 3.Scalable k-means 4.Non-Scalable k-means..Fri, 16 Sep 2011 00:30:11 GMTmiriyalasriharihow to calculate support in Association ruleshttp://www.sqlservercentral.com/Forums/Topic1173250-2797-1.aspxin my Microsoft Association RuleAccountID as key,YardID as Predictable Column..by using MS Association rule, i created one mining structure that containsItemset as YardID &lt; 29size as 1support as 8793here i don't know how to calculate this support...plz help me...Mon, 12 Sep 2011 03:33:30 GMTmiriyalasriharideploying errore in ssrs how to solve ithttp://www.sqlservercentral.com/Forums/Topic1145165-2797-1.aspxI got an error while deploying my report: The permissions granted to user machineNameuserName are insufficient for performing this operation. After reading the posts in the forum, I realized that my RS setup may be incorrect. On http://localhost/reports, Contents and Properties tabs are missing... Please let me know how I can correct the problems. I am using SQL Server 2008, and I have admin rights on my local machineWed, 20 Jul 2011 09:34:10 GMTasrananthaData Mining with MS SQL Server 2008 (book)http://www.sqlservercentral.com/Forums/Topic1047887-2797-1.aspxHas anyone read the book [url=http://www.amazon.com/Data-Mining-Microsoft-Server-2008/dp/0470277742/ref=sr_1_1?s=books&ie=UTF8&qid=1295014131&sr=1-1]Data Mining with Microsoft SQL Server 2008[/url]?If yes, it it worth the read? Or should I avoid it?Fri, 14 Jan 2011 07:11:13 GMTKoen Verbeeck