Syed Fahad Anwar - PeerSpot reviewer
Principal System Developer at HHRC
Real User
Top 5Leaderboard
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?

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

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
March 2024
Learn what your peers think about Microsoft Power BI. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
767,667 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.
PeerSpot user
Practice Manager at a computer software company with 10,001+ employees
Real User
Reasonably priced, easy to deploy, and user-friendly data analytics and reporting solution
Pros and Cons
  • "Good reporting and data analysis tool that's user-friendly, easy to deploy, stable, and scalable."
  • "The UI looks awkward once the graphs have been generated in the console. This is what Microsoft can work on."

What is our primary use case?

We use Microsoft Power BI for production testing. We're not using it for production automation. It's being used for testing and testing themes. We have a testing requirement, so we want to mimic automated workflows on production to be validated on regular intervals, and this is how we use this solution.

What is most valuable?

One valuable feature of Microsoft Power BI is that it's user-friendly. It also has good connectivity between multiple source systems. It's also a good data analysis tool.

What needs improvement?

The UI looks awkward once the graphs have been generated in the console. This is what Microsoft can work on. They should make the graphs more user-friendly, because other parts of Microsoft Power BI are user-friendly, but the graphical representations aren't.

For how long have I used the solution?

We've been dealing with Microsoft Power BI for five to ten years now. We were early adopters of cloud solutions, e.g. AWS and Azure, which we adopted from the start. We are a complete cloud company.

What do I think about the stability of the solution?

Microsoft Power BI is a stable solution.

What do I think about the scalability of the solution?

I find Microsoft Power BI scalable.

How was the initial setup?

It's very easy to deploy Microsoft Power BI.

What's my experience with pricing, setup cost, and licensing?

Microsoft Power BI has reasonable pricing.

Which other solutions did I evaluate?

We evaluated Microsoft Azure.

What other advice do I have?

We use Microsoft Power BI. We also use AWS, but what we primarily use is Microsoft Power BI.

We're using a combination of deployment models for this solution, because the model will depend on the customer need.

We don't procure this solution and other Microsoft tools for ourselves. It's the customer who procures them, and there is not much issues for us to contact support. We are a Microsoft company, e.g. we are partners with Microsoft, so we have good rapport with them.

We recommend Microsoft Power BI even for large enterprises. It's a tool that could be used even by smaller enterprises and by end customers.

My rating for Microsoft Power BI is an eight out of ten.

Which deployment model are you using for this solution?

Hybrid Cloud
Disclosure: My company has a business relationship with this vendor other than being a customer: partner
PeerSpot user
Buyer's Guide
Microsoft Power BI
March 2024
Learn what your peers think about Microsoft Power BI. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
767,667 professionals have used our research since 2012.
BI Consultant at a manufacturing company with 1,001-5,000 employees
Real User
DAX and M Query makes impossible things possible, but is overall lacking in visual standardization
Pros and Cons
  • "Everything that's in M Query and DAX is the heart of Power BI because with these tools you can make up for a lot of other missing features."
  • "There is no specific area that I have a problem with. It's just that, with whatever feature you come across, every visual has its own formatting and behavior. What you get in one visual for a feature, you don't seem to get in another."

What is our primary use case?

I am a Power BI technical senior developer and consultant and I use Power BI to provide solutions for my clients.

What is most valuable?

Everything that's in M Query and DAX is the heart of Power BI because with these tools you can make up for a lot of other missing features. When I say "missing features", I mean it in the sense that, even if you don't have a direct feature to do something, there are quite a few workarounds that you can figure out with DAX and M Query to make different situations work. I think these two are really the soul of the tool because they make a lot of impossible things possible.

What needs improvement?

There's a lot of room for improvement because Power BI is a new tool and hasn't really been in the market for that long, especially considering alternative tools such as MicroStrategy or Tableau which have been around for more than a decade. Because Power BI is younger than those tools, I feel it hasn't reached a certain level of maturity that comes with time and it is lacking in quite a few areas which I'm hoping will be seen to in the future, given how it has been progressing so far with its new releases.

