President & Owner at Altrim Systems
Reseller
Good visibility, graphic visuals, and easy to install
Pros and Cons
  • "It gives us, the ability to do a lot of analysis quickly, similar to ad hoc analysis."
  • "One of the more difficult things to do is to export some of the data from Power BI to Excel."

What is our primary use case?

We are Microsoft resellers.

We use it for clients to extract and analyze data from ERP systems. Then, we basically put it in on-premise Power BI, and once we have the reports and visuals that we want, we publish it to different members of whoever has access to see the reports. Basically, we publish it to their Power BI in the Cloud.

How has it helped my organization?

For one client, it gives all sales reps across all geographic regions access to sales data, so they know who's purchasing what product in what part of the country, and that sort of thing. It shows them overtime when sales are high and low, as well as what types of customers are buying. We occasionally connect it to external data. We link it to some demographic data, such as population figures in different provinces in Canada, to see how sales are doing.

It is beneficial. It's one of the applications we use for a client's sales reps all over the country to get all kinds of sales data. It also benefits them. They can ask, "Why isn't this customer purchasing this specific product?" So they know which customers are genuine or who are purchasing and may try to push a different line with them. It provides a wealth of useful information to the salespeople.

What is most valuable?

It gives us, the ability to do a lot of analysis quickly, similar to ad hoc analysis. People want to know, for example, which customers are purchasing which products over what time period. It's very simple to make visuals for them. We create a matrix that resembles a spreadsheet and then link it to various graphic visuals, pie charts, and other types of charts. They also get a visual sense of what's going on. Those features are fantastic.

What needs improvement?

One of the more difficult things to do is to export some of the data from Power BI to Excel. It is getting better. It's better than it was six, eight, or nine months ago, but it's still not quite there. They could probably improve that a little bit. 

The only disadvantage of how we're using it is that it can be difficult to get the data into Excel at times. A lot of users are very familiar with Excel, so having a seamless interface into Excel would be a big plus for a lot of people, in my opinion. Otherwise, it's an excellent product.

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

For how long have I used the solution?

I have been selling Microsoft BI for two years.

I am using the most recent version.

It can be deployed both on the cloud and on-premises.

What do I think about the stability of the solution?

For us, the stability has been great. We have no issues with the stability of Microsoft BI.

What do I think about the scalability of the solution?

I believe it is a scalable product. I'm aware that they have other products on the market, but I haven't tried them. To analyze data, it appears to be scalable to fairly large businesses. Scalability is quite good.

It is not a single organization. It's amongst a few clients of mine. I would estimate the number of users to be about 20, 25, or something along those lines. Their roles vary a lot. Several users are salespeople and people in purchasing. There are also people in management who use it and people in the accounting area as well. There are also one or two more technical users who use it to export data to Excel PivotTables. These are the people who make use of it.

For one client, it's very extensively used. Others, I wouldn't say that it is used as extensively. They could use it a lot more.

How are customer service and support?

I have not had any interaction with technical support.

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

Before using Power BI, we used a lot of Excel, Power Pivot, and other similar tools. We transitioned a lot of our data models from Excel and Power Pivot to Power BI, including the PivotTables. It was a Microsoft solution. It was Excel, from Excel and Power Pivot to Power BI.

How was the initial setup?

The initial setup went quite well. It was a fairly straightforward process. There were no major hiccups.

It took approximately four to five hours to configure.

I have one client who has an administrator who updates the system. He updates the product and his data on a regular basis. I believe the data must be updated once a month. Other clients' updates are handled by me.

What about the implementation team?

We did not need assistance, we completed it in-house.

What was our ROI?

Yes, I believe so. I haven't actually measured it, but based on one particular client, I believe their company is expanding at a rapid pace. I believe a large portion of it is or a good deal of it is based on the information they receive. I believe there will be a return.

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

It's straightforward licensing. I would guess we pay $300 to $400 per month for everyone or something along those lines.

What other advice do I have?

