It is one of the business intelligence tools we are using—mainly for all our data visualization purposes and building interactive dashboards. We use Microsoft Power BI to generate all different types of analytic reports. We move information from our data warehouse to a SSAS cube that we've built on top of all our dimensions. We also do a certain level of aggregation in the cube itself, which is then connected to Power BI.
Manager Technical Architect at Legato Health Technologies
Useful for data visualization and building interactive dashboards
Pros and Cons
- "It works well with SSAS, which we use to generate all different kinds of trending and analytics reports. Sometimes we use Power Query and DAX to build some aggregations on the Power BI side as well."
- "Sluggish performance when handling large amounts of data."
What is our primary use case?
What is most valuable?
It works well with SSAS, which we use to generate all different kinds of trending and analytics reports. Sometimes we use Power Query and DAX to build some aggregations on the Power BI side as well.
What needs improvement?
I would like to see Microsoft BI add custom visuals and certain machine-learning capabilities. It would be nice if the DAX functions could perform some kind of predictive modeling. Right now, it just does a kind of descriptive analytics.
For how long have I used the solution?
I've been working on Microsoft Power BI for three years.
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 stability of the solution?
Throughout several updates over the past three years, I never saw any issues, particularly with installation or anything, so I see the product as stable.
What do I think about the scalability of the solution?
I feel that scalability is one area where there is room for improvement. When there is a huge volume of data, like when we apply the aggregation, the reporting slows down. That's why we mostly build things in the SSAS cube itself instead of bringing it back to Microsoft BI to do the aggregation. Certain incredibly small aggregations can be done on the Microsoft BI side, but if the dashboard size is more than 1 Gigabyte, you start to see some performance issues.
How are customer service and support?
The Power BI community is really big, so we mostly rely on other users for support.
Which solution did I use previously and why did I switch?
In some projects, we have used Tableau or ThoughtSpot. If we're dealing with big data, then we often consider using Tableau. Power BI has some additional features that Tableau doesn't have, like DAX and Power Query, but Tableau works better from a scalability standpoint. Sometimes for reporting purposes, when we want to generate some kind of dashboard on the fly for the user, we have used ThoughtSpot.
How was the initial setup?
We didn't experience any complications. We built everything on the desktop and in the .pvi files, then just move those files to the server. Afterward, we didn't see any issues at all in terms of setup.
What's my experience with pricing, setup cost, and licensing?
I'm unsure about the exact cost, but the Pro license comes out to around $10 per user. There are also additional costs for custom visuals that you can pay for.
What other advice do I have?
I would rate Microsoft BI an eight 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.
Portfolio manager at a transportation company with 5,001-10,000 employees
Great for visualizing data with good flexibility and an excellent dashboard
Pros and Cons
- "The visuals are great and make everything look very professional. We can change the look and feel or manipulate the data according to our requirements. It's extremely flexible."
- "It's quite difficult to learn how to use Power BI."
What is most valuable?
Microsoft Power BI is a very powerful tool. It allows us to extract data from Excel or Share Point.
We can send various project reports from the dashboard to management. It allows us to set up our own preferences.
We can work with all sorts of data from the previous year or two. With that native data, we can have everything in one dashboard that accurately reflects the reporting. The visuals are great and make everything look very professional. We can change the look and feel or manipulate the data according to our requirements. It's extremely flexible.
The solution has been very stable so far.
We find the product to be quite scalable.
What needs improvement?
It's quite difficult to learn how to use Power BI. I'm not from the IT background, and I've been given the license to use the Power BI, however, I find that the support and video demos from Microsoft are not really helpful for me. I don't handle Microsoft BI 24/7. My working time isn't dedicated to using it and learning it. I need it for certain tasks and trying to wrap my head around it, while also handling other duties is difficult. There's too much of a learning curve for beginners.
The cost of the solution is high.
For how long have I used the solution?
We originally started our migration back at the end of 2019. We've used it for a year or two now.
What do I think about the stability of the solution?
The product is 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 solution can scale. If a company needs to expand it, it can do so. It's not a problem.
Right now, in our organization, only 15 of us have the full license for the Power BI Pro. Not everyone in the office actually uses it. However, we have over 1,000 people using various other Microsoft products in our company.
How was the initial setup?
As I am not technical, I did not handle the initial setup. We have IT personnel within our organization that handled it. I just gave them my laptop, and they just installed it for me. Occasionally, they can also do it remotely from their office to our office. I never touch it. We just open the apps from the desktop. The process, when do that way, i's quite convenient. It's quite easy for end-users.
What about the implementation team?
We have our own IT team that handles the installation. They either take the laptop or do the installation remotely. In either case, it's handled in-house and not by integrators or consultants.
What's my experience with pricing, setup cost, and licensing?
The solution is quite expensive.
What other advice do I have?
I'm an end-user of the product, however, I'm not overly technical or in IT.
We have a custom Microsoft setup. We are using a few apps from Microsoft, such as the Microsoft Plan, and we are using Power BI, Power Automate, et cetera. It's all from Microsoft, and it is part of our IT infrastructure. When we combine it together, it is a project and portfolio management solution. It is not a commercial, off-the-shelf product.
I'm not sure which version number we are using.
I'd rate the solution at a nine out of ten.
In terms of Microsoft Power BI, for all people who need to do their own reporting or want to visualize their daily work or tasks, in terms of projection, giving others a view on what they are doing, it's a very good tool. It allows users to show projections of what we are doing. Users can grab statistics, which is quite convenient, and understand what they are doing from a visual perspective, which we find quite useful.
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.
Lead Technical Instructor at Code.Hub
A more intuitive solution than the competitors and provides a better understanding of the whole process without needing much code
Pros and Cons
- "In contrast to what we were using before I think that Power BI has given us more extensive results."
- "I would like to see integration with Excel."
What is our primary use case?
I'm using the desktop version and collaborating within our company.
As a training company we wish to analyze the instructions as they relate to our customers. Also, we take certain examples for our classrooms, our training.
What is most valuable?
I consider the solution to be quite good. In contrast to what we were using before I think that Power BI has given us more extensive results. It's more intuitive and it is better for understanding the whole process without much code. We're only using the user interface, not writing code.
We find it to be easier and it provides a better understanding of the results, both for us and our customers.
What needs improvement?
I cannot think of anything needing improvement at present and am quite satisfied with what we have, This said, I would like to see integration with Excel. This is because many of our customers like to have their results appear not only on a dashboard, but also in Excel, as they use it extensively. They would approve of the integration.
Also, there should be greater functionality from Power BI for the performance of certain complex tasks. Many things are being done with the interface and if we'll want automation to play a role then we will need more flexible programming, such as we have with Data Expressions. The interface must be utilized for carrying out more complex tasks. We wish to automate this using software and programming language.
For how long have I used the solution?
I have been using Microsoft BI for one or two years.
How are customer service and technical support?
I feel the technical support to be fine. We have all the support that we need.
How was the initial setup?
Having a proper understanding of how the data is modeled poses the greatest challenge. However, someone who has this should find the installation to be quite straightforward. The initial step involves having an understanding of the data model.
I think the setup is quite easy and straightforward. The solution can simply be downloaded and used. The most difficult thing involves the distillation of SQL Server, not what relates to Power BI.
What about the implementation team?
From our side we have around 20 people who are responsible for the deployment and maintenance, although I include in this figure not only the technical but all of the administrative staff. We have the trainers and also the people who are working with the technical support to deliver the training.
What's my experience with pricing, setup cost, and licensing?
The cost of the solution is more flexible for us because the desktop is free and we pay as we use it in the cloud.
The customers have licenses of their own. We use their installations to help them with their work. Usually, these people represent new entries into the company and we give them the initial experience to start working with the software.
What other advice do I have?
As I could tell, I feel the solution to be easy. It is very good that all the users, as they use MS SQL, have a product from the same company. It is an overall experience for them to use Power BI.
We are an end-user and a partner to the vendor. We do training and provide consultations to our customers.
We work with companies, around eight in total, and we deal with their employees. Overall, we are talking about approximately 300 people. We give training to the employees of these companies and also provide consultations.
I strongly recommend the solution because I think it's a very modern tool and quite easy for all the data analysts and programmers.
I believe that all of the people who we have mentioned so far are quite satisfied with the solution.
I rate Microsoft BI as a nine out of 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
Manage Client Partner at a tech services company with 501-1,000 employees
Feature rich, functional dashboard, and plenty of charting visuals
Pros and Cons
- "I have found the best features to be the dashboard creation, graphs, charts, and presentation bar graphs."
- "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."
What is our primary use case?
I am using the solution for data analytics.
What is most valuable?
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.
What needs improvement?
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.
For how long have I used the solution?
I have been using the solution for approximately one year.
What do I think about the stability of the solution?
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.
What's my experience with pricing, setup cost, and licensing?
This solution came free, it was offered by Microsoft with our E3 license.
What other advice do I have?
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.
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
Regional PDS - Director of Business Intelligence at JLL
I like it's ability to do almost anything to create the necessary calculated fields and measures (DAX)
What is our primary use case?
- Running a team to build end-to-end BI solutions for large enterprises.
- Data typically stores in SQL Server. Some ad-hoc data pulled from SharePoint lists or Excel files.
- Use of SSAS Tabular in some models.
- Currently, no deployment of premium. A large deployment of PBI Pro.
- We also use Tableau Desktop and on-prem server, but Power BI was a go-to product.
How has it helped my organization?
- An easy learning curve for analysts. If they know how to use Excel pivot tables, then they can self-serve building visitations on curated data.
- Full stack end-to-end ETL and viz in one tool.
- Power Query for ETL, and externally easy to use. Majority of activities are low or no code.
- Creating a model and augmenting with additional calculations and measures extremely easily.
- Viz layer build is super fast. Very much like a PowerPoint experience.
- All elements together allowed for the rapid deployment of PoC products that could be tested and validated by businesses before being deployed.
What is most valuable?
- Power Query: The data prep tool allows for very easy ingestion, shaping and prepping of the data before loading into the model.
- DAX: Its ability to do almost anything to create the necessary calculated fields and measures.
- Viz layer: It's just easy to lay out a page.
What needs improvement?
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).
For how long have I used the solution?
One to three years.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
BI Expert with 501-1,000 employees
Cost-effective, all-in-one package for business intelligence
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?
Disclosure: I am a real user, and this review is based on my own experience and opinions.
New Digital Applications Specialist at Alpina Sa
Intuitive design, scales well, and simple setup
Pros and Cons
- "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."
What is our primary use case?
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.
How has it helped my organization?
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.
What is most valuable?
The most valuable features of Microsoft BI are its intuitiveness and ease to use.
What needs improvement?
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.
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?
I rate the stability of Microsoft BI an eight out of ten.
What do I think about the scalability of the solution?
I have plans to use the solution more in the future.
I rate the scalability of Microsoft BI an eight out of ten.
How was the initial setup?
The initial setup of Microsoft BI is simple.
What was our ROI?
We have received a return on investment using Microsoft BI.
What's my experience with pricing, setup cost, and licensing?
The price of the license can be better.
What other advice do I have?
I rate Microsoft BI an eight out of ten.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Product and Systems Director at SPCM
It's good for tracking indicators like KPI, sales, and a bunch of other essential metrics for our company's strategic planning.
Pros and Cons
- "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."
- "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."
What is our primary use case?
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.
What needs improvement?
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.
For how long have I used the solution?
We've been a Microsoft partner for 12 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?
Microsoft BI is scalable.
How are customer service and support?
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.
How was the initial setup?
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.
What's my experience with pricing, setup cost, and licensing?
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.
What other advice do I have?
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.
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: 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?
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.