The use case for power BI is to generate dashboards for high-end management and operational dashboards.
Principal System Developer at HHRC
Is easy to install, stable, and scalable, and helps to quickly create dashboards
Pros and Cons
- "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."
- "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."
What is our primary use case?
How has it helped my organization?
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 is most valuable?
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.
What needs improvement?
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.
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 been using this solution for two to three years.
What do I think about the stability of the solution?
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.
What do I think about the scalability of the solution?
The scalability of Power BI is quite good.
How are customer service and support?
Microsoft technical support could be more knowledgeable.
Which solution did I use previously and why did I switch?
We switched to Power BI because it is easy, and there is rapid development.
How was the initial setup?
Installation is easy and took about half an hour.
What about the implementation team?
It requires a little bit of effort, and we needed the help of a consultant.
What's my experience with pricing, setup cost, and licensing?
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.
What other advice do I have?
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.
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.
Manager- Projects at a computer software company with 10,001+ employees
Dashboards are easy to use
Pros and Cons
- "The dashboards of Microsoft BI are easy to use."
- "Microsoft BI has its own challenges in terms of user interface and how quickly somebody can learn how to use it."
What is our primary use case?
My company uses Microsoft BI's dashboards. We build them for the business and the operations team. We have four to five customers using this solution.
What is most valuable?
The dashboards of Microsoft BI are easy to use.
What needs improvement?
I would like to see the usability improved with Microsoft BI. Microsoft BI has its own challenges in terms of user interface and how quickly somebody can learn how to use it.
For how long have I used the solution?
I have been using Microsoft BI for four years.
What do I think about the stability of the solution?
Microsoft Power BI is stable compared to any other business subjects or any other tools.
What do I think about the scalability of the solution?
Any Microsoft project is scalable.
How are customer service and support?
Technical support has been good.
Which solution did I use previously and why did I switch?
We have used QlikView. Microsoft BI's dashboards are easier to use and not as complex.
How was the initial setup?
The initial setup of Microsoft BI is straightforward and easy to install. We install ourselves.
What other advice do I have?
I would recommend Microsoft BI. The dashboards are not that complex and are easy to use.
I would rate this solution an 8 out of 10.
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
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.
Managing Director at Innovative Business Analytics
Reasonably priced, with excellent virtualization
Pros and Cons
- "The virtualization of Microsoft BI is very good."
- "The DAX in Microsoft BI is quite difficult."
What is our primary use case?
I am surveying and researching this solution, in order to provide it to my customer.
Microsoft BI is used to create a dashboard or reports in the customer's environment.
I implement Power BI on desktops for my customers to use for sales and financial analysis. The customer must purchase Power BI Pro from their company, and then they can use it.
What is most valuable?
The virtualization of Microsoft BI is very good.
What needs improvement?
The DAX in Microsoft BI is quite difficult.
The DAX is where the soft data is accessed. The DAX command is used for coding.
I would like to see the DAX simplified, and the number of pages in Microsoft BI should not be limited to one. You should be able to scroll endlessly left, right, up, and down. Typically, Power BI has a page. On this page, the limit could be eight or ten objects that fill the entire page, and you must proceed to the next page. If possible, I'd like Power BI to do the scroll up, scroll down, with unlimited scrolling on one page.
For how long have I used the solution?
I have been working with Microsoft BI for a few months.
What's my experience with pricing, setup cost, and licensing?
The price is good. They have a free Power BI Desktop version, but it has limitations.
They also offer Power BI Pro at a reasonable price. Power BI Pro is appropriate for large enterprises with at least 500 users. The price may be very expensive per month.
The pro version is not suitable for the majority of my customers, who have five or ten users.
What other advice do I have?
If you are a single person using this solution, I would recommend using the desktop version. Power Pro can be used for multiple users ranging from 20 to 50, eliminating the need to invest in Power BI Premium.
Maybe, in the long run, I can be a Microsoft partner, but first I need a large number of customers.
I would rate Microsoft BI 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.
General Manager at a tech services company with 51-200 employees
Great for companies using a lot of Microsoft products, stable, and fairly simple to set up
Pros and Cons
- "It's pretty easy to set up the product."
- "We haven't used it that long and I haven't come across anything that's stood out as needing to be fixed."
What is most valuable?
The stability is good.
It's pretty easy to set up the product.
For the most part, users can scale the solution.
Technical support is okay.
It's a great option if a business is already heavily involved with other Microsoft tools.
What needs improvement?
I can't speak to any missing features. We haven't used it that long and I haven't come across anything that's stood out as needing to be fixed.
For how long have I used the solution?
I've just started with the solution. I've used it for under a year so far.
What do I think about the stability of the solution?
The solution is stable and the performance is pretty good, From what I have experienced. There are no bugs or glitches. It doesn't crash or freeze. It's reliable.
That said, we haven't used it for a full year yet, and it's hard to gauge its stability for the long term. Right now, based on the information I have, I'd rate it at 70% stable.
What do I think about the scalability of the solution?
While, for the most part, it is scalable, it still has its own limitations.
We have three customers that currently use the product.
How are customer service and support?
We've dealt with technical support in the past. They are okay. I'd describe them as average. We haven't necessarily had a bad experience.
How was the initial setup?
I wasn't directly involved in the implementation process. From the feedback from the engineers working on it, in terms of if it is an easy installation, t's not that difficult. The difficulty level depends on the experience of whoever is installing. It depends on the experience of the guy behind the installation or the software guy. My understanding is that there is no difficulty region to region.
We have about five people who can handle deployment and maintenance duties on our team. We have a mix of managers and admins.
What about the implementation team?
We are able to handle the implementation process for our clients.
What's my experience with pricing, setup cost, and licensing?
The client does need to pay for a license in order to use the product, however, I can't speak to the exact lengths of license agreements on offer or how much they cost.
Beyond the standard licensing fees, the only other extra cost would be support.
Which other solutions did I evaluate?
There are other options, however, it depends on the client's services. If clients have already made up their minds and they know what they want to go for, we simply help implement. We can give them more options of solutions to choose from. However, many prefer Microsoft as most of their other applications are already Microsoft. It makes sense to stay within the brand.
What other advice do I have?
I'm an integrator and reseller.
I'm not the one in charge of the installation or the technicality of the product. I'm more on the business side.
I always let clients have options and guide them to go for the one that best fits what they want to achieve. Other solutions have areas of strengths and weaknesses. You need to look at everything and examine everything before making a decision.
Currently, I'd rate the solution at a seven out of ten. We haven't yet used it a year, and we're still learning about it and seeing what works well for clients. Over the next few months, we'll likely have a fuller picture of the product.
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?
Amazon Web Services (AWS)
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Graduate Engineer at a transportation company with 5,001-10,000 employees
Stable and easy to use
Pros and Cons
- "One of the most valuable features of Power BI is the ease of use. It is comfortable and there is not a steep learning curve for this solution. If you have some idea of the data and basic visualization ideas, you can use this solution comfortably."
- "Power BI's drillthrough feature could be improved. I didn't like drillthrough and those options much, but I did like it in MicroStrategy."
What is our primary use case?
We use Power BI for a variety of applications, including retail analytics, sales, and process digitization. Except for time series data, we use it for everything.
We have both deployment options open, so we have the requirements for both on-prem as well as on the cloud.
What is most valuable?
One of the most valuable features of Power BI is the ease of use. It is comfortable and there is not a steep learning curve for this solution. If you have some idea of the data and basic visualization ideas, you can use this solution comfortably.
What needs improvement?
Power BI's drillthrough feature could be improved. I didn't like drillthrough and those options much, but I did like it in MicroStrategy.
As for additional features, I think Power BI could have better interactive features for the end user and scalable drillthrough options.
For how long have I used the solution?
I have one year of experience with Microsoft BI.
What do I think about the stability of the solution?
Power BI is stable. I have not used it extensively, but from what I understand from my colleagues, it's stable.
What do I think about the scalability of the solution?
Power BI is scalable. In my organization, there are probably 400 or 500 companies using this solution. We are probably going to increase our usage.
How was the initial setup?
I have no idea whether the installation process was straightforward or not, on the admin side. As for the technical team required for deployment and maintenance, I would say you need maybe one or two admins. The development is based on use cases, but on average, I would say you need some 10 to 15 BI developers.
What's my experience with pricing, setup cost, and licensing?
We pay for licensing for Power BI.
Which other solutions did I evaluate?
We are also using MicroStrategy. I did not like the drillthrough feature in Power BI, but I liked it in MicroStrategy. The way visualization works, I found that the interactiveness of MicroStrategy was better than Power BI. Similarly to Power BI, you can comfortably use MicroStrategy if you have some idea of the data and basic visualization ideas.
What other advice do I have?
I rate Power BI an eight out of ten.
I would recommend Power BI to those considering using it, but would also recommend that they explore it themselves and understand their requirements. Their requirements will be different, so it's all use case based.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Manager - Customer Success at a tech services company with 10,001+ employees
User-friendly and easy to install but isn't very scalable
Pros and Cons
- "The product is stable."
- "My data is restricted to my DB and I'm not sure how this would handle an extremely large dataset."
What is our primary use case?
We primarily use the solution for analysis. I have a DB setup that I have. I use that DB for analyzing data, providing business solutions or business insights to the customers. Most of the time, I use Power BI for that or sometimes even Tableau.
What is most valuable?
The solution isn't hard to use. It's very user-friendly.
The product is stable.
The product is easy to install.
What needs improvement?
I haven't used the advanced version and therefore haven't accessed all of the features.
The solution isn't very scalable. My data is restricted to my DB and I'm not sure how this would handle an extremely large dataset.
For how long have I used the solution?
I've been using the solution for two years.
What do I think about the stability of the solution?
The stability of the product is good. It doesn't crash or freeze. there are no bugs or glitches. It's reliable.
What do I think about the scalability of the solution?
I wouldn't describe the solution as scalable.
While it is available as an option to most people in our organization, I'm not sure how many people are actually actively using it. I know that I use it myself quite often.
How are customer service and technical support?
I've never reached out to technical support for assistance. I cannot speak to how helpful or responsive they are.
Which solution did I use previously and why did I switch?
I also use Tableau. I've used Tableau for about seven months.
There are other programming languages like Python and R, where they use analytics for graphical representation, or they can use Power BI and Tableau in our company. There are many options.
How was the initial setup?
The installation is not complex or difficult. It's straightforward.
We have Office 365, which holds Power BI, and therefore I was able to have it easily installed.
I can't recall how long the deployment actually took.
What's my experience with pricing, setup cost, and licensing?
I personally do not pay for a license. It may be arranged through our company. I have no insights into that aspect of the solution, however.
What other advice do I have?
I'm a customer and an end-user.
The solution, being on the cloud, is automatically updated, and therefore, you are always on the latest version if you are using it.
I'd rate the solution at a seven out of ten.
I'd recommend the product to those who want a basic tool that can help them study analytics.
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.
Certified Adjunct Faculty, School of Engineering and Computing at a university with 1,001-5,000 employees
Helps introduce data analytics in a way that students understand and appreciate
Pros and Cons
- "What Power BI is, is a whole collection of templates of small amounts of data that can be used to do something for a real world project, that can be easily set up and become the business intelligence environment or a data warehouse for a large amount of data, for a real world customer. That's what is remarkable."
- "When it comes to improvement, I would say there could be more tutorials for students in universities who are just learning it. And it wouldn't have to be just for students in universities. It might also be for the people who use it in the real world."
What is our primary use case?
I have taught and mastered many desktop tools, including Power BI, for the purpose of prototyping designs for business intelligence and data warehousing. Currently, I am teaching data analytics at graduate level and Power BI is on my schedule.
We teach tools like Power BI by going through common scenarios in a business intelligence environment, which most often deal with the factual numerics that get designed into a sales force reporting dashboard or similar solution, showing details like order placement, orders shipped and paid for, etc. The templates for these typically use a style of diagramming called star schema, which is a common dimension modeling technique.
I can't say whether it's the most frequent real-world use case that a real customer would focus on, but for the level of our tutorials, a sales scenario might involve a description of customers, products, locations, maybe geography, and the timing of sales for trends analysis.
Other than Power BI, I also teach AWS and Azure, where I help guide students to plan and come up with architecture for deploying to the cloud. It's not actually very hands-on, as it's more to help with architecture diagramming for the intentions that students have when using them. And at our institution, all of our courses last only four weeks, so it's very fast tracked, which sometimes means that we don't really go too in-depth.
AWS has a lot of samples and diagrams, including many graphics that are fairly artistically detailed. The level at which I've helped students reference those kinds of diagrams is mainly for their team projects, to illustrate their intention, for example, to deploy a database into AWS. If it's an SQL Server database, we usually choose Azure. But it's not to actually do it. It's rather to have the intention to, for illustration purposes.
How has it helped my organization?
I had a brilliant student in May last year, 2019, who did her graduate capstone project - where I was her advisor - using Power BI. And she has two times now responded to my invitation to be a guest speaker on that tool to classes such as the data analytics class that I've been teaching for about 20 times now, going back six years.
At my institution, I'm the only one teaching database design, whether undergrad or grad, and I found Power BI was a very attractive tool to introduce during the database design class, and then later enable the students to use it for their capstone. Unfortunately, it didn't work out in November this year, because few of the students picked up on it and gave the actual time it would take to focus their attention on using Power BI templates.
Overall, my observation is that the enrollment is way down and the students who are still in the program are very distracted, I think because of the pandemic. Despite this, Power BI has helped me introduce students to business intelligence and data analytics because it's a very attractive and cost-effective tool (there's no cost to it, it's free).
Another reason I'm inspired to focus my time on helping students with Power BI is because of the analyses done by the Gartner Group and Forrester Research, wherein they reviewed the strengths of Power BI. Both of them call it a "killer app". That caught my attention. And Power BI seems like the best thing to suggest to the students.
And I'm up to it on my side teaching through online, although I'm regretting that I cannot go on a campus to be still there for the students whose strong preference is to be together in a room learning on site. I hope that in the class in May, there'll be more people really interested in actually using it. In November, I was hoping some of the students would, but for reasons such as the pandemic, these online students have too many distractions. Especially if they're also still working or they have families with kids at home.
What is most valuable?
What Power BI is, is a whole collection of templates of small amounts of data that can be used to do something for a real world project, that can be easily set up and become the business intelligence environment or a data warehouse for a large amount of data, for a real world customer. That's what is remarkable. And that's what it takes.
It makes use of the ordinary things, and they'll sound familiar. Excel, Access, or SQL Server as the database, and the deployment techniques like Azure for it to be in the cloud.
It's very heavily like Microsoft promoting its own products, but I forgive it because this time it works. And I'm speaking from some experience; I worked in the data warehouse technology group at Oracle for three and a half years, and I was helping Oracle's clients put up a data warehouse with Oracle as the database, and to migrate data into the Oracle database. So that was my background. And for me to be persuaded that this collection of regular, already known, already used desktop tools could work just as well, but with the added value of the samples, the templates, frequent updates, and lots of support. That says a lot.
It also has other features that I like, especially regarding the designs in the set of templates for things that would perhaps be very puzzling to somebody doing it for themselves. It has pre-built tables to hold, during project lifestyle, maybe a small select amount of test data with the intention of the large amount of data going into production after deployment. And it has all the table designs that start out generic but that can be easily customized.
What needs improvement?
When it comes to improvement, I would say there could be more tutorials for students in universities who are just learning it. And it wouldn't have to be just for students in universities. It might also be for the people who use it in the real world.
The evidence that I see when I look into it is there's a lot of user group type of connections to the Power BI world. And many, many bloggers telling their stories and promoting themselves or small businesses promoting themselves to do it for you using Power BI. The claim being that they could help you get it done instead of you doing it yourself. That's what goes on in this industry. You see a lot of entrepreneurial people who want to work in the role of consultant and get paid for it. There's a lot of that.
And the invitation to look into the websites comes from little mini tutorials, which can be very helpful. But the next step of those tutorials, if most of the people get what they want out of them, is a contract to do the work. I don't want to introduce those kinds of things to my students, because it's kind of promoting something that could be a distraction.
I worked for years as an independent consultant. I even did a fairly long series of contracts up in the state of Washington at Microsoft and I had 38 years in the industry before I became an academic teacher. But I'm avant-garde when it comes to sales. I avoid salesman because I don't want to believe the hype. I don't want to be deceived. And I don't want to suggest that somebody go that way. The topic of sales is overdone. This is an opinion on my part.
On a practical note, the process of importing data into a new environment that has recently been designed is always a major effort. And Power BI has some weaknesses when it comes to loading data into an otherwise good concept and a good design because if it's not seriously tested and all shortcomings noticed beforehand, the importing process will fail.
Even a cool tool like Power BI cannot anticipate the complexity of the variety of sources of data. But they're not alone. That would not be a disqualifier. But because I don't have direct yet, hands-on, having done this, I don't really know how Microsoft would improve this area.
I think they've got it handled on integration. Everything that you're working with is already a Microsoft environment or a Microsoft tool. It's integrated. But if you're using the desktop tools by Microsoft and you need to deploy into a backend of Oracle, there might be some things that a smart consultant has to help out with. So cross-platform integration could use some improvement in terms of ease-of-use.
For how long have I used the solution?
I have used Microsoft BI in my data analytics classes for a few years now.
What do I think about the stability of the solution?
In an abstract sense, it's holding up. I don't speak to actual customers of Microsoft products to answer that question. But I would suggest that it's holding up because the Gartner Group put out another magic quadrant output that describes it as being in the leader category.
It's a well-respected research group, Gartner. In fact, companies that want to acquire its research for anything more specific or consulting, have to pay for it and have ownership. I don't pay for it. But there are many vendors who have my school email on their lists, so I get the reports for free, and I have my hands on quite a collection of the reports.
And that's why I'm mentioning them because the Gartner Group has mentioned Power BI twice now. So as far as long-term prospects go, I'd say Power BI is a stable solution.
How are customer service and technical support?
Microsoft provides frequent updates and a lot of support for Power BI.
Which solution did I use previously and why did I switch?
I have worked in the data warehouse technology group at Oracle for three and a half years, helping Oracle's clients deploy a data warehouse with Oracle as the database. But when Power BI came onto the scene, I was more and more persuaded to use it instead for business intelligence and data warehouse purposes. This was mainly because I enjoyed how easily Power BI builds on existing tools that I'm already familiar with like Excel and Access.
How was the initial setup?
The setup is straightforward, because it exhibits itself within familiar tools, like spreadsheets.
The complexity comes when you try to convert from simple beginnings into something that needs to eventually become reality. But I'm guessing. I don't know that it's complex. And anyway, I personally like complex. It attracts my attention.
What's my experience with pricing, setup cost, and licensing?
For my primary use case, i.e. teaching students, the free version of Power BI is adequate.
What other advice do I have?
May is the next time I'll be teaching the data analytics class, the graduate class, and I will be actively trying to promote Power BI for the team project.
I would rate Microsoft Power BI an eight out of ten.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Interim Manager Supply Chain / IT at a consultancy with 501-1,000 employees
It is connected to every database: Whatever and wherever it is
Pros and Cons
- "It is easy to work with and very chic."
- "Its connection to every database: Whatever and wherever it is."
- "The look is simple, and could be a little more professional."
What is our primary use case?
Its primary use case is for CIPs from the purchasing department. It performs perfectly. It is very quick and easy to use.
How has it helped my organization?
We approve it for use with SAP BI, so it has been more effective for our users and much cheaper. So, the costs are small and the benefits are high.
What is most valuable?
Its connection to every database: Whatever and wherever it is.
It is easy to work with and very chic.
What needs improvement?
The look is simple, and could be a little more professional.
For how long have I used the solution?
One to three years.
What do I think about the stability of the solution?
The stability is very good. We have no problems.
We receive an update every month with new functions, so we are not missing anything.
What do I think about the scalability of the solution?
The scalability is good. It works for a large community just fine.
How are customer service and technical support?
We have not needed to use technical support. We are able to do everything by ourselves. That is one of the main reasons that we like the product.
Which solution did I use previously and why did I switch?
We have SAP BI working. It has cost us more than a million Euro, and it does not work. This was one of the reasons to change.
Power BI is very easy to use and much sleeker.
How was the initial setup?
The initial setup was straightforward. 30 minutes, and it runs perfectly.
What other advice do I have?
I would recommend Power BI as the best working solution.
Most important criteria when selecting a vendor: Usability of the solution.
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?