Try our new research platform with insights from 80,000+ expert users
Solutions Architect at a tech services company with 11-50 employees
Real User
Easy to learn with good data preparation features and good stability
Pros and Cons
  • "As it was my first time using Power BI, I can say that it was fairly easy to learn, especially if you already know BI-type tools."
  • "The one thing that I noticed specifically was the graphical features, and some of the analytical features. They were stronger on the Tableau side."

What is our primary use case?

There were two systems that the client was looking at creating some BI visualizations for. There was the system called ICE, which is a system that takes in automated calls, for service calls. They go into voicemail, however, if there's not an agent to take the call, it'll track statistics like how long a client was on hold, if an agent actually took the call, if the person hung up, et cetera. There are all of these different statuses and it would take all of those statistics. The product was used primarily to take that data in that case.

The other system was an ITSM system, which was the ticketing system. It would

it was my first time using Power BI, I can say that it was fairly easy to learn, especially if you already know BI-type tools. But the one thing that I noticed specifically was the graphical features, and some of the analytical features, I think they were stronger on the Tableau side. But the data preparation features, I much preferred the Power BI with the Power Query type features, at least for the datasets that we were working with. They were helpful in preparing the data.

 combine those two data sets and reduce a merged analytical set of reports to just show when the call volumes were and what the performance rate was and the nature of the calls and things like that.

What is most valuable?

As it was my first time using Power BI, I can say that it was fairly easy to learn, especially if you already know BI-type tools. 

The data preparation features were great. I much preferred the Power BI with the Power Query type features - at least for the datasets that we were working with. They were helpful in preparing the data.

What needs improvement?

The one thing that I noticed specifically was the graphical features, and some of the analytical features. They were stronger on the Tableau side.

There are two areas where the solution can be enhanced. One is natural language, where you can have third parties, however, it would be nice to have it built-in within Power BI, where a graph could be automatically explained in whatever language so that somebody can just kind of read through and have the graphic as an extra for exploring. That's something that I was looking at.

The other is the explained data, which is more of a lineage-type feature. My understanding is Tableau has that feature and Power BI doesn't. I was looking at a graph of comparisons and I noticed Tableau had this explained data feature, which gives, some lineage where data has come from, and Power BI doesn't have that. Or, if it does, it's not as well developed as Tableau.

For how long have I used the solution?

I used the solution a few months ago. I'm semi-retired, however, I did have a two-month contract and did some work with it. On the project, I did work a lot with Tableau, however, I also used Power BI, and would like to continue to use it more. 

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 stability of the solution?

It was a short project on the Power BI side. I didn't really identify any glitches. Certainly, over time things might've come out, however, I enjoy doing experimenting and playing around with things. The one definite thing that I noticed, as I do art with Tableau, is some really neat art stuff, so I tried to replicate that with Power BI and the quality just wasn't there.

What do I think about the scalability of the solution?

With ITSM, there's a lot of data that they collect on that side. That could be an issue, scalability. It wasn't moved to production yet. I basically produced a report as there were some issues with the ICE data, the voicemail system, and data collection. They had some issues that they had to solve. However, they were collecting data on a daily basis. You get thousands and thousands of calls on a daily basis. It depends on how they want to store that data historically. There may be some performance issues and scalability issues, however, for me, I can't really address that, as I didn't see that side. There's always a potential for trouble.

How are customer service and support?

It was a really short project for me. I was really there just to analyze those two data sources and produce a report for them, with some examples, using Power BI. I was able to do that without getting tech support involved.

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

I've used other solutions, such as Tableau and Power Query. Tableau from a graphical point of view is much better than Power BI, however, from a data manipulation standpoint and things like that, I prefer Power BI and Power Query to prep the data.

Tableau got bought out by Salesforce, which is a cloud-based company, so they're all going to push everything to the cloud. I'm sure they'll incorporate all these new features.

How was the initial setup?

I downloaded the solution from their website. 

The server side was already set up, therefore, I don't know much about the initial setup process. As a contractor, I came in just on the development side, which was just downloading the Power BI tool as a client. It was fairly easy. That's the nice thing is it's easy to set up. It is similar to Tableau, in that Tableau is fairly easy to set up. It is all built towards this whole idea of self-service.

What other advice do I have?

I'm just a customer.

As I downloaded the solution right off the website, I assume it was the latest version. I don't know the version number off-hand. 

