Try our new research platform with insights from 80,000+ expert users
Owner at BNS
Real User
Reliable with good reporting, easy to setup, can capable of scaling
Pros and Cons
  • "The reports are easy to create."
  • "The orchestration module for refreshing data flows is something that is missing and we have to do it manually."

What is our primary use case?

We are software developers. We generate data using the basic data connectors that Microsoft provides. We just follow the importing and exporting data around, the Azure platform.

We are doing C# development. We use an SQL server, and we use Power BI. Those are the main three technologies, and then it's just Microsoft to put it together.

We use this solution to create business intelligence reports for the executive users of our applications. We are creating standard business applications like ERP and CRM and e-commerce type applications. Then, we extract a sample of the data, build a simple data warehouse, in the Power BI service, and create some BI reports.

What is most valuable?

The data visualisation is very attractive from the user's point of view. Users see their reports and think "Wow - that is amazing". 

However, it is much harder to prepare data for reporting. I would say 95% of your development time is spent gathering, cleaning, and modelling data. However once that is done reporting is easy.

What needs improvement?

The capacity needs improvement. It is limited in its capacity in power.

Some of its features are incredibly difficult to understand. There is a learning curve to do the more sophisticated things. For example, paginated reports are complicated. But in general, Power BI, it's not an end-user tool, however much Microsoft pretended it is. We just treat it is like another tool that we use and we deliver the reports to our clients.

The orchestration module for refreshing data flows is something that is missing and we have to do it manually. It should be one of the admin features of Microsoft BI.

For how long have I used the solution?

I have been working with Microsoft BI for 15 months.

We are using the latest version.

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.
823,875 professionals have used our research since 2012.

What do I think about the stability of the solution?

It is a reliable solution. 

What do I think about the scalability of the solution?

I haven't tried to scale it, but in theory, I know that is capable. Power BI Premium is easy to scale as long as you have the money.

Inside the business, we only have one user, and outside the business, we have our clients where we have four developers who use this solution.

Our clients are medium-sized companies with 50 to 100 users.

How are customer service and support?

I have not contacted technical support. Google provides the information that we need.

How was the initial setup?

The initial setup is straightforward.

It can take a couple of hours to deploy the gateways, then there is the development of it.

It doesn't require maintenance, but we are forever enhancing the reports. In general, it works without problems.

What about the implementation team?

We are developers, we can complete the installation ourselves.

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

We view it as an expensive product. 

Most of our clients cannot afford the premium capacity. 

We just make do with Power BI pro features, which is always a big shame because we know that the premium version has a lot of features that we would like to use, and are not available to us.

There are a few different licensing models.

It ends up being complicated and people don't like paying for things. It's okay if you're working for a large corporation because they can obviously spend thousands of pounds every month on licenses, but our customers cannot.

Licensing is paid on a monthly basis.

What other advice do I have?

Power BI has approximately 20 new features that come out every month. You just have to be patient and eventually, the features come out.

My advice to others would be to do your homework. It's one of those things where you have to get past the marketing. The marketing message is not helpful.

I would suggest that if you are going to use Power BI, you need to use developers who understand what it can do, what it can't do, and how it works. 

Then they will then guide you to say, this is the type of report you can expect. 

It took me a long time to realize what you can and cannot do with Power BI.

That's why I suggest doing your homework first. It's not as wonderful as Microsoft pretends it to be, but it's not bad, and I am not knocking it, but you have to cut out all the hype that comes with it.

I would rate Microsoft BI a nine out of ten.

Which deployment model are you using for this solution?

On-premises
Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
PeerSpot user
reviewer1638714 - PeerSpot reviewer
Junior Data Scientist at a university with 5,001-10,000 employees
Real User
Good transforming of data for visualization, useful, stable, and scalable
Pros and Cons
  • "It is quite easy to use and it helps me to achieve the projects that I've been assigned."
  • "I feel the modeling page should be simplified."

What is our primary use case?

We use Microsoft BI typically to clean up data in Excel, as well as to create reports for my supervisor that will be analyzed and then used to draw conclusions.

