Microsoft BI Review

We were able to improve the performance of our reporting system. Monitoring features and SSIS Connectors need improvement.


How has it helped my organization?

By building the multi-dimensional database with Analysis Services, we were able to improve the performance of our reporting system. Now, our end-users can see the data stories quickly through Excel, Power BI tools, etc.

What is most valuable?

It provides a full platform for our BI solution (database, ETL, reporting, analysis, and so on).

What needs improvement?

  • Monitoring features: I need Microsoft to provide a set of tools to help me monitor Microsoft's products. For example, when I need to investigate the performance issues of SSIS packages, I do not have a tool, instead I have to write scripts to query data for analyzing performance.
  • SSIS Connectors: Microsoft needs to provide more drivers to connect other data sources in a native way, which they are doing very well in Power BI, and that we can connect and process data from JSON, SOAP, SAP, Salesforce, and so on.

What do I think about the stability of the solution?

No.

What do I think about the scalability of the solution?

No.

How is customer service and technical support?

It is not excellent, but enough to resolve our issues.

How was the initial setup?

It is quite easy to setup.

Which other solutions did I evaluate?

There are a lot of factors which we analyze and consider before we choose any product. In case we need a solution that we can develop, deploy quickly, and adapt to our business changes, Microsoft is the best candidate.

What other advice do I have?

Microsoft offers us a full platform, which we use to develop and deploy our BI solution quickly and easily. It also provides both of these infrastructure for use: On-Premise and Azure Cloud. They are very flexible.

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