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.
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.
Microsoft provides some tools to transform your business data into information. We can use these tools with the interface of Visual Studio.
With the release of SQL Server 2012, Business Intelligence Development Studio (BIDS) was renamed to SQL Server Data Tools (SSDT).
SQL Server Data Tools(SSDT)
The following provides a brief description of BI Tools:
These are the three tools we are using for ETL, Analysis and reporting in MSBI.
SQL Server Integration Service (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.
We can process the data from various locations and various formats (source locations) and save the data into a centralized repository as a Data Warehouse/Data Mart (destination).
It includes graphical tools and wizards for building and debugging packages.
This tool is used for the integration like duping the data from one database to another like from Oracle to SQL Server or from Excel to Sql Server etc.
This tool is also used for bulk transactions in the database like inserting lac’s of records at once.
SQL Server Analysis Service (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.
This tool is used to analyse the performance of the sql server in terms of load balancing, heavy data, transaction etc. So it is more or less related to administration of the SQL Server using this tool.
This is very powerful tool and through this we can analyse the data inserting in to the database like how many transactions happens in a second etc