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.
Example showing Why
MSBI?
Let’s understand this picture by taking an example of an
organization. Let’s take the example: - Calvin Klein (CK). We have outlets of
Calvin Klein (CK) in most parts of India. Every outlet stores their customer
data in their respective database and it’s not mandatory that every outlet is
using the same database. Some outlets may have Sybase as their database, some
might be using oracle or some stores prefer storing their data in simple text
files.
Before proceeding ahead with our explanation, we should know
“what OLTP is”? It stands for Online Transaction Processing. These are
basically the online transactions (Insert, Update, Delete) performed on
database at every outlet by the customer.
No comments:
Post a Comment