Try our new research platform with insights from 80,000+ expert users
Enterprise Architect at a tech services company with 5,001-10,000 employees
Real User
I like its drill-down feature and overall ease of use
Pros and Cons
  • "I like Microsoft BI's drill-down feature and its overall ease of use."
  • "The setup took a lot of tinkering with InfoSec to allow us to do stuff."

What is our primary use case?

The primary use case for Microsoft BI is reporting. It comes with the Microsoft 365 E5 license. Then you just need to secure and harden it. That took a bit of time, but you can open it up and let people use it after that. There is a desktop component that they can work on that's independent of the Microsoft license. In that case, they can create files that are like dashboards.

What is most valuable?

I like Microsoft BI's drill-down feature and its overall ease of use.

For how long have I used the solution?

I've been using Microsoft BI for about eight months.

What do I think about the stability of the solution?

Microsoft BI has been stable so far.

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

How are customer service and support?

Microsoft's support is pretty good. 

How was the initial setup?

Installing Microsoft BI was relatively straightforward. It just took a lot of tinkering with InfoSec to allow us to do stuff.

What other advice do I have?

I rate Microsoft Power BI nine out of 10. If you plan to implement it, ensure that you harden it, so you do not leave it wide open. Otherwise, you're vulnerable to data leakage.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
PeerSpot user
Director at Decision Science
Real User
Top 10
Saves time in preprocessing stage, but it needs to be more user-friendly for non-technical users
Pros and Cons
  • "I like the downloadable visualizations a lot. I think that they give the user a very nice starting point in creating awesome dashboards, with the right way to tell their data story."
  • "Some kind of expression wizard, where the user can build a complex expression without any knowledge of DAX, can be a good addition to the product."

What is our primary use case?

Since we are a consulting company, our cases vary from customer to customer and from department to department, but mainly we have found two "standard" cases: Business users connecting to a DWH, or trying to consolidate several Excel workbooks to create business dashboards.

In the DWH cases, it is simpler since most of the data transformations and modeling are done by IT, but in the 'spreadsheet world', it becomes more complicated.

Users try to move from a huge table filled with numbers and "color-coded" cells to data visualizations, sometimes not even knowing how to write a simple Excel expression.

How has it helped my organization?

The biggest improvement comes from a "do it once, refresh many" concept. The users used to perform a lot of massaging on the data itself prior to the analysis phase. Now, they build their reports and refresh the data, so they have a lot more time to perform analysis, which is the real added value to the business.

Unlike other tools (like Tableau), getting to this point took a lot of resources in training, but when the users got there, it is a real time saver for them, allowing them to focus more on analysis, not on data manipulation.

What is most valuable?

I like the downloadable visualizations a lot. I think that they give the user a very nice starting point in creating awesome dashboards, with the right way to tell their data story.

Data Modeling is very simple and powerful for an experienced user, but I think it needs some improvement for the non-technical people. Besides this, it allows us to save a lot of time in data "massaging" prior to the analysis phase.

Reports are quite easy to build, even when some programming concepts are needed. Some users struggle with DAX a lot!

What needs improvement?

I think Power BI needs to focus more on the end-user (i.e. the business user). Solving things in DAX is not a nice approach to a user that has no knowledge of IT nor wants to get it.

Some kind of expression wizard, where the user can build a complex expression without any knowledge of DAX, can be a good addition to the product.

I see a lot of materials on how to go about doing things in Power BI, but Microsoft can add a "learning path". It would instruct users where to start, then what to learn next, etc, to sort out their learning journey.

For how long have I used the solution?

I have been using Microsoft BI for ~four years.

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
February 2025
Learn what your peers think about Microsoft Power BI. Get advice and tips from experienced pros sharing their opinions. Updated: February 2025.
837,501 professionals have used our research since 2012.
reviewer1571454 - PeerSpot reviewer
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
reviewer1413633 - PeerSpot reviewer
Head of Digitalization at a mining and metals company with 5,001-10,000 employees
Real User
Seamlessly integrates with Microsoft products, but can be made simpler to operate
Pros and Cons
  • "Its seamless integration with Microsoft products, such as Microsoft SQL Server or Microsoft Excel, is the most valuable."
  • "They can provide a user-friendly and easy way to use this tool for people who don't know about programming or technical things. It will be quite good if they can improve the look and feel and make it simpler to operate. They can make it easier to create some of the reports. They can also include predefined templates that you can directly use."

What is our primary use case?

It is mostly used for monthly cost reports for our department. We are also using it as a dashboard for giving some overview for management purposes. We are using the latest version.

What is most valuable?

Its seamless integration with Microsoft products, such as Microsoft SQL Server or Microsoft Excel, is the most valuable.

What needs improvement?

They can provide a user-friendly and easy way to use this tool for people who don't know about programming or technical things. It will be quite good if they can improve the look and feel and make it simpler to operate. 

They can make it easier to create some of the reports. They can also include predefined templates that you can directly use.

For how long have I used the solution?

I have been using Microsoft BI for almost two and a half years.

What do I think about the stability of the solution?

Stability is quite good as long as you have proper sizing from the beginnings. If you do the right sizing keeping in mind the current usage as well as future growth, it is good.

What do I think about the scalability of the solution?

It is scalable. We have around 65 seniors managers who use it on a weekly or monthly basis. Some reports are done weekly and some monthly.

How are customer service and technical support?

I have not contacted them so far. I am from the user side. We contact our centralized IT department for any issues. If they have a technical issue that requires further escalation, they will directly contact Microsoft technical support.

How was the initial setup?