How has it helped my organization?

It provides the common ground for data to be cleaned. We use this for everyone to work on cleaning up data in order to use it for visualizations, which has been helpful.

What is most valuable?

The transforming data before you start with the visualization comes in pretty handy.

It is quite easy to use and it helps me to achieve the projects that I've been assigned.

I have never had the inability to perform the tasks I've been assigned with the software. 

It's very useful because you can create helpful reports, which assist you to analyze data in a very organized way.

What needs improvement?

I feel the modeling page should be simplified. The links between different parts of your data, on the models' page, are a bit confusing. It was difficult for me to learn. 

For how long have I used the solution?

I have been using Microsoft BI for three months.

We are using an older version specific to the organization.

What do I think about the stability of the solution?

Microsoft BI is a stable product.

What do I think about the scalability of the solution?

Microsoft BI is quite scalable, especially with the number of coding languages that are available to use.

We have approximately 23 data scientists in our organization who are using this solution. We use it extensively.

We are mostly using Microsoft BI but we are trying to bring in Tableau and maximize the potential of both.

How are customer service and technical support?

I have not contacted technical support.

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

I also have experience with Tableau.

How was the initial setup?

When I arrived, this solution was already set up.

What other advice do I have?

For others who want to start using Microsoft BI, I would say go through some tutorials on your own first and then try and practice with practice data sets that are available online. Also, feel free to play around with the different tools, and the different visualizations, because you can use them differently for different things.

I would rate Microsoft BI 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
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.
823,875 professionals have used our research since 2012.
Group DWH and BI Senior Manager at Virgin Mobile Middle East and Africa
Real User
Scalable, easy to learn, and integrates well with the entire Microsoft Office Suite
Pros and Cons
  • "The initial setup is straightforward."
  • "Maybe they can enhance the UI a bit. Right now, it's very basic, I would say, compared to the MicroStrategy or Qlik."

What is our primary use case?

I mainly use it for sales analysis. We are in the telecom industry, so on a daily basis, we see a couple of trends in the number of activations of customers and registration, the performance of the dealer, and items like that.

What is most valuable?

Its integration with the Microsoft Office Suite is great. I can easily connect it to any of the Excel or any CSV files, and I can immediately create a dashboard. 

It's like the higher level of pivot tables. For the people who mainly use Excel, this is like an advanced version. This is much more flexible and I don't have to train people to use it, as it's very user-friendly compared to Qlik. Qlik needs some expertise and a layman cannot immediately go to Qlik and do stuff unless he understands it. When it comes to Power BI it's a five minutes tutorial, he can definitely understand what needs to be done.

The solution is stable and scalable. So far I don't have any issues, however, it depends on the amount of data we use. I'm just running it on my PC.

The initial setup is straightforward. 

The solution is free as it's bundled with Office 365.

What needs improvement?

Maybe they can enhance the UI a bit. Right now, it's very basic, I would say, compared to the MicroStrategy or Qlik. 

They could also improve the mobile experience. If people are using this mobile app for BI, they need better performance there. The rendering of the objects, for example, if you create the dashboard on Power BI when someone sees that on the app, it comes in a different format. They can do some enhancements there to standardize it.

Once we expand it as a centralized repository, if I could find much more use cases, that would be ideal. However, now it's very limited in our organization.

For how long have I used the solution?

We don't use the solution filly and don't yet have a license for it. That said, I've had the chance to work with it for more than a year now.

What do I think about the stability of the solution?

The solution is stable. There are no bugs or glitches and we don't have any trouble with it crashing or freezing. It's reliable and the performance is good. 

What do I think about the scalability of the solution?

My understanding is that the solution is scalable. 

I can easily load a billion rows in less than two or three minutes and play around with it. However, I haven't tested on big data files or anything like that.

Right now, we don't have too many users. It's just three to four people as of now, as our primary BI tool is still Qlik Sense. It's only for ad hoc use cases we use Power BI, and just myself and a couple of team members, as well as the BI specialist, that access it.

How are customer service and technical support?

