MSBI is an acronym for Microsoft Business Intelligence. It’s the Microsoft suite comprising of various tool for implementing Business intelligence solutions.
Using MSBI we will get an opportunity to work on 3 areas of Business Intelligence.
- SSIS – Which will help us to perform ETL operation or in simple words. It will be used to fill Data warehouse.
- SSAS – Let us create Cube out of Data Warehouse. We will talk about cube in detail as we move further. For now, just take cube as one more storage space like Data Warehouse but here data will be stored in more performance efficient manner. Data retrieval will be faster here compared to normal Data Warehouse.
- SSRS – Let us create reports which display data in nice graphical way with the help of various charts, images etc. SSRS reports are final source of information to end user. By looking into end user will make decisions.