Microsoft BI Review

​MS BI comes with all the tools and it is to the best of my knowledge the most affordable solution​.​


What is most valuable?

MS SQL & SQL Server Analysis Services.

How has it helped my organization?

We provide BI solutions to the users at every level in order to monitor business. We can deploy DWH, cubes and reports from scratch within weeks of implementation.

What needs improvement?

SQL Server Reporting Services (SSRS) is not user friendly, requires development. Power BI will surely provide a huge boost to MS BI in terms of self-service BI. Then again, SSRS developers are plenty, thus not so expensive.

For how long have I used the solution?

Ten-plus years.

What do I think about the stability of the solution?

Stability issues are due to bad hardware sizing, bad forecast of volumes, or bad data modeling.

What do I think about the scalability of the solution?

Only when data models were faulty of when the infrastructure was not compliant to MS recommendations.

How are customer service and technical support?

Tech support from Microsoft, when needed, is as efficient as can be.

Which solution did I use previously and why did I switch?

Worked in different technical environments but never saw a switch from MS BI.

How was the initial setup?

Developers and architects are easily available for this technology.

What's my experience with pricing, setup cost, and licensing?

MS BI comes with all the tools and it is, to the best of my knowledge, the most affordable solution.

What other advice do I have?

Watch your data model, use data marts when possible, set your archiving/purge policy from the beginning, size your hardware well (unless on cloud).

Disclosure: I am a real user, and this review is based on my own experience and opinions.
Add a Comment
Guest