Microsoft Power BI Reviews

The data is captured by transaction processing systems, and even when the data is captured by a very sophisticated enterprise resource planning system, or ERP system, such as SAP. We'll find that that data is organized in a manner that is suited for the data updated. Therefore, when data has to be used for decision making, it has to be reoriented and organized in a manner that is suitable for data analysis and further for predictive analytics also. What we do is pull out data from multiple data sources, either on SAP or somewhere else.

There could be a certain budget or plan or target-related data on some other platform or on a Microsoft Excel spreadsheet. The data is stored at different places. Some data could be on your internet platforms. Wherever it is, we pull out the data. Then we get that into the SQL server and we organize it in a manner that's suitable for further creation of dashboards and analytics applications, which can be used for better decision making.

The company has been able to make better decisions, due to the fact that, when we prepare business intelligence or data analytics applications, they are used by very similar decision-makers, as well as middle-level management decision-makers. From the same infrastructure, the data is used by even the report consumers. You can consider three layers of users, report consumers, mid-level use, as in, those who do interactive analysis of data, and decision-makers. Right at the top, those who would like to see the key performance indicators and use them for deciding a course of action can do so. All of our applications have been providing functionality for all these types of needs, including risk and compliance.

The solution offers many features, however, just the way in which that product is designed is quite useful for us. 

The way in which it can connect to multiple data sources is also very useful. The way in which data can be manipulated by using data analysis expressions has also been a good feature for us.

The solution is stable.

The solution is quite scalable. 

Our clients seem to be happy with the level of technical support they receive.

With our experience, the initial setup is straightforward.

Microsoft is often updating the solution adding new helpful features.

I'm not a product expert as such, however, I am aware that Microsoft comes out with a newer version, which is really downloadable and it's replaced every month. Therefore, the improvement is continuous. Since Microsoft provides a free downloadable desktop version of our BI. That desktop portion gets a new version which comes every month, we can replace the older version. 

Their ecosystem is quite good in terms of adding new features, in terms of adding custom visuals or adding many more interfaces or reporting features and more functionality within existing reporting and graphs. We don't have much to complain about except that they can always add many more features as they go.

Microsoft has got a very large repository of all change suggestions which have been raised by the BI community. They keep on adding features that are very widely sought after by the community. We don't focus on product features. We focus on business requirements. To use the solution, we find that existing features are good enough and offer us a very effective solution.

We've used the solution since its inception. We've used it for a very long time. We have been in this domain for the past 30 years.

The solution is quite stable. That's why it is right at the top, of Gartner's quadrant. We have deployed it with hundreds of users and it's withstood the test of time.

The solution is quite scalable. Of course, it requires data strategy just like any solution or any tool.

We tend to have 100 to 200 users at a minimum using the solution.

The solution is extensively deployed. We have plans to use it on an ongoing basis. They come out with new versions and new features every month, and this constant updating and iteration of the product have really been very helpful for us to provide more advanced solutions.

In terms of technical support, we don't really deal with it. Normally, our clients have a contract with Microsoft, however, my understanding is that their experience is good. 

We were using a CA tool and we have done work on Oracle. We have done work on many such platforms. However, since 2008 or 2009, we have been focusing on Microsoft as the total cost of ownership has been quite reasonable.

The initial setup is quite straightforward.

Our implementation strategy involved a business requirement phase where we sought out to understand exactly the expectations for a particular project. Then there is was a design phase where we decided on a data strategy of pulling data from multiple data switches. After that, there was a dashboard design phase, which includes wireframing of dashboards and then designing the dashboards according to those wireframes. Finally, we deploy and in that phase, we put in role level security, et cetera, and deploy it at an enterprise level. The entire process tasks three to four months in total, end-to-end.

We don't require much maintenance due to our maturity in design and development. We have been monitoring sites without having to add too many resources at our end as we have a robust design and maybe one person can handle four to five.

We do the implementation on our own. We have deep experience in this area, and we have developed two types of processes that we use to deploy our solutions. One is the data approach, where you know all best practices and methodologies are embedded into that thing. That framework gives a hundred percent assurance in terms of the success of that project. We have also developed a presentation layer framework whereby different subject areas are designed with very indicative dashboards and those dashboards can be quickly adapted to any data. That way, rather than starting from scratch, we use this framework which helps us to deploy our solution quite successfully. It's very fast also. We save around 50% to 55% of the time this way.