I've never reached out to technical support in the past. If I run into issues, I tend to Google solutions to find answers to my questions. YouTube is also a good resource if you need information.

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

We currently use Qlik Sense as our BI product.

How was the initial setup?

The initial setup is not complex or difficult. It's simple and straightforward. 

It took, 10 to 15 minutes, if I remember correctly, to set everything up. It's just a .exe file installing. It's not hard and it's pretty fast.

What about the implementation team?

We did not need a consultant or an integrator to handle the implementation. I just played around a bit with it.

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

We don't have a license on Power BI, so we don't publish anything. It's mainly for some ad hoc use cases that we use Power BI format.

Power BI is free; it comes with Office 365.

Which other solutions did I evaluate?

I've currently looked at MicroStrategy and am in the process of comparing a few other products.

What other advice do I have?

We are just a customer and an end-user.

We are using Power BI, however, not to the full scale. It's still unlicensed as of now, and I'm using desktop versions only.

I don't remember the version, as it comes with Office 365. I didn't give a thought to the version.

From my experience with the desktop version, I'd rate the solution at a nine out of ten.

From my experience, I'd recommend the solution to others. 

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
reviewer1565994 - PeerSpot reviewer
Technical Director, Information Management at a construction company with 5,001-10,000 employees
Real User
Good reports, dashboards, and visualizations, but needs more report outputs and better documentation
Pros and Cons
  • "Reports, dashboards, and visualizations are most valuable."
  • "It should have more report outputs. They should expand the report outputs. Its documentation should also be better."

What is our primary use case?

It is used for data visualization and analytics. We have its latest version.

How has it helped my organization?

It has provided better and deeper analytics for our data. It has also been helpful for custom visualizations as per client requirements.

What is most valuable?

Reports, dashboards, and visualizations are most valuable.

What needs improvement?

It should have more report outputs. They should expand the report outputs.

Its documentation should also be better.

For how long have I used the solution?

I have been using this solution for five years.

What do I think about the stability of the solution?

It is fairly stable.

What do I think about the scalability of the solution?

It is scalable based on licensing. You would need premium and additional organizational licenses. Mostly everyone in the organization uses this feature. We have around 4,000 users of this solution in our organization, which includes a lot of project management people.

We don't have any plans to increase the usage in the future. We are currently content with its usage.

How are customer service and technical support?

They exceed expectations and provide good quality support.

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

We had other solutions, but they were some form of ad hoc databases and spreadsheets. We switched to this solution for integrating various data sets from different data sources and for richer analytics.

How was the initial setup?

It was straightforward. It took two weeks.

What about the implementation team?

It was an in-house job. For its maintenance, we probably have a staff of about 20 people.

What other advice do I have?

I would rate Microsoft BI a seven out of ten. It is a really well-developed product, but it has some room for improvement.

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
reviewer1477869 - PeerSpot reviewer
Senior Consultant at a computer software company with 10,001+ employees
Vendor
Good user interface, good technical support, and has the ability to scale
Pros and Cons
  • "The solution's initial setup isn't too complicated."
  • "The integration with other solutions could be improved for reporting aspects."

What is our primary use case?

We have a few projects. We're using the solution primarily to develop a modern sitemap.

What is most valuable?

The product has a very defined, well-prescribed format to it. It's easy for everyone to use for the most part.

The training is pretty good. It's well-described so that users can navigate the solution easily and follow the correct steps to initiate tasks effectively.

The user interface is pretty good.

The technical support on offer is excellent.

We've found the scalability to be quite good.

The solution's initial setup isn't too complicated.

What needs improvement?

I need more time with the solution. Right now, I can't think of any features that are missing from the product.

The integration with other solutions could be improved for reporting aspects. There are some reporting features in Tableau that we need access to and it would be ideal if there was a function between the two for data integration and data manipulation, with the final representation of the report available on Tableau.

For how long have I used the solution?

I've been using the solution for a year or more at this point. It hasn't been too long.

What do I think about the stability of the solution?

