What is most valuable?
Defining the most valuable features would take a long time. While I cannot point to a specific feature, I feel the solution provides a full range of implementation capabilities. This allows for integration and modeling, for carrying out good transformations within the same platform, as well as visualization. There are not many products included inside and one can start from scratch.
In respect of the customer, one can quickly implement phases. A person can start out with creating his data set on a miniscule amount of the client's work and, working solely with a sales team, make it agile, only involving three or four dashboards. At this point, completion is possible and progress may be made to the next one very quickly. We like the solution's ease of use, functionality range and ability to be quickly implemented.
What needs improvement?
I would like to see a change in the premium capacity. It is very costly, particularly for the Egyptian market, amounting to $5,000 per month. Perhaps in the Gulf this would work well. The data flow should be enhanced from OnPrem-Gateways, which we find to be somewhat complicated and which does not always work. Regional pricing is the main issue.
The stability is okay, although there can sometimes be an issue with the connection when it comes to data OnPrem and the need to manage gateway communication and do troubleshooting. In brief, there are certain issues with OnPrem stability.
'Although we feel the solution to be a dream, it would be great to see everything on Power BI services, obviating the need for Power BI desktop. I hope to see such Power BI implementation.
I feel like we don't have a very powerful ELT or ETL tool when it comes to power and data cleansing. The solution compares unfavorably with such products as Informatica in this regard.
For how long have I used the solution?
I have been using Microsoft BI for two years.
What do I think about the stability of the solution?
The stability is okay, although there are occasional connectivity problems when it comes to managed gateway communication of data OnPrem and troubleshooting. The OnPrem stability should be addressed.
What do I think about the scalability of the solution?
While the stability is okay, there is an occasional need to add extra products, such as those involving Azure data analysis and Azure Analytics Services.
Big data would require the involvement of different products, Microsoft sign ups, for example. While we did not go for this, our technical teams are trying to get up to speed to have big data rediness.
I feel like the solution has a comparatively inferior ELT or ETL tool when it comes to power and data cleansing and compares unfavorably with Informatica. There is occasionally a need to involve other solutions, such as Informatica and Alteryx.
How are customer service and support?
While we have not made much use of Microsoft support, I did previously work with Microsoft's premier support and found it to be very good, overall.
How was the initial setup?
The solution is easy to set up and implement.
What's my experience with pricing, setup cost, and licensing?
The premium capacity is very costly in respect of the market in Egypt, amounting to $5,000 monthly. The regional pricing should be addressed.
Which other solutions did I evaluate?
The solution has an edge over others in its quick implementation. It is also very helpful to consider Microsoft data platform on Azure. Doing a combination with Microsoft data plaform will give one a great edge over, say, Tableau.
The combining of Power BI with Microsoft data platform on Azure provides one increased familiarity. We are talking about a great ecosystem.
The solution is comparatively inferior to those offered by other companies in respect of the ETL and ELT as these relate to power and data cleansing. It is not the best.
What other advice do I have?
My advice to someone looking to implement Power BI for his own organization would be to take things step by step. He should initially refrain from taking on big projects, instead focusing on agility, starting with the most requisite dashboards, working on them and garnering experience. The person will improve from one time to the next. One should familiarize himself with the details and how to move data and big data. He should not remain stuck waiting for the implementation of a big project.
I rate Microsoft BI as an eight out of ten.
Disclosure: My company does not have a business relationship with this vendor other than being a customer.