We primarily use the solution primarily for making dashboards. We are also doing analytics on Microsoft BI.
Data Warehouse Engineer at a government with 1,001-5,000 employees
Easy to use and flexible but can't handle big data
Pros and Cons
- "The product is easy to use and simple to navigate."
- "The product doesn't support unstructured data. It doesn't support video, streaming, and strings of files."
What is our primary use case?
What is most valuable?
The solution is very stable.
The product is easy to use and simple to navigate.
The product has proven to be quite flexible.
It is quite scalable and it is doing the work that we want it to.
What needs improvement?
We'd like the solution to be more scalable.
We'd like the ability to manage it on the cloud, as a cloud-based solution. It is running out of business as it is not able to keep pace with the big data. Big data is not something that BI can support. It cannot be scaled that much.
The product doesn't support unstructured data. It doesn't support video, streaming, and strings of files. Microsoft is aware of this.
For how long have I used the solution?
I've been using the solution for seven to eight years at this point. It's been a while.
Buyer's Guide
Microsoft Power BI
November 2024
Learn what your peers think about Microsoft Power BI. Get advice and tips from experienced pros sharing their opinions. Updated: November 2024.
815,854 professionals have used our research since 2012.
What do I think about the stability of the solution?
The solution is very stable. There are no bugs or glitches. It doesn't crash or freeze. It's reliable and the performance is very good.
What do I think about the scalability of the solution?
The solution is quite scalable, although, in our case, as we are not on the cloud, we are facing some issues.
We have more than ten people using the solution currently.
How are customer service and support?
I've never reached out to technical support in the past. I cannot speak to how helpful or responsive they are.
How was the initial setup?
I wasn't a part of the initial setup. That was something that was handled by another team. I can't speak to how long it took to deploy.
My understanding is that you only need two people to deploy the solution. Admins usually handle it.
What's my experience with pricing, setup cost, and licensing?
I don't have any insights into the licensing and payments required.
What other advice do I have?
We are using the latest version of the solution. I'm not sure of the exact version number.
I'd rate the solution at a seven out of ten. For us, it has met our expectations and we enjoy its capabilities.
I'd recommend this product to other users and organizations.
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.
Founder with 1-10 employees
Users can access data much more easily than before, and it works with Excel
Pros and Cons
- "Other people can access data much more easily than before. Its usability is the main advantage, people in the company are using it."
- "With Power BI, you're able to store your data within spreadsheets and SharePoints, and then have Power BI pull the data out and report on it. So we actually saved a ton of money not needing to load the data into databases, which is a big prerequisite for many other reporting tools."
What is our primary use case?
It's primarily for reporting, and the performance has been very good.
How has it helped my organization?
Other people can access data much more easily than before. Its usability is the main advantage, people in the company are using it.
What is most valuable?
It works mostly with Excel, and it's a very good price.
What needs improvement?
The Report Server is pretty expensive on-premise. But as long companies are happy to use the cloud version, that's very cost effective.
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 now; it was definitely really poor a year ago.
What do I think about the scalability of the solution?
Because it's cloud-based, it's very scalable.
How are customer service and technical support?
I haven't used tech support specifically for Power BI but, in general, for Office and Office 365, it has been very responsive.
Which solution did I use previously and why did I switch?
Before, we just had a whole bunch of spreadsheets lying around all over the place. So we really needed to get things tightened up but we weren't ready to invest in a database. But with Power BI, you're able to store your data within spreadsheets and SharePoints, and then have Power BI pull the data out and report on it. So we actually saved a ton of money not needing to load the data into databases, which is a big prerequisite for many other reporting tools.
My most important criteria when selecting a vendor are usability and support.
How was the initial setup?
The initial setup was very straightforward.
Which other solutions did I evaluate?
The shortlist was, obviously, Tableau because they're in everyone's face and a couple of other smaller tools.
What other advice do I have?
I rate it a nine out of 10 because it's very cost-effective, so it's very accessible in that respect, and a lot of folks do use spreadsheets so it helps ease the transition from using just spreadsheets to a more mature reporting environment.
My advice is, speak to your users because, at the end of the day, if they don't use it, you've failed, which was the case with other reporting tools.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Buyer's Guide
Microsoft Power BI
November 2024
Learn what your peers think about Microsoft Power BI. Get advice and tips from experienced pros sharing their opinions. Updated: November 2024.
815,854 professionals have used our research since 2012.
Project Manager with 51-200 employees
It helped identify bad data
Pros and Cons
- "Helped identify bad data, enabling the corrections needed to the data for management."
- "It needs more graphics and overlays."
- "It needs more analytic tools."
What is our primary use case?
Our primary use cases for this solution are Health and Wellness claims and short-term and long-term disability data.
How has it helped my organization?
It helped identify bad data, enabling the corrections needed to the data for management.
What is most valuable?
- Ease of use
- Dashboard
- Easy access to databases and spreadsheets
- Multi-table access
What needs improvement?
- More graphics and overlays
- More analytic tools
- More interfaces to databases, especially multi-table management
For how long have I used the solution?
Three to five years.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Partner at a consultancy with 11-50 employees
Competitors' products have more functionality, though the self-service aspect is good
Pros and Cons
- "We can see that it's really improved the way end users can do their own graphs and pick their own fields of information and present that in a nice way."
- "The way you navigate the product, compared to other products in this industry, that could be improved a bit."
What is most valuable?
The self-service part.
How has it helped my organization?
We are a consultancy firm, helping our clients with billing and business intelligence solutions. We can see that it's really improved the way end users can do their own graphs and pick their own fields of information and present that in a nice way.
What needs improvement?
The navigation. The way you navigate the product, compared to other products in this industry, that could be improved a bit. It's user friendly, but you would like to have it even more user friendly.
When you do selections in one tab in Report, and then you move to the next tab, then you have to do your selections again. So one tab as a global, central selection possibility would help.
If you compare to QlikView, there's still a lot of functionality that QlikView has that Power BI doesn't. For most companies, Power BI is good enough, especially if you consider the price tag it's an easy choice. But it still has some catching up to do to match the functionality in QlikView.
For how long have I used the solution?
Eight to 10 months.
What do I think about the stability of the solution?
It feels very stable. A bit slow sometimes when you change stuff and you want to refresh data and apply it to the data model in your queries. You want to apply that to your reports and dashboards and it can be a bit slow sometimes.
What do I think about the scalability of the solution?
We don't have that experience yet. We still don't know how it is to deploy it in larger scales. So, that's my concern, but I haven't seen the scalability issues at our clients.
How are customer service and technical support?
No, not yet. There are a lot of self-training videos and such out there on the internet and on the Microsoft websites.
Which solution did I use previously and why did I switch?
QlikView and Qlik Sense. We felt demand in the market for Microsoft Power BI. Also, within my company we are selling services around Microsoft Dynamics, and Microsoft Power BI hooks very well into the other Microsoft products.
How was the initial setup?
It was pretty straightforward. Not much to set up. Cloud service and desktop client that you need to download and install, but if you have worked with other similar tools then you and know about that.
Which other solutions did I evaluate?
We are constantly looking for what is hot in the market and this has really come up as a rising star on the BI market, so it was not so much of a question about it at all. Quite obvious.
What other advice do I have?
There are some limitations in regards to the navigation part.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Developer at a tech consulting company with 51-200 employees
It offers high performance & low cost BI solutions with ability to integrate with other third party tools.
Valuable Features:
Microsoft SSRS biggest advantage is its ability to integrate with other third party components. You could integrate it with Share Point web part or you can access it from a Web browser, depending on your existing scenario you don’t need to change much to be able to integrate SSRS with your existing application. Microsoft SSAS offers low cost BI solutions comparing with IBM Cognos, licensing for SSAS is core-based or you could opt for server + CAL-based license which is very low in comparison with IBM Cognos. Microsoft SSRS & SSAS suite is uncompromising when it comes to performance. It provides very high performance and it could be connected to many different data sources. It requires very less time to build Microsoft SSRS & SSAS solution.
Room for Improvement:
Microsoft SSRS is unable to provide a mechanism where poor performance reports could be prevented to run on production environment. In case if a user creates a report which can cause huge impact on server resources / performance it should not be allowed to run on production server during normal working hours. Alternative that is provided is to use subscription option to deliver reports to particular directory or email them at scheduled time (preferably non-working hours).Microsoft SSRS does not offer any interoperability with Andriod or iPad at this time (need to consider this if you are planning to develop reports for these environments) Microsoft SSRS & SSAS suite is very easy to configure and maintain. You don’t need any license if you are looking to try out Microsoft SSRS; you can simply download and use Microsoft SQL Server Express (with Advanced Services). You can create dashboards, drill through reports, charts, graphs, maps, dynamic grouping using Microsoft SSRS.
Other Advice:
It offers a very vibrant MSDN community along with Microsoft support staff for assistance.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
I found Microsoft BI stack to be far better and it's "free" since it comes along with sql server. Since it is free people usually do not care much about its advantages but more loud about its disadvantages. SSRS is one of my favorite tools, it provide flexibility and good web support and strong AD integration for security. SSRS should not be running in the production server instance as it will kill your performance. Second, make sure it runs in a scale out manner (more than one server) based on total load. Third, change the memory setting in your SSRS configuration so that it can utilize more memory in the server rather than default, it will cut down the rendering. Fourth, never run big reports on the production server, find an alternative solution, if that's not possible then use resource governor so that your production database will not get the performance hit. Check query response time and actual query plan for long running reports match up with dba's performance baseline for that day.
Director of Product Management at PeerSpot
The Gartner Magic Quadrant for Business Intelligence says that Microsoft BI's overall costs are consistent with other Megavendors. Do you agree?
The Gartner Magic Quadrant for Business Intelligence says that most companies chose Microsoft BI because of low license cost and overall low cost of ownership. However, while the total ownership costs is low for a per user basis, because of implementation and ongoing development costs it is consistent with other large vendors.
Are you a Real User of Microsoft BI? Have you found this to be the case in your organization?
If you are a user or are evaluating Microsoft BI, add your comment below or write your own review. Share your opinion with our community!
Disclosure: I am a real user, and this review is based on my own experience and opinions.
I do agree with the Gartner Magic Quadrant for BI. Although the licensing costs might be low and Microsoft products can come with incentives depending on the client in question, it is important to consider the general costs that span long term use of the product. I also agree with Robert Goodman on the high availability of people resources when it comes to Microsoft BI products. Microsoft is a big brand worldwide with its training resources available not just online but also in many schools across the globe, hence finding a person knowledgeable in Microsoft BI is much easier than any other brands in the market. Back to Gartner; although Microsoft has certain cost aspects of their BI products down, the costs incurred during implementation stages and continuously as the product is used definitely raises the initial costs and thus making the cost of Microsoft BI products consistent with that of BI tools from other brands.
Educator at a university with 51-200 employees
Great teaching tool for data transfers
Pros and Cons
- "Being able to transfer data with the Power Query feature is great for teaching with about one to two hundred rows of data. I am also able to see the relationship between multiple tables and create various sheets and dashboards."
- "The Power Query feature needs to be improved to handle large amounts of data. This feature is also slow for large data transfers making it better to use some kind of script."
What is our primary use case?
I have been a professor at a program mastery at UISEK University for the past two years where I teach students how to use these tools.
What is most valuable?
Being able to transfer data with the Power Query feature is great for teaching with about one to two hundred rows of data. I am also able to see the relationship between multiple tables and create various sheets and dashboards.
What needs improvement?
The Power Query feature needs to be improved to handle large amounts of data. This feature is also slow for large data transfers making it better to use some kind of script.
Additionally, in the next release, I would like to be able to export thing, such as charts, as a PDF.
For how long have I used the solution?
I have been using this solution for two years.
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
A generally uncomplicated installation, but stability fairs at only 70 percent
Pros and Cons
- "The solution is not that difficult to install, although this will vary with the experience of the person responsible for its installation."
- "I find the solution to be 70 percent stable."
What needs improvement?
I would rate the stability of Microsoft BI at 70 percent.
While the solution is scalable, it certainly has its limitations.
What do I think about the stability of the solution?
I find the solution to be 70 percent stable.
What do I think about the scalability of the solution?
Although the solution comes with limitations, it is scalable.
How are customer service and support?
Technical support is not that bad, fairing in the average range.
How was the initial setup?
The solution is not that difficult to install, although this will vary with the experience of the person responsible for its installation.
What about the implementation team?
There are five people responsible for the deployment, their roles comprising a mixed bag, some of them being managers.
What's my experience with pricing, setup cost, and licensing?
Our customers definitely incur a licensing fee.
The only other cost, besides the licensing fee, would be to cover support.
What other advice do I have?
There are only three customers using the solution at present.
I always offer more than one solution and the person must choose which he feels best suits his needs. All solutions have plusses and minuses and these should be carefully weighed before one decides which one to go with. Once the client has settled on a solution, this is what I will go with. We are talking about Microsoft store. Generally speaking, our clients prefer to make use of Microsoft.
I rate Microsoft BI as a seven out of ten.
This rating is based on what we have observed about the solution thus far, although it may be amended over the next few months as we become more acquainted with it.
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?
The above review is consistent with the findings in my organisation.
Cloud hosting is the way to go to avoid expensive on premises support costs.