Depending on where they're coming from, one thing is that if you want to get deeply involved in it, you have to learn the programming language, which I believe is DAX. It is not difficult to become involved in and learn. Microsoft, in my opinion, has done a good job of making it simple. That's one area I believe people should look into if they want to learn more than just the fundamentals of the DAX programming language. Which we have done in part. Again, we are not experts, but we have looked into it.

I would rate Microsoft BI a nine out of ten. It does almost everything we require.

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:
PeerSpot user
Manager Technical Architect at Legato Health Technologies
Real User
Useful for data visualization and building interactive dashboards
Pros and Cons
  • "It works well with SSAS, which we use to generate all different kinds of trending and analytics reports. Sometimes we use Power Query and DAX to build some aggregations on the Power BI side as well."
  • "Sluggish performance when handling large amounts of data."

What is our primary use case?

It is one of the business intelligence tools we are using—mainly for all our data visualization purposes and building interactive dashboards. We use Microsoft Power BI to generate all different types of analytic reports. We move information from our data warehouse to a SSAS cube that we've built on top of all our dimensions. We also do a certain level of aggregation in the cube itself, which is then connected to Power BI.

What is most valuable?

It works well with SSAS, which we use to generate all different kinds of trending and analytics reports. Sometimes we use Power Query and DAX to build some aggregations on the Power BI side as well.  

What needs improvement?

I would like to see Microsoft BI add custom visuals and certain machine-learning capabilities. It would be nice if the DAX functions could perform some kind of predictive modeling. Right now, it just does a kind of descriptive analytics.

For how long have I used the solution?

I've been working on Microsoft Power BI for three years. 

What do I think about the stability of the solution?

Throughout several updates over the past three years, I never saw any issues, particularly with installation or anything, so I see the product as stable.

What do I think about the scalability of the solution?

I feel that scalability is one area where there is room for improvement. When there is a huge volume of data, like when we apply the aggregation, the reporting slows down. That's why we mostly build things in the SSAS cube itself instead of bringing it back to Microsoft BI to do the aggregation. Certain incredibly small aggregations can be done on the Microsoft BI side, but if the dashboard size is more than 1 Gigabyte, you start to see some performance issues. 

How are customer service and technical support?

The Power BI community is really big, so we mostly rely on other users for support.

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

In some projects, we have used Tableau or ThoughtSpot. If we're dealing with big data, then we often consider using Tableau. Power BI has some additional features that Tableau doesn't have, like DAX and Power Query, but Tableau works better from a scalability standpoint. Sometimes for reporting purposes, when we want to generate some kind of dashboard on the fly for the user, we have used ThoughtSpot. 

How was the initial setup?

We didn't experience any complications. We built everything on the desktop and in the .pvi files, then just move those files to the server. Afterward, we didn't see any issues at all in terms of setup.

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

I'm unsure about the exact cost, but the Pro license comes out to around $10 per user. There are also additional costs for custom visuals that you can pay for.

What other advice do I have?

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
Microsoft Power BI
April 2024
Learn what your peers think about Microsoft Power BI. Get advice and tips from experienced pros sharing their opinions. Updated: April 2024.
768,857 professionals have used our research since 2012.
Portfolio manager at a transportation company with 5,001-10,000 employees
Real User
Great for visualizing data with good flexibility and an excellent dashboard
Pros and Cons
  • "The visuals are great and make everything look very professional. We can change the look and feel or manipulate the data according to our requirements. It's extremely flexible."
  • "It's quite difficult to learn how to use Power BI."

What is most valuable?

Microsoft Power BI is a very powerful tool. It allows us to extract data from Excel or Share Point. 

We can send various project reports from the dashboard to management. It allows us to set up our own preferences. 

We can work with all sorts of data from the previous year or two. With that native data, we can have everything in one dashboard that accurately reflects the reporting. The visuals are great and make everything look very professional. We can change the look and feel or manipulate the data according to our requirements. It's extremely flexible. 

The solution has been very stable so far.

We find the product to be quite scalable. 

What needs improvement?

