Difference and Usefulness of SSIS and SSAS 1

[Sohailaziz]

HI All,

We are in the process of implementing a new Reporting (business intelligence system). It could be anything from BO, Proclarity, cognos etc. Our operational systems is currently sitting in Sql Server. and the database will remain SQL server even in the new reporting tool.

We are not sure yet weather the new reporting tool will require a datawarehouse or not. but moving forward, my manager want us (team) to be ready for anything..

he tasked me to find out why he should send us on SSIS and SSAS training ?

But he want this information not in technical language. becuase he will put forward the proposal infront of the board who are deciding on the reporting tool. It will great to have some examples which really prove that needs of going for these courses.

a big thanks in advance.

 

[johnherman]

SSIS will allow you to convert, transform, standardize, and customize your data. SSAS will allow you to analyze your data using OLAP, or let data mining do it for you.

====================================
The trouble with doing something right the first time is that nobody appreciates how difficult it was - Steven Wright

 

[Sohailaziz]

thanks for your reply.

Can you please explain with an example what would be OLAP and why a compnay would need OLAP ? As we got transactional database...

 

[johnherman]

OLAP is On Line Analytical Processing. It's a way to create multidimensional cubes. The cells of the cubes are measures (or metrics, or facts). The different axis of the cube are the dimensions, aspects of the business you want to study. Typical measures might be orders, revenue, cost, and profit. Typical dimensions include the product line, sales channel, geography, and time. So you could analyze profit by product, salesperson, and month (for instance).

====================================
The trouble with doing something right the first time is that nobody appreciates how difficult it was - Steven Wright