SQL Server 2012 is picking up and recently lot of people has started asking questions around it and here the favorite SQL Server analysis service interview question.
BISM stands for Business intelligence semantic model. It’s actually unifies Multi-dimensional model plus tabular model. In the previous SSAS ( SQL Server analysis ) version if we want to do analysis, your database design structure needs to comply with OLAP model. In other words we need to define the structure in Fact and measures (star schema or snow flake).
But then there are certain classes (developers, people working with excel) of people who are very comfortable with tabular formats. Where people think in terms of tables and relationships. That’s where tabular model is introduced.
So if you are pure corporate BI guy, use your Multi-dimensional model and if you are happy going personal BI person (developer, simple end user who uses excel) you can use Tabular model
I have taken this answer from chapter SQL Server 2012 interview question which is published by Bpb publication.
Click here to see Most asked SQL Server database design interview questions.
write a comment