MSBI Features:

MSBI Features:

1. SSIS  : it acts like ETL to perform Load & Unload Operations
2. SSAS : It creates Multidimensional Objects & Provides Multidimensional Analysis
3. SSRS : Generate Reports From IS Loaded Table & AS created Data Base
4. SSNS : sends/Receives notifications according to the Events.                                                                    Eg: Sending an Email when SSIS execution is Successful/ Over.
5. Full Support to MS-Office
6. Full Support to Data Mining
7. Full Support to Report Builder
8. Full Support to Proactive Caching
9. Hosted CLR : However .NET Languages running under a single Run Time(CLR)                     Similarly MSBI also runs under CLR
10. Advanced TSQL : They are many keywords added in 2005 to satisfy the demands of BI