There is no specific area that I have a problem with. It's just that, with whatever feature you come across, every visual has its own formatting and behavior. What you get in one visual for a feature, you don't seem to get in another.

When it comes to the feature's functionality, that's all fine, but, say, for instance, that you want to go ahead and turn off only the sub totals and not the grand totals. This might not be immediately possible, especially if you are working in a project where your technical solution is the backend site which the users don't quite care about. What they care about is what they see and interact with, and the visuals and formatting (and visual settings) at hand are what really matter to them.

This is where I think standardization really needs to come in. Basic stuff like being able to selectively turn on or off only the sub totals or grand totals. There should be certain formatting options which should be standard across every visual. What options you get here, you should also get over there, for example. These are simple things, but many a time it's something the end user takes very seriously. They generally do not care about what's happening in the background with regard to the calculations and everything else.

In essence, the standard visualizations should have features and options in common with one another, even when it comes to other visualization tools such as bar charts and line charts. These are all pretty basic visualization features, and giving them some standard way to be customized will make them as capable and competitive as what other tools allow you to do. Of course, you can do this if you add your own custom visuals from the library, but when it comes to basic default stuff, they should at least be deep enough in terms of standard customization to compete.

Right now it seems like they're trying to add a lot of features, but at the expense of losing out on the essence of the basics. The basics in Power BI should be equally as good as the basics in any other tool, and in this case I believe it to be a problem of adding more depth to certain features. The width, and variety, of features is not a problem for me. Whatever features are already available need to be deep enough to work with comfortably, and I feel this is where Microsoft needs to direct its focus.

For how long have I used the solution?

I have been in the BI world for about six or seven years now and for the last few years it's all been Power BI for me.

How are customer service and support?

Their support is a little slow in the sense that when I post a question to them, I don't get a response as fast as I'd like. Unless you're a premium user and you've got a dedicated technical support team — that's a different thing.

When it comes the usual Microsoft bugs, they generally don't come up with solutions too quickly. And many a time they don't even have a running solution; some bug fixes will probably only be part of the next release. Even then, however, the new releases are themselves often not terribly stable. Whenever you get a new feature, you almost know that this one's not going to work as perfectly as you would want it to. So you just have to wait for the next one, and that's what it is. It takes a little while to stabilize. This kind of thing, along with their support in general, can probably be sped up a little bit.

Which solution did I use previously and why did I switch?

I am certified in MicroStrategy and have worked with it for several years. However, most of the business I am getting lately is all Power BI.

In my experience, everybody is switching from either MicroStrategy to Power BI or Tableau to Power BI. I'm hearing and seeing this going on in the market, for some very good reasons. I'm no longer working with MicroStrategy, but not because I don't like it. It's simply that I'm not getting enough work in that area.

How was the initial setup?

Setup is very easy. In Power BI that's one thing you will find across the board when using it. It is very easy in terms of getting something done. Even complex things can be done in a pretty easy way and there's no complex challenge in it.

What's my experience with pricing, setup cost, and licensing?

The pricing is good. It's pretty competitive because I have worked on a few other tools as well, and Power BI is on the cheaper side.

That said, many times people are attracted by its affordable price tag, but then they see that it doesn't do everything they want and they conclude that that was the reason why it was so cheap. There's a problem with this kind of thinking, because even though it might not have everything, the price is still on the cheaper side compared to other analysis products like MicroStrategy. The complete suite of features from MicroStrategy is very costly, but at the same time there's no doubt that it can achieve a lot.

What you get with Power BI is that you start to find that even simple stuff requires a lot of gymnastics to achieve because there's no in-built, straightforward feature for it and you need to come up with a workaround. There are a few too many workarounds needed for my comfort, but otherwise it's a very good tool and it's one of my favorites. The pricing is competitive for a reason.

What other advice do I have?

If you are looking for tabular reporting, then Power BI is not the tool for you. This isn't something that Microsoft speaks much about, and in my experience, if you want to do tabular reporting then there first has to be something in Power BI which can actually take loads of data and print it out on visuals in a tabular way, which is currently lacking. Power BI is really designed for analytical dashboarding and that's what it does best. For tabular reporting, on the other hand, it's better to just get the data exported out into Excel and do the rest there.