So far, the solution has been largely stable. However, I'm still exploring the solution and testing it against my requirements. The stability hasn't quite been proven fully just yet.

What do I think about the scalability of the solution?

The solution is pretty scalable. It meets all of my client's requirements. I'm able to make changes and expand if I need to. It's pretty simple to scale it out as necessary.

We deal, for the most part, with medium-sized companies. We don't really deal with smaller organizations or bigger enterprises.

How are customer service and technical support?

I'm extremely satisfied with technical support. It's been excellent so far. They are responsive and knowledgeable and I always get my questions answered in a timely manner. I have no complaints about their level of service.

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

I've also worked with Tableau and SAP products. We use them all currently.

How was the initial setup?

The initial setup is not complex in any way. It's quite straightforward. It was installed quite easily onto our system. We didn't run into any issues in that sense.

What other advice do I have?

I'm using the calculator version of the solution.

We use both the cloud and on-premises deployment models.

We are Microsoft partners. We're not just users.

Overall, I would recommend the solution. We do have other plans to use other BI solutions, however, we haven't really focused on that just yet. So far, this product has met our needs pretty well.

On a scale from one to ten, I'd rate the solution at a nine. We've largely been happy with the product and its offering.

Which deployment model are you using for this solution?

On-premises
Disclosure: My company has a business relationship with this vendor other than being a customer: partner
PeerSpot user
Consultor at Scitum
Consultant
Works very well for updating indicator boards,and for quick visualizations in demos
Pros and Cons
  • "The uploading of information is very easy, as you just use an Excel sheet to start work right away and obtain the benefits of Power BI."
  • "I would like to see the product offer more graphics to impact different audiences."

What is our primary use case?

We use this for data analysis and the creation of indicators. It is one of the most powerful tools for BI in my experience. It works very fast, is intuitive, and useful. You just drag and drop, as soon as you download it.

How has it helped my organization?

This solution works very well for updating indicator boards, and for quick visualizations in demos. You can present results in many ways to improve the presentation.

I have used it on a variety of applications where it is important to show analysis and present information in a graphical perspective, and also to modify and present information to developers and executives.

What is most valuable?

One of the features I really like is that there are a lot of different graphics that are very nicely presented. The uploading of information is very easy, as you just use an Excel sheet to start work right away and obtain the benefits of Power BI.

When you start, right from the beginning it can help you. Once you upload the data you can start to play with the different options you have from the graphics available, and also from the different mathematical and logical conversions that it offers.

I also work with other data processors and the facilities that Power BI offer can help to better understand the traditional database tools such as SQL, or others.

Another advantage is that you don't have to have a lot of knowledge about databases. This is because you use Power BI knowing your goal and what you want to achieve with respect to the data that you are processing.

What needs improvement?

I would like to see the product offer more graphics to impact different audiences. Also, I would like more ease in connecting with the different database drives.

For how long have I used the solution?

Less than one year.

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

This is different from other solutions in that Power BI offers ease of use. It is different from any SQL tool because you can use it right away.

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

If you are looking for free tools to process data in different ways for an easy to medium analysis then you have the free version available. However, if you want a complex analysis from multiple sources of data then you should look for the charge and support version.

In my opinion, both options are good.

Which other solutions did I evaluate?

I evaluated some other tools but I think they had very different objectives. Power BI looked more generic and has an easy and quick way to present the information in different forms.

What other advice do I have?

It is important to say that the information cannot be confidential or secret. This is because the platform processes all data from the Microsoft cloud and you have to be certain of the security issues that someone could face if a security breach happens.

I very much recommend the free trial mode.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user181869 - PeerSpot reviewer
Microsoft BI Architect at a tech services company with 10,001+ employees
Real User
Despite vague error messages, some functions were cut down from 90 seconds to about less than one second

What is most valuable?

  • SQL Server Integration Services
  • SQL Server Management Studio

How has it helped my organization?

There have been occasions when a certain application would work very slowly on other DB platforms and once we migrated to SQL Server the response times improved dramatically. For example, I recently migrated an application from TeraData to SQL Server and the response times for some functions were cut down from 90 seconds to about less than 1 second! This obviously speeds up the work that gets done within a day.