We don't deal directly with licensing. That said, certainly, we are aware in terms of what the Microsoft BI license costs. If it has to be applied on the cloud, then it costs around $10 per month per user. For a pro license and for a premium license it's around $20 per month per user. If it has to be applied on-premises then, depending on the course of your server, you have to buy a software assurance version of the database.

They don't charge for additional features. If you want a premium capacity to handle your work or job, then there is a separate license available. That is a premium license, which is available with the entire product managed by Microsoft and you can use lot more features, including Azure, et cetera.

We are Microsoft partners.

We have two deployment options. Some of our clients have deployed the cloud solution. Some are deployed on-premises.

Anybody who has worked on existing spreadsheet-based solutions can quickly adapt to Microsoft BI and the data visualization and interactive data features, they'll find it very exciting to use and very fast to adapt to it. It's a very effective solution.

I'd rate the solution at a nine out of ten.

I would describe myself as more of a casual user, only because I have so many other things that I have to get done. I wish I could be more of a user, but it's hard. Right now, I have two different main use cases. I use it for teaching. At another institution, I use it for demonstrating how easy it is to build dashboards. It was really to show to all my users the benefit of business analytics. I use it to demonstrate how easy it is to generate your own analytics versus having a department run reports for you then putting it in Excel and making graphs. 

I like the fact that Power BI lets me use Excel data. At least 90% of my state data is in Excel spreadsheets. Having the ability to just attach a spreadsheet as a data source is very, very important. It's also good for training and teaching. Sometimes you don't always have access to a live production database, so having a spreadsheet with sample data is always nice.

The Microsoft BI interface should be simpler and more user-friendly. I find it very difficult to move between their data sources and their analytics section. It's probably designed by data analysts that typically get the data from somewhere else. So, one person logs into Power BI, moves the data around and puts it in the proper form then somebody else goes in from the dashboard. What I'm finding more and more is that the person playing with the data is also going to be the person building the dashboard, so the interface needs to be more seamless and dumbed down for the average user. 

Tableau is much better at that, which is probably why it's more expensive. The days where one person works on the data and someone else does the analytics are coming to an end. In the past, larger organizations usually had a dedicated analytics team and a dedicated data team. Now we buy data as a service, so we got rid of our data team and we don't have analysts per se. Instead, we have smart users. So I think Microsoft BI needs to move on to the next iteration of truly user-friendly solutions.

I've been using Microsoft BI for about three years.

Microsoft BI has never crashed on me.

I honestly can't comment on how scalable Microsoft BI is because I've never taken it beyond training or simple use. But I would imagine, if it's on Azure, that it's scalable. I haven't had the pleasure of scaling it, so I don't know, but it doesn't strike me as a solution that would have problems with scalability.

I have not had to contact technical support, but I've actually downloaded and taken three Power BI courses for free and they're very good.

I was using Tableau but the licensing cost went up when Salesforce required them to raise the price. But if the price hadn't changed, I would've absolutely stuck with Tableau because I like it. I do not know about the cost of the licenses. We buy it from the state and when it went up, our CIO at the time said no more Tableau licenses. I had to scramble to find a replacement, and fortunately, I discovered that Power BI is included in Microsoft 365. However, I prefer Tableau's interface. Microsoft BI's user interface is convoluted in terms of how you attach a data source. You have a separate screen for defining your data and then you have to jump to a different screen to model the results. In other words, there are two separate interfaces for data and analytics. In Tableau, it's more seamless. 

Setup is very easy. You click on the icon, download the MSI, and it loads itself. It takes about a couple of hours to deploy overall.

I'd rate Microsoft BI as an eight out of 10. The biggest drawback is the user interface. From what I'm seeing, Windows 11 is going to have a more user-friendly interface. Even Microsoft Edge is adopting a more user-friendly interface. I'm hoping that Power BI follows this trend as well. 

My advice for anyone who is thinking about adopting Microsoft BI is to understand what you're trying to do with it. If you're trying to do analytics with it, then it depends on the kind of analytics. If you're want to do statistical analytics, it's not the tool for you. It's a tool that's better suited for visual analytics than it is for straight-up analytics. If you're dealing with patterns and data, it's great. If you're working with numbers and data, it's not so good. You're better off with a statistical package.