I would rate Microsoft PowerBI a seven out of ten.

Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
PeerSpot user
Accounting Services Finance Manager M&S at a hospitality company with 10,001+ employees
Real User
User-friendly, offers helpful reports, and has good dashboards
Pros and Cons
  • "It's a very easy-to-use solution."
  • "The initial installation is difficult."

What is our primary use case?

I primarily use the solution for the reports. We use it a lot for self-reporting.

What is most valuable?

We're making a dashboard that can show specific details and can be easily customized. It's very useful for creating dashboards.

The reporting is good.

The solution is stable. 

We can scale it if we need to.

It's a very easy-to-use solution. The product is quite user-friendly.

What needs improvement?

The initial installation is difficult. 

The pricing is a bit high and we'd like it to be less expensive.

For how long have I used the solution?

I've used the solution for two years now.

What do I think about the stability of the solution?

The product is stable. Its performance is good. There are no bugs or glitches. It doesn't crash or freeze.

What do I think about the scalability of the solution?

The scalability is good. If a company wants to, it can expand.

We have about 15 to 20 people that use the solution.

We're not sure if we will expand usage in the future or not. That's still to be decided.

How are customer service and support?

We manage technical support ourselves. We do not need to reach out to Microsoft for help. Therefore, I can't speak to how helpful or responsive they would be.

How was the initial setup?

I found the initial setup to be difficult. It's not exactly straightforward. The deployment might take about an hour.

We use three people for deployment and maintenance tasks. 

What's my experience with pricing, setup cost, and licensing?

We have to pay for licensing. I've paid for a license in the past.

We'd like for it to be a little less expensive.

What other advice do I have?

I would recommend the solution to others based on its ease of use.

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.
PeerSpot user
Contact Center Consultant at a consultancy with 51-200 employees
Real User
Simple to implement, beneficial customization, and plenty of features
Pros and Cons
  • "Microsoft BI is easy to use and to design. I found Microsoft BI a lot easier than Tableau."
  • "I am taking a course to be able to use the solution better. Some aspects of the solution are not straightforward."

What is our primary use case?

I'm a call center consultant and I use Microsoft BI to receive in-depth metrics. I download the metrics from the contact center and then I can figure out what's going on in the contact center. Additionally, if we integrate it with other tools and databases, et cetera, we can receive a better understanding of what is happening. For example, we had a customer that made products for Costco and Walmart and if they had an engineering issue or a problem, they don't find out about it until they saw the orders from the engineering team explaining what the issue was.

We added a screen to the agent's desktop and listed the model numbers of the products and then used Microsoft BI analytics to see what particular problem happened to what product. The executive could drill down and hear the calls as to what the customer was saying about the issue.

The executives liked the data, the engineers liked hearing what the customers were saying about the certain product that had an issue.

What is most valuable?

Microsoft BI is easy to use and to design. I found Microsoft BI a lot easier than Tableau.

You can set Microsoft BI up for administration to use it and then you can set up views for your end-users to look at. For example, if you are a report analyst you could have your marketing person wants Microsoft BI to report on how many widgets the East Coast sold in five years, if you set Microsoft BI up the right way, they can retrieve that information themselves. You save manpower from your IT staff.

Microsoft BI is a lot easier to analyze data than with other solutions, such as Excel.

What needs improvement?

I am taking a course to be able to use the solution better. Some aspects of the solution are not straightforward.

For how long have I used the solution?

I have been using Microsoft BI for approximately one year.

What do I think about the stability of the solution?

I have found Microsoft BI is stable. 

I have not had any issues. I am a new user myself, and I typically suggest an application that I have found good and then somebody else that I work with, would set it up.

What do I think about the scalability of the solution?

The solution has been scalable for what I use it for.

How are customer service and support?

I have not used technical support.

Which solution did I use previously and why did I switch?

I have used Tableau.

How was the initial setup?

