We primarily use Power BI for data science solutions.
BI Consultant at a manufacturing company with 1,001-5,000 employees
Easy to use, good inquiry and visual gallery features, and the community is strong
Pros and Cons
- "This is a self-service BI tool, so it doesn't require a huge amount of technical training, knowledge, or a background in BI in order to induct new people into it."
- "A lot of people work on Excel, so being able to export an Excel file as part of a subscription would be an improvement."
What is our primary use case?
How has it helped my organization?
This is a self-service BI tool, so it doesn't require a huge amount of technical training, knowledge, or a background in BI in order to induct new people into it. This is true even for business people who want to do a little bit of self-service. The whole thing has become quite simplified, as compared to what it was.
What is most valuable?
There are many good features in this product.
The most valuable features are a combination of the DAX and the inquiry capability, plus the visual gallery that we have. I think that these three things, or the combination of them, is the best that we have found.
What needs improvement?
I would like to have the capability to schedule exports in different versions. For example, if I want to schedule a subscription and attach an Excel file, we don't have this capability right now. A lot of people work on Excel, so being able to export an Excel file as part of a subscription would be an improvement.
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.
For how long have I used the solution?
We have been working with Power BI for more than five years.
What do I think about the stability of the solution?
Overall, it is pretty stable. The cloud version is definitely very stable, and I have found very few flaws or areas for improvement. We have been using it for more than five years and we have every intention to continue with it.
What do I think about the scalability of the solution?
It has been pretty nice for us, in terms of scalability. There hasn't really been a problem, as such. We have approximately 300 users.
How are customer service and support?
Technical support from Microsoft gets a big thumbs up from me. They have blogs, a support page, and the community is very active. Most of the answers we need, we find them there.
With this amount of information available, we don't need to use technical support extensively. When we do post something on the blog or in the community, the response that we get is pretty prompt.
The last time we utilized technical support was when we were investigating creating a subscription with an Excel file attached to it. We found out that it isn't yet possible with the current version.
How was the initial setup?
The initial setup is straightforward, to say that least. It took just a few days to deploy.
What's my experience with pricing, setup cost, and licensing?
The pricing is very reasonable compared to any other tool.
What other advice do I have?
My advice for anybody who is considering this tool is that if you want to move to a self-service BI, this is probably the best tool available right now. The self-service is pretty good in terms of os user acceptance, usage, and simplicity. It is something that everybody wants and Power BI does really well in that area.
The biggest lesson that I have learned from using Power BI is that if the data is not according to what you want, that really isn't a problem. It has been a problem in the past, especially where the data is not in the form or the shape that you need, but with Power BI, that problem can be solved very easily.
I would rate this solution an eight out of ten.
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: I am a real user, and this review is based on my own experience and opinions.
BI Expert with 1,001-5,000 employees
Each solution has its pros and cons which are largely dependent on the target organisation’s existing software, infrastructure and skill set
Last year ServiceNow released ODBC access to their database, enabling customers to produce their own high quality reporting.
As direct reporting from ServiceNow is in increasing demand, I thought I’d put together a brief overview of the more popular choices of Reporting Software on the market.
Of course, if anyone has experience of any others, or wants to add to (or contradict!) my views, please feel free to post.
MS SQL Reporting Services (SSRS)
MS SQL Reporting Services is part of the MS BID package of Business Intelligence software but is a capable piece of reporting software in its own right which produces professional results.
But its main selling point is that it is not sold! If you already have MS SQL Server, it is free. This is fantastic news for software of this calibre. And because SSRS belongs to a suite of programs within SQL Server, there is no extra cost to schedule reports to run at set times automatically.
Report development in SSRS is quite SQL heavy, which is great for DBAs and programmers, not so much for people used to Excel as a reporting tool.
Of course, the flip side of it being free if you already have MS SQL Server is that it is expensive to buy a database just to get the free reporting software.
Because SSRS is intended for use with a suite of other software, it can struggle to do some of the more complex things that other programs in this list can as it is not a full solution in its own right. This can lead to a ‘bitty’ architectural solution with functionality being spread out without any apparent order.
SSRS is primarily designed for use with MS SQL Server. As a result, pointing it at over databases can be trickier than the other software in this list (who were created independently of any particular database).
Hiring SSRS expertise can be difficult as consultants tend to be DBAs, rather than SSRS specialists and are in high demand.
Business Objects
‘Business Objects’ tends to refer to an actual suite of software which together form an impressive toolset for data manipulation and display. The Business Objects component itself is focused on taking the tables from a database and transforming them into a structure ideal for reporting: called a Universe.
With the latest version of Business Objects there is a choice of Web Intelligence (WebI) and Crystal Reports for Enterprise to actually cut and display the data gathered in the Universe.
(Older versions of BO have Desktop Intelligence, but I strongly recommend avoiding this option, it is not future proof and produces reports that just look dated.)
Crystal Reports is covered as a separate solution later, but viewed purely as a means to report on a Universe, it is a match for WebI and arguably better in some respects. But Business Objects and WebI have been used together for longer and most BO developers are also WebI developers, whereas Crystal Reports is often a separate skill set.
Most of the shortcomings in WebI functionality is covered by the work already done when developing the Universe.
One of the best things about a Universe is that all the statistics you want to create can be done in one place and then included in reports as needed. There is no duplication of effort that tends to occur in standalone reporting and a standardisation of reporting metrics is enforced automatically.
Scheduling reports is not a problem, as the scheduling software is included within the standard Business Objects suite of products.
However, this standardisation can also be a hindrance. Professional level ITIL reporting often requires a very flexible approach to data interrogation to cover certain measures. Often some measurements are at logical odds with other measures based on the same data. This is where Business Objects can get mired down trying to accommodate all requirements in one place.
Even with free software (and Business Objects is far from free!) implementing an ITIL reporting solution costs money. Expertise usually has to be hired in, time and money is spent on requirements gathering, hardware and so on. Setting up a Business Objects Universe and then a complementary suite of reports can take weeks or even months.
This can be too long a wait for a business eager to give their managers the information they need to work at full capacity. This is a shame, as the table structure of the ServiceNow database is so well thought out there is almost no need for a Universe anyway beyond the aforementioned efficiency of effort.
Crystal Reports
Crystal Reports can report from virtually any data source including of course, the ServiceNow ODBC, is quick to develop with and can produce a wide variety of reporting styles.
Crystal’s inbuilt scripting language allows a huge amount of control though can take some time to learn for those new to programming.
Crystal Reports is hugely popular and used across all business sectors and is versatile enough to do just about any job. This versatility can also be a problem and without proper work practices in place a suite of Crystal Reports can become an unmaintainable mess.
The main negative thing for Crystal Reports is that it requires a separate piece of scheduling software to automate reporting. Whichever scheduling software is chosen, be sure to thoroughly test it within your business before deployment, especially the security if you intend distributing reports outside your own intranet.
The charting can also be a bit limiting and is starting to look a little dated now, but still crisp and clear.
Another possible minus for Crystal Reports is that if you do not have the skills in-house already, it can be tricky to hire an effective consultant. Unlike SSRS and Business Objects developers, who tend to come from a DBA or programmer background, a large percent of Crystal Reports consultants started in office admin jobs and tend not to have the technical experience needed to solve the more difficult questions.
Xcelsius / Crystal Visualation / SAP Dashboards
This product of many names was originally developed as an add-on to MS Excel and still uses Excel for much of its underlying functionality.
The result is reporting software with a shallow learning curve which produces gorgeous, interactive looking Dashboards that can be easily exported and distributed online.
Of course, there is a downside, or two.
The main one is that plugging Xcelsius directly into databases is a pain. It does not have that underpinning ODBC foundation like the other products in this list and data must either be piped in via another product entirely or through a third party component that plugs straight into Xcelsius.
The good news on this front is any company using ServiceNow probably has some good Java developers at their disposal that can develop Web services to connect Xcelsius to the database.
On a final note, anyone using Business Objects and/or Crystal Reports should add Xcelsius to their arsenal. It integrates well will both software and is definitely worth the effort in this case, both for dashboard designs and more flexible/nicer looking charting in standard reports.
JasperReports
This software is not really in the same league as the above products in many respects and may look like the odd one out.
But it does have a number of strong benefits in its favour:
1. Very capable software and produces professional results to challenge any other product in this list.
2. It is free.
3. Very, very similar to Crystal Reports, so similar that a Crystal Reports expert can quickly get to grips with JasperReports.
4. Java based and can be distributed through your organisation with relative ease.
JasperReports is definitely worth a look for any serious ServiceNow reporting implementation.
Summary
All of the above software has its own pros and cons which are largely dependent on the target organisation’s existing software, infrastructure and skill set. With this in mind, I cannot recommend a specific piece of software, but am happy to answer any questions I can.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
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.
BI Analyst at Infosys Technology
Has valuable reporting and printing features
Pros and Cons
- "I find Power BI's reporting feature the most valuable. The solution has improved a lot. There are new features getting added day by day. In the past, they didn't even have the printing feature, but now they have it."
- "If you look at the new tool, even though they promised that you could do data modeling, that you could do everything from the Power BI side, if your data is really large in volume, sometimes it doesn't work on the Power BI. More feature testing from their side would certainly help users."
What is our primary use case?
I use this for its analysis service.
What is most valuable?
I find Power BI's reporting feature the most valuable. The solution has improved a lot. There are new features getting added day by day. In the past, they didn't even have the printing feature, but now they have it.
What needs improvement?
Every tool has room for improvement. Microsoft also has a lot of room for improvement. If you look at the new tool, even though they promised that you could do data modeling, that you could do everything from the Power BI side, if your data is really large in volume, sometimes it doesn't work on the Power BI. More feature testing from their side would certainly help users.
For how long have I used the solution?
I've used this for eight years. I've used this solution within the last 12 months.
What do I think about the stability of the solution?
This solution is stable. It's a nice solution to have.
What do I think about the scalability of the solution?
This solution is very much scalable.
How are customer service and support?
Technical support is good. It's not really very helpful sometimes, but it is good.
Which solution did I use previously and why did I switch?
We previously used a different solution for a different location, a different customer. If a customer decides to go for one vendor, they stick to that vendor, so changing a vendor is not an option most of the time.
How was the initial setup?
Initial setup is straightforward, but it depends on the business case. It's straightforward, but sometimes it is complex, but compared to any other tool, the setup for this solution is straightforward.
What about the implementation team?
My experience with them is okay.
Which other solutions did I evaluate?
I wasn't able to evaluate other options before choosing because it was already chosen by the customer.
What other advice do I have?
Deployment for this solution in our organization is mixed: on-premise and through Microsoft cloud.
If you have a source on the Microsoft side then it's always easier to use one vendor for end-to-end solution. Even if there are some other sources, Microsoft has a big and varied area. Take the reporting ETL analysis as an example, everything's built as part Microsoft. It's always good to have one vendor than multiple vendors.
How long deployment of this solution takes all depends on how much data you have. Sometimes it takes a long time if you have a billion rows of data e.g. it could take hours. It also depends on the architecture. It depends on so many things.
There are a hundred users of this solution in our organization. The real users are customers who require reporting to make business decisions. Mostly the users are business analysts.
This solution is pretty much automated, so no maintenance. For AD, some are there as a team, so they help.
No plans of increasing usage of this solution. Maybe in the future, but not right now.
My advice to other people looking into implementing Power BI is to go for it. It's one tool that has everything, and they should always try to evaluate Microsoft compared to open source. Like in open source, you'll always have a lot of libraries, a lot of different tools that you would be using. It's great to try Microsoft Suite because at the end, you'll only have to deal with one vendor so maintenance will be less.
The lesson that I have learned from using Power BI is to try it out. Don't just rely on the features and promises about the solution. You first try it out, then share your experiences with the customer.
My rating for this solution would be seven or eight out of ten because it has everything in it and I don't see anything missing in it. It is efficient for our needs.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Managing Director at Innovative Business Analytics
Reasonably priced, with excellent virtualization
Pros and Cons
- "The virtualization of Microsoft BI is very good."
- "The DAX in Microsoft BI is quite difficult."
What is our primary use case?
I am surveying and researching this solution, in order to provide it to my customer.
Microsoft BI is used to create a dashboard or reports in the customer's environment.
I implement Power BI on desktops for my customers to use for sales and financial analysis. The customer must purchase Power BI Pro from their company, and then they can use it.
What is most valuable?
The virtualization of Microsoft BI is very good.
What needs improvement?
The DAX in Microsoft BI is quite difficult.
The DAX is where the soft data is accessed. The DAX command is used for coding.
I would like to see the DAX simplified, and the number of pages in Microsoft BI should not be limited to one. You should be able to scroll endlessly left, right, up, and down. Typically, Power BI has a page. On this page, the limit could be eight or ten objects that fill the entire page, and you must proceed to the next page. If possible, I'd like Power BI to do the scroll up, scroll down, with unlimited scrolling on one page.
For how long have I used the solution?
I have been working with Microsoft BI for a few months.
What's my experience with pricing, setup cost, and licensing?
The price is good. They have a free Power BI Desktop version, but it has limitations.
They also offer Power BI Pro at a reasonable price. Power BI Pro is appropriate for large enterprises with at least 500 users. The price may be very expensive per month.
The pro version is not suitable for the majority of my customers, who have five or ten users.
What other advice do I have?
If you are a single person using this solution, I would recommend using the desktop version. Power Pro can be used for multiple users ranging from 20 to 50, eliminating the need to invest in Power BI Premium.
Maybe, in the long run, I can be a Microsoft partner, but first I need a large number of customers.
I would 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.
Lead Data Engineer at Sensilab
A powerful and easy-to-use platform with a lot of connectors
Pros and Cons
- "The most valuable feature would be the abundance of connectors. It is also easy to use."
- "It is easy enough. I don't see any real substantial improvements that are needed. It is great as it is, but its interface could be a bit modern."
What is most valuable?
The most valuable feature would be the abundance of connectors. It is also easy to use.
It is a very powerful platform for BI. It has everything that you want from BI.
What needs improvement?
It is easy enough. I don't see any real substantial improvements that are needed. It is great as it is, but its interface could be a bit modern.
For how long have I used the solution?
I have been using this solution for six years. I am using the online version. So, it is the latest one.
What do I think about the stability of the solution?
It has improved over the years. There were problems a few years ago, but now, it is way better.
How are customer service and support?
Their support is fine. I had to reach technical support a few times, and they have been very good in the last two years.
What's my experience with pricing, setup cost, and licensing?
Compared to others, I think it is reasonable.
Which other solutions did I evaluate?
I tested a few other similar products before deciding on Power BI.
What other advice do I have?
I would advise others to just try it. I would rate it a 10 out of 10.
Which deployment model are you using for this solution?
Public Cloud
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Project Manager at a computer software company with 5,001-10,000 employees
User-friendly with a straightforward setup and good stability
Pros and Cons
- "The initial setup is pretty straightforward."
- "It seems that the solution could use more analytics to help users draw more contextual business insights. Right now, you need other solutions for that."
What is our primary use case?
We primarily use the solution to run our industry reports. We get the data from data warehouse we are creating. I use it to export the data.
We have been using Microsoft BI for one of the customers. That was completely in the customer environment. That's all. We did not have that solution for us in-house. However, we are working towards introducing it for our own purposes in the near future.
What is most valuable?
The product is very user-friendly.
The solution can be used with any BI tool you have.
The initial setup is pretty straightforward.
The solution has been very stable for our customers.
It appears the solution has the capability to scale, although we have yet to try to do so.
What needs improvement?
We have yet to implement the solution completely. We're still exploring features and capabilities. It's too early to discuss items that may be lacking.
It seems that the solution could use more analytics to help users draw more contextual business insights. Right now, you need other solutions for that.
For how long have I used the solution?
I've been using the solution for the past five years now. It's been a while.
What do I think about the stability of the solution?
The product has been quite stable so far. The performance is good. It's reliable. There aren't bugs or glitches. It doesn't crash or freeze.
What do I think about the scalability of the solution?
We have not attempted to scale the solution yet. We are in the initial stage of exploring different features on it. We believe it to be a scalable product, however, we have not attempted it ourselves yet. We might in the future.
We don't have any customers on the solution right now as we are just trying to figure things out.
How are customer service and technical support?
We haven't used technical support. I wouldn't be able to speak to how helpful or responsive they are.
Which solution did I use previously and why did I switch?
We are also using Tableau. We use Tableau right now, and we are likely introducing Microsoft BI in-house in the near future. For now, we just have customers that use it.
How was the initial setup?
We found the initial setup to be straightforward. It's not a difficult implementation and I wouldn't describe it as complex. A company setting up the solution for the first time shouldn't have any problem doing so.
What's my experience with pricing, setup cost, and licensing?
We're still in the process of licensing the model. We don't have it set up yet. My understanding is that we will pay for licensing on a yearly basis. I don't have the exact figures in terms of the costs.
Which other solutions did I evaluate?
Right now, I am looking to do a comparison between Tableau, Power BI, MicroStrategy, and Pyramid Analytics. I have not had a chance to really dig too deep into research.
What other advice do I have?
We are just customers and end-users. We don't have a business relationship with Microsoft.
We are using the most recent version of the solution at this time.
We're still exploring the solution and haven't fully implemented it yet.
I would rate the solution at an eight out of ten. It's very user-friendly and so far I have had a good experience.
Which deployment model are you using for this solution?
Private Cloud
If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?
Microsoft Azure
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Advisory Software Engineer at a tech services company with 1,001-5,000 employees
Interactive, user friendly, and efficient in terms of performance
Pros and Cons
- "The best thing about this solution is that it is very user friendly. It is interactive in terms of visualizations. It is very eye-catching, and it attracts users. There are a lot of options to visualize the data in different drafts and views. I have used different visualization tools, and I found Power BI to be more efficient in terms of performance, user-friendliness, and ease of use."
- "A few features available in Tableau are not available in Power BI. For example. Tableau has the ability to make up the physical layer and all other stuff at runtime. In Power BI, we have to develop a proper physical layer to connect it. The limitation that we normally face is related to the direct query mode. When it comes to the direct query mode, most of the functionality is not working, which is an issue for us. We have to use the direct query mode frequently because the client needs real-time data. They should work on this limitation. There are a lot of other technical things that need to be improved. I am also following the Power BI platform and Microsoft Support Center platform on the web where users have put their requirements. Microsoft is also working on improving this solution. In every update, they add new features to this solution."
What is most valuable?
The best thing about this solution is that it is very user friendly. It is interactive in terms of visualizations. It is very eye-catching, and it attracts users. There are a lot of options to visualize the data in different drafts and views.
I have used different visualization tools, and I found Power BI to be more efficient in terms of performance, user-friendliness, and ease of use.
What needs improvement?
A few features available in Tableau are not available in Power BI. For example. Tableau has the ability to make up the physical layer and all other stuff at runtime. In Power BI, we have to develop a proper physical layer to connect it.
The limitation that we normally face is related to the direct query mode. When it comes to the direct query mode, most of the functionality is not working, which is an issue for us. We have to use the direct query mode frequently because the client needs real-time data. They should work on this limitation.
There are a lot of other technical things that need to be improved. I am also following the Power BI platform and Microsoft Support Center platform on the web where users have put their requirements. Microsoft is also working on improving this solution. In every update, they add new features to this solution.
For how long have I used the solution?
I have been using this solution for more than four years.
What do I think about the stability of the solution?
It is stable. I haven't found it hanging. It consumes a lot of memory on the local system but not while developing the reports. It also depends on the data on which we are working, but generally, it is light and stable.
How are customer service and technical support?
My overall experience with Microsoft is actually quite good. We have contacted their technical support once or twice. It was something related to the Power BI visualization, where we needed to visualize some data, but they had some kind of limitation in personalization. We also wanted to connect Power BI with other servers, but we were facing some performance issues. The reports were not working fine. I don't think they managed to solve our issues.
Which solution did I use previously and why did I switch?
I have worked on SiteSense and Oracle OBIEE. I feel more satisfied when I'm working with Power BI. It is more convenient as compared to other solutions.
How was the initial setup?
The initial setup is easy. I didn't find any complexity in it. It can be difficult if the end users don't know how to use it. If they are trained on it, then after a week or a month, it gets easier for the end users.
What's my experience with pricing, setup cost, and licensing?
Its cost seems to be unreasonable if you have many users, but for a lesser number of users, it is reasonable. It is $10 per month. Clients easily accept this option, so they must think it is reasonable.
It is quite cheap as compared to other tools, such as Tableau. One of the best things about this solution is that it has a trial version.
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.
CEO at a tech services company
Tool is easy to use, DAX coding language is good for creating formulae
Pros and Cons
- "The DAX coding language is good for creating formulae."
What is our primary use case?
We use it for visualization, to create presentations and dashboards. It works pretty well.
How has it helped my organization?
We are using Power BI because it is one of the best tools. It has been very good for all situations. The DAX coding language is good for creating formulae.
What is most valuable?
It is easy to work with. The tool is very complete.
For how long have I used the solution?
One to three years.
What do I think about the stability of the solution?
The stability is good, no problem. We haven't had any trouble with it.
What do I think about the scalability of the solution?
Our solutions are not for very many people, say 25 users. For them, it works very well. I don't know how it works with more users than that.
Which solution did I use previously and why did I switch?
The customers we work with didn't have very elegant solutions. They were using traditional ERP and were getting default reports. Now, with programming code, it is fantastic. They are very happy with our solutions with Power BI.
Which other solutions did I evaluate?
Qlik Sense and QlikView are very good tools, very close to Power BI. Tableau is also a competitor but we haven't used it.
What other advice do I have?
When selecting a vendor we look for expertise, a company that understands the problems and knows the market, solutions, tools; and one that creates successful products. That is the most important criterion. Also, when you are in front of your clients, you need to know who is supporting you from the back.
I would rate Power BI at eight out of 10 because it enables us to do all the things we want to do. Moving forward, for more than 5,000 users, or for very complex dashboards, we don't know how it works.
I always recommend Power BI. It's very good.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Buyer's Guide
Download our free Microsoft Power BI Report and get advice and tips from experienced pros
sharing their opinions.
Updated: January 2025
Popular Comparisons
Teradata
Amazon QuickSight
IBM Cognos
SAP Analytics Cloud
SAP BusinessObjects Business Intelligence Platform
Oracle OBIEE
MicroStrategy
Oracle Analytics Cloud
Salesforce Einstein Analytics
TIBCO Spotfire
ThoughtSpot
Buyer's Guide
Download our free Microsoft Power BI Report and get advice and tips from experienced pros
sharing their opinions.
Quick Links
Learn More: Questions:
- BI Reports for business users - which BI solutions should we choose?
- Business users moving from Tableau to MS Report builder
- Is Power BI a complete platform or only a visualization tool?
- What are the key advantages of OBIEE compared to Microsoft BI?
- What Is The Biggest Difference Between Microsoft BI and Oracle OBIEE?
- Is Microsoft Power BI good for an ETL process?
- How would you decide between Microsoft Power BI and TIBCO Spotfire?
- Is it easy to extract data from Oracle Fusion into Power BI?
- PowerBI or SyncFusion - which is better?
- What challenges to expect when migrating multiple dashboards from TIBCO Spotfire to Microsoft Power BI?
It is completely true that while a certain BI product (or any other product for that matter) can work for a particular business, it might fail in another. This is due to the fact that a perfect solution for any business is influenced by various factors such as infrastructure that vary from one company to another. Therefore, businesses should not just pick the Microsoft BI tool for their needs but consider other options that would work best for them to achieve maximum output.