Hello everyone! I have a Data Mart in SQL Server 2000 and have established an Excel 2002 file that accesses several OLAP cubes from the Database. In addition I've put in a few user forms which allow the user to query the warehouse based on a number of drop down list boxes (ie, show me all customers who have been here in the past X months who have averaged between X hundred and Y hundred dollars per Day [or Trip or Overall], etc.) These are done using dynamic sql strings.
The next step I'd like to add is to implement Data Mining based either on tables in the warehouse or on the cubes - but I'm not at all sure how this will be implemented. I'm aware of all the mining Wizards in Sql Server 2k, but I'm not sure how the decision making users will be involved.
Is there a friendly user interface that allows them to allocate weights to various business factors and train data sets, or is this something that the administrators will set up with their input? Should I just go through the Wizards myself for familiarity and then have the President sit with me and complete the Wizards per his input, or is there a good 3rd party software program that allows a nontech user to do it all themselves? Any help would be much appreciated!
The next step I'd like to add is to implement Data Mining based either on tables in the warehouse or on the cubes - but I'm not at all sure how this will be implemented. I'm aware of all the mining Wizards in Sql Server 2k, but I'm not sure how the decision making users will be involved.
Is there a friendly user interface that allows them to allocate weights to various business factors and train data sets, or is this something that the administrators will set up with their input? Should I just go through the Wizards myself for familiarity and then have the President sit with me and complete the Wizards per his input, or is there a good 3rd party software program that allows a nontech user to do it all themselves? Any help would be much appreciated!