It's quite difficult to learn how to use Power BI. I'm not from the IT background, and I've been given the license to use the Power BI, however, I find that the support and video demos from Microsoft are not really helpful for me. I don't handle Microsoft BI 24/7. My working time isn't dedicated to using it and learning it. I need it for certain tasks and trying to wrap my head around it, while also handling other duties is difficult. There's too much of a learning curve for beginners.

The cost of the solution is high.

For how long have I used the solution?

We originally started our migration back at the end of 2019. We've used it for a year or two now.

What do I think about the stability of the solution?

The product is stable. There are no bugs or glitches. It doesn't crash or freeze. It's reliable. 

What do I think about the scalability of the solution?

The solution can scale. If a company needs to expand it, it can do so. It's not a problem. 

Right now, in our organization, only 15 of us have the full license for the Power BI Pro. Not everyone in the office actually uses it. However, we have over 1,000 people using various other Microsoft products in our company.

How was the initial setup?

As I am not technical, I did not handle the initial setup. We have IT personnel within our organization that handled it. I just gave them my laptop, and they just installed it for me. Occasionally, they can also do it remotely from their office to our office. I never touch it. We just open the apps from the desktop. The process, when do that way, i's quite convenient. It's quite easy for end-users.

What about the implementation team?

We have our own IT team that handles the installation. They either take the laptop or do the installation remotely. In either case, it's handled in-house and not by integrators or consultants. 

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

The solution is quite expensive. 

What other advice do I have?

I'm an end-user of the product, however, I'm not overly technical or in IT.

We have a custom Microsoft setup. We are using a few apps from Microsoft, such as the Microsoft Plan, and we are using Power BI, Power Automate, et cetera. It's all from Microsoft, and it is part of our IT infrastructure. When we combine it together, it is a project and portfolio management solution. It is not a commercial, off-the-shelf product. 

I'm not sure which version number we are using. 

I'd rate the solution at a nine out of ten.

In terms of Microsoft Power BI, for all people who need to do their own reporting or want to visualize their daily work or tasks, in terms of projection, giving others a view on what they are doing, it's a very good tool. It allows users to show projections of what we are doing. Users can grab statistics, which is quite convenient, and understand what they are doing from a visual perspective, which we find quite useful.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Global Director - HR Technology & Platforms at a manufacturing company with 10,001+ employees
Real User
Good visualization with an easy initial setup and good overall stability
Pros and Cons
  • "The fact that you can visualize items is great."
  • "The solution could be quicker at rendering data."

What is our primary use case?

We primarily use the solution for building dashboards, one-off analytics, and things of that nature that combine data.

How has it helped my organization?

The functions from a standpoint of generating analytics have been really helpful overall. That aspect has helped improve our organization.

What is most valuable?

In general, we are pretty pleased.

The ability to combine the data and to connect with pretty established platforms has been the solution's most valuable aspect to us. 

The fact that you can visualize items is great. The visualization power is very good.

The initial setup is straightforward.

What needs improvement?

I don't know if I can pinpoint any specific items that I don't like. However, the more connectors that they provide the better. 

I don't use it day in, day out to tell you if it has any kind of functionality items that may be open up for improvement opportunities. 

The solution could probably beef up items related to statistics and things to cover the gap between the advanced things that you can do with Tableau. Any kind of advanced statistical analysis would be very helpful in future releases.  

The solution could be quicker at rendering data.

For how long have I used the solution?

I've been using the solution for three years or so.

What do I think about the stability of the solution?

The solution is very stable. It's reliable. We've been happy with it. There aren't bugs or glitches. It doesn't crash or freeze.

What do I think about the scalability of the solution?

The solution can scale well if you need it to. That shouldn't be a problem for any organization.

I'm not sure how many people are actually using the solution in our organization. Everybody has been kind of encouraged to leverage the platform on an ongoing basis. However, obviously, those that are holding jobs related to any kind of analytics are probably more prone to using it.

How are customer service and technical support?

I don't tend to deal with technical support. That's probably more on the IT team than on my plate and therefore I don't really know how their tech support works. I can't speak to their knowledgeability and response times.

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