What needs improvement?

The SQL Server Reporting Services can certainly use some more help. Within SSIS, I see room for more connectors and easier debug messages that would speed up the process of development. The biggest hurdle that any developer comes across is vague error messages.

For how long have I used the solution?

About eight to nine years.

What was my experience with deployment of the solution?

No. The installation and deployment process has always been smooth and simple.

What do I think about the stability of the solution?

No. Product is very robust and reliable.

What do I think about the scalability of the solution?

Adding extra machines to the cluster environment is not difficult but certainly needs experienced developers/implementers to do that.

How are customer service and technical support?

Customer Service:

Excellent. They usually turn around within good time and you can also request new features directly from the group that is responsible for the product.

Technical Support:

9/10

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

A different solution was not used previously.

How was the initial setup?

I have been to many projects and usually the setup is pretty straight forward. But even when it comes to complicated setups such as multiple clusters, the product still seems easy once understood.

What about the implementation team?

In-house implementation.

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

It varies from place to place. But a typical license would cost anywhere from a few thousand bucks to the upper $20k-$30k range.

Which other solutions did I evaluate?

  • MicroStrategy
  • TeraData
  • Informatica.

What other advice do I have?

Look at the amount of data that you have and the amount you anticipate in the future. If you have multiple sources of data and multiple applications consuming it, sticking to a single solution might not be the best idea.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
reviewer1776825 - PeerSpot reviewer
Practice Manager at a computer software company with 10,001+ employees
Vendor
Reasonably priced, easy to deploy, and user-friendly data analytics and reporting solution
Pros and Cons
  • "Good reporting and data analysis tool that's user-friendly, easy to deploy, stable, and scalable."
  • "The UI looks awkward once the graphs have been generated in the console. This is what Microsoft can work on."

What is our primary use case?

We use Microsoft Power BI for production testing. We're not using it for production automation. It's being used for testing and testing themes. We have a testing requirement, so we want to mimic automated workflows on production to be validated on regular intervals, and this is how we use this solution.

What is most valuable?

One valuable feature of Microsoft Power BI is that it's user-friendly. It also has good connectivity between multiple source systems. It's also a good data analysis tool.

What needs improvement?

The UI looks awkward once the graphs have been generated in the console. This is what Microsoft can work on. They should make the graphs more user-friendly, because other parts of Microsoft Power BI are user-friendly, but the graphical representations aren't.

For how long have I used the solution?

We've been dealing with Microsoft Power BI for five to ten years now. We were early adopters of cloud solutions, e.g. AWS and Azure, which we adopted from the start. We are a complete cloud company.

What do I think about the stability of the solution?

Microsoft Power BI is a stable solution.

What do I think about the scalability of the solution?

I find Microsoft Power BI scalable.

How was the initial setup?

It's very easy to deploy Microsoft Power BI.

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

Microsoft Power BI has reasonable pricing.

Which other solutions did I evaluate?

We evaluated Microsoft Azure.

What other advice do I have?

We use Microsoft Power BI. We also use AWS, but what we primarily use is Microsoft Power BI.

We're using a combination of deployment models for this solution, because the model will depend on the customer need.

We don't procure this solution and other Microsoft tools for ourselves. It's the customer who procures them, and there is not much issues for us to contact support. We are a Microsoft company, e.g. we are partners with Microsoft, so we have good rapport with them.

We recommend Microsoft Power BI even for large enterprises. It's a tool that could be used even by smaller enterprises and by end customers.

My rating for Microsoft Power BI is an eight out of ten.

Which deployment model are you using for this solution?

Hybrid Cloud
Disclosure: My company has a business relationship with this vendor other than being a customer: partner
PeerSpot user
Buyer's Guide
Download our free Microsoft Power BI Report and get advice and tips from experienced pros sharing their opinions.
Updated: November 2024
Buyer's Guide
Download our free Microsoft Power BI Report and get advice and tips from experienced pros sharing their opinions.