I would do the development on-pre

There were two systems that they were looking at creating some BI visualizations for. So there was the system called ICE, which is a system that takes in automated calls, for service calls. And so goes into voicemail, but if there's not an agent to take the call, it'll track statistics like how long you were on hold, if an agent actually took your call, if you hung up. All of these different statuses would take all of those statistics. And so it was to take that data.

And the other system was the ITSM system, which is the ticketing system. And kind of combine those two data sets and reduce a merged analytical set of reports to just show when were the call volumes were, and what was the performance rate, and the nature of the calls and things like that.

It's easy to set up, however, regarding scalability and high-end analytical features, Tableau is still better on that. It's always important to keep up, as technology's changing all the time. They're always adding new features. There are no negatives in exploring these tools. In the end, you just want some visualizations that help you make decisions. Both Tableau and Power BI tools are great for that. However, if you want advanced stuff, then it's just about experimenting and seeing what will help you solve your problems.

I'd rate the solution at an eight out of ten.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
reviewer1381863 - PeerSpot reviewer
CEO at a tech services company with 201-500 employees
Consultant
Highly scalable, very stable, good data presentation, and useful for deeper insights and analysis
Pros and Cons
  • "The way data is presented is very valuable. The amount of information that we can get at a glance is also valuable. You can then drill-down and see data from many different angles in the same chart by selecting certain things. Based on the selection, everything changes automatically. If we have four parameters in a particular item, when you select a parameter, the remaining charts on that page automatically change for that particular parameter."
  • "Its price could be better. Its licensing cost is very high."

What is our primary use case?

We are using Power BI Premium at the moment. It is an online solution, which always has the latest version.

It is for data visualization and data insights. BI means business intelligence, so it helps you understand the performance of your business better. It gives you deeper insight into the data so that you can draw meaningful conclusions from the data, and your decisions are based on data insights rather than a hunch. 

How has it helped my organization?

It is a good and very useful product. I find it to be extremely useful because it gives me a deeper insight into my business, and it lets me analyze things and make decisions based on the data.

What is most valuable?

The way data is presented is very valuable. The amount of information that we can get at a glance is also valuable. You can then drill-down and see data from many different angles in the same chart by selecting certain things. Based on the selection, everything changes automatically. If we have four parameters in a particular item, when you select a parameter, the remaining charts on that page automatically change for that particular parameter.

What needs improvement?

Its price could be better. Its licensing cost is very high.

For how long have I used the solution?

We discovered it about two months ago, and we started using it.

What do I think about the stability of the solution?

It is very stable.

What do I think about the scalability of the solution?

You can scale it to thousands of users. It is a cloud product. Microsoft Cloud is being used by people across the world. So, there is no limitation in terms of scalability.

At the moment, we have about five users, but the number of users will increase to 50. We are absolutely going to keep using it.

How are customer service and technical support?

We generally don't approach Microsoft for support. We are able to handle things at our end.

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

We used simple Excel reports, but Excel reports are not as good as Power BI. Power BI is far ahead.

How was the initial setup?

It is a cloud product. You can access it through a web browser. It takes no time. 

It takes time only when you have to prepare the reports because you need to know how to prepare the Power BI reports. There is an MIS team, and there are Power BI designers who design the reports, but for users, it doesn't take much effort because they just have to click and see.

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

Its licensing cost is very high. It is $20 per user, which is very high, but it is a good product, so you pay for it.

What other advice do I have?

I would recommend this solution. I would rate Microsoft BI a nine out of ten.

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
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.
Managing Director at IDMdev Tech Solutions®
Real User
It is stable and provides a quick view of the most important indicators, but its setup and support should be better
Pros and Cons
  • "The use of graphics to show and view the data indicators is the most valuable feature. It is also very stable."
  • "Its setup and support should be improved. We would like to see more material for developers that provides clear explanations about how we can do data mining by using Microsoft BI. It would also be good if we can connect a feature to other customized machine learning solutions."

What is our primary use case?

We have integrated this solution into the software that we created for a client specifically for reports and data consumption. It is a hybrid infrastructure project with hybrid integration. It has a lot of reports executed or created from the cloud.

How has it helped my organization?

It has helped us to have a really quick view of the most important indicators of the operational issues of our platform. It has enabled collaboration between different operational levels in the company.

What is most valuable?

The use of graphics to show and view the data indicators is the most valuable feature. It is also very stable.