With our company, there were probably those that needed to do advanced analytics that were using solutions like Tableau or Excel.

How was the initial setup?

The initial setup is not complex. It's pretty straightforward. A company shouldn't run into any problems when it comes to setting it up.

What other advice do I have?

We have a pretty strong partnership with Microsoft and we tend to help them develop their product as well.

We are using the latest version of the solution at this time.

I would advise other organizations that the product has a lot to offer and therefore it's worth the investment and the effort.

I would rate the solution at a nine out of ten. Sometimes it could be quite at rendering data, however, overall, we've been happy with the results.

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
New Digital Applications Specialist at Alpina Sa
Real User
Top 5
Intuitive design, scales well, and simple setup
Pros and Cons
  • "The most valuable features of Microsoft BI are its intuitiveness and ease to use."
  • "Microsoft BI lacks some of the scheme features. It would be beneficial if there were a way to show how we move values in a different way."

What is our primary use case?

We utilize Microsoft BI for conducting comprehensive analytics by comparing data from the current year with the preceding year to identify patterns and variations. This software aids us in performing overall data analysis.

The solution can be deployed on the cloud and on-premise.

How has it helped my organization?

Microsoft BI has proven beneficial for my organization as it simplifies the presentation of complex data that was previously challenging to comprehend through other means. Specifically, Power BI allows for graphical representation that significantly enhances data understanding compared to raw tables.

What is most valuable?

The most valuable features of Microsoft BI are its intuitiveness and ease to use.

What needs improvement?

Microsoft BI lacks some of the scheme features. It would be beneficial if there were a way to show how we move values in a different way.

For how long have I used the solution?

I have been using Microsoft BI for approximately three years.

What do I think about the stability of the solution?

I rate the stability of Microsoft BI an eight out of ten.

What do I think about the scalability of the solution?

I have plans to use the solution more in the future.

I rate the scalability of Microsoft BI an eight out of ten.

How was the initial setup?

The initial setup of Microsoft BI is simple.

What was our ROI?

We have received a return on investment using Microsoft BI.

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

The price of the license can be better. 

What other advice do I have?

I rate Microsoft BI an eight out of ten.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Cognos Consultant at Surtel technologies
Consultant
A good tool with easy to design dashboards and helpful automation elements
Pros and Cons
  • "There are some great automation elements in the product."
  • "You do need to do some hard coding for certain things in Microsoft BI."

What is our primary use case?

For the most part, clients require dashboards. We are developing quite a few dashboards for them.

How has it helped my organization?

The solution has improved a lot within the organization. We can view chunks of data and detailed data at various levels. 

What is most valuable?

When we have done training in the cloud previously, I have a long experience in BI tools. I've worked on Cognos BI, Informatica, and other tools including QlikView. 

The solution is stable.

The scalability is good.

There are some great automation elements in the product.

It's a good tool and designing dashboards is easy.

What needs improvement?

In SAP, we have a suite of components here in a single module. This includes forecasting and budgeting. There's also a smart answers section. Whenever we design any chart or something, the tool provides some information regarding that data. That would be quite a good feature that could be included in future versions of Microsoft BI.

The licensing could be a bit better.

You do need to do some hard coding for certain things in Microsoft BI.

For how long have I used the solution?

I've used the solution for about one year.

What do I think about the stability of the solution?

The solution is stable. There are no bugs or glitches. I haven't had issues with it crashing or freezing.

What do I think about the scalability of the solution?

The scalability is great. If you need to expand the product, you can do so. You can easily add more users. 

I'm not sure how many users are using the product. 

How are customer service and support?

Technical support is great. I've worked with them before and have been happy with their level of service. 

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

I've previously used Cognos BI. I've also had the opportunity to work with SAP.

How was the initial setup?

I haven't got any opportunity to install any Power BI system. That said, for tutorial purposes, I have installed the desktop version in my system. It was very smooth.

It took 30 to 40 minutes for me to install the desktop version. During my learning phase, I prepared one dashboard. Similar to when I worked on Cognos BI, there were some features that we have to hard code and incorporate manually. There is some automation in Power BI. For example, if we are designing some interactive things we have to write code possibly. Still, even having to write code, in Power BI, was a very smooth experience.