We are using it for financial analytics and reporting. We are using it to keep a track of projects and being able to degrade the projects. We are also using it for contract closeout.

My technical guy has been using the first version of it since it came out, but we are getting ready to upgrade to the newer version. It comes along in a bundle with the 365 Enterprise version.

It is on the cloud. We're probably going to run a hybrid because we want to be able to move around. If anything happens or if needed, we can move from platform to platform.

We can see things from a bird's eye view. We can do predictive analytics. I can tell who's capable, who's doing what, when and how much money they're spending, and how fast they're burning. So, it gives us a bird's eye view over the financials and the money. It basically gives us the ability to collaborate and keep track of everything that's going on in an organization. We were able to bring all the collaboration and tasks right into Power BI.

It is easy to use. It has got a desktop where people can develop their own dashboards. Basically, we have figured out how to connect finance contracts and all programs for the government agency. So, they can see everything in a dashboard. So, it is very easy to use from a technical standpoint of view. We publish a report every morning for the government, and we got all the data into one place. The data can be refreshed. We are using the API to connect to various systems, such as the financial system, contract writing system, and workflow. We are able to bring things from NIPA, which is their budget and where they keep all their money. There are a lot of features, but the most important thing is it is very easy to use. It is not like Tableau. With Tableau, you've almost got to be a rocket scientist.

On the user side, it is quite simple. If you know how to run a pivot table, and then you can do almost anything. All the data is right there in the database. So, if you understand pivot tables and know how they are run, and you know the reports that you are looking for, then everything becomes very easy to run in your organization.

Its desktop tool is a little bit memory CPU intensive, and it can be improved, but the machines nowadays come with a lot of memory. For the desktop users who are using it on the desktop, we recommend that they do an upgrade. It is a minor issue. We can fix it on the desktop.

We've been using Microsoft BI for about four and a half years.

Its stability is pretty good. It is pretty stable.

I would rate it an eight out of 10 in terms of scalability. Currently, we are running a pilot. We're doing a pilot for army headquarters. They dictate what happens and what they use. Currently, there are 10 users, but I'm looking to go up to at least a hundred. 

We got an architect and an assistant administrator. We got a staff of three and a half people because people take vacations or sick leaves. The good part about it is that these people can work from anywhere.

We are a Microsoft reseller. We have partnered with Microsoft. We have developed a relationship with their technical folks over the years. So, we kind of go directly to them. My partner came from Microsoft, so he has a very good relationship with a few technical folks. So, we, kind of, have some special privileges that a couple of other vendors don't have.

As a matter of fact, we had built a tool, but it took so long to get it vetted and get it through to ATOs. That's when we decided to convert to Microsoft Power BI. It has already been vetted and approved in the army environment. It is an approved government site for cloud services. We were looking for the easiest path, and that's why we worked with Microsoft BI. They've already been embedded into the government. It is bundled with Office 365.

If my technical person had to rate it, he would say very easy. All we need is to have the software.

It was done in-house.

They are charging us by users in storage, and there is a license fee. My financial people handle all that. The client has already worked out a contract with Microsoft, and basically, we're getting government prices.

The backend is the most important part. We understand its backend. We implemented the on-time system for an airport. We don't find its modeling complicated. We set up the back offices and get all the modeling done and everything connected. The customer doesn't even see that. They only see the part where they're running their reports and doing the analytics or whatever they need to do. We give them all the information at their fingertips.

Everybody is going to Business Analytics. A lot of people don't understand the difference between analytics and coding, but that's something for me to teach and educate them on.

I would advise doing your testing and environment setup. You should evaluate your product very well and figure out what platform your organization is running on. You should be careful and look at how well it integrates with other products. If you're not in a Microsoft environment, it is going to be quite difficult. Oracle and Microsoft are competitive. So, you go with one or the other. The reason why I like Microsoft is that they integrate with all applications. Microsoft controls 99% of the desktops.

I would rate Microsoft BI a nine out of 10.

We utilize Microsoft BI for conducting comprehensive analytics by comparing data from the current year with the preceding year to identify patterns and variations. This software aids us in performing overall data analysis.

The solution can be deployed on the cloud and on-premise.