What needs improvement?

Its setup and support should be improved. We would like to see more material for developers that provides clear explanations about how we can do data mining by using Microsoft BI. It would also be good if we can connect a feature to other customized machine learning solutions.

What do I think about the stability of the solution?

It has good stability.

What do I think about the scalability of the solution?

We haven't used it a lot, but it seems good so far. We have only three users. We may include two or three more users to the platform.

How are customer service and technical support?

Their technical support is bad. I didn't like the technical support of Microsoft.

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

We also use Oracle and Tableau.

How was the initial setup?

The initial setup was not complex, but we would like a more agile process. The initial deployment took about two months. The platform that we created was very robust.

What about the implementation team?

We are a reseller of the solution. We did the deployment.

Which other solutions did I evaluate?

We were thinking of integrating Tableau instead of Microsoft BI, but the client chose Microsoft BI.

What other advice do I have?

I would rate Microsoft BI a seven out of ten.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Senior Programmer Analyst with 1,001-5,000 employees
Real User
Data abstracting and good reporting features are keys for us
Pros and Cons
  • "It's user-friendly and provides data abstracting capabilities. We are also able to share reports with our colleagues very easily."
  • "The DAX features need some improvement. It's not as easy as Excel. They need more DAX formulas."

What is our primary use case?

Our primary use case is for data prediction. We use our predictive model index, and then express the data to Power BI.

What is most valuable?

It's user-friendly and provides data abstracting capabilities. We are also able to share reports with our colleagues very easily.

What needs improvement?

The DAX features need some improvement. It's not as easy as Excel. They need more DAX formulas.

What do I think about the stability of the solution?

The stability is good.

How was the initial setup?

The setup was straightforward.

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

The most important criterion for me, when selecting a vendor, is that the product is cost-effective.

What other advice do I have?

It depends on how you're going to use the reports, but when looking into this product or similar solutions, check the security side of things. If you don't want to share information with everyone, how does it deal with that?

So far, it's one of the best reporting tools I've found. They are improving the product every month. I would rate it at eight out of 10. The two missing points are to see what comes out in the future.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user866316 - PeerSpot reviewer
Director, Education Management Information Systems with 51-200 employees
Real User
Ease of integration with various data sources and the dashboards are key for us
Pros and Cons
  • "Key features are its dashboard functionality and ease of integration with various data sources."
  • "It is definitely a wonderful analytics tool. However, database ETL, data integration functionality would be absolutely perfect in many cases. Currently, it doesn't get the job done and we need to extract, transform, and load the data from faulty data sets into something more suitable for the deployment of the analytics tool."

What is our primary use case?

We use it primarily to create visualizations, along with very light analytics of education performance data.

How has it helped my organization?

We cannot truly speak to improvements yet, as we are just exploring it. Potentially, it can provide instant access to a very current state of affairs for school performance.

What is most valuable?

  • Dashboard functionality
  • Ease of integration with various data sources

What needs improvement?

It is definitely a wonderful analytics tool. However, database ETL, data integration functionality would be absolutely perfect in many cases. Currently, it doesn't get the job done and we need to extract, transform, and load the data from faulty data sets into something more suitable for the deployment of the analytics tool.

What do I think about the stability of the solution?

No issues with the stability.

What do I think about the scalability of the solution?

I can't speak about the scalability, but I can speak more towards the interoperability. There is a very rich capacity for sharing its functionality.

How was the initial setup?

It is a very simple application so there was no real setup. Just download it.

What other advice do I have?

My most important criteria when selecting a vendor are

  • cost
  • sustainability.

I would rate it at eight out of 10 because of its ease of use, simple setup, and excellent integration. I would rate it a 10 if they provided free training.

It's a wonderful application, it meets our needs.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user654243 - PeerSpot reviewer
Business Intelligence Developer at a financial services firm with 5,001-10,000 employees
Real User
Self-service allows end-users to source information, but email-based subscription is needed

How has it helped my organization?

It cuts away the time spent to source some of this information. It saves a lot of time, and a lot of things have been automated. Things that used to take close to a week, now, in one day, we are done with it.

What is most valuable?

It's actually the self-service of Power BI, because we're on a lean structure here, the technical side. So we wanted them to push some of those things back to end-users.

What needs improvement?

For our reporting services, it would be good to have the capability for email-based subscriptions. I want to be able to change the sender dynamically, without having to rely on running through an exercise passage.