The initial setup is very easy because it is on the cloud. You only need to have your database and connect it to Microsoft BI. They have different connectors in order to make it easy to do.

What's my experience with pricing, setup cost, and licensing?

I have not had a customer suggest the solution is too expensive. There are licenses to use the solution.

What other advice do I have?

The solution has all the features I need, I do not use large data sets.

I rate Microsoft BI a ten out of ten.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Manager - Customer Success at a tech services company with 10,001+ employees
Real User
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.
PeerSpot user
Lead Technical Instructor at codehub
Real User
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
PeerSpot user
Consultant at a computer software company with 10,001+ employees
Real User
A scalable BI solution with useful visualization features
Pros and Cons
  • "I think the visualization part is valuable."
  • "Actionable insights could be better."

What is our primary use case?

All our operational dashboards are on Microsoft BI. Visualization is primarily what we use Microsoft Power BI for today. 

We're in a position to explore all the underlying data. For example, your SLAs, how they're trending month on month, or how your backlog of tickets is going.

We look at all the respondent resolution SLAs or different priorities every month. If there's a dip somewhere, we're able to double click and then go to the actual client or the ticket, which has caused a problem.

You can go back and see if you need to do anything to recover from that situation. For example, if your SLA brings 25% and if you're dipping to 94%, go back and see why you're dipping. If there are, let's say, too many incidences from a specific technology or a specific client, go back and see what you need to do to fix those things.

We're now looking to get to the next level with exploratory analytics. We want to go into what we call explanatory analytics, which analyzes the underlying data. Instead of waiting for something to fail, you come out and say, "Hey, these are some areas that are not working well, and you probably need to look at it."

We're trying to use Microsoft BI and for what we call actionable insights. This tool should be able to build up and show you what the underlying data is telling you. For example, our affiliates may be trending at 95%, but since we run a shared service, there could be some clients where it's 100% and some clients where it's probably 85%. Those claims could lead to a client-side problem or a client satisfaction issue.

Explanatory analytics can give you such exceptions automatically. Then you can go back and work on those clients to ensure that you pull your SLA back up from 85% to 95% and ensure that customer satisfaction doesn't dip.

What is most valuable?

I think the visualization part is valuable. It's also very easy to build new dashboards. It's fairly intuitive for people who understand the Microsoft Power BI tool.

We're fairly happy with the product in terms of both configuring the Microsoft BI dashboards and making changes to them. It's fairly easy to make changes.

What needs improvement?

Actionable insights could be better. I would like it to provide exceptional reports that you need to act upon to keep your operations or businesses going. That's something I would like to see. 

On the origination side, if there are better graphs and maps to visualize data like I've seen other tools like Tableau do, it might be useful. They need to have very different ways of presenting information. If it's eye-catching, better than a pie chart or a bar graph, that's even better.

For how long have I used the solution?

I have been using Microsoft Power BI for about a year.

What do I think about the stability of the solution?

Microsoft BI is stable. We aren't faced with too much downtime. On a scale of five, I would probably rate it at 4.8 out of five throughout any given week.

What do I think about the scalability of the solution?

I think we have scaled up Microsoft BI fairly easily because it's on a cloud. We've added users. We added more dashboards from our different service lines, and we found it fairly easy to scale up.

How was the initial setup?

The initial setup is fairly easy and straightforward.

What other advice do I have?

I would definitely recommend Power BI from a visualization perspective. It's quick and easy to set up and scales up very well. If you've been using data on Excel sheets and converting them to graphs on PowerPoint, I think this is a tool that gives you almost a live visualization of what your operations are. 

We use it for our day-to-day IT operations. I'm sure it can also be used to visualize other data like how many clients, how clients build up weekly, and the various stages of transitioning client needs into services. These things can be very easily developed on our Microsoft BI dashboard.

On a scale from one to ten, I would give Microsoft BI an eight.

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
PeerSpot user
Buyer's Guide
Download our free Microsoft Power BI Report and get advice and tips from experienced pros sharing their opinions.
Updated: March 2024
Buyer's Guide
Download our free Microsoft Power BI Report and get advice and tips from experienced pros sharing their opinions.