How MS BI drives Business Intelligence?. . . Part 1
MSBI (Microsoft Business Intelligence), comprises set of tools which provide best nailing solutions for Business Intelligence engagements. These set of tools use Visual Studio interface and a part of SharePoint services along with SQL Server. MSBI offer different tools for different processes required in BI solutions.
Below is a general architecture of BI Projects and set of MS BI tools to facilitate the processes:
Basically division of MS BI tools is in three different categories here it covers all the area of BI solutions as mentioned in processes of BI Solutions (post What is BI).
Different abbreviations used in diagram are:
OLTP Online Transaction Processing DW Data Warehouse DM Data Mart BISM Business Intelligence Semantic Model DMi Data Mining
A brief intro to the different terms:
An upper bound name for all the different kind of data sources an organization can possess. These data sources have data for various purposes and stored in different mediums like SQL Server Database, Oracle, MS Access, Excel, Text, Flat files, etc. It’s about the diversity of information stored.
- Organization can have different branches across the globe and so data is spread at different locations
- Organization can have different departments so type of information is different for each department
- By the period of time, Organization can have different storage medium for data from legacy to new upcoming technologies for data storage.
Storage medium for data are required here (for e.g. SQL Server) but no other MSBI tool. In spite of this diversity of data in organizations, we need all the data for our completion of analytics.
We are covering other terms in next post as “How MS BI drives Business Intelligence?. . . Part 2”.
Posted on September 26, 2012, in Begin BI and tagged BI Architecture, BI End to End Solutions, Data sources, Data Sources in BI, dm data, general architecture, MS BI, MSBI, MSBI Tools, What is BI, What is Business Intelligence, What is MS BI. Bookmark the permalink. 1 Comment.