Senior Technology Architect/Strategist at a aerospace/defense firm with 51-200 employees
Real User
Easy to use and scalable, but needs better support and speed
Pros and Cons
  • "Its ease of use is most valuable."
  • "The biggest thing with Microsoft right now is better support. There should be more timely support. We can do 90% of it ourselves by the same token. When we're into the 10%, we do not get timely support via Microsoft's support team."

What is our primary use case?

We use it for taking data and turning it into intelligence.

I have been using the most recent version of it. It is deployed in a government cloud.

How has it helped my organization?

It saved time.

What is most valuable?

Its ease of use is most valuable.

What needs improvement?

The biggest thing with Microsoft right now is better support. There should be more timely support. We can do 90% of it ourselves by the same token. When we're into the 10%, we do not get timely support via Microsoft's support team.

Its speed can also be improved. They should come up with a fix for the speed issue and give us some good parameters as to what would help with the speed. They should give us a good white paper that has a compatibility list, similar to what they provide with operating systems, and that describes what you should have before you use Microsoft BI.

There should also be a better way to possibly do things like geolocation, and where they do it, they should do it better. If you have a satellite, offices, and that sort of thing, it would be nice to see it in Tableau and different formats.

Buyer's Guide
Microsoft Power BI
April 2024
Learn what your peers think about Microsoft Power BI. Get advice and tips from experienced pros sharing their opinions. Updated: April 2024.
768,857 professionals have used our research since 2012.

For how long have I used the solution?

I have been using this solution since it came out. It was probably 2010. I'm a Microsoft engineer, so I'm on a lot of beta test teams. So, I would see these items a bit earlier than anybody else.

What do I think about the stability of the solution?

It is overall in mid-range. Sometimes, it works very well, and sometimes, it doesn't. If it is not working very well sometimes, that means it is not a hundred percent stable.

What do I think about the scalability of the solution?

Its scalability is good. I've used it in very large major banks down to smaller entities, and it seems to not care about the scale.

Currently, we probably have 50 users. Its usage is moderate. We will increase its usage if they come up with a fix for the issues such as the speed.

How are customer service and support?

There should be more timely support. I would rate them a two out of 10 because of the lack of availability. Sometimes, we can't fix what we don't know how to fix, and it causes us a lot of time and waiting and that sort of thing. We have to have a US citizen, and I'm sure that they're just not scaled up to that.

How would you rate customer service and support?

Negative

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

I have used other solutions but not in this cooperation.

How was the initial setup?

Its initial setup is somewhere in the middle. Each deployment seems to be a little different. You have auto-updates all the time on PCs. When you image a PC, it doesn't always match. So, each deployment is different, and I'm not sure they can change that because most of the updates are for security, but it is very important to be sure that you test the environment first before you put it into production. I know a lot of people who just put it into production because of the ease of use, but sometimes, that can be problematic. In terms of maintenance, it is not terrible.

What about the implementation team?

It was done in-house with the help of a Microsoft partner. Our experience with them was horrible. We ended up fixing it all ourselves. If five was the top, they were a zero.

What other advice do I have?

I would advise others to just do their homework. You should check it out first, do the trial, get it into your test environment, and then make your decisions. Don't rush to production. Everybody is a bit different. If you have monster databases out there, the performance might be a little different.

I would rate it a six out of 10. If their support were better, it would get a higher rating. 

If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

Microsoft Azure
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Senior Analyst at a tech services company with 10,001+ employees
Real User
Good visualizations, dashboards, and scalability, but needs better user interface, rule-based security, and support
Pros and Cons
  • "Its visualizations and dashboards are most valuable. Power BI is great in terms of visualizations and dashboards. The reports that we previously had were not very nice in terms of visualization. It also provides the ability to play with the data."
  • "We have a lot of servers and applications from which we want reports, and it allows us to create reports from an SQL source or some other source."
  • "They can improve it in terms of rule-based security. Currently, it has very limited rules."
  • "They can improve the user interface a little bit to make it more user-friendly. When creating a dashboard, it is not very user-friendly. You have to click on a certain style and use your keyboard keys to move it. You cannot drag and drop it."
  • "Their technical support can be better. They normally take too long to escalate and resolve a case."

What is our primary use case?

We use it for reporting. We are using its latest version.

What is most valuable?

Its visualizations and dashboards are most valuable. Power BI is great in terms of visualizations and dashboards. The reports that we previously had were not very nice in terms of visualization. It also provides the ability to play with the data.

We have a lot of servers and applications from which we want reports, and it allows us to create reports from an SQL source or some other source.

What needs improvement?

They can improve it in terms of rule-based security. Currently, it has very limited rules.

They can improve the user interface a little bit to make it more user-friendly. When creating a dashboard, it is not very user-friendly. You have to click on a certain style and use your keyboard keys to move it. You cannot drag and drop it. 

Their technical support can be better. They normally take too long to escalate and resolve a case.

For how long have I used the solution?

I have been working with Power BI for five or six months.

What do I think about the stability of the solution?

