excel data mining add-in for categorical data

Hi my friends,

I do have a problem with results of clustering algorithm with my categorical data.
In reality I have a big table with one's and zero's and I try to cluster according to 60 attributes.
I tries to cluster to two categories many times but I get only one cluster. What do you suggest. Which values can I change to the algorithm? Is there anything particular for categorical data ?

Thank for your help in advance.

Manolis

First, check Properties of your clustering model then AlgorithmParameters ->Set algorithm parameter; look at CLUSTER_COUNT parameter- it define the number of cluster in model- default is 10, maybe it has value 1.

Second explain the significance of your data with a set o sample so we can make a suggest.

|||

The way the cluster algorithm works is it starts from a semi-random starting point (it uses the data distributions and randomly jitters them) using the number of clusters you choose (or the number of auto-detected clusters). If, during the clustering operation, two clusters are coincident, it merges the clusters and creates a new randomized starting point. Of course, this can end up coincident with another cluster as well. In the end, any remaining coincident clusters are merged.

I could imagine a scenario where the data is distributed such that a probabilistic model of two clusters always results in merging, yet a model of more clusters could produce an interesting model. So one thing to try would be to increase the number of clusters to see what you have.

Another option is to not use the default probabilistic clustering method and switch to K-means. You will not be able to access this parameter through the Table Analysis Tool "Detect Categories" button or the simple "Cluster" button on the DM ribbon. You need to use the advanced "Create Model Manually" option where you explicitly select an algorithm and there's a button for parameters. The appropriate parameter is "CLUSTERING_METHOD".

HTH

-Jamie

Every time job property changes

Dear friends,

Every time i open the jobs propertimes on server, it changes the sql server login to windows from sql authentication. also the properties i set at the time of creating a job had given me an option to select the run as user but from that moment the option has gone, whats that all about?

thanks,

This is a SSIS forum. Is this an SSIS related issue? otherwise, I could moved this thread to the Database Engine forum http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=93&SiteID=1|||

Thanks,

How to move this?

Rafael Salas wrote:

This is a SSIS forum. Is this an SSIS related issue? otherwise, I could moved this thread to the Database Engine forum http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=93&SiteID=1

|||

Dear Rafael Salas, can you please move this thread to the database engine forum, or else as being a simple member of msdn forums can i do this? if yes then how?

thanks,

|||

thanks, but how do i prevent those changes.

thanks,

Evaluation of Database Administrators and Developers of SQL server!

Hi friends !
We are in the process of annual evaluation of our database
administrators and developers for SQL Server. Their jobs
cannot be evaluated as of accountants and our sales Team because
their projects are always of on going nature.
What is the best way for their evaluation ?
Please advise !Evaluate them against agreed objectives and performance metrics I
expect. Is that a problem? If they aren't expected to meet any targets
then I'm not sure what you want to evaluate.
David Portas
SQL Server MVP
--|||strange question....
Typically DBAs rated on Performance, up time, customer satisfaction
Developers rated on projects on time, on budget and meeting custom
expectations (requirements)
Greg Jackson
PDX, Oregon|||Did you have a contract. If so, what are the expected results for the
contract. That should be the ONLY valid/fair evaluation. Anything else the
consultants outside of the contract is not contractually bound. Tis not
appropriate for evaluation.
-oj
"IMRAN SAROIA" <imransaroia2000@.hotmail.com> wrote in message
news:ukAsmFRFFHA.2564@.tk2msftngp13.phx.gbl...
> Hi friends !
> We are in the process of annual evaluation of our database
> administrators and developers for SQL Server. Their jobs
> cannot be evaluated as of accountants and our sales Team because
> their projects are always of on going nature.
> What is the best way for their evaluation ?
> Please advise !
>|||Are you wanting to evaluate the performance of the DBA group as a whole or
each individual relative to the group?
"IMRAN SAROIA" <imransaroia2000@.hotmail.com> wrote in message
news:ukAsmFRFFHA.2564@.tk2msftngp13.phx.gbl...
> Hi friends !
> We are in the process of annual evaluation of our database
> administrators and developers for SQL Server. Their jobs
> cannot be evaluated as of accountants and our sales Team because
> their projects are always of on going nature.
> What is the best way for their evaluation ?
> Please advise !
>|||We want to evaluate on individual basis ?
Problem is that we have very few developers i.e. 5 and 2 DBAs.
Due to the changing and urgent requriements their 50% of projects
remain unfinished ?
"IMRAN SAROIA" <imransaroia2000@.hotmail.com> wrote in message
news:ukAsmFRFFHA.2564@.tk2msftngp13.phx.gbl...
> Hi friends !
> We are in the process of annual evaluation of our database
> administrators and developers for SQL Server. Their jobs
> cannot be evaluated as of accountants and our sales Team because
> their projects are always of on going nature.
> What is the best way for their evaluation ?
> Please advise !
>|||With constantly changing requirements, it's hard to judge if the project is
really only 50% complete. Do the DBA have an understanding of how the
business operates? Do they prioritize their tasks according to which are
most important to management? When a crisis occurs that demands immediate
action, do they step up to the plate and get a functional solution in place
so the business is not negatively impacted?
"IMRAN SAROIA" <imransaroia2000@.hotmail.com> wrote in message
news:OUkc7TdFFHA.2460@.TK2MSFTNGP09.phx.gbl...
> We want to evaluate on individual basis ?
> Problem is that we have very few developers i.e. 5 and 2 DBAs.
> Due to the changing and urgent requriements their 50% of projects
> remain unfinished ?
>
> "IMRAN SAROIA" <imransaroia2000@.hotmail.com> wrote in message
> news:ukAsmFRFFHA.2564@.tk2msftngp13.phx.gbl...
>