Hi,
I have built a Clustering model that captures customer demographic information
and identify various hidden clusters based on the information.
What kind of predictions can I make using the above model?
I´ve developed a Clustering Model with a total population of 25,000 customers. As a result I have 10 clusters. The variables are products.
My question is:
How can I automatically detect which clusters to select if the Product Manager of Product A (one of the variables) ask me for a DataBase of customers that are more willing to by Product A? In that case I´d like to select the clusters where the penetration of product A is more than 65% and select the customers of those clusters that don´t have Product A.
Basically the question will be....How I detect with a query which is the cluster where the penetration of a given producto is more than X%
Which will be the query that I should use to extract that information?
Thanks in advance!!
Ezes
I have a question about writing a prediction query against a clustering model that has the same column added more than once.
Per Jamie, I can accomplish some crude weighting by adding a column to my model multiple times. See this post for an explnation... Now that I have that worked out, I was wondering how my DM query would look? If I have Input_A1, Input_A2 , & Input_A3 all being source from the same column in my structure do I have to reference all three when writing my prediction query?
I am using Sequence Clustering algorithm. (I've built several models with Clustering algorithm and Decision Trees for this client, which work fine.).
Background: Sequence data must be stored in a nested table, which can have only 1 non-key attribute.
I specify a mining model structure with the nested table key as the datetime, and the nested table discrete prediction column as [sort name] . this builds the model fine.
When I try to process this data mining model, I get Process failed: "Errors in the OLAP storage engine: The sort order specified for distinct count records is incorrect".
Iit may be that OLAP distinct count requests numerical data type, but not from the examples I've seen. Tried this anyway €“ doesn€™t work on numeric either €“ same problem.
Any Suggestions?
Hi! I have created a DMM using Trees. But when I go to the Mining Model Predition tab and select a Predict function, I get this in the criteria column: <Scalar column reference>[, EXCLUDE_NULL|INCLUDE_NULL][, INCLUDE_NODE_ID]. When select Result, I get this error: "An incorrect number of arguments are used in the function at line 3, column 3." I'm predicting a continuous variable.
But when I delete everything except <Scalar column reference> I get this error: "Parser: The syntax for '<' is incorrect."
When I delete everything in the criteria column, I get this: "Query execution failed."
If I change the criteria to "<Scalar column reference>,INCLUDE_NULL, INCLUDE_NODE_ID" I get the error again that the query execution failed.
I'm working from a data set I created. I had no problems with predictions using clustering, but can't seem to get Trees to work.
Hello,
I have a question regarding whether or not Data Mining can be utilized in a specific problem I have to solve.
Situation: I€™m going to simplify the problem by explaining it in terms of a €śpizza manufacturer€?. Suppose I wanted to predict the run minutes + downtime minutes (I use these to get an hourly rate: Pizzas/(run hrs + delay hrs) = Pizzas per hour) by looking at a set of input properties.
My properties could be something like the following:
# of Toppings
# of Special Pricing Stickers
Cardboard Box Indicator
Case Indicator (0 represents auto-casing, 1 represents putting in case by hand)
Machine Type (0 or 1€¦ 0 represents an older €“slower machine, 1 is newer)
Quantity of Run
(there could be up to 15 other properties that may or may not impact our rate)
Measured Values:
Run Minutes
Delay (down) minutes
Steps I€™ve Done So Far:
I€™ve created a couple different data mining models for this as I was unsure which one(s) to use. I checked the lift chart while feeding back in the original data set and my scatter plot appeared fairly inaccurate.
I've attempted to use Excel to create a linear regression, however my r squared value was always around .30. I decided to try to use SQL Server Data Mining to see if it could be something to help predict our accuracy better than a linear formula.
I've played with a couple different algorithms in Data Mining, and it appeared that none of them did exceptionally well with prediction. I even checked the lift chart using the same table as I used to train the model.
What algorithm(s) might work the best?
Can I reasonably expect a prediction within a fairly strict tolerance (I'm guessing the answer to this is: "yes, if your source data represents a consistent pattern")?
How can I best utilize Data Mining to give an answer like "historically, your run rate has been between these 2 values with a probability of X". I'm thinking I can utilize the predictprobability and stdev to some extent.
Any suggestions would be greatly appreciated.
If anyone needs further clarification, please let me know.
Thank you.
Regards,
Dan
I would like to create a simple regression equation to predict player win on their next trip. I have tried to create the model using a linear regression tree based on two players (as a test). The result gives me a single node (expected) with only a coefficient instead of a regression equation. I can do this math by hand to get a regression equation and predicted value for the next trip for each player.
The dataset I used for a simple test is.....
Trip #
Player
Win
1
1001
1,250
1
1002
50
2
1001
1,450
2
1002
75
3
1001
1,600
3
1002
100
4
1001
2,000
4
1002
175
I also tried to predict next trip worth using a forecasting model. I was able to process the model but I was not able to browse the model content in the viewer.
Ultimately, I want to predict next trip worth for individual players off of a cube. The cube has about 1.5- 6M records (multiple records per player) depending on the datasource.
FYI - I have created a working linear regression and a forecasting model off of a cube --- I think I am setting it up correctly.
Running 2005 Beta 3 Refresh. When I first deploy, it works fine. Subsequent deployments yield the following error:
View 9 Replies View Related
Hi
In this site sample €śgenerate DMX creation statement for a server mining structure and contained model€? I didn€™t understand, what is output? You say output is like a table, but I don€™t know what usage of this sample is because my request was about showing the result of time series algorithm. please notice my question, I should use a query like this for connecting with forecasting model
€śSELECT
PredictTimeSeries(amount)
From
[Forecasting]€?
And then save this value in the text box?
Also I should have training for showing value in the text box, which stage I should do it, this stage is after creating model or no?
In time series algorithm, training is equivalent of historic prediction?
In this code why these items are unknown and after running we have error
In server. Connect for server and in database db for database and in MiningStructure ms for MiningStructurewe have error .
private void button1_Click(object sender, EventArgs e)
{
Microsoft.AnalysisServices.Server server = new Server();
server.Connect("data source=localhost");
Database db = server.Databases["DMClass"];
foreach (MiningStructure ms in db.MiningStructures)
{
MessageBox.Show("Processing " + ms.Name);
ms.Process(ProcessType.ProcessDefault);
}
MiningStructure msIris = db.MiningStructures["Iris"];
MiningModel mm = msIris.CreateMiningModel(true, "newModel");
mm.Algorithm = MiningModelAlgorithms.MicrosoftClustering;
mm.Update();
mm.Process(ProcessType.ProcessDefault);
server.Disconnect();
}
Please alittle define this code.
What is diffrence between amo and adomd ?
And for viweing prediction vlue in textbox and connecting I can use both of them
And how can I build a child form?Thanks a lot for your answers
Lets take the following example:
Movie train table:
ID Class
1 +
2 +
3 -
4 +
5 -
Actor train nested table:
ID MovieID Gender
1 1 F
2 1 M
3 1 F
4 1 F
5 2 M
6 2 M
7 2 F
8 3 F
9 3 F
10 4 M
11 4 M
12 4 F
13 4 F
14 5 F
15 5 M
We want to build a classifier model in order to predict the Class of a Movie based on the Gender of movie's actors. To deal with the nested table Analysis Services maps each record of the nested table to an attribute of the case table. These attributes are named Actor(n).Gender with n = 1..15, and so they are dependent on the nested table record numbers. Both Microsoft Decision Trees and Microsoft Naive Bayes algorihms use these attributes without any modification.
We are implementing a Relational Naive Bayes algorithm and we are planning to aggregate such attributes in order to make them independent of the nested table record numbers.
Next step we tried to predict some unseen cases and here we face with
a very huge problem.
Lets take more two tables of unseen cases:
Movie test table:
ID Class
6 +
7 NULL
8 NULL
Actor test nested table:
ID MovieID Gender
1 6 F
2 6 M
3 6 F
4 6 F
16 7 F
17 7 M
18 7 F
19 7 F
20 7 F
21 8 M
22 8 M
23 8 F
Predicting the movie 6 Class is not a problem since the movie actors were included in the training dataset and when the records are mapped to attributes because they already exist in the model. But when you
try to predict movies (7 an 8) with unseen actors all new attributes are simply ignored in the ALGORITHM:redict call (in_ulCaseValues is zero!) because they do not exist in the model!
What is the solution?
We have 2 env. : Testing and Production, both are running Windows 2003 Enterprise Server with SQL Server 2005. The difference is Testing is NOT running Windows cluster but Production do so, what is the best way to transfer a database from testing to production?
We have another systems that both testing and production are running on NON-cluster and we use backup/restore to transfer the database, can it apply in this case.
And I found that there are a tools called DTC, which can transfer all DB objects from one DB to another, is it a best way to transfer between non-cluster and cluster env.?
I need to develop a language specific dwh, meaning that descriptions of products are available from a SAP system in multiple languages. English is the most important language and that is the standard. But, there are also requirements of countries that wants productdescriptions in their language.Â
Productnr Productdesc Language
1       product    EN
1       produkt    DE
One option is to column the descriptions, but that is not very elegantly. I was thinking of using bridge tables to model this but you have to always select a language in a filter (I think)..
I'm thinking of a technical solution, such that when a user logs on, the language is determined and a view determines whether to pick a certain product table specific for a certain language. But then I don't have the opportunity to interchange the different language specific fields in a report (or in my case PowerPivot).
We have the following scenario,
We have our Production server having database on which Few DTS packages execute every night. Most of them have Bulk Insert stored procedures running.
SO we have to set Recovery Model of the database to simple for that period of time, otherwise it will blow up our logs.
Is there any way we can set up log shipping between our production and standby server, but pause it for some time, set recovery model of primary db to simple, execute DTS Bulk Insert Jobs, Bring it Back to Full recovery Model AND finally bring back Log SHipping.
It it possible, if yes how can we achieve this.
If not what could be another DR solution in this scenario.
Thanks Much
Tejinder
Hi all,
I have MS Time Seeries model using a database of over a thousand products each of which has hundreds of cases. It amazingly takes only a few minutes to finish processing the model, but when I click Mining Model Viewer to view the models, it takes many hours to show up. Once the window is open, I can choose model for different products almost instantly. Is this normal?
hi !!i have a question about the connected and disconnected model to access the Sql server DB.......i know that there is better to choose one rather than the other in some situantions and there is no better model in all cases...... os i hope you can help me to decide what shall i choose...i will use the DB to connect to Web services and read data from the DB and wrtie some data back.......i do not know that to use ..... i hope you advise me and tell me about the rules that will allow me to choose what model to choose .... i appreciate your help!!Thanks !!!
View 2 Replies View RelatedI get the following error when I try to load the mining model in the mining model viewer
Query (1, 6) The '[System].[Microsoft].[AnalysisServices].[System].[DataMining].[NeuralNet].[GetAttributeValues]' function does not exist.
I get a similar error when I try to load the Load Mining Accuracy Chart
Failed to execute the query due to the following error:
Query (1, 6) The '[System].[Microsoft].[AnalysisServices].[System].[DataMining].[AllOther].[GenerateLiftTableUsingDatasource]' function does not exist.
I have OWC 11 installed. What am I missing here?
Thanks
What is clustering?Why is it done?
Any suggestion appreciated.
Cheers!
I need to cluster two NT Enterrpise Servers with SQL 7 running on them. I have been looking all over the Net for info but not much luck. I need to have some specifics. Can you help me with some good sites or books or both? I have tried Microsoft and they had some info but not much.
Please help!
thanks
We are in the process of consolidating all our SQL6.5 and SQL7 databases to a single SQL 7 server - once completed we want to setup a 2 node SQL7/2000 cluster on either NT4 Enterprise or W2k Advanced Server. I would therefore appreciate any advice in choosing between the two platforms based on cost, ease of setup & configuration and ongoing reliabilty & uptime etc - we currently have no NT4 Enterprise Servers so would have to purchase these licenses anyway. Correct me if I am wrong but I also understand that setting up a cluster on NT4 Enterprise is considerabely more complicated and time consuming than on W2K Advanced Server? Any advice would be greatly appreciated..
regards
Marcfw
I have a job interview and I need to know what type of questions can be asked about working in a cluster environment, I don't have much experience in clustering, can someone please give me an idea?
Thanks in advance!!
Can I implement failover clustering between SQL Server 2000 & SQL Server 7.0? Or do they both need to be the same version of SQL Server.
View 3 Replies View RelatedI have a question relating more to documentation and support. I'm trying to find documentation on clustering.
I remember quite some time ago I found a white paper that literally walked you through every step involved in setting up a SQL Server failover cluster. I had also found a white paper that walked you through setting up an Active/Active cluster.
I've been going through Microsoft's site, but all I've found are little bits and pieces.
If anyone can point me in the right direction, or even provide a link, etc. as to where to find some good solid documentation, that would be awesome.
Thanks!!
Anthony
If i have an activepassive cluster for SQL Server, under what circumstances would it prompt to automatic changeover to the passive cluster ? Failure of the SQL Server, or let's say 1 user database out of 25 becomes suspect?
View 1 Replies View RelatedIs this possible with Express Edition.
We have two servers both running SQL 2005 express. Is there anyway that any changes on one could be replicated on the other?
Thanks
HiI would like to know if it's possible to make a basic SQL cluster withwindows 2003 server and SQL 2000 standard edtition. It has to be abasic cluster, I dont need it to be very quick, I can have minutes ofservers down and it's ok.In case the answer is Yes, can you recommend some links to build itup, please?Thanks in advance!!Ignacio
View 2 Replies View Relatedwhat is clustering tell me in detail
We currently have a cluster configuration that is running as failover with one shared SAN storage solution. Two servers running Windows Server 2003 Enterprise and SQL 2005 Enterprise. We have two nodes right now running in failover and we will be purchasing a third.
Everything is working now, but we would like to move to an N+1 configuration with two active nodes hosting a separate SQL instance each with one failover node. I've seen N+1 mentioned on about a dozen Microsoft websites, but I cant find any documentation on how to setup or configure this clustering method. Has anyone ever set up a configuration like this or seen any documentation on how to do it? Is it possible to run failover with three nodes, two of them being active?
Any insight would be greatly appreciated.
Hi,
Where can I post issues with SQL 2005 clustering. Is there any prereq that needs to be followed before installing SQL 2005 on a windows cluster?
Thanks
Hi All,
Is anyone can tell me the difference between log shipping and clustering? I look at it and I think that this is the same thing as they use two different servers.
TIA
Does anyone know the answers to either of these, given that we are talking about an active/passive cluster using MSCS, and we use Groupwise for mail (don't ask!)?
1) How do I configure Agent Mail on the cluster under this setup?
2) How do I set up linked servers from this setup to other (non-clustered) SQL servers - I can set up the cluster virtual server as a linked server from the others OK, but the other way around doesn't work - perhaps not surprisingly, but is there a way around it?
Thanks
Martin
I need some documentation on how to trouble shoot clustering SQL7EE. I have setup the cluster and looks like it is working but I missed somthing. When I test a failover by pulling the Network cable to the main network not the heartbeat network both boxes lock up. I can failover by powering down one box and using the MSCluster Admin. I am using NT40 6a on Dell PowerEdge 2400 and PowerValut 211s
View 3 Replies View RelatedIs any doing any using Microsoft's Clustering technology as a failover
system with NT/SQL Server ?
Those of you who are using MS Clustering, what are some advantages vs. a third party product such as "Double-Take" ? If you have used "Doube-Take" I would be extremely interested in your thought of the product.
Is it relatively easy to setup and configure with and environment
that's using all the standard products of BACKOFFICE (SQL Server 7.0 Standard Edition, NT 4.0 Standard Edition etc...)
Any hints, tips, etc... would be also GREATLY appreciated.
Thanks in advance.