I am at the initial stage of using it. We have just deployed a report in our organization, and it is working fine so far. It seems to be stable. I am not sure if we faced any issues with it.

What do I think about the scalability of the solution?

It is good in terms of scalability.

How are customer service and technical support?

I have had only one interaction with them, and it was a bad one. They took around a month to resolve a simple issue. We also had to escalate the case. The resolution was very simple, and ideally, they should have found it on the first day. They normally take too long when it comes to the escalation of cases.

How was the initial setup?

As a first-time user, I found it to be of medium complexity. You have to connect it with the SQL database or your data source. You might not find it very straightforward.

What other advice do I have?

It can also be deployed on-premises. If you have it on-premises, make sure that you meet all the prerequisites and have all permissions. You should sort these things out before deploying Power BI. I faced some issues because I missed one of the prerequisites, and it took me one month to get it resolved. That's why I recommend completing all prerequisites.

I would rate Microsoft Power BI a seven out of ten.

Which deployment model are you using for this solution?

Public Cloud

If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

Microsoft Azure
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Buyer's Guide
Microsoft Power BI
April 2024
Learn what your peers think about Microsoft Power BI. Get advice and tips from experienced pros sharing their opinions. Updated: April 2024.
768,857 professionals have used our research since 2012.
Manage Client Partner at a tech services company with 501-1,000 employees
Real User
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
PeerSpot user
Regional PDS - Director of Business Intelligence at JLL
Real User
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.
PeerSpot user
it_user6858 - PeerSpot reviewer
BI Expert with 501-1,000 employees
Real User
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.
PeerSpot user
it_user1068 - PeerSpot reviewer
it_user1068Tech Support Staff at a tech company with 51-200 employees
Vendor

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.

Product and Systems Director at SPCM
Real User
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
PeerSpot user
IT RM at KNV
Real User
Dashboards allow for reporting to higher levels of management, and navigation is simple enough for ordinary users
Pros and Cons
  • "We encourage end users to use Power BI because it's quite easy for them to interact with the menus and the navigation bar. Even for ordinary users, they can create their own dashboard using Power BI."
  • "There's always room for improvement for Microsoft Power BI, especially for the UX and the menus to make it more accessible to business users."

What is our primary use case?

The IT department has dashboards for reporting to the higher levels of management.

The solution is deployed on a hybrid model: cloud-based and on-premise. We always get the latest version because we have the Enterprise Agreement with Microsoft.

What is most valuable?

We encourage end users to use Power BI because it's quite easy for them to interact with the menus and the navigation bar. Even for ordinary users, they can create their own dashboard using Power BI.

What needs improvement?

There's always room for improvement for Microsoft Power BI, especially for the UX and the menus to make it more accessible to business users. These improvements wouldn't be too technical.

For how long have I used the solution?

I have been using Microsoft BI for a very long time—since it was first released.

What do I think about the stability of the solution?

The solution is stable enough, but I think Tableau has a better interactive UX and user experience. We are not using Tableau right now.

We have tens of thousands of users, and we are willing to increase the number of users.

How are customer service and support?

Support is amazing.

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

I have experience with Tableau.

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

The license is on a yearly basis.

What other advice do I have?

I would rate this solution 8 out of 10. I would recommend this solution for others. 

We don't have any other solution out there right now, so I would say we are satisfied with it. There are some disadvantages, some weaknesses of Microsoft Power BI that we have addressed to the Microsoft team.

The IT department has a good relationship with the Microsoft team, so they always give input to Microsoft's department teams.

Which deployment model are you using for this solution?

Hybrid Cloud
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Managing partner at a tech vendor with 1-10 employees
MSP
Low cost, good reporting, and simple installation
Pros and Cons
  • "In my opinion, Microsoft BI is a low-cost solution, and it could be an interesting solution for a tourism company."
  • "I believe the price should be degressive, and we should have a lower, or better unit price if we have more users."

What is our primary use case?

I am a reseller for Sage business solutions and will start to sell Microsoft BI.

Microsoft BI is primarily used for sales, financial, and production reports.

What is most valuable?

I believe that it's a good solution. 

It is not an expensive solution. The price is very important in the solution selection process. In my opinion, Microsoft BI is a low-cost solution, and it could be an interesting solution for a tourism company.

For how long have I used the solution?

I have been using Microsoft BI for a few months.

As a cloud solution, we are always working with the latest version.

What do I think about the scalability of the solution?

In our company, we have five users.

The price is an important consideration when upgrading or adding new users. In my opinion, it would be better for the price to be degressive by the user. For example, if you have five users, you simply multiply five by the unit price to find the total cost of the solution. 

I believe the price should be degressive, and we should have a lower, or better unit price if we have more users.

How are customer service and support?

I hadn't really needed Microsoft's technical support until now. We have not had any issues to resolve.

How was the initial setup?

The installation is not a difficult thing, it is very simple.

We only need one IT manager, to deploy this solution.

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

Licensing fees are paid on a yearly basis.

What other advice do I have?

I would recommend this solution to others who are considering this solution, which is the reason that I will be selling it.

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