SQL Server interview question:- Mention SSIS, SSAS and SSRS?
All these 3 things are related to Business intelligence. Business intelligence is all about making meaning of your data, forecasting using that data, making more business sense from the data.
In order to do the same we first need to collect data, analyze it and then display it to the stake holders.
The collection of data is done by using SSIS.
The data analyzation part is done by SSAS.
The displaying of data is done by using SSRS or reporting services.
Below is a simple video in 2 parts which explains the same in more detail and with full demonstration.
Part 1:
Please click to see the Part 2 of what are SSIS, SSAS and SSRS video.
Click for more SQL Server interview questions
Regards,
Visit for more author’s blog on SQL Server interview questions
http://
http://
Contributed by:
Shivprasad koirala Koirala
I am a Microsoft MVP for ASP/ASP.NET and currently a CEO of a small
E-learning company in India. We are very much active in making training videos ,
writing books and corporate trainings. Do visit my site http://www.questpond.com for
.NET, C# , design pattern , WCF , Silverlight , LINQ , ASP.NET , ADO.NET , Sharepoint , UML , SQL Server training and Interview questions and answers
Resourse address on xpode.com
http://www.xpode.com/Print.aspx?Articleid=555
Click here to go on website
|