Try our new research platform with insights from 80,000+ expert users
Consultant en Business Intelligence
Consultant
Free software which is very intuitive and easy to use
Pros and Cons
  • "Very intuitive and easy to use."
  • "Capacity could be improved."

What is our primary use case?

Our primary use case of this solution is as a reporting tool. We implement it for our clients. I'm a consultant in business intelligence and we are customers of Microsoft BI.

What is most valuable?

I like this product because it's a free software, very intuitive and very easy to use.

What needs improvement?

The capacity of the solution could be improved. If you don't need all the data it offers then don't download it because the software slows down. 

For how long have I used the solution?

I've been using this product for the last year. 

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

What do I think about the stability of the solution?

It's a stable solution. 

How was the initial setup?

The initial setup is quite straightforward. 

What other advice do I have?

I rate this solution an eight out of 10. 

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
reviewer1537680 - PeerSpot reviewer
Head of Analytics Director at a tech services company with 51-200 employees
Real User
Low-cost, feature-rich, and easy to deploy, but would be nice to get faster support for new features
Pros and Cons
  • "It is low-cost and easy to deploy. It is fully-featured."
  • "They are improving it all the time. What would be nice is if they could respond to feature requests more quickly. They can provide faster support for new features."

What is our primary use case?

It is for dashboards and reports. 

What is most valuable?

It is low-cost and easy to deploy. It is fully-featured.

What needs improvement?

They are improving it all the time. What would be nice is if they could respond to feature requests more quickly. They can provide faster support for new features.

For how long have I used the solution?

I have been using this solution for two years.

What do I think about the stability of the solution?

It is reasonably stable.

What do I think about the scalability of the solution?

In my organization, we have around ten users. In our client's organization, we have about 100 users.

How are customer service and technical support?

I normally find whatever I need in Microsoft documentation or through Google. There is a lot of activity in the market. A lot of other people typically would have already asked the same question that I have, so it is fairly easy to find information.

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

I didn't really use any other product. I used to be a Qlik partner, and I became a Microsoft partner two years ago.

How was the initial setup?

Its installation is straightforward. The developer suite has one-click installation. The end-users just get a web URL. There is no installation for end-users. They just access it.

There is a Microsoft certification that you need to complete, but it is all deployed on the Microsoft Azure cloud. So, there are no infrastructure requirements.

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

It depends upon the tier of your Office 365 subscription. On E5, which is a Microsoft Azure subscription, you get it for free. If you are on a lower tier, you can subscribe for $10 a month per user, which is really cheap.

What other advice do I have?

I would recommend this solution. It is pretty good. Technically, it is at the same level as the other products that I've used so far. It has all the features, and it is easy to deploy. Its costs are really palatable. They are improving it all the time. I am fairly satisfied with this product.

I would rate Microsoft BI a seven out of ten. There are always areas for improvement, but I am fairly happy with it. I would not rate anything else also higher than seven.

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: Integrator
PeerSpot user
Buyer's Guide
Microsoft Power BI
March 2025
Learn what your peers think about Microsoft Power BI. Get advice and tips from experienced pros sharing their opinions. Updated: March 2025.
844,944 professionals have used our research since 2012.
reviewer1040850 - PeerSpot reviewer
Director of Sales and Marketing at a tech services company with 11-50 employees
Real User
Integrates well with Microsoft tools and has a good familiarity but lacks technical support
Pros and Cons
  • "It integrates with all of the Microsoft tools."
  • "The initial setup is a little bit technical."

What is our primary use case?

We primarily use the solution for integrating into our ERP so people can have a dashboard analysis of whatever is important to analyze or compare, whether it be top-selling products or sales performance, or quota analysis.

What is most valuable?

Just as a BI tool, there's not much difference between solutions. It works well with our product and it's something that customers are familiar with and they often already have a lot of licensing with Microsoft. It's an easy add-on to their users.

There's generally a sense of familiarity with the product.

It integrates with all of the Microsoft tools.

What needs improvement?

It's not even fair for me to respond on that as that's not my wheelhouse. I don't know how easy it is as I'm not doing any of the designs. Therefore, I have not had any real training on it. I don't think that's fair for me to criticize anything that they're doing.

The initial setup is a little bit technical and what an end user wants to see is always a moving target.

The solution needs better technical support.

For how long have I used the solution?

I've been using the solution for about three years at this point.

What do I think about the stability of the solution?

In terms of stability, we haven't had any challenges with it at this point. As with multiple integrations across several companies we tend to make whatever change is best for the biggest base of clients. We haven't had any issues thus far.

How are customer service and technical support?

Technical and end user support is something that might be lacking from Microsoft. As a user when I want to find an answer to, "Hey, how do I do this?" I often get better answers by going to a  website of a company that represents them than I do going directly to their site.  Maybe they do that on purpose to help drive business to those people, however, it would be helpful if it was more centralized and the quick and simple steps answers that I get elsewhere.

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

I have some past experience with solutions such as Tableau and Cognose but not integrated into this ERP product.  We chose one that we would feel would be on a common platform of our customers.

How was the initial setup?

The setup is fairly straightforward but implementation is a little bit complex mostly due to how the customer driven scope changes often as they realize the power of a BI tool and want to be able to expand it's use.

We're on a Progress platform, so that's a little more technical on our side at the beginning of the original project.

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

The licensing costs vary. It all depends on the individual customer due to the fact that Microsoft's options are modular. For example, they have Microsoft Office suite, then they add CRM and then you might add BI.  It's not expensive per user, however, as you increase the functionality or add different tools, it becomes more expensive.

What other advice do I have?

We qualify as a partner as we're a software distributor. We're using the most current version of the solution.