Microsoft BI has proven beneficial for my organization as it simplifies the presentation of complex data that was previously challenging to comprehend through other means. Specifically, Power BI allows for graphical representation that significantly enhances data understanding compared to raw tables.

The most valuable features of Microsoft BI are its intuitiveness and ease to use.

Microsoft BI lacks some of the scheme features. It would be beneficial if there were a way to show how we move values in a different way.

I have been using Microsoft BI for approximately three years.

I rate the stability of Microsoft BI an eight out of ten.

I have plans to use the solution more in the future.

I rate the scalability of Microsoft BI an eight out of ten.

The initial setup of Microsoft BI is simple.

We have received a return on investment using Microsoft BI.

The price of the license can be better. 

I rate Microsoft BI an eight out of ten.

The use case for power BI is to generate dashboards for high-end management and operational dashboards.

Microsoft BI, if used properly, can provide insights that will help management to take better decisions and can benefit from cost optimizations, reduce risks, etc.

What I like about Power BI is how fast you are able to create dashboards and how fast you are able to fetch the data. You can connect to the database or data source, and then you can design your dashboards very easily.

The best thing about Power BI is that you can manipulate the data within Power BI, so you don't have to update the data source to have filtration or conditional formatting. You can easily do those things under Power BI.

It is easy and has rapid development.

It is stable and scalable as well.

There is an issue with Microsoft because the on-premises Power BI is behind the cloud Power BI. So, the on-premises Power BI is six months or one year behind the cloud version because Microsoft published the cloud features first, and then they published the on-premises version. This has been an issue. They should be on the same level of capability.

There are some limitations in Power BI; you have to work in the Power BI base. However, if you want something not out-of-the-box and you want something custom, you have to do a lot of work. Microsoft can provide some easy way to customize the dashboards.

I've been using this solution for two to three years.

It is stable, but there is an issue with Microsoft because the on-premises Power BI is behind the cloud Power BI. The features of on-premises Power BI are six months or one year behind the cloud version. They are not on the same level of capability.

The scalability of Power BI is quite good.

Microsoft technical support could be more knowledgeable.

We switched to Power BI because it is easy, and there is rapid development.

Installation is easy and took about half an hour.

It requires a little bit of effort, and we needed the help of a consultant.

Power BI comes with enterprise Microsoft licensing. So for the user, you don't have to pay, but you do have to pay a one-time cost.

If you want to use Power BI, you should go for the cloud version. Don't use the on-premises version because the cloud version has a lot of features which the on-premises version doesn't have.

Also, if you are going to use Power BI, you should know what all your capabilities are. Otherwise, if you try to do some things such as develop a dashboard which is not supported by Power BI, it will be a showstopper for you.

I would rate this solution at eight on a scale from one to ten.

Enterprise reporting and digitization of dashboards using Microsoft Power BI, SSRS and Azure Reporting DB by integrating several applications to establish single version of truth.

Microsoft BI stack is very easy to use and most of the developer versions are free such as Power BI, DAX, SQL Server Development Edition. This helped us quick prototyping to generate value of data resting in silos. 

What I like most is that I can do everything in Power BI that I can do in Excel. It is very compatible with Excel tools, and anybody who works with Excel can learn and use Power BI quickly. 

Writing formulas and data transformation are good features.

The only challenge I have found is that they do not have a Mac version of Power BI. They should have versions for both Apple and Unix because you cannot install the desktop version for these operating systems.

In the future, I would like to see them add more AI and machine learning features, as well as self-service analytics.

You can use R and Python, but it would be helpful if they had some no-code machine learning options that you find in other tools.

The UI/UX can be improved. Products such as Tableau and QlikView are very good in terms of the user interface.

I have been using Microsoft BI for five years, on and off.

I have not found any issues with respect to stability. Microsoft has invested a lot and they are continuing to invest in Power BI.

Given that there is a server version for services that can be used to implement and roll out reports at the organizational level, it's scalable.

In my current organization, I am training 15 people on how to use it and I am looking to expand to 50 users.

Microsoft support is quick. We also have a dedicated partner for support, and they are good.

Positive

Prior to incorporate Power BI in the stack, we were using Microsoft SQL Server Reporting Services(SSRS) only. They do not have any visualization interface, but you can do static reporting. This is the reason that we are switching. Probably, we will use SSRS and Azure SQL at the backend, but there won't be used as the visualization tool.