We have people on our team that can handle maintenance tasks. 

What about the implementation team?

We had a team of five to six people that handled the implementation in-house.

What was our ROI?

The client is continuing to use it, likely due to the fact that they see some sort of ROI. However, I don't have exact metrics. 

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

I'd prefer if the licensing was a bit better.

The customers need to pay the licensing fee. I can't speak to the exact pricing for their contract.

Which other solutions did I evaluate?

Typically, the solution architect is the one who decides which tool to use. However, we also were there and had a brainstorming session before choosing the tools. We did look at open-source options. At the time I prepared one checklist comparison between all the tools available in the market. Those included SAP, QlikView, and Tableau.

What other advice do I have?

We are an integrator and a partner. We are providing support activities to one of our clients.

I would rate the solution at 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
Senior Product Manager Data Science at a insurance company with 1,001-5,000 employees
Real User
Powerful, low-maintenance, and useful for bringing visualization to data
Pros and Cons
  • "It is useful for bringing visualization to data. It calculates counts, ratios, etc."
  • "There could be an integrated AI that can automatically analyze some of your data and highlight or provide suggestions. For example, when you are looking at a data set, it can suggest putting it into a certain type of chart so that you gain different insights or a trend line. You would almost have templates that it would recommend for you."

What is our primary use case?

We use it for data visualization.

What is most valuable?

It is useful for bringing visualization to data. It calculates counts, ratios, etc.

What needs improvement?

There could be an integrated AI that can automatically analyze some of your data and highlight or provide suggestions. For example, when you are looking at a data set, it can suggest putting it into a certain type of chart so that you gain different insights or a trend line. You would almost have templates that it would recommend for you.

What do I think about the stability of the solution?

It is absolutely stable.

What do I think about the scalability of the solution?

It is absolutely scalable. You can scale it a lot.

How was the initial setup?

It has been straightforward and easy. 

In terms of maintenance, for the most part, it is fairly low-maintenance. Once you have it set, it is fire-and-forget. The users want to see the view and the information, and there is nothing more to do other than just let it be.

What other advice do I have?

I would give it an eight out of 10. It is a pretty powerful tool.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Head-IT/SAP at Barista Coffee Company Ltd.
Real User
Beneficial report generation, effective report management, and scalable
Pros and Cons
  • "The solution overall is very useful. The reports that are generated and the reporting functionality management are beneficial."
  • "We have used other solutions and the reporting functionality should be user-friendly and have a drag and drop feature should be available, but Microsoft BI doesn't have these features. When you are creating reports and you can't change as a user. Every time you need one developer or one technical person to make the changes."

What is our primary use case?

We are using Microsoft BI to generate point of sale reports.

What is most valuable?

The solution overall is very useful. The reports that are generated and the reporting functionality management are beneficial.

What needs improvement?

We have used other solutions and the reporting functionality should be user-friendly and have a drag and drop feature should be available, but Microsoft BI doesn't have these features. When you are creating reports and you can't change as a user. Every time you need one developer or one technical person to make the changes.

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?

Microsoft BI is highly stable.

The performance depends on the requirement. You have to complete your requirement which is a priority. After that, you understand your requirement and the performance could be better. The performance is the second.

What do I think about the scalability of the solution?

I have found Microsoft BI to be scalable.

How was the initial setup?

The installation difficulty depends on the integration, once integrated properly you can receive results. Microsoft BI can be very helpful to your business.

The implementation took us 15 to 20 days.

What about the implementation team?

We use two Microsoft consultants to do the implementation of the solution.

Which other solutions did I evaluate?

I have evaluated other solutions.

What other advice do I have?

I rate Microsoft BI a five out of ten.

If I compare Microsoft BI with other solutions, other solutions are much better, but because we have already invested in Microsoft BI. We are using this and maybe in one or two years, we will use something else. We will finalize the testing of other solutions and implement one of them.

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