I know for a fact that SAP can do this, dynamic sending for subscriptions. Also IBM Cognos can do it. Why Microsoft refused to do that, that you have to rely on add-on to be able to do that...

Overall, it has performed to our expectation. It's okay for what we want to use it for. But because they keep changing, every now and then, there's a major shift in versions, so we are trying to catch up.

What do I think about the stability of the solution?

I've used the IBM suite, and I've used SAP, and Microsoft is fairly stable for me. And because there is a large community for issues that arise, for every bug that you encounter, you have a solution, just Google it, without having to go for special training like with SAS.

What do I think about the scalability of the solution?

From what I understand, it requires some level of expertise to even understand what it can do, how it can be used in a huge enterprise. That is not so easy for deployment. But for a medium sized organization, yes, it's scalable.

How was the initial setup?

It was straightforward. Very straightforward.

You can just go to YouTube, somebody has done it before. Because it has GUI, just click, click, click, next, next, and you're done. And YouTube helped a lot in deploying projects: SSAS Projects, SSIS projects, and SSRS projects.

Which other solutions did I evaluate?

IBM Analytics. But the learning curve for IBM, that's what actually led us to pause on the implementation of the Cognos 10. Everything was pretty much difficult to do. Things that you could do in two clicks in Microsoft, you would be doing in five, ten clicks in IBM.

What other advice do I have?

When selecting a vendor, the most important criteria are affordability - because of the exchange in my country - and ease of use. 

I would rate this solution a seven out of 10, because you can actually go from the common tools that you use, from your Excel, from your SharePoint... You can pretty much do everything with it. The little things that you can't do, you can customize it to do by writing code.

I would say that, you should look away from the limitations. Focus on the positives of it, because it's cheaper to acquire than most of the big five. It's cheaper to acquire and easy to use.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user7845 - PeerSpot reviewer
Consultant at a tech consulting company with 501-1,000 employees
Consultant
My 30 tips for building a Microsoft BI solution, Part I: Tips 1-5

Having worked with Microsoft BI for more than a decade now here are the top 30 things I wished I knew before starting development of a solution. These are not general BI project recommendations such as “listen to the business” or “build incrementally” but specific lessons I have learned (more often than not the hard way) designing and implementing Microsoft based Business Intelligence solutions. So here are the first five:

#1: Have at least one SharePoint expert on the team.

The vast majority of front-end BI tools from Microsoft are integrated with SharePoint. In fact, some of them only exist in SharePoint (for instance PerformancePoint). This means that if you want to deliver Business Intelligence with a Microsoft solution, you will probably deliver a lot of it through SharePoint. And make no mistake: SharePoint is very complex. You have farms, site collections, lists, services, applications, security… the list goes on and on. To make matters worse you may have to integrate your solution with an already existing SharePoint portal. There is a reason there are professional SharePoint consultants around, so use them.

#2: Do not get too excited about Visio integration with Analysis Services.

Yes, you can query and visualize Analysis Services data in Visio. You may have seen the supply chain demo from Microsoft which looks really flashy. You might think about a hundred cool visualizations you could do. Before you spend any time on this or start designing your solution to utilize it, try out the feature. While its a great feature, it requires a lot of work to implement (at least for anything more than trivial). Also, it (currently) only supports some quite specific reporting scenarios (think decomposition trees).

#3: Carefully consider when to use Reporting Services.

Reporting Services is a great report authoring environment. It allows you to design and publish pixel perfect reports with lots of interactivity. It also provides valuable services such as caching, subscriptions and alerts. This comes at a cost though. The effort needed to create SSRS reports is quite high and needs a specialized skill set. This is no end user tool. There are also issues with certain data providers (especially Analysis Services). But if you need any combination of multiple report formats , high scalability (caching, scale-out), subscriptions or alerts, you should seriously consider Reporting Services.

#4: Use Nvarchar / unicode strings throughout the solution.

Unless you live in the US (and are pretty damn sure you will never have “international data”) use unicode. Granted, varchars are more efficient but you do not want to deal with collations / codepages. Ever. Remember this is not only an issue with the database engine but also with other services such as Integration Services.

#5: Check if it exists on codeplex.

