__ MSBI stands for Microsoft Business Intelligence.

__ This tool uses Visual studio along with SQL server.

__ This powerful suite is composed of tools which helps in providing best solutions for Business Intelligence and Data Mining Queries.

__  It offers different tools for different processes which are required in Business Intelligence (BI) solutions.

 

__  It empower users to gain access to accurate and up-to-date information for better decision making in an organization.

​

 MSBI is divided into 3 entities :

    SSIS - SQL Server Integration Services. 
    SSRS - SQL Server Reporting Services. 
    SSAS - SQL Server Analytical Services. 

​

1  SSIS is basically a integration service it integrates the data from differnt format like Sybase, Oracle, Text, Excel, Mysql into one format, while doing integration it first refreshes data and cleans data. 
2  So we have achieved by keeping centralized SharePoint Server is centralized point, same protocol / medium of sharing data . 
3  If CEO request for customer information then he/she will get touch base with back-office team for customer data and in-return back-office team lets say shares information with CEO via email shares customer data. 
4  Now in this whole process if you read carefully there is an dependancy of communication. 
5  This integration process is done with the help of OLTP (Online Transaction Processing) component of MS SQL Server. 
6  SSAS use use OLAP (Online Analytical Processing) component and data mining capabilities.
7  For analyze process it build multi-dimensional structures called CUBES and build mining models to perform data analysis and to get valuable information. 
8  SSAS is analyze service, It analyzes the stored data. 
9  SSRS is reporting service, Now represent analyze data in a graphical way SSRS is used, SSRS generates reports of analyze data, Reports, Plans, Dashboards, Scorecards, Excel etc. 
10  If we centralize data on a same server our above example problem will be solved. 
11  Means accountant have organization account details, back-office team have customer information and all this data shares via different medium channel. 
12  Suppose if CEO request for any account information then he/she get touch base with accountant for information and in return accountant lets say shares information via google drive.
13  As a result collaboration between an entities becomes complex. 
14  So if we have centralized SharePoint Server then CEO, Back-Office team, accountant and end-customer will use same server and same point of sharing data. 
15  So to resolve this kind of issue "Share-Point" comes into picture. 
16  Now coming to end-customer if end-customer wants to connect to organization lets say there is an intranet/website medium to communicate with an organization visa-versa same for organization to communicate with end-customer. 
17  What is BI ? BI stands for Business Intelligence, refers to set of techniques which helps in searching, finding and analyzing best data or relevant info out of huge data for good business decision making. 
18  This will increase collaboration between entities and an information will be shared in a collaborative manner. 

​

​

​