|MSBI stands for” Microsoft Business Intelligence’. This powerful suite is composed of tools which helps in providing best solutions for Business Intelligence and Data Mining Queries. This tool uses Visual studio along with SQL server. It empower users to gain access to accurate and up-to-date information for better decision making in an organization. It offers different tools for different processes which are required in Business Intelligence (BI) solutions.
ETL (Extracts, Transform, Load) Tools
ETL means that its takes the data from various source locations, maybe as a different data format.
Transforms the data for storing it in a proper format or structure for querying and analysis purpose.
Loads it into the final target.
MSBI is divided into 3 categories :
SSIS – SQL Server Integration Services – Integration tool
SSAS – SQL Server Analytical Services – Analysis tool
SSRS – SQL Server Reporting Services – Reporting tool
SQL Server Integration Services(SSIS) :
SSIS is the ETL tool from Microsoft.
Integration Services is a platform for building high-performance data integration and workflow solutions, including extraction, transformation and loading (ETL) operations for data warehousing.
SQL Server Analysis services(SSAS) :
This is the process of converting two dimensional (rows and columns/OLTP) data into multi-dimensional data model (OLTP). This will help you to analyze the large volume of data.
SQL Server Reporting Services(SSRS) :
Microsoft SQL Server Reporting Services (SSRS) is an enterprise reporting platform supporting traditional and interactive reports delivered over the web or through custom applications. It supports various data sources like two dimensional and multi-dimensional.