For the most part, clients require dashboards. We are developing quite a few dashboards for them.
Cognos Consultant at Surtel technologies
A good tool with easy to design dashboards and helpful automation elements
Pros and Cons
- "There are some great automation elements in the product."
- "You do need to do some hard coding for certain things in Microsoft BI."
What is our primary use case?
How has it helped my organization?
The solution has improved a lot within the organization. We can view chunks of data and detailed data at various levels.
What is most valuable?
When we have done training in the cloud previously, I have a long experience in BI tools. I've worked on Cognos BI, Informatica, and other tools including QlikView.
The solution is stable.
The scalability is good.
There are some great automation elements in the product.
It's a good tool and designing dashboards is easy.
What needs improvement?
In SAP, we have a suite of components here in a single module. This includes forecasting and budgeting. There's also a smart answers section. Whenever we design any chart or something, the tool provides some information regarding that data. That would be quite a good feature that could be included in future versions of Microsoft BI.
The licensing could be a bit better.
You do need to do some hard coding for certain things in Microsoft BI.
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.
For how long have I used the solution?
I've used the solution for about one year.
What do I think about the stability of the solution?
The solution is stable. There are no bugs or glitches. I haven't had issues with it crashing or freezing.
What do I think about the scalability of the solution?
The scalability is great. If you need to expand the product, you can do so. You can easily add more users.
I'm not sure how many users are using the product.
How are customer service and support?
Technical support is great. I've worked with them before and have been happy with their level of service.
Which solution did I use previously and why did I switch?
I've previously used Cognos BI. I've also had the opportunity to work with SAP.
How was the initial setup?
I haven't got any opportunity to install any Power BI system. That said, for tutorial purposes, I have installed the desktop version in my system. It was very smooth.
It took 30 to 40 minutes for me to install the desktop version. During my learning phase, I prepared one dashboard. Similar to when I worked on Cognos BI, there were some features that we have to hard code and incorporate manually. There is some automation in Power BI. For example, if we are designing some interactive things we have to write code possibly. Still, even having to write code, in Power BI, was a very smooth experience.
We have people on our team that can handle maintenance tasks.
What about the implementation team?
We had a team of five to six people that handled the implementation in-house.
What was our ROI?
The client is continuing to use it, likely due to the fact that they see some sort of ROI. However, I don't have exact metrics.
What's my experience with pricing, setup cost, and licensing?
I'd prefer if the licensing was a bit better.
The customers need to pay the licensing fee. I can't speak to the exact pricing for their contract.
Which other solutions did I evaluate?
Typically, the solution architect is the one who decides which tool to use. However, we also were there and had a brainstorming session before choosing the tools. We did look at open-source options. At the time I prepared one checklist comparison between all the tools available in the market. Those included SAP, QlikView, and Tableau.
What other advice do I have?
We are an integrator and a partner. We are providing support activities to one of our clients.
I would rate the solution at an eight out of ten.
Which deployment model are you using for this solution?
On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Senior Product Manager Data Science at a insurance company with 1,001-5,000 employees
Powerful, low-maintenance, and useful for bringing visualization to data
Pros and Cons
- "It is useful for bringing visualization to data. It calculates counts, ratios, etc."
- "There could be an integrated AI that can automatically analyze some of your data and highlight or provide suggestions. For example, when you are looking at a data set, it can suggest putting it into a certain type of chart so that you gain different insights or a trend line. You would almost have templates that it would recommend for you."
What is our primary use case?
We use it for data visualization.
What is most valuable?
It is useful for bringing visualization to data. It calculates counts, ratios, etc.
What needs improvement?
There could be an integrated AI that can automatically analyze some of your data and highlight or provide suggestions. For example, when you are looking at a data set, it can suggest putting it into a certain type of chart so that you gain different insights or a trend line. You would almost have templates that it would recommend for you.
What do I think about the stability of the solution?
It is absolutely stable.
What do I think about the scalability of the solution?
It is absolutely scalable. You can scale it a lot.
How was the initial setup?
It has been straightforward and easy.
In terms of maintenance, for the most part, it is fairly low-maintenance. Once you have it set, it is fire-and-forget. The users want to see the view and the information, and there is nothing more to do other than just let it be.
What other advice do I have?
I would give it an eight out of 10. It is a pretty powerful tool.
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.
Head-IT/SAP at Barista Coffee Company Ltd.
Beneficial report generation, effective report management, and scalable
Pros and Cons
- "The solution overall is very useful. The reports that are generated and the reporting functionality management are beneficial."
- "We have used other solutions and the reporting functionality should be user-friendly and have a drag and drop feature should be available, but Microsoft BI doesn't have these features. When you are creating reports and you can't change as a user. Every time you need one developer or one technical person to make the changes."
What is our primary use case?
We are using Microsoft BI to generate point of sale reports.
What is most valuable?
The solution overall is very useful. The reports that are generated and the reporting functionality management are beneficial.
What needs improvement?
We have used other solutions and the reporting functionality should be user-friendly and have a drag and drop feature should be available, but Microsoft BI doesn't have these features. When you are creating reports and you can't change as a user. Every time you need one developer or one technical person to make the changes.
For how long have I used the solution?
I have been using Microsoft BI for approximately six years.
What do I think about the stability of the solution?
Microsoft BI is highly stable.
The performance depends on the requirement. You have to complete your requirement which is a priority. After that, you understand your requirement and the performance could be better. The performance is the second.
What do I think about the scalability of the solution?
I have found Microsoft BI to be scalable.
How was the initial setup?
The installation difficulty depends on the integration, once integrated properly you can receive results. Microsoft BI can be very helpful to your business.
The implementation took us 15 to 20 days.
What about the implementation team?
We use two Microsoft consultants to do the implementation of the solution.
Which other solutions did I evaluate?
I have evaluated other solutions.
What other advice do I have?
I rate Microsoft BI a five out of ten.
If I compare Microsoft BI with other solutions, other solutions are much better, but because we have already invested in Microsoft BI. We are using this and maybe in one or two years, we will use something else. We will finalize the testing of other solutions and implement one of them.
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.
Head of Product at Bitz
Stable, easy to set up and scalable
Pros and Cons
- "The initial setup is easy."
- "The solution doesn't integrate well with third-party tools."
What is our primary use case?
We use that solution to provide all the KPIs for the software development to manage the business, et cetera.
What is most valuable?
The solution is very helpful for managing the business.
The initial setup is easy.
We have found the scalability to be quite good.
Stability is excellent overall.
Technical support is good.
What needs improvement?
For managing the business, it's okay, however, as a product management tool, it's lacking. I would like to use BI to provide services for the customers eventually. Microsoft's solution is not good for improving the product for the customers. It's just good for managing the business, and not supporting the customers.
The solution doesn't integrate well with third-party tools.
I'd like them to add to the knowledge base, or at least to offer more documentation about how to use the solution.
It would be helpful if more AI was integrated into the solution.
For how long have I used the solution?
I['ve used the solution since 2013.
What do I think about the stability of the solution?
I find the product to be quite stable. There are no bugs or glitches. It doesn't crash or freeze. It's reliable.
What do I think about the scalability of the solution?
The scalability of the product is quite good. If a company needs to expand it, it can.
How are customer service and support?
We get technical support from a third party, however, they offer very good support and we have been quite happy with their level of service. They always have enough staff.
How was the initial setup?
The implementation process is straightforward. It's not overly complex or difficult.
Deployment took less than a month.
Which other solutions did I evaluate?
I'm also aware of Power BI, which has better integration with third-party tools.
What other advice do I have?
We do not sell Microsoft products. We just use them.
I'm not sure which version of the solution we're using.
We use both cloud and on-premises deployments.
I'd rate the solution at an eight out of ten. I'd recommend the solution to others as the management portion of the solution is very easy.
Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
VP Cloud Platform
Intuitive with great visuals and good scalability capabilities
Pros and Cons
- "Technical support has been great."
- "Most clients have MacBooks. Therefore, they use Tableau as Power BI Desktop is not available for the MacBook right now."
What is our primary use case?
We have a startup focused on analytics around sports and athletes' performance. The data sits in our platform called Hercules, which is exposed through an ODBC connector or API layer. We're currently building a connector to expose that data in a consumable way, inside Power BI (with one connector for Tableau as well).
What is most valuable?
I love the fact that it's got a very intuitive user interface.
I like the fact that you can create aggregations and view measures and metrics on the fly.
I like the visuals themselves as all of our customers are moving away from Excel and this gives them a very unique way to have their data represented in a more visual manner with active slicing and dicing data right there, with the time dimensions and different dimensions.
I also like the automatic refresh mechanism that it can do. You can have the data refresh automatically every 30 minutes, for example.
The initial setup is pretty simple.
The stability has been pretty good.
The solution can scale.
Technical support has been great.
What needs improvement?
Most clients have MacBooks. Therefore, they use Tableau as Power BI Desktop is not available for the MacBook right now.
When you're building, the documentation sucks. It's a painful experience to find out how to do things inside the connector framework.
I don't like the fact that they need to have a premium excuse to manage larger sets of data. On top of that, there are limitations in building a custom connector. If you want to build a custom connector for your customers, the navigation is flawed. For example, when I build a custom connector to talk to Power BI and report, I want some contextual data of the report, and I want to have what we call incremental refresh. However, incremental refresh right now is only supported in a SQL-based backend. It's not supported for API-based connectors. That's something that we really, really want. We only try to work around it.
Basically, I would love to see that incremental refresh with API-based connectors. I'd also want the report-based contextual information available inside the connector.
The licensing is very confusing.
For how long have I used the solution?
I've been using the solution since about 2014. I've used it for many years at this point.
What do I think about the stability of the solution?
We've found the stability to be fine so far. there are no bugs or glitches. It doesn't crash or freeze.
What do I think about the scalability of the solution?
It's easy to scale if you have the premium model. We just started exploring that right now.
The clients we have that use it are medium-sized businesses. These are basically soccer clubs or sports clubs, who are internally using it. however, we want to give it to a larger audience. We haven't gone there yet, though likely we will in the future.
How are customer service and technical support?
Technical support has been awesome. they are helpful and responsive and we are more than satisfied with the level of service we receive from them.
Which solution did I use previously and why did I switch?
I also use Tableau. I've used Power BI to a larger extent than Tableau, however, we have a startup in which we have an audience on BI and we are doing research to see how many of them are on Tableau versus Power BI.
We didn't previously use a different solution. We started with Power BI because that was one of our device partner's tools of choice. However, we are trying to support Tableau and Power BI now.
How was the initial setup?
The setup was pretty straightforward. I mean the setup for the Power BI Desktop. The download is pretty straightforward. Once you get to do more complex things with it, using the gateway and things like that, then it gets a little complex. On top of that, the documentation is difficult. It's there, however, it's difficult to find.
What's my experience with pricing, setup cost, and licensing?
The licensing is a little convoluted, and not easy to take advantage of. You're able to scale it in the premium model. However, they are very different versions. There's a difficulty in understanding which one of them applies to you and what the costs would be eventually, and what the performance and thresholds are for each one. The documentation might be there, however, for a small company, in order to find out all the aspects of licensing it's not that easy.
Which other solutions did I evaluate?
We've also evaluated Tableau and we use both right now.
What other advice do I have?
We are in the startup program for Microsoft.
I'm on the latest version of the solution. I cannot speak to the exact version number.
It's deployed on the cloud for automatic refreshment service and it's got a gateway on-prem.
It's a very good tool to quickly get started and it does scale, however, as you get into the larger deployments and at a larger scale, it's better to involve a Power BI expert or a partner to help you get there.
I'd rate the solution at an eight out of ten. There's room for improvement from the setup and scale perspective.
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
Data Scientist at a energy/utilities company with 501-1,000 employees
Provides good and logical visibility; difficult to easily share the dashboard with external people
Pros and Cons
- "It provides good visibility."
- "Things can slow down if you create too many pages."
What is our primary use case?
We are power industry consultants and we collect line operation data from power plants, preprocess it and then put it into some visualization software such as Tabula or Power BI. We then generate a regular test report for our customers who are power plant operators.
What is most valuable?
It provides good visibility to the customer. They can see everything that's going on in a logical and user-friendly way.
What needs improvement?
If you create too many pages, things can get heavy and slow down significantly. Once you create the dashboard, the data is updated at certain time intervals. I'd like to see more flexibility around those time options. It's difficult to easily share the dashboard with people outside the organization.
For how long have I used the solution?
I've used this solution for two years.
How are customer service and support?
The Microsoft support is not very good. When issues arise, I use Google or the user discussion boards.
How would you rate customer service and support?
Neutral
How was the initial setup?
The initial setup is straightforward, it's just a matter of downloading the software from Microsoft and installing it.
What's my experience with pricing, setup cost, and licensing?
The solution is very affordable.
Which other solutions did I evaluate?
The big difference between Tableau and Microsoft BI is the price tag which is much higher for Tableau. Tableau also provides a server for web publishing. It means you can easily share the visualization with people outside your company. In that sense, Power BI is more difficult. I also think Tableau may be more secure.
What other advice do I have?
I would recommend this solution if you're a smaller organization. If you have massive data, like a corporation, then Tableau is probably the product to use.
I rate this solution six out of 10.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Cloud business Director at a tech services company with 51-200 employees
Easily customizable, good reporting, and offers self-serve analytics
Pros and Cons
- "The amount of customization that you can do is good, and it's relatively straightforward to do."
- "The look and feel should be updated in terms of the types of dashboards and graphs that you can produce. They aren't as visual as some of its competitors."
What is our primary use case?
We are a solution provider and Microsoft BI is one of the products that we implement for our customers. It is used for customized dashboarding, reporting, and self-serve analytics, on a broad scale in enterprise.
What is most valuable?
The amount of customization that you can do is good, and it's relatively straightforward to do. People with limited experience in terms of coding can implement this themselves. If an organization doesn't have a high amount of skill, internally, then it's something that they can still spin up themselves, relatively well.
What needs improvement?
It could be changed to the point where it's more suited for self-serve analytics.
The look and feel should be updated in terms of the types of dashboards and graphs that you can produce. They aren't as visual as some of its competitors.
For how long have I used the solution?
I have been selling and using Microsoft BI for approximately two years.
What do I think about the stability of the solution?
Microsoft BI is a stable solution.
What do I think about the scalability of the solution?
This product is scalable.
We have dozens of customers that use it.
How are customer service and support?
The Microsoft technical support is not great. You need to have a partner in place that's able to handle these services for you. Customers aren't going to get answers quick enough if they're going directly to the vendor.
Which solution did I use previously and why did I switch?
I have experience with a couple of other similar products but I'd only downloaded the free versions of these tools to play around with. One of these is Tableau.
Tableau is a solution that would be used more at the enterprise scale. It may be more suitable for analytics.
These days, from a visual perspective in terms of analytics, dashboards, and customized dashboards, I tend to use Google products.
How was the initial setup?
The complexity of the installation depends on what you're using it for. If you're doing anything relatively complex, such as working with AI or machine learning, then you would probably want to have a specialist service provider do it for you.
We've seen that people are tending to use solutions that compete with it, just because they are easier to automate. From a large-scale point of view, the installation could be simpler.
That said, in its simplest form, it can be used for self-serve analytics.
What about the implementation team?
A company can handle the deployment and maintenance in-house on its own. Or, if they're doing a large-scale project, they might be in need of two engineers.
What's my experience with pricing, setup cost, and licensing?
My customers pay a yearly licensing fee.
From a cost point of view, it's competitive in the enterprise space, although it's not as competitive when you add up all of the additional costs. Things like integrations cost extra and it's probably where Microsoft makes more of the money.
What other advice do I have?
I would rate this solution an eight out of ten.
Which deployment model are you using for this solution?
Public Cloud
Disclosure: My company has a business relationship with this vendor other than being a customer:
Chief Technical Officer at Value Partners
Offers simple licensing, good pricing, and an easy setup
Pros and Cons
- "We find the solution offers good stability."
- "Microsoft Power BI was born native on the cloud, however, it's quite difficult when it has to connect to on-premise data sources."
What is our primary use case?
We are a consultant company so we use the many tools, just for our customers. However, we have professional services on, for example, Microsoft Power BI.
What is most valuable?
The initial setup is easy.
The solution is cloud-native.
It works well with Microsoft products.
The licensing is very simple.
We find the solution offers good stability.
You can scale the solution if you need to.
Technical support has always been helpful and responsive.
Pricing is quite reasonable.
What needs improvement?
They should improve the connector to on-premises data. Microsoft Power BI was born native on the cloud, however, it's quite difficult when it has to connect to on-premise data sources. You have a gateway. It's not very easy.
What do I think about the stability of the solution?
The solution offers good stability. There are no bugs or glitches. It doesn't crash or freeze. It's reliable.
What do I think about the scalability of the solution?
The product scales well. If a company needs to expand it, it's not a problem.
How are customer service and support?
We use a couple of professionals from Microsoft directly for our clients, and we are really satisfied with them.
Which solution did I use previously and why did I switch?
We use SAS BI and Microsoft BI. I prefer Microsoft BI as, from a licensing point of view, it's easier as it's a per-user licensing. If Power BI is the right tool for companies, it's a shorter time-to-market approach to business intelligence.
How was the initial setup?
The initial setup is very straightforward. It's not overly complex or difficult. A company should have no issue with the process.
What's my experience with pricing, setup cost, and licensing?
We find the licensing to be very straightforward. It's easier to understand than other options on the market.
The pricing is fairly inexpensive. It's not a costly solution.
What other advice do I have?
We have a business relationship with Microsoft. We are a Microsoft Gold Partner for cloud products. In the past, we've used a lot of Microsoft products and also some of our clients have used them directly.
I'd rate the solution at a nine out of ten.
I'd advise that new users should take care of the technical architecture in order to connect in the right way to the data sources to extract data.
Which deployment model are you using for this solution?
Public Cloud
Disclosure: My company has a business relationship with this vendor other than being a customer: partner
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?