Microsoft 400x400

Microsoft BI Review
It made data correlation between the agencies fast. Our expectation is to get real-time data collection systems in the maritime environment.


Valuable Features:

  • It provides easy integration with the Office tools.
  • It is easy to understand BI architecture.

Improvements to My Organization:

Microsoft SQL Server BI made data correlation between the agencies so fast, that the simple POCs for the dashboards let the decision-makers to migrate our so-called enterprise architecture. Enterprise architecture is the integration of ETL, CDC, DWH, reporting and forecasting tools.

Room for Improvement:

Our expectation is putting BI to work in real-time data collection systems in the maritime environment.

The Automatic Identification System is a great source of data regarding the ships from around the world. From kinematic to static including some commercial data, it streams to the maritime monitoring stations. So, collecting and processing of this data and also, creating useful information are the key factors for our government entity. However, this data is real-time data which means that the process should be done in seconds for thousands of ships. We are forcing the boundaries of the Microsoft BI product right now and wish to see some stream data processing methodologies in the future.

Use of Solution:

I have used this product for a year and a half year.

Stability Issues:

The product was pretty stable but when it comes to collect real-time data we encountered some data dropping issues.

Scalability Issues:

Sometimes, the scalability becomes an issue; instead of horizontal scaling, we always need vertical scaling

Technical Support:

The technical support in Turkey is very good.

Previous Solutions:

We were using some open-source BI tools. It was very difficult to get support for open-source and that is why we switched to Microsoft.

Initial Setup:

The setup was okay because Microsoft integrated BI to the SQL product. Instead of using a special product, you get the sense of using native add-on libraries for BI. It is a part of the database process. Training is the key here.

Cost and Licensing Advice:

I don't want to speculate but there is room for at least 45% discount as compared to the initial price. So bargain wildly with Microsoft.

Other Solutions Considered:

We evaluated other open-source alternatives.

Other Advice:

You will need training personnel and powerful servers.

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

0 Comments

Anonymous avatar x30
Guest

Have A Question About Microsoft BI?

Our experts can help. 229,168 professionals have used our research on 5,846 solutions.
Why do you like it?

Sign Up with Email