Try our new research platform with insights from 80,000+ expert users
reviewer1330689 - PeerSpot reviewer
Client Director, Head of Sales & Marketing, Partner at a tech services company with 11-50 employees
Real User
Very smooth, has matured a lot; great scalability
Pros and Cons
  • "Implementation is very quick and the solution is very user-friendly."
  • "Automation could be improved and performance enhanced."

What is our primary use case?

We are a consultant company, so we use BI for project follow-up, sales and pipeline. We are partners with Microsoft and I'm the company's client director.

What is most valuable?

I like that implementation is very quick and that the solution is very user-friendly and easy to work with. The solution has provided us with speedy insight and faster effects on the table. It's a smooth product. 

What needs improvement?

I think that automation could be improved and performance enhanced. Documentation for developers could also be improved. 

What do I think about the stability of the solution?

The solution is stable. 

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

What do I think about the scalability of the solution?

Scalability is very good. It can be pricey to move to the P1 licenses for $5,000 a month for smaller companies, but there are workarounds using A1 to A6 licenses which are cheaper and more flexible in the pricing. We have 50 users in the company. 

How was the initial setup?

When we deployed five years ago, the setup was very complex. Since then, it's become much easier. 

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

Compared to competitors like Tableau, Microsoft BI is not so expensive.

What other advice do I have?

I recommend this solution. Microsoft BI has matured a lot in the last year.

I rate this solution nine out of 10. 

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
MIS Specialist at a agriculture with 201-500 employees
Real User
It's easy to conduct analysis but needs more work to make it stable
Pros and Cons
  • "Microsoft BI is better than most solutions we have. It's pretty easy to conduct analysis with it."
  • "Microsoft needs to do some more research and development to make it more stable."

What is our primary use case?

In our sector, we're dealing with lots of FinDocs and routine FinDoc activities. So all these things are managed locally, with data coming from some secondary source. By that, I mean our in-house technicians provide a data service that is locally developed on our end, and we analyze data in Microsoft Power BI. We have about 10 to 12 users working with it.

What is most valuable?

Microsoft BI is better than most solutions we have. It's pretty easy to conduct analysis with it.

What needs improvement?

Microsoft needs to do some more research and development to make it more stable.

For how long have I used the solution?

We've been using Microsoft BI for about six months.

What do I think about the scalability of the solution?

I think Microsoft BI is scalable.

How are customer service and support?

We have some technical partners from Microsoft, so we contact them for any issues.

How was the initial setup?

Installing Microsoft BI is fast and easy. We just downloaded it from Microsoft. That's it. It only takes about half an hour. It takes a little longer for the overall deployment, depending on the data volume. If we're getting the data from a secondary source, it depends upon both the source and volume. The greater the volume, the greater the time. Usually, we can manage to get it done in one or two hours plus the testing. It takes around four people to deploy and manage the solution.

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

We haven't thought much about licensing because we're still dealing with some administrative hang-ups. Once all these things are resolved, then we go for the license. It is in process.

What other advice do I have?

I rate Microsoft BI six out of 10. I would recommend it.

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
Microsoft Power BI
January 2025
Learn what your peers think about Microsoft Power BI. Get advice and tips from experienced pros sharing their opinions. Updated: January 2025.
831,071 professionals have used our research since 2012.
Analyst Operations with 1-10 employees
Real User
Displays information well, simple to install, and low maintenance
Pros and Cons
  • "In the process of using data there is the Extract, Transform and Load (ETL). For extracting we are using another software, for transforming we are using our own coding in C#, and then we use Microsoft BI for loading the information. Microsoft BI displays information very well."
  • "The solution could improve the extraction and transformation of data. For example, you transform the data and then send it to Microsoft BI without having to use your own API. We are only providing the API to Power BI, and then Power BI is doing the job."

What is our primary use case?

We were using Microsoft BI but it could not do what we wanted it to do. Then we moved to an open-source platform, which was Apache Tika, Kafka, and third solution. We ended up moving back to Power BI only to display the information because displaying information with Power BI is better than open-source software. We are not using all aspects of the solution at the moment.

What is most valuable?

In the process of using data there is the Extract, Transform and Load (ETL). For extracting we are using another software, for transforming we are using our own coding in C#, and then we use Microsoft BI for loading the information. Microsoft BI displays information very well.

What needs improvement?

The solution could improve the extraction and transformation of data. For example, you transform the data and then send it to Microsoft BI without having to use your own API. We are only providing the API to Power BI, and then Power BI is doing the job.

In an upcoming release, Microsoft BI should increase the functionality of the solution.

For how long have I used the solution?

I have been using Microsoft BI for approximately six years.

What do I think about the stability of the solution?

We were satisfied with the stability of Microsoft BI.

What do I think about the scalability of the solution?

We have 30 users using the solution in my organization.

How are customer service and support?

We are in contact with the support of Microsoft but I have not been in contact directly.

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

I have used other solutions, such as Apache Tika and Kafka.

How was the initial setup?

The initial setup was straightforward.

What about the implementation team?

The solution only needs one person to do the maintenance.

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

There are a few options available for purchasing a license. Typically the number of users you have will determine the price of the license. The more users you have the more you will pay.

What other advice do I have?

The solution has had a lot of changes over the years and it is very good. However, there is more work to be done on extract and transform functions for it to be done properly.

I rate Microsoft BI an eight 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
Business Analyst at a non-tech company with 10,001+ employees
Real User
An easy and flexible BI solution, but the dashboard could be better
Pros and Cons
  • "The Microsoft Power BI app is very good. It's also very flexible."
  • "The dashboard could be simplified."

What is our primary use case?

