Introduction to Msbi

MSBI stands for Microsoft Business Intelligence. MSBI is a powerful suite composed of tools. This helps in providing best solutions for Business Intelligence and Data Mining Queries. MSBI users access to up-to-date information for decision making in an organization. This uses Visual studio along with SQL server. It offers different tools for different processes in Business Intelligence (BI) solutions.

Features of MSBI:

• Provides a ‘Single Version of Truth’ to make effective decisions

• Eliminates or reduces ‘Instinctive Decisions’

• Provides quick and timely answers to the business. Making it more responsive to the dynamic business trends

• Cut error-prone manual and mundane work

• Robust support for advanced analysis

• Support for Historical data

• Support for summarized data

MSBI divides into 3 categories

SSIS – SQL Server Integration Services – Integration tool.

SSAS – SQL Server Analytical Services -Analysis tool.

SSRS – SQL Server Reporting Services – Reporting tool.

The Visual studio always helps to understand any concept defines Microsoft Business Intelligence.

Example Why MSBI?

We have outlets of Calvin Klein (CK) in most parts of India. Every outlet stores their customer data in their respective database. It’s not mandatory that every outlet is using the same database. Some outlets have Sybase as their database, some might be using oracle. Some stores prefer storing their data in simple text files.

What OLTP is? It stands for Online Transaction Processing. The online transactions performed on the database at every outlet by the customer.

SSIS:

The data store in different types of customers. The data is then integrated and saved it in a centralized database. The component of OLTP is MS SQL Server component. Integration means merging of data from different data stores. The Refresh data in data warehouses and clean data is loading to remove errors.

SSAS:

The stores centralize data in Analyze. This huge data is then divided into Data Marts on which analytic process carried on. Analysis services use OLAP component and data mining capabilities. It allows building multi-dimensional structures called CUBES. The data analysis perform calculate and store complex aggregations build mining models. This helps to identify valuable information. Like what are the recent trends, patterns, dislikes of customers. Business analyst performs data mining function on multidimensional cube structure.

SSRS:

The only thing left is to represent this analysis. That an organization decision to revenue, gain the largest profit. Like in form of Reports, Scorecards, Plans, Dashboards, Excel workbooks. The revenue of report organization is specific time at specific place report organization. Where they captured the market, in which part they are lacking and needs to boost up and many other things.

This completes our diagram and I hope that you are now clear with the components of MSBI.