Here is the biggest thing: when you look at any BI tool or if it's the first time you're implementing one, you can easily get over enticed by the flashy display or the common things. However, it's the ability to drill down to your true business processes that are going to make it or break it as being the right tool or accesses the right information. Somebody that gets a BI tool for the first time will open a dashboard and say, "Oh, that's important for me to see every day." However, the reality is, when using a dashboard view you're looking for a red flag or highlights. The power of the BI tool is allowing you to drill down to the data behind the dashboard, that's where the real testing comes in.  Figuring out where to get the information from and how best to analyze it.  That's my best BI tool advice. Anybody can make a dashboard look pretty. It has to be useful too.

In general, I would rate the solution seven 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
reviewer1472169 - PeerSpot reviewer
Solutions Architect at a tech vendor with 10,001+ employees
Real User
Full featured dashboard, easy to use, but expensive and needs more customization
Pros and Cons
  • "The dashboard features are really valuable, you can connect to multiple data points."
  • "The solution could be more customizable and you do not have too much freedom on the code."

What is most valuable?

The dashboard features are really valuable, you can connect to multiple data points. Overall, the solution is easy to use.

What needs improvement?

The solution could be more customizable and you do not have enough freedom on the code.

For how long have I used the solution?

I have used the solution for one year.

How was the initial setup?

The install was straightforward and the advanced dashboards operate on well-branded tablets.

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

The premium licensing is approximately $5,000 per month which is pretty expensive.

What other advice do I have?

If you are planning on implementing Microsoft BI, having experience with other Microsoft products will make using this solution easy and straightforward. 

I rate Microsoft BI a seven out of ten.

Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
PeerSpot user
ERP Consultant MS Dynamics Nav at Witteveen Logistics & IT
Consultant
Better insights, flexibility, and performance

What is our primary use case?

My primary use case is for the performance, compared to MS Dynamics NAV, and flexibility in data and dashboard building.

How has it helped my organization?

Better insights, flexibility, and performance.

What is most valuable?

Great performance.

What needs improvement?

  • Sharing reports with non-Power BI users 
  • Use of ISO weeks (European) in relative date options.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
PeerSpot user
Senior Business Analyst, Big data at a manufacturing company
Real User
It has a nice integration with Office 365.
Pros and Cons
  • "My primary use is for view of the dashboard."
  • "It ingegrates nicely with Office 365."
  • "Powerpoints are not available in the report server."
  • "The report server feature is quite limited."

What is our primary use case?

My primary use case is for view of the dashboard. 

How has it helped my organization?

We did not previously have a BI platform before. This has helped us.

What is most valuable?

It has a nice integration with Office 365.

What needs improvement?

Once the report updated, we want the system to send a notification to user automatically. Especially if the email can imbed the dashboard data into the email, instead of a link. This does not necessarily happen.

In addition, importing the dashboard to a powerpoint is not available in the report server.  Even though we go to the public cloud service, the export is only the picture, or a snapshot of the dashboard. We cannot play the features or see the data we could change in a powerpoint. This is frustrating  because sometimes the finance manager needs to export the report to a powerpoint. Actually, we wanted to export because we wanted to do the presentation. We wanted to show the figures or something like that, but those figures are just static, and are only a picture.

Finally, an additional feature should be added to add a cost table.

What do I think about the stability of the solution?

Actually, it's a stable solution. But in some companies, based on my experience, my previous company, using the FAP solution for their IP solution. Then for our Powerband, the BI2, the data come from EIPCN, something like that, but actually it seems that the Powerband don't have very good integration with FAP interface. The integration from from FAP is not so convenient

What do I think about the scalability of the solution?

The scalability is quite good. 

How is customer service and technical support?

The technical support team is quite responsive and helpful. They are responsive to our questions in their forum.

How was the initial setup?

I was not involed with the initial setup of the solution.

What was our ROI?

We always review:

  • Scalability
  • Price

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

It is a cheap solution for our needs. 

What other advice do I have?

It is a solution that is easy for developers to be hands-on, even if they do not have prior experience with it. It is quite easy to learn.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
PeerSpot user
MSBI Technology Architect/Developer at a pharma/biotech company with 51-200 employees
Vendor
Very stable tool with some improvements needed in SSIS

What is most valuable?

SSIS is the most valuable. Individually I would rate features out of 10 as SSIS: 9, SSAS: 8, and SSRS: 7.

How has it helped my organization?

Automation. With MSBI, we realized automation from data loading, transformation and reporting.

What needs improvement?

The aggregate functions in SSRS.

For how long have I used the solution?

5 years

What was my experience with deployment of the solution?

Not much with appropriate configuration design.

What do I think about the stability of the solution?

None encountered.

What do I think about the scalability of the solution?

Data set is not big enough to tell.

How are customer service and technical support?

Customer Service:

Good. Also easy to find solution by Googling.

Technical Support:

Haven't been using it due to the ease of getting answers on the internet.

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

No previous solution used.

How was the initial setup?

I was able to figure out the setup by doing some research and it's not too complex for experienced user.

What about the implementation team?

In-house implementation.

What was our ROI?

The company spent less than $100k to switch from SSAS to MSBI, which saved the company at least one SAS programmer.

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

Not sure.

Which other solutions did I evaluate?

Not sure.

What other advice do I have?

It's a proven stable tool.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
PeerSpot user
Developer at a tech consulting company with 51-200 employees
Consultant
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.
PeerSpot user

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.

See all 4 comments
Buyer's Guide
Download our free Microsoft Power BI Report and get advice and tips from experienced pros sharing their opinions.
Updated: March 2025
Buyer's Guide
Download our free Microsoft Power BI Report and get advice and tips from experienced pros sharing their opinions.