The initial setup is quite simple, but for the product use, you need to have people who have got experience of at least three to six months in using these applications. It took us two months to deploy across the company.

What about the implementation team?

We have a core team that gets training from a Microsoft partner. We then deploy it ourselves. After six months of using this solution, some of the key users get advanced training. 

We also maintain it ourselves. We have around ten people for its maintenance.

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

It is somewhere in the middle in terms of price. Licensing is quite clear.

Which other solutions did I evaluate?

We reviewed some other intelligence tools, and we just used them for trials.

What other advice do I have?

I would recommend this solution, especially for the companies that mostly use Microsoft products and ecosystem. I would rate Microsoft BI a seven out of ten.

Which deployment model are you using for this solution?

Private 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
PeerSpot user
Director Research and Development at Projects Factory
Real User
A comprehensive source for visualizations and analytics
Pros and Cons
  • "Because this solution is very easy, and very visual, you can have results in minutes."
  • "I would like to see a feature that connects with a Machine Learning platform like a RapidMiner or Azure Machine Learning Studio. It would be great to have a Machine Learning application link to connect."

What is our primary use case?

I primarily use this for creating dashboards and reports for the oil and gas industry.

What is most valuable?

Power BI is always updating. I receive multi mail from Power BI with new visualizations, new analytics, new webinars and I'm going to Microsoft here locally in order to have a updated presentation about the new features of Power BI. For me it's very versatile. I can publish on my iPad. I have a Power BI application in order to manage the visualization of my report and my dashboard. Also I can speak to Power BI and ask about production and Q&A. But, I don't have compilation with other tools yet. For me, Power BI is the best.

What needs improvement?

I would like to see a feature that connects with a Machine Learning platform like a RapidMiner or Azure Machine Learning Studio. It would be great to have a Machine Learning application link to connect. 

For how long have I used the solution?

One to three years.

How was the initial setup?

It was straightforward. We had no problems with implementation.

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

The pricing is fine for our company. It is reasonably priced.

What other advice do I have?

Because this solution is very easy, and very visual, you can have results in minutes. 

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
Real User

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.

Fabio Xavier - PeerSpot reviewer
Director of Systems of the TCESP at a government with 501-1,000 employees
Real User
Useful drag and drop function, straightforward implementation, and high availability
Pros and Cons
  • "The most valuable features in Microsoft BI are the analysis using the feature drag and drop function. It's very easy to load and use different data sources."
  • "Microsoft BI could improve by allowing large-size data sources. We have large data sources, and we have problems loading them in Microsoft BI."

What is our primary use case?

We use Microsoft BI to construct panels and analysis for the final users by themselves. We have all the units outside and analyses made by the final users. They can share their work with other colleagues and other teammates easily.

What is most valuable?

The most valuable features in Microsoft BI are the analysis using the feature drag and drop function. It's very easy to load and use different data sources.

What needs improvement?

Microsoft BI could improve by allowing large-size data sources. We have large data sources, and we have problems loading them in Microsoft BI.

I would like to see in a future release the ability to create rules with no code. Similar to drag-and-drop solutions, or some other way with no code.

For how long have I used the solution?

I have been using Microsoft BI for approximately two years.

What do I think about the stability of the solution?

The solution is reliable, we do not have a problem with the availability.

What do I think about the scalability of the solution?

Microsoft BI is a scalable solution.

We have approximately 500 users using this solution in my organization. We have plans to increase the use of the solution. Our employees are getting better with the ability to use the solution.

How are customer service and support?

The support from Microsoft is satisfactory.

How was the initial setup?

The initial setup of Microsoft BI was straightforward.

What other advice do I have?

I would encourage others to use Microsoft BI, it is a good solution.

I rate Microsoft BI a nine out of ten.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
reviewer1785144 - PeerSpot reviewer
Strategy & Advisory - Solutions Architect at a financial services firm with 1,001-5,000 employees
Real User
Quality reporting and data migration with strong visibility, functional dashboards and more
Pros and Cons
  • "I like having the ability to connect Excel files as data inputs."
  • "I would like for the next release to have better desktop performance, especially for big databases. Additionally, I would like to have more integrations with programs like Salesforce in order to get more live data coming in."

What is our primary use case?

We use this solution for reporting around data migration.

How has it helped my organization?

BI provides us with strong computing power and calculations with quality visibility which helps with the whole pipeline.

What is most valuable?

I like having the ability to connect Excel files as data inputs.

BI also allows us to make functional dashboards, perform queries, and display data in various ways. And, there are always new features being released.

What needs improvement?

I would like for the next release to have better desktop performance, especially for big databases. Additionally, I would like to have more integrations with programs like Salesforce in order to get more live data coming in.

For how long have I used the solution?

I have been using BI on and off for the past two years.

What do I think about the stability of the solution?

Stability is very good.

What do I think about the scalability of the solution?

This solution is scalable.

How are customer service and support?

I have not needed to contact support.

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

Originally, we were only using Excel, trying out different dashboards for the data. This was not powerful enough for us. It was not easy to use or streamline so we made the switch.

How was the initial setup?

The initial setup was straightforward and deployment took about a week plus another few weeks to do work within the BI.

What about the implementation team?

Our deployment was performed by our in-house team of one.

What other advice do I have?

There is a free version of the Power BI which may be worth looking into for small teams prior to purchasing a license. I would rate this solution a nine 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.
PeerSpot user
Buyer's Guide
Download our free Microsoft Power BI Report and get advice and tips from experienced pros sharing their opinions.
Updated: February 2025
Buyer's Guide
Download our free Microsoft Power BI Report and get advice and tips from experienced pros sharing their opinions.