Microsoft 400x400

Microsoft BI Review
Despite vague error messages, some functions were cut down from 90 seconds to about less than one second


Valuable Features:

  • SQL Server Integration Services 
  • SQL Server Management Studio

Improvements to My Organization:

There have been occasions when a certain application would work very slowly on other DB platforms and once we migrated to SQL Server the response times improved dramatically. For example, I recently migrated an application from TeraData to SQL Server and the response times for some functions were cut down from 90 seconds to about less than 1 second! This obviously speeds up the work that gets done within a day.

Room for Improvement:

The SQL Server Reporting Services can certainly use some more help. Within SSIS, I see room for more connectors and easier debug messages that would speed up the process of development. The biggest hurdle that any developer comes across is vague error messages.

Use of Solution:

About eight to nine years.

Deployment Issues:

No. The installation and deployment process has always been smooth and simple.

Stability Issues:

No. Product is very robust and reliable.

Scalability Issues:

Adding extra machines to the cluster environment is not difficult but certainly needs experienced developers/implementers to do that.

Customer Service:

Excellent. They usually turn around within good time and you can also request new features directly from the group that is responsible for the product.

Technical Support:

9/10

Previous Solutions:

A different solution was not used previously.

Initial Setup:

I have been to many projects and usually the setup is pretty straight forward. But even when it comes to complicated setups such as multiple clusters, the product still seems easy once understood.

Implementation Team:

In-house implementation.

Cost and Licensing Advice:

It varies from place to place. But a typical license would cost anywhere from a few thousand bucks to the upper $20k-$30k range.

Other Solutions Considered:

  • MicroStrategy
  • TeraData
  • Informatica.

Other Advice:

Look at the amount of data that you have and the amount you anticipate in the future. If you have multiple sources of data and multiple applications consuming it, sticking to a single solution might not be the best idea.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
1 visitor found this review helpful
Reviewer148614 li?1414338641

0 Comments

Have A Question About Microsoft BI?

Our experts can help. 203,620 professionals have used our research on 5,518 solutions.
Why do you like it?

Sign Up with Email