We use it mainly for Qlik Sense. We're using business interests analytics. Everyone from marketing to sales uses it. Microsoft BI is usually used for oversight.

What is most valuable?

Microsoft BI is easy and but not very user-friendly. But you can directly connect it to an Excel file. You can find out how many sites to look at and do it yourself directly. The Microsoft Power BI app is very good. It's also very flexible. 

What needs improvement?

The dashboard could be simplified. The service is currently good, but it could be better. If you compare it to Tableau and Qlik Sense, they are doing much better work. The ability of their dashboards is much better. The technical part is easy in Qlik Sense, where we can do some coding. It isn't easy in Power-BI.

Microsoft BI can be more user-friendly. Scalability is also a challenge for us because it's difficult to handle Power BI's dashboard.

For how long have I used the solution?

I have been using Microsoft BI for the last four years.

What do I think about the stability of the solution?

Microsoft BI is a stable solution. We haven't had any issues yet.

What do I think about the scalability of the solution?

It's not very scalable because it's difficult to manage the Microsoft BI dashboard.

How are customer service and technical support?

Technical support is good.

How was the initial setup?

The initial setup is very easy.

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

Their price is good.

What other advice do I have?

I would recommend this product to potential users. But if they have options, I would recommend one of the others.

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

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
Engineer at Jade Global
MSP
The Microsoft tech support blog is very helpful.
Pros and Cons
  • "Tech support is very helpful."
  • "We did have some issues building the Microsoft blog."

What is our primary use case?

The primary use case for this solution is mirroring it to the dock so we can match up different parts of Office like Excel, Word, etc. and then we can clear it.

How has it helped my organization?

Microsoft always believes in adding different features. We did have some issues building the Microsoft blog.

What needs improvement?

We were having trouble working with the icons.

For how long have I used the solution?

Less than one year.

How is customer service and technical support?

The Microsoft tech support blog was very helpful to me. But, it supports the non-BI people also.

How was the initial setup?

I was not involved with implementation of the product.

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

I do not have a comment on the pricing of the solution.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
PeerSpot user
Business Intelligence Architect at a tech services company
Real User
Data integration enabled my organization to easily pool data from our varied system into one data warehouse.​
Pros and Cons
  • "Data integration enabled my organization to easily pool data from our varied system into one data warehouse."
  • "SSMS & SSRS."

What is most valuable?

Power Query, Power Pivot, Power View & SQL Server Data Tools comprising of (SSIS, SSAS, SSRS).

How has it helped my organization?

Data integration enabled my organization to easily pool data from our varied system into one data warehouse.

SSRS improved our report delivery timings and the Power BI feature empowered the data users.

Power View improved the visualization of our reporting and dashboards.

What needs improvement?

SSMS & SSRS.

For how long have I used the solution?

For over five years.

What do I think about the stability of the solution?

Yes.

What do I think about the scalability of the solution?

Yes, SSRS reporting portal cannot run on tablets, iPads and all other mobile devices. But SQL 2016 has been shipped with this capability.

How are customer service and technical support?

Microsoft has a lot of products, hence some products are given little attention and VS is one of them, so I would say their technical support for the BI suite is average.

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

No.

How was the initial setup?

The initial setup was fairly simple and straight forward, I must say.

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

To others, I would advise that Microsoft BI products are rightly priced and the licensing is easy to follow and to fulfill.

Which other solutions did I evaluate?

Yes, Tableau.

What other advice do I have?

For users intending to use the product in exclusively Microsoft environment, this product will meet most of your requirement if not all.

If there is a need for integration with other vendors’ products precautionary measures must be taken.

SQL 2016 is bringing and offering that support for mobile BI, so it would be great to give it a try.

If you are comfortable with MS Excel spreadsheets, then Power BI is your thing as it has the same look and feel of Excel, actually, it is embedded in Excel.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
PeerSpot user
Founder at a tech consulting company with 11-50 employees
Real User
Top 10Leaderboard
SQL Server 2016 delivers built-in mobile BI capabilities.

Valuable Features:

Microsoft SQL Server Report Publisher

Microsoft SQL Server Report Builder

Microsoft SQL Server Reporting Services (Web Portal)

SQL Server 2016 delivers built-in mobile BI capabilities.  The above tools give professionals the ability to deliver business insights quickly and easily as well as enabling a quick way of presenting the data/charts/reports over a web portal.  The portal is compatible for cross platform, from desktops to major mobile devices.

Overall a great way of delivering your insights to your data.

Improvements to My Organization:

Works with data, systems and tools we already have. They are "additional" tools rather than complete replacement software.  Easy to upgrade / install.  The new SSRS tools in particular give us an easier way to share insights and reports to our clients and within our own teams.  Security is easily managed within SharePoint.

Room for Improvement:

License fee structure.  Mobile reporting Services is only available for the "Enterprise" addition of SQL Server 2016.  This comes with a hefty price tag.  Would be better if you could pick and choose the features you require and then the price tag is set accordingly.  Rather than paying for the full Enterprise addition and getting a lot of features we do not need/use.  

Use of Solution:

We have been using Microsoft's extensive software library for years.  But at the time of writing this review, SQL Server 2016 Enterprise is pretty brand new.  We knew of the latest reporting services offering and were eager to trial it.

Deployment Issues:

Deployment isn't rocket science, but it isn't child's play either.  There were a fair few standard issues getting everything to talk to each other.  Nothing to worry about though.  Microsoft has worked well to make sure the latest SSRS is an "add-on" feature that integrates seamlessly. 

Initial Setup:

Straightforward easy setup.  Typical Microsoft software (familiar).

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
Real User
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: January 2025
Buyer's Guide
Download our free Microsoft Power BI Report and get advice and tips from experienced pros sharing their opinions.