Hurry! 20% Off Ends SoonRegister Now
  • Home
  • Blog
  • MSBI
  • MSBI Advantages and Its Data Evaluation Stages - MSBI

MSBI Advantages and Its Data Evaluation Stages - MSBI

MSBI Competitive Advantages

1) It is a single suite for end-to-end business solution.

2) It has extended capability for extraction, transformation and loading.

3) low-cost TCO [Total cost of ownership]

  • Easy to Install
  • Easy to use
  • Easy to maintain
  • Cheaper price

4) Highly scalable – It supports multiple instances to connect o the server without sacrificing its performances.

Before 2008

  • Instances                         
  • Linearly                      

2008 onwards

  • Instances
  • Performance(server)

The BMI is said to be a “linear scalable application” due to having CMS (central management server) and PBM (Policy Based Management) servers. (“2008R2”).

If you want to enrich your career and become a professional in MSBI, then enroll in "MSBI Training" - This course will help you to achieve excellence in this domain.

Full compatibility between the components of MSBI

– All components runs in the single runtime called ‘CLR’ [common language runtime].

i.e., it is having similar coding, Notation (naming).

– Full support to .Net, XML. and web services (universal language)

– MSBI provides very good support to the semiware house application (if we are reusing OLTP functionality in the warehouse.

MindMajix Youtube Channel

Related Article: Msbi Interview Questions

Data Evaluation Stages

System TypeTime TakenNo.of rows it operates
OLTP(Online Transaction Processing)Ex: Immediate operations booking tickets, movie tickets etc…SecondsLess
DSS(Decision Support System)Ex: The no. of saving account opened in year 2009 and 2010Minutes/ hoursMore
OLCP(Online Complex Processing)Ex: Loan ApplicationMinutes/hrs/daysMore
OLAP (Online Analytical Processing)Minutes/hrs/daysMore

OLTP and DSS are Traditional systems

OLCP and OLAP are Modern systems

 Ex: The no of saving accounts opened for the years 2009 & 2010 every month-wise and every location of INDIA & SINGAPORE.

 Explore MSBI Sample Resumes Download & Edit, Get Noticed by Top Employers!  

 

Job Support Program

Online Work Support for your on-job roles.

jobservice

Our work-support plans provide precise options as per your project tasks. Whether you are a newbie or an experienced professional seeking assistance in completing project tasks, we are here with the following plans to meet your custom needs:

  • Pay Per Hour
  • Pay Per Week
  • Monthly
Learn MoreGet Job Support
Course Schedule
NameDates
MSBI TrainingDec 24 to Jan 08View Details
MSBI TrainingDec 28 to Jan 12View Details
MSBI TrainingDec 31 to Jan 15View Details
MSBI TrainingJan 04 to Jan 19View Details
Last updated: 03 Apr 2023
About Author

Ravindra Savaram is a Technical Lead at Mindmajix.com. His passion lies in writing articles on the most popular IT platforms including Machine learning, DevOps, Data Science, Artificial Intelligence, RPA, Deep Learning, and so on. You can stay up to date on all these technologies by following him on LinkedIn and Twitter.

read less
  1. Share:
MSBI Articles