can data analysis done using SQL Server 2005 be used in a consumer website?

I just have a simple question that can hopefully answer whether I should dive too deeply into Reporting/Analysis Services. I'm looking to run some clustering algorithms on user-inputted keywords on objects within my database (please see http://flickr.com/photos/tags/friends/clusters/ for an example of what I'm talking about). It seems to me that the various reporting methods that SQL Server provides would be an ideal, quick and easy way of providing this for my SQL Server 2005 database.

Can the reporting services provide this type of functionality? And if so, would this be scalable? I would want to be able to access this clustered data in much the same way I do queries across my database and would want them to be done quickly and efficiently.

Thank you for your help.

We hacve done tests executing up to 36 million data mining singleton queries/day on desktop hardware. Up to 240M/day on really nice hardware. This was issuing queried through ASP.NET (I believe, I know it was IIS).

Regarding the scalability of RS, you need to ask on the RS forum