MSBI stands for Microsoft Business brilliance. This powerful suite is composed of tools which helps in providing best explanation for Business Intelligence and Data Mining Queries. This tool uses Visual studio along with SQL server. It empower users to gain access to carefull and up-to- date information for better decision making in an organization. It offers various tools for different processes, which are required in Business Intelligence
SSIS: (Sql Server Integration Services) This engine is used for the integration like duping the data from one database to another like from Oracle to SQL Server or from shine to Sql Server etc.This tool is also used for bulk transactions in the database like introduce lac's of records at once. We can create the integration services modules which will be do the job anti us. Integration Services are the platform for built high-performance workflow solutions and data integration, including extract, transform and loading ETL operations for data warehousing.
SSAS: (SQL Server Analysis Services) This tool is used to analyse the performance of the sql server in provisions of heavy data, load balancing, transaction etc. So it is more or less related to administration of the SQL Sevrer using this tool. This is very dynamic tool and through this we can analyse the data inserting in to the database, how much of transactions will happened in a second etc. This is the process of transforming two dimensional (OLTP) data into multi- dimensional data model (OLTP). This is help you to analyse the large volume of data.
SSRS(SQL Server Reporting Services) This tool is related to the propagation of report. This is efficient tool as it is platform independent. We can generate the report, use this tool and also use any type of applications. Now a days this is very popular in the market. Microsoft SQL Server Reporting Services is an enterprise reporting platform, which is supporting universal and collective reports send over the web or through custom applications. It supports various data sources like two dimensional and multi-dimensional.