We use Microsoft Power BI to budget for all departments and to compare the balance of the past month.
Software Engineer at Lorenzo Imperatrice
Enables us to look at the budget for all of the departments in our company
Pros and Cons
- "The accounting data needs improvement."
What is our primary use case?
What needs improvement?
The accounting data needs improvement.
For how long have I used the solution?
I have been using Microsoft Power BI for a year.
What do I think about the stability of the solution?
It is a stable solution.
Buyer's Guide
Microsoft Power BI
November 2024
Learn what your peers think about Microsoft Power BI. Get advice and tips from experienced pros sharing their opinions. Updated: November 2024.
815,854 professionals have used our research since 2012.
What do I think about the scalability of the solution?
Ten users are using the solution.
How was the initial setup?
The initial setup is complex.
What other advice do I have?
I would rate the overall solution an eight out of ten.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Last updated: Mar 26, 2024
Flag as inappropriateBI/BO Hana Application Consultant at a manufacturing company with 10,001+ employees
Flexible with good pricing but there are limitations around data volume
Pros and Cons
- "The stability is great and continues to get better and better."
- "Technical support could be a bit better."
What is most valuable?
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.
What needs improvement?
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.
What do I think about the stability of the solution?
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.
What do I think about the scalability of the solution?
It's scalable and it scales quickly. Nowadays, being on the cloud, expanding is very easy.
How are customer service and support?
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.
Which solution did I use previously and why did I switch?
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.
What's my experience with pricing, setup cost, and licensing?
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.
What other advice do I have?
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.
Which deployment model are you using for this solution?
Public Cloud
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Buyer's Guide
Microsoft Power BI
November 2024
Learn what your peers think about Microsoft Power BI. Get advice and tips from experienced pros sharing their opinions. Updated: November 2024.
815,854 professionals have used our research since 2012.
Senior Analyst at a manufacturing company with 5,001-10,000 employees
Reasonably priced, stable, but tab options needed
Pros and Cons
- "The initial setup is simple to do."
- "In Microsoft Excel, you are able to have tabs. However, in Microsoft BI you do not have this flexibility."
What is our primary use case?
We have both deployments for Microsoft BI, cloud, and the on-premise.
We are using SAP BI and Microsoft BI to augment the other.
What is most valuable?
Overall Microsoft BI is meeting our needs.
What needs improvement?
In Microsoft Excel, you are able to have tabs. However, in Microsoft BI you do not have this flexibility.
When you create tables in Microsoft BI, you have to create them separately. I can't have several reports packed together in one document, whereby I can have different tabs. You could have several pages of your dashboard, such as a summary page with all the detail. However, in the paginated reports, you don't have that kind of flexibility. This is a major area that Microsoft needs to work on.
For how long have I used the solution?
I have been using Microsoft BI for approximately three years.
What do I think about the stability of the solution?
Microsoft BI is stable.
What do I think about the scalability of the solution?
I have found Microsoft BI to be scalable. We did an enterprise-wide deployment and every one of the 500 people in the company uses it.
How are customer service and support?
I have not needed to contact Microsoft or the local vendor.
Which solution did I use previously and why did I switch?
We use SAP BI in parallel to Microsoft BI currently. Our plan is to replace the SAP BI with Power BI. The phase we are in now is to run both of them in parallel and see how everything is operating before we completely phase out SAP BI. The focus isn't on SAP or Power BI. It used to be our SAP BI solution. Since we started using Power BI, the plan is to actually discontinue SAP BI. maybe by next year we will no longer use the SAP BI.
I switched to Microsoft BI from SAP BI because, in my part of the world, it is becoming the most popular BI tool. Additionally, the ease of integration and our organization is a Microsoft shop. Everything is Microsoft, our databases, our ERP, and we use Microsoft dynamics and Business Center.
The ease of integration of the BI tool is important for our organization. The scalability and then the licensing are good. If you choose the cloud for SAP BI, you have to spend more. The planning modules sometimes do not come with the package and you will need to spend on it.
It is not necessarily that Microsoft BI is better, but because there are other benefits when you consider Microsoft BI. The ease of integration with the DB and the ERP, and then you look at the overall cost.
How was the initial setup?
The initial setup is simple to do.
What about the implementation team?
We did the implementation ourselves. The solution does require maintenance.
What's my experience with pricing, setup cost, and licensing?
The price of Microsoft BI is reasonable. Other solutions such as SAP Cloud are more expensive.
We pay annually for the license of the solution and we are using a premium license.
What other advice do I have?
The choice of a BI tool is relative. If you have the capacity and the budget, you could decide to use SAP BI. There are other BI tools on the market. Why did we choose Microsoft BI is because of the nature of our business environment, the nature of your data, and many other factors that have to be considered.
I rate Microsoft BI a seven out of then.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Technical Analyst at a energy/utilities company with 10,001+ employees
Accurate, with good frequency, and has a wide range of features
Pros and Cons
- "ou can pull reports, visualize them in real-time, and connect them to a variety of other data sources."
- "Integrating it with the physics build model or the engineering model should be included."
What is our primary use case?
I mostly work in the oil and gas industry. Microsoft BI is primarily associated with surveillance, optimization, product, and forecasting-related items. While I am not currently using Microsoft BI, I have prior experience, and in my current position, I am guiding the team on a larger scale. I don't use it myself frequently, but I am the lead for that team, and when I do use it, I use it for reporting purposes.
What is most valuable?
Microsoft BI has a multitude of additional features. Overall it's an EDA tool, from which you can extract, transform, and load data. You can pull reports, visualize them in real-time, and connect them to a variety of other data sources.
When I compare other analytical tools to Microsoft BI, I believe Microsoft BI is far more accurate, and the frequency is also better.
It has additional features, which are very much useful. The most important thing I like is that it is just a data platform connecting to the overall process and it can be utilized in any sector.
What needs improvement?
Integrating it with the physics build model or the engineering model should be included. When we use engineering models linked to Microsoft BI or Salesforce, the engineering models are from a third-party application.
For how long have I used the solution?
I have been working with Microsoft BI for the last three and a half years.
We are using the latest update.
I have used it both on-premises and on the cloud.
What do I think about the stability of the solution?
In terms of stability, I have seen some cases where it is difficult as well as some cases where it is very easy. Overall, it is a stable and reliable product.
What do I think about the scalability of the solution?
It is easy to scale Microsoft BI.
We have a larger team. Microsoft BI specifically, is not limited to any subset or any team. I believe we have 1,000 plus users in my company currently who are using this application.
How are customer service and support?
I have been in touch with the technical team, but not specifically for Microsoft BI. Based on my experience with Microsft technical support, I would rate them a four out of five.
Technical support is pretty decent.
Which solution did I use previously and why did I switch?
I use a variety of tools, including Salesforce, and I have developed a number of Python-based tools.
How was the initial setup?
The initial setup was simple. However, when I did it the first time, it was complex. Once I understood the process it was simple.
My field was small due to the type of setup required. I scheduled it for one week, during which we also tested.
Definitely, it requires maintenance in terms of quality checking of the data, as well as whether or not the run times or schedules are working properly.
What about the implementation team?
I had some assistance when I deployed the first time, but I am now able to complete the deployment on my own.
What's my experience with pricing, setup cost, and licensing?
In terms of licensing, I've never worked on the contractual side of their license. However, I believe that the number of licenses currently in use is appropriate for our organization. It also adds value to the team. I have never worked on licensing, but I have heard that it is reasonable.
What other advice do I have?
I have not used it on the mobile app. I'm not sure how Microsoft BI works on a mobile app.
Mobile apps are sometimes third-party apps that are difficult to configure and use. As a result, mobile apps are something that will be required in the future, upcoming data transformation.
Before implementing Microsoft BI or any other analytical tool, we must first understand the domain. Basically, how the data is linked, what data you want to transform, and what output you need for the finished product. Then you proceed with your deployment in a sequential manner. It will be very simple.
I would rate Microsoft BI an eight out of ten. I haven't explored many other items that are feasible or possible, or the analytical part of Microsoft BI's functionality, which I haven't personally used, so there's a gap. Otherwise, I would have given it a ten.
Which deployment model are you using for this solution?
On-premises
Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
OBIEE/ODI senior consultant at Kastech
A stable and scalable solution with good tech support
Pros and Cons
- "The visualization part and its inclusion in a cloud-based application are valuable features."
- "The solution is somewhat costly in comparison with MSBI tools."
What is most valuable?
The visualization part and its inclusion in a cloud-based application are valuable features.
What needs improvement?
The solution is somewhat costly in comparison with MSBI tools.
In MSBI, when it comes to mobile and maps-related applications, we are always looking for some support with the reporting tools. Once we click on the region, then automatically it goes to the two area maps. Based on the map, it will reinforce our data values. There is constant change involved and new updates and enhancements are coming out as needed in new versions.
What do I think about the stability of the solution?
The solution performs well and is stable.
What do I think about the scalability of the solution?
The scalability is very good and use of the application is flexible.
How are customer service and technical support?
We can create certain tickets, contact them and explain our requirements and they will look into the issue and help us to find a workaround for us to implement. They will address the issue in the next version.
We are very satisfied with their support.
What about the implementation team?
We are implementers of this solution and maintain the visualization on the reporting parts, as well as fulfill the business requirements.
What's my experience with pricing, setup cost, and licensing?
The solution is less expensive than other PowerBI tools, but more so than those of MSBI.
Which other solutions did I evaluate?
The solution is less expensive than other PowerBI tools, which is why most people go with it, although it does cost more than MSBI tools. It has good feasibility for fulfilling one's business needs. PowerBI is very strong in the market at the moment and we are creating visualization that works. It is a stable tool, as well.
What other advice do I have?
While PowerBI is cloud-based, it can be used both on-and-off-premises. MSBI can also be implemented on-premises. PowerBI mostly involves visualization.
I rate Microsoft BI as an eight out of ten.
Disclosure: My company has a business relationship with this vendor other than being a customer: Implementer
Associate at a financial services firm with 10,001+ employees
Affordable but a little complicated to get used to
Pros and Cons
- "Connectivity, installation, and configuration are pretty fast and seamless compared to Cognos."
- "For someone who is new, I think that Power BI can be a little complicated."
What is most valuable?
How was the initial setup?
The initial setup is very quick. Connectivity, installation, and configuration are pretty fast and seamless compared to Cognos. Power BI eradicated dependency on a framework model.
What's my experience with pricing, setup cost, and licensing?
Power BI is cheaper than Tableau and Cognos. Power BI Desktop comes free and the Pro license is $10 per month whereas Tableau desktop would cost you $70 per month. Cognos is mostly suited for large and medium size companies
What other advice do I have?
For someone who is new, I think that Power BI can be a little complicated. Overall, on a scale from one to ten, I would give Power BI a rating of seven.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
CFO at Travel Food Services ltd
Very scalable and stable with a fluid interface
Pros and Cons
- "The interface is very fluid."
- "The challenge of this product is in truncating the table data."
What is our primary use case?
We're a retail hospitality chain spread throughout India, operating over 330 outlets across the country in various formats, ranging from a coffee chain to fast food restaurants through our in-house bespoke brands. All these brands run out of travel hubs like airports, railway stations, and highways stops. We needed a solution to manage both the multiple SKU levels and in terms of individual dynamics, the profitability of each store. We constantly track the various types of back-end raw materials, specifically on our prediction modeling where we use Power BI. We also use Power BI analytics to drive those results with regard to the day-to-day dashboarding, reporting in terms of collection, on sales trends per hour, manpower and the like. We are customers of Microsoft and I'm the CIO.
What is most valuable?
I like that the interface is very fluid in the sense that you can upload via Excel or you can attach via connectors, any software you like.
What needs improvement?
The challenge of this product is in truncating the table data. It would be great if Microsoft would include a naming convention which has the advantage of enabling a VLOOKUP on top of it, so two tables can be merged more seamlessly. Currently, the time it takes to merge two tables in Power BI makes the entire analysis quite complex because it requires common numbering in one table and then creating another common indicator in another table in order to merge the two. It wastes precious time.
Secondly, while they talk about visual analytics, sometimes the challenge is when you're looking for more in terms of geovisual analytics, such as city maps which requires a functionality whereby you can upload transactions. For example, if I want to visually present my data on an airport map, showing which stores are generating what revenue dependent on the traffic heat map, I am unable to do that because I cannot upload drawings. Ideally, I'd like to show each store as a bar map with waves explaining the sales in each location. It allows me to pinpoint which locations are more profitable.
I'd like to see a degree of variability so I have the flexibility of putting those variable components in my predictive modeling, and I can get a feel for the trends. It requires a common input database. You can do it in Excel, but you can't do it in Power BI, which I find surprising.
For how long have I used the solution?
We've been using this solution for nine months.
What do I think about the stability of the solution?
The product is fairly stable, it doesn't get too many upgrades or updates from that perspective so it's fairly straightforward in terms of implementation and our entire ecosystem was on Microsoft which helped us. The only area that can be problematic is when you're trying to create relationships between two databases and you're trying to link it with your Power BI solution, sometimes that mapping takes considerable time.
What do I think about the scalability of the solution?
The solution is scalable. We are a cluster of eight legal entities and we've been able to expand to all of them. We started with 20 outlets and today we have 350 outlets. We are more granular and today Power BI allows us to drill down to the last voucher. We have around 14 users from the finance and operations teams.
How are customer service and technical support?
We haven't needed to call Microsoft, because we worked with one of their gold partners in India. So we are on an AMC model with them in terms of manpower. If there are any problems or upgrades we need, we reach out to the partner.
How was the initial setup?
The initial setup was straightforward for the simple reason that our entire ecosystem was on Microsoft and we use Azure Web Services in terms of hosting. We split the entire project into two parts to simplify things. The first part was more about the granular analysis of sales and various other elements, which took considerable time due to the many external stakeholders involved. Phase two was relatively simple, because it was department specific and we created a split team, which led to the creation of a better platform.
What's my experience with pricing, setup cost, and licensing?
Licensing is on an annual basis. We have a complete Microsoft Ecosystem license. I think there is room for improvement with the licensing, specifically during the pandemic when it would have been reasonable to offer a discount. Many other companies, SAP and Oracle, for example, gave waivers to the MSME sector. Microsoft traditionally is used by smaller or medium-sized companies so I was expecting some sort of discount on the pricing, but unfortunately that didn't happen. We managed to avoid an escalation in cost, but frankly speaking, a discount would have been much appreciated.
What other advice do I have?
It's important to understand your entire ecosystem in terms of your tables; the kinds of tables your back-end database has and the elements of analysis that you are looking at. If you are looking at predictive modeling, you need to have at least two to three years of data, because that allows you to define the trajectory of the predictive modeling. Otherwise, it doesn't serve any purpose. Secondly, be very specific with your implementation partner, as to how you'd like a particular visualization tool to look, otherwise you may not get what you want. Finally, it's important to invest in people and create a center of excellence made up of people who know Power BI well, or who will get trained and certified on it. You'll need an in-house team which can do the small tweaks and changes as you require, otherwise you'll get stuck each time you need to do something.
I rate this solution an eight out of 10.
Which deployment model are you using for this solution?
Public Cloud
If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?
Microsoft Azure
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Compensation Coordinator at a computer software company with 1,001-5,000 employees
The easiest and most stable solution that has good querying capabilities and great support and is light years ahead of other solutions
Pros and Cons
- "The querying capabilities are the most valuable because they allow me to build many automations. We have many workflows and many databases that we work on a daily basis. They need to be updated quite quickly. In order to not to take much of our time doing these updates manually, I have set up these automations using the systems. The process is just to ingest the data and reprocess it. Every time I click a button, everything is updated in almost real time. It is by far the easiest system not only for querying but also for data modeling, data visualization, and deployment. It is light years ahead of Tableau and even Microsoft Excel to do these kinds of things. It is very easy to use and set up, and it has a lot of videos on the internet."
- "I would like it to be a little bit more secure when I'm using the design feature on my desktop. For example, to have the ability to set up security passwords for opening the file. Currently, they don't have that. Tableau, for example, has a visual way of doing data processing steps, whereas the Power BI system still has some code, although it is very low code. It would be great to have the kind of view that Tableau has."
What is our primary use case?
In general, we use it to have access to the data that we have processed from the HCM system and also to deploy it to the teams. Because it has low-level security features, I can guarantee that only selected people have access to the information seamlessly. We don't take a lot of steps to create, for example, different profiles and ensure the data security that I need.
It is on the cloud because we have pro accounts. Usually, we have the desktop version for designing and using ourselves here, but when we deploy this, it is usually on the Microsoft cloud; it is not on-premises. We are using the most updated version because they release monthly updates.
What is most valuable?
The querying capabilities are the most valuable because they allow me to build many automations. We have many workflows and many databases that we work on a daily basis. They need to be updated quite quickly. In order to not to take much of our time doing these updates manually, I have set up these automations using the systems. The process is just to ingest the data and reprocess it. Every time I click a button, everything is updated in almost real time.
It is by far the easiest system not only for querying but also for data modeling, data visualization, and deployment. It is light years ahead of Tableau and even Microsoft Excel to do these kinds of things. It is very easy to use and set up, and it has a lot of videos on the internet.
What needs improvement?
I would like it to be a little bit more secure when I'm using the design feature on my desktop. For example, to have the ability to set up security passwords for opening the file. Currently, they don't have that.
Tableau, for example, has a visual way of doing data processing steps, whereas the Power BI system still has some code, although it is very low code. It would be great to have the kind of view that Tableau has.
For how long have I used the solution?
I have been using this solution for around two and a half years. I am currently using it, and I have also used it in the previous company.
What do I think about the stability of the solution?
It is very stable and very reliable. It is by far the most reliable system I have used for deploying many things.
What do I think about the scalability of the solution?
It is very scalable, especially because the pricing was great. Right now, they are integrating a lot with Microsoft Power Apps and the Power Platform as a whole. Power Ultimate and other things are being integrated into the system as well.
In my previous company, more than 200 to 300 people were using it on a daily basis. In my current company, we have less than ten people using it because we are still a very confined team.
How are customer service and technical support?
The technical assistance is great, and I have never had any problems with them. Their support to communities is also great. I would rate them a ten out of ten.
How was the initial setup?
The initial setup was very easy. It took a little bit less than a month to get everything designed, tested, and deployed after we got the licenses.
What's my experience with pricing, setup cost, and licensing?
Its pricing is great.
What other advice do I have?
The first piece of advice is to become very clear about licensing and the data governors. Always get the licenses and get them right. You must also be clear about who is going to control these accesses. The second piece of advice is to understand a lot about the low-level security to create profiles and data access features to allow the specific data to be seen only by a specific public.
Currently, in my organization, the greatest challenge is getting proper licensing. We have a little bit of resistance from our IT department who would like us to use Tableau more. It is not Microsoft's problem. It has more to do with the vendor of choice of the company, and they say that we have to use Tableau, but I don't want to use Tableau.
I would rate this solution a ten out of ten. It deserves this rating.
Which deployment model are you using for this solution?
Private Cloud
If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?
Microsoft Azure
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Buyer's Guide
Download our free Microsoft Power BI Report and get advice and tips from experienced pros
sharing their opinions.
Updated: November 2024
Popular Comparisons
Splunk Enterprise Security
Databricks
SQL Server
Amazon QuickSight
Teradata
IBM Cognos
Rapid7 InsightVM
SAP Analytics Cloud
Qlik Sense
SAP BusinessObjects Business Intelligence Platform
Oracle OBIEE
Buyer's Guide
Download our free Microsoft Power BI Report and get advice and tips from experienced pros
sharing their opinions.
Quick Links
Learn More: Questions:
- BI Reports for business users - which BI solutions should we choose?
- Business users moving from Tableau to MS Report builder
- Is Power BI a complete platform or only a visualization tool?
- What are the key advantages of OBIEE compared to Microsoft BI?
- What Is The Biggest Difference Between Microsoft BI and Oracle OBIEE?
- Is Microsoft Power BI good for an ETL process?
- How would you decide between Microsoft Power BI and TIBCO Spotfire?
- Is it easy to extract data from Oracle Fusion into Power BI?
- PowerBI or SyncFusion - which is better?
- What challenges to expect when migrating multiple dashboards from TIBCO Spotfire to Microsoft Power BI?