How MS BI drives Business Intelligence?. . . Part 2
As part of below architecture we are continuing rest of the important terms in BI Processes with MSBI Tools:
Centralized Database and Data Marts:
To answer the question of “Need all the data four completion of analytics”, we create a Data Warehouse out of different data sources.
To achieve this data warehouse from different data sources we need SSIS as MSBI Tool. Brief definitions for terms covered under this section are:
- Data Warehouse:
A complete database for all the data required in analytics for Organization, prepared out of different data sources having all types of data.
MS BI tool which Extract-Transform- Load data from different data sources to one Data warehouse.
- Data Marts:
As per basic definition, Data marts are part or say subset of Data Warehouse which stores data specific to a category or department of Organization.
But mostly in BI Practice we store all the data required in Data Warehouse (in case we don’t have a staging data base) and prepare a Data Mart with specific de-normalized structure of Dimensions and Facts tables. So this Data Mart will have the immediate (and specific) data for cube preparation.
A cube is multidimensional database to view facts with different perspectives. Dimensions are different perspective to view measures and facts in cube.
- See last 5 years production (Dimension : Time and Fact: Sales)
- See top selling cities (Dimension: City or Geography and Fact: Sales)
- See revenue based on different category of products (Dimension: Product Category and Fact: Revenue)
So we use SSAS, Power Pivot and Tabular Model to create a cube out of Data Warehouse or Data Mart.
Let’s give a look to different terms under this section:
- BISM (the cube):
This is multidimensional database which holds data at aggregated level for different perspectives (dimensions). A cube relates and aggregate different tables from DW. So a readymade data for fast retrieval from huge lump (DW) is available in BISM Model.
MS BI Tool for creating a cube from DW. Visual Studio provides Analysis Services Project to create Cubes which use DW as data source and build a multidimensional database on top of it.
- Power Pivot:
An Excel add on which attach an extra workbook (green in color ;)) with excel working as Data store. This data can be stored in form of Table and then specify relationship among the tables. And you are done. You can use this workbook as cube, which again provide you aggregated data for different perspectives.
- BI Semantic Tabular:
A new version of Power Pivot with Visual Studio Interface. I’ll suggest to look an old post for better understanding on differences from above two MS BI tools (post What is BISM).
Most important part, which prepare final outcome of BI Solutions. This is the part which an end user sees. We query Cubes for data input in the reports. We create these reports for better understanding of the analytics and it could be in any form as Metrics, Tables, Graphs, Charts, KPIs, Gauges, Scorecards, Dashboards etc.
MS BI Tool which provide best solution for different kinds of reports. We get a lot of options for representing a report in different forms (charts, graphs, tables, matrices, KPIs, Bars, Range Charts, Gauges etc.)
- Performance Point Services:
A MS BI tool which earlier came integrated with SharePoint but now available individually. It provides rapid creation of PPS reports which could be in any form and at the same time forms can be changed just by right click. An easy tool for report generation along with flexibility of creating custom parts. Most of the scorecards and Dashboards come under this umbrella.
SharePoint is one of the remarkable tools by Microsoft but here we will talk about only its BI related stuff. It provides different reporting mechanism like integration of SSRS, PPS and Power View etc. Moreover BI solutions in MS BI are finally prepared on SharePoint. Every report, dashboard and scorecard is integrated in SharePoint under different pages of a Portal.
A form of report which display growth and goals. It compare the performance using KPIs (Key Performance Indicator) and use visual indicators for success, failure, effort, achievements etc.
A collection of reports and scorecards. It works as a container for different types of reports and pages.
A complete web portal dedicated to BI Engagement for an Organization. It covers different reports and all other BI related objectives like security (to authenticate and authorize). It’s actually a SharePoint website for Organization based on its BI needs.
- Data Mining
This is a different kind of reporting done on cube which is covered in SSAS. A form of predictive analysis based on historical data. Well we will discuss a lot more about this in upcoming posts.
Posted on September 26, 2012, in Begin BI and tagged BI Architecture, BI End to End Solutions, BI Solutions, Cube, Data Mart, Data warehouse, Definition in BI, MS BI, MSBI Reporting, MSBI Tools, Sharepoint, SSAS, SSIS, SSRS, Tabular Model, What is BI, What is Business Intelligence. Bookmark the permalink. 1 Comment.