Benifits of Using SSRS,SSAS, SSIS

Question

2.00/5 (1 vote)

See more:

Hello Sir,
I want to ask the benefits of using SSRS , SSAS ,SSIS and SSMS .Please guide me

SS(RS+AS+IS+MS) what's the need of it

Posted 1-Jan-12 18:53pm

Prashant Srivastava LKO

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sergey Alexandrovich Kryukov · Answer 1 · 2012-01-01T19:34:00

Solution 1

All four are very different things not related to each other beyond being related to SQL Service; only first tree are "Services". If you don't see where is the need in each, maybe you don't need them? :-) To find it out, see:

http://en.wikipedia.org/wiki/SQL_Server_Reporting_Services[^],
http://en.wikipedia.org/wiki/Microsoft_Analysis_Services[^],
http://en.wikipedia.org/wiki/SQL_Server_Integration_Services[^],
http://en.wikipedia.org/wiki/SQL_Server_Management_Studio[^].

—SA

Posted 1-Jan-12 19:34pm

Sergey Alexandrovich Kryukov

Comments

Prashant Srivastava LKO 3-Jan-12 5:35am

Hello Sir,
I want one Suggestion from you that from where you have covered the above topics I asked, you read any book or did any training,please don't mind....

Prashant Srivastava LKO 3-Jan-12 5:36am

I want personal suggestion for myself

Sergey Alexandrovich Kryukov 3-Jan-12 12:34pm

Sorry, I have no suggestions for "yourself". Suggestions for what, exactly? My zero-approximation suggestions would be -- don't use any of them as they are all extras. Don't use anything unless you need something in practice: reporting, analysis, integration... How do I know what kind of work do you do? Everyone should be able to read and draw conclusions...
--SA

Prashant Srivastava LKO 12-Jan-12 4:27am

Sir, My company doesn't work on these Business Intelligence Tools,I asked only for my practice, I want some extra skills to be in my CV, so that's why asked for your suggestion

Prashant Srivastava LKO 12-Jan-12 4:30am

Sir as you told me earlier,Until the brain will not damage one can learn so many languages,so that's why I asked could I get your perfect advices for myself, well I am eager to learn the above BI tools I asked in the question,please usher the name of any best book or any training you know so far.

RDBurmon · Answer 2 · 2012-01-02T00:51:00

These are called components of BI (Microsoft SQL Server Business Intelligence)
Like wise called as MS BI.

SSIS : SQL Server Integration Services : This service / tool is used to create ETL / packages as per business requirement and to load data mostly use for Data warehouse data migration process.

SSRS : SQL Server reporting Services : This service / tool is used to create reports as per business requirement

SSAS : SQL Server Analysis Services : Advance vesion of reporting . This is used to crated Adhoc report . Used to create cube which we can use in reporting to enable user to generate adhoc report as per there requirement

SSMS/SSME : actually it is SSME Sql Server Management environment where you can interact with sql server to do your developement , administration activities.

This all combined made for Datawarehouse.