For visualization, we used to use Excel. Which not reliable. 

The installation is easy. The download takes perhaps five minutes, depending on the bandwidth. Overall, it can be downloaded and installed within half an hour and no training is required.

The desktop version is used for development and the cloud version is used to submit a report. Essentially, it is Power BI Desktop and Power BI Services. The desktop version is what is on-premises.

You can deploy yourself but of course, in an office, you require an administrator.

The cost of this product is very low, at approximately $8 or $9 per month for a developer. It is the cheapest of all of the visualization tools. They have a 30-day trial available for you to try it.

For personal use, this product is free to use.

Tableau is a little bit expensive, although it is good if they want a very sophisticated solution. Both Tableau and QlikView are a little better in terms of the user interface.

You need a technical team to operate the solution. You need people for the administration of the data connection and data integration. They should be skilled in SQL, data management, and so forth. Typically, these are data engineers.

We plan to continue using Microsoft BI. We are onboarding and implementing organization-wide for our long-term strategy, and the entire organization will be using Power BI.

My advice for anybody who is considering this product is that it is easy to learn, especially for somebody who is good at Excel. Other tools are easy to use as well but if you are a Windows user then Power BI is a good option.

I would rate this solution an eight out of ten.

We are using Power BI for reporting.

It is very good, and it supports the Microsoft ecosystem, including Excel, etc.

We have been using it only for a couple of months, and we are at the beginning of our learning. The area of improvement is difficult to say. The handling of the workspaces can be made more granular for user access rights. It can be managed a little bit better in terms of the connection to Active Directory so that we have more granular access rights. I am not sure if this is really possible or if we can solve it differently, but we need a lot of workspaces, and we are not sure how we can deal with it from the access rights perspective.

I have been using this solution for a couple of months.

It is stable.

We are not sure because we currently have a simple installation on the PC, but the idea is to scale it via Office 365 cloud implementation.

It seems suitable for small, medium, and large enterprises. It should be able to scale up. Based on the marketing slides, it should be able to handle all kinds of enterprises.

We have not had any problems, so we had no requirement to use technical support. 

It is quite easy. You just need to install a program and use the connectors and drivers, and that's it. 

I did it myself.

We are end-users, and we don't take care of the prices and accounting. We get a product and pay the fee to our internal service provider, but its price should be reasonable. Otherwise, they wouldn't have bought it.

We are not very experienced in it. So, I don't know if I can recommend it, but we are using it because it is very good.

I would rate it an eight out of 10.

The solution is very powerful and very flexible. 

It is very easy to set up and you can connect it to multiple systems very easily.

They keep on upgrading, performance-wise. 

Power BI is very fast; they have improved Power BI a lot in general over time. YOu can see the difference. 

The stability is great and continues to get better and better.

The pricing is pretty good.

They should provide some kind of extra visual. There are a lot of third-party companies that provide these visuals, however, it would be better if, instead of relying on a third party, they could have their own. We should have by default in the package itself, some good visuals.

Technical support could be a bit better.

The performance could be enhanced in the sense that there is a limitation of the volume of data that it can hold. 

While they have some different options out there, they did not improve anything when you connect to any dataset, when you have to import. You need to connect online, meaning live.  

You cannot create so many things on the Power BI side, such as adding a new column, which is not possible in your live reporting, direct query option. In contrast, with the import method, you can do so many things. They need to improve on the direct query option side.

The product is stable. I have seen a lot of improvements in the stability of their application lately. If you compare what's available now to the last three to four years back, you can see it's more stable.

It's scalable and it scales quickly. Nowadays, being on the cloud, expanding is very easy.

While support is okay, they need to improve it a lot. Of course, they're improving as we speak, yet, I would say, if you can ask me the ratings, I would still say it's still rather low and good - not great.

I'm also familiar with SAP, which doesn't scale as well. SAP also is much more expensive. SAP is a big product, whereas Microsoft BI is much smaller. They only overlap in terms of the analytics cloud and the SAP goes above and beyond and offers many, many more things. 

The pricing is fair. They give you many options by splitting up the licensing. They have multiple types of licenses out there based on your usage. You can increase your pricing if you use it a bit more, however, it's still quite reasonable as compared to SAP. 

We are a customer and end-user. We are not a Microsoft (or SAP) partner.

I would rate the solution at a seven out of ten.