Data Analysis

We have b2b portal. We have team of data management ,sales & client support working on data.

I want to analyze data from many aspects.

Is there any data mining tool available in dot net with which i can create analysis system.

So that i can get analysis & required data with out querying the database every time.

Means i can save my analysis in one warehouse, After some period i l replicate this data.

How i would do this????
Umesh ModiAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Curiosity overwhelms me ... if you have 'a team of data management', wouldn't that team be led by someone that would know this?  Seems like by asking the question here you do not have faith in this person.

So you have two needs here:  a data warehouse and analysis.

SQL Server SSIS and the native T-SQL querying language will allow deveoperts to build data warehouse solutions.

SQL Server SSAS is a tood designed for data mining and various analyses.

Of course there are other tools available.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
DB Reporting Tools

From novice to tech pro — start learning today.