We use it for taking data and turning it into intelligence.
I have been using the most recent version of it. It is deployed in a government cloud.
We use it for taking data and turning it into intelligence.
I have been using the most recent version of it. It is deployed in a government cloud.
It saved time.
Its ease of use is most valuable.
The biggest thing with Microsoft right now is better support. There should be more timely support. We can do 90% of it ourselves by the same token. When we're into the 10%, we do not get timely support via Microsoft's support team.
Its speed can also be improved. They should come up with a fix for the speed issue and give us some good parameters as to what would help with the speed. They should give us a good white paper that has a compatibility list, similar to what they provide with operating systems, and that describes what you should have before you use Microsoft BI.
There should also be a better way to possibly do things like geolocation, and where they do it, they should do it better. If you have a satellite, offices, and that sort of thing, it would be nice to see it in Tableau and different formats.
I have been using this solution since it came out. It was probably 2010. I'm a Microsoft engineer, so I'm on a lot of beta test teams. So, I would see these items a bit earlier than anybody else.
It is overall in mid-range. Sometimes, it works very well, and sometimes, it doesn't. If it is not working very well sometimes, that means it is not a hundred percent stable.
Its scalability is good. I've used it in very large major banks down to smaller entities, and it seems to not care about the scale.
Currently, we probably have 50 users. Its usage is moderate. We will increase its usage if they come up with a fix for the issues such as the speed.
There should be more timely support. I would rate them a two out of 10 because of the lack of availability. Sometimes, we can't fix what we don't know how to fix, and it causes us a lot of time and waiting and that sort of thing. We have to have a US citizen, and I'm sure that they're just not scaled up to that.
Negative
I have used other solutions but not in this cooperation.
Its initial setup is somewhere in the middle. Each deployment seems to be a little different. You have auto-updates all the time on PCs. When you image a PC, it doesn't always match. So, each deployment is different, and I'm not sure they can change that because most of the updates are for security, but it is very important to be sure that you test the environment first before you put it into production. I know a lot of people who just put it into production because of the ease of use, but sometimes, that can be problematic. In terms of maintenance, it is not terrible.
It was done in-house with the help of a Microsoft partner. Our experience with them was horrible. We ended up fixing it all ourselves. If five was the top, they were a zero.
I would advise others to just do their homework. You should check it out first, do the trial, get it into your test environment, and then make your decisions. Don't rush to production. Everybody is a bit different. If you have monster databases out there, the performance might be a little different.
I would rate it a six out of 10. If their support were better, it would get a higher rating.
We use it for reporting. We are using its latest version.
Its visualizations and dashboards are most valuable. Power BI is great in terms of visualizations and dashboards. The reports that we previously had were not very nice in terms of visualization. It also provides the ability to play with the data.
We have a lot of servers and applications from which we want reports, and it allows us to create reports from an SQL source or some other source.
They can improve it in terms of rule-based security. Currently, it has very limited rules.
They can improve the user interface a little bit to make it more user-friendly. When creating a dashboard, it is not very user-friendly. You have to click on a certain style and use your keyboard keys to move it. You cannot drag and drop it.
Their technical support can be better. They normally take too long to escalate and resolve a case.
I have been working with Power BI for five or six months.
I am at the initial stage of using it. We have just deployed a report in our organization, and it is working fine so far. It seems to be stable. I am not sure if we faced any issues with it.
It is good in terms of scalability.
I have had only one interaction with them, and it was a bad one. They took around a month to resolve a simple issue. We also had to escalate the case. The resolution was very simple, and ideally, they should have found it on the first day. They normally take too long when it comes to the escalation of cases.
As a first-time user, I found it to be of medium complexity. You have to connect it with the SQL database or your data source. You might not find it very straightforward.
It can also be deployed on-premises. If you have it on-premises, make sure that you meet all the prerequisites and have all permissions. You should sort these things out before deploying Power BI. I faced some issues because I missed one of the prerequisites, and it took me one month to get it resolved. That's why I recommend completing all prerequisites.
I would rate Microsoft Power BI a seven out of ten.
I am using the solution for data analytics.
I have found the best features to be the dashboard creation, graphs, charts, and presentation bar graphs. As for now, I am able to do a lot of operations but not with much proficiency. I am just getting started with it. I am not very good at doing dashboard creation or writing reports but sometimes I do it during office hours to understand and learn the analytical tools.
I have been doing trial and error to figuring out how to do the data analyzing and modeling. There could be some improvement to simplify it.
I have been using the solution for approximately one year.
I am only working with small datasets at the moment and the solution has been stable. I am not sure how it will be for larger datasets. We have approximately 50 people using the solution in my organization.
This solution came free, it was offered by Microsoft with our E3 license.
This solution is a useful tool for the business and experts. It has plenty of features. I do not have a lot of advice because I am just starting to explore the solution but I have found it very helpful in terms of data presentation.
I rate Microsoft BI a nine out of ten.
The only real need is a lower tier pricing plan around premium. It’s a big step-up unless you have a very large user base (1000).
Pros
SQL Server is flexible and relatively straight-forward to deploy. It is fantastic that reports can be delivered via Report Manager without any additional license fees. Reports can also be placed on subscriptions with the Enterprise version of SQL Server. This allows different people to get the same report with data that is tailored to their perspective.
Cons
The product would be better if it came bundled with Microsoft SharePoint. Some of the more advanced business intelligence dashboards must be run through SharePoint (SharePoint dashboards, PowerView, etc.). We also found that SharePoint Dashboards are time intensive to design.
My experiences
Getting back to the license costs, we have found SQL Server to be an effective tool at a very good cost. Compared to purchasing 2 or 3 other products, SQL Server is a very nice all-in-one package (SQL Server database platform - MS SQL, SQL Server Integration Services - SSIS, SQL Server Reporting Services - SSRS, SQL Server Analysis Services - SSAS). The educational discount is also very helpful for K-12 or Higher Education customers. Installation and deployment was relatively straightforward. There is a slight learning curve on SSRS, but easy to pick-up.
Business Metrics
If you are looking at cost savings alone, Microsoft SQL Server will pay for itself when compared an Oracle/Informatica/IBM Cognos solution. In a direct comparison of one-time software fees and ongoing annual support fees, Microsoft SQL Server will come out much cheaper. I would also argue that the software features are similar between the tools as well - so you're not foregoing functionality to save cost. We have found that BI developers are also easier to find on the Microsoft platform - which over time - may lead to lower TCO.
What needs improvement?
It would be nice if the Report Manager portal interface were more updated. It is much nicer to deploy the reports through the "shiny" SharePoint interface, but it is not as integrated with SSRS as the Report Manager.
Alternatives Vendors
Oracle, IBM Cognos, Informatica
Which others did you consider?
Power BI is used internally to track indicators like KPI, sales, and a bunch of other essential metrics for our company's strategic planning. Power BI creates reports and compiles data coming from various sources, and we create dashboards for managers and executives to monitor these indicators.
There is also an external use case. We also have a team that provides BI as a service. Let's say your company collects all your data manually in Excel sheets and creates reports. We get rid of the Excel files and automate everything using Power BI to create dashboards and reports.
Microsoft has made a lot of progress with Power BI in the past couple of years, but there is still some room for improvement. For example, Integration is one area they could work on. They are adding more integration with other Microsoft tools, but I would like it if they sped up the process.
We've been a Microsoft partner for 12 years.
Microsoft Bi is stable.
Microsoft BI is scalable.
Power BI has strong support from Microsoft. If you need help, they answer promptly. There are also several discussion groups where you can get information, like the product roadmap and any new things coming up.
Everything is in the cloud, so you don't do anything. You only need to download a client, and that's it. If you have to create an embedded solution, it only takes five minutes.
The entire deployment takes a couple of hours, but you don't need a specialist to deploy it. Obviously, you need someone who understands the technology and how to follow instructions, but it's pretty straightforward stuff.
Power BI's price is good relative to its competitors. It has more than 400 or 500 different connectors. A lower price would always be welcome. The price is fine, but the licensing is complicated. Quantum mechanics is easier to understand than Microsoft licensing.
I rate Microsoft BI nine out of 10. If you are thinking about using Microsoft BI, go for it. Microsoft BI is worth it. It's one of the products Microsoft got right from the beginning. It's perfect.
The IT department has dashboards for reporting to the higher levels of management.
The solution is deployed on a hybrid model: cloud-based and on-premise. We always get the latest version because we have the Enterprise Agreement with Microsoft.
We encourage end users to use Power BI because it's quite easy for them to interact with the menus and the navigation bar. Even for ordinary users, they can create their own dashboard using Power BI.
There's always room for improvement for Microsoft Power BI, especially for the UX and the menus to make it more accessible to business users. These improvements wouldn't be too technical.
I have been using Microsoft BI for a very long time—since it was first released.
The solution is stable enough, but I think Tableau has a better interactive UX and user experience. We are not using Tableau right now.
We have tens of thousands of users, and we are willing to increase the number of users.
Support is amazing.
I have experience with Tableau.
The license is on a yearly basis.
I would rate this solution 8 out of 10. I would recommend this solution for others.
We don't have any other solution out there right now, so I would say we are satisfied with it. There are some disadvantages, some weaknesses of Microsoft Power BI that we have addressed to the Microsoft team.
The IT department has a good relationship with the Microsoft team, so they always give input to Microsoft's department teams.
I am a reseller for Sage business solutions and will start to sell Microsoft BI.
Microsoft BI is primarily used for sales, financial, and production reports.
I believe that it's a good solution.
It is not an expensive solution. The price is very important in the solution selection process. In my opinion, Microsoft BI is a low-cost solution, and it could be an interesting solution for a tourism company.
I have been using Microsoft BI for a few months.
As a cloud solution, we are always working with the latest version.
In our company, we have five users.
The price is an important consideration when upgrading or adding new users. In my opinion, it would be better for the price to be degressive by the user. For example, if you have five users, you simply multiply five by the unit price to find the total cost of the solution.
I believe the price should be degressive, and we should have a lower, or better unit price if we have more users.
I hadn't really needed Microsoft's technical support until now. We have not had any issues to resolve.
The installation is not a difficult thing, it is very simple.
We only need one IT manager, to deploy this solution.
Licensing fees are paid on a yearly basis.
I would recommend this solution to others who are considering this solution, which is the reason that I will be selling it.
I would rate Microsoft BI an eight out of ten.
Just like MySQL, SQL is very easy to use or program when creating databases. In fact, with some knowledge of either one of the database programs, one can easily use the other without much difficulties.