Do not build anything before you have checked codeplex. Chances are someone has already done the same or something similar that can be tweaked. If you are skeptical of including “foreign” code in your solution (like me) use the codeplex code as a cheat-sheet and build your own based on it. There is a lot stuff there including SSAS stored procedures, SSIS components and frameworks and much more.

Disclosure: The company I work for is a Microsoft Partner
[Syndicated from www.peterkollerbi.wordpress.com]

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user4014 - PeerSpot reviewer
it_user4014Developer at a tech consulting company with 51-200 employees
Consultant

Hi Peter !

Let’s talk about the difficulties you have faced during your BI career;

#1: I do agree with you partially, that having a dedicated Share Point resource would be handy because you might be going to run into performance or security issues somewhere along the project, but my idea is to have a Single Share Point resource which can be share between multiple BI projects. Because from my experience what i have seen is, it’s not that much hard to configure the Performance Point Services, Power View & Reporting Services on Share Point. With some help BI consultant can do this on his own, and as a BI consultant one should take the ownership of the project and try to resolve issues on his own. This will give them more of a learning curve and hands on other front end tools. You can't always rely on someone else to fix the issues for you.

#2: I haven't yet to see any BI Consulting firm delivering their solutions through Microsoft Visio integration with SSAS. All I could say is Microsoft has done investment in lot of tools to see which tool become a real contender for replacing all other BI stack, or get most popular response from the market. This is more of a market strategy to see which product / tool gets more response.

#3: SSRS has been the greatest thing Microsoft has delivered for Reporting apart from PPS lately. I still feel there is still lot of areas where SSRS need to be improved, like SSRS don't have alters, or its very restricted when it comes to dynamic dashboard or interactive reporting. If you have seen PPS, as a BI Consultant i want to show my client how much interactive my BI Solution is. Still there are areas like you mentioned Subscription & caching are great from SSRS. Additionally SSRS is designed to keep in mind that developers will be using it for building reports. For End User Microsoft Excel is best they can have where they can slice & dice and with Power Pivot included there is a lot End User can do with SSAS Cube.

#4: Use navarchar / varchar will always be a debate between developers. It's more of a choice thing. But if you are developing a BI Solution which is going to be used across multiple regions, consider using nvarchar but keep in mind the overhead of extra storage that you will be paying as a developer.

#5: CodePlex is a great community, but most of the clients want things to be customized and be their own proprietary. This is what we are paid for as a BI Consultant to provide them solution which fulfills organization needs and you might agree every management has different needs. But still good idea to look on CodePlex and peer sites for reference.

When choosing between tools, there is no single tool which can meet all of your customer requirements, so keep in mind that you might be using some tool which you have rejected in your initial analysis, and believe me this will save you big time facing problem against clients, because one you communicate that we won't be using this tool, and then you go back and say now we are providing this particular report using the tool which you have discarded in your earlier review.

So my point is as a BI Consultant, one needs to be flexible, adaptive & responsive to be a successful BI Consultant.

Regards,
Hasham Niaz

Ariel Lindenfeld - PeerSpot reviewer
Director of Product Management at PeerSpot
Real User
The Gartner Magic Quadrant for Business Intelligence says that Microsoft BI's overall costs are consistent with other Megavendors. Do you agree?

The Gartner Magic Quadrant for Business Intelligence says that most companies chose Microsoft BI because of low license cost and overall low cost of ownership. However, while the total ownership costs is low for a per user basis, because of implementation and ongoing development costs it is consistent with other large vendors.

Are you a Real User of Microsoft BI? Have you found this to be the case in your organization?

If you are a user or are evaluating Microsoft BI, add your comment below or write your own review. Share your opinion with our community!

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user1068 - PeerSpot reviewer
it_user1068Tech Support Staff at a tech company with 51-200 employees
Real User

I do agree with the Gartner Magic Quadrant for BI. Although the licensing costs might be low and Microsoft products can come with incentives depending on the client in question, it is important to consider the general costs that span long term use of the product. I also agree with Robert Goodman on the high availability of people resources when it comes to Microsoft BI products. Microsoft is a big brand worldwide with its training resources available not just online but also in many schools across the globe, hence finding a person knowledgeable in Microsoft BI is much easier than any other brands in the market. Back to Gartner; although Microsoft has certain cost aspects of their BI products down, the costs incurred during implementation stages and continuously as the product is used definitely raises the initial costs and thus making the cost of Microsoft BI products consistent with that of BI tools from other brands.

See all 3 comments
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.