With the out-of-the-box Data Platform and Business Intelligence ecosystem, you get the entire platform with a single license.
Presales Architect at a tech services company with 10,001+ employees
With the Data Platform and Business Intelligence ecosystem, you get the entire platform with a single license
Pros and Cons
- "With the out-of-the-box Data Platform and Business Intelligence ecosystem, you get the entire platform with a single license."
- "It is getting better but still, there are opportunity areas in some aspects, especially the Windows OS dependency."
What is most valuable?
How has it helped my organization?
Previously, I was working for a retail company and when I got there, there weren't any analytics implemented yet.
So, what I did was, firstly, I implemented an EDW solution so as to gather all the possible data in a single repository.
After that, I developed a self-service model so the company could take advantage of their ad hoc analysis.
Then, I implemented some standard reports to understand some basic indicators, together with the delivery subscriptions so that all the organization's levels could receive this valuable information, i.e., for more than 500 users.
Lastly, I connected this platform to the cloud (Power BI) together with a top BI solution (QlikView) so as to take full advantage of the second data insights' step journey.
What needs improvement?
The Windows OS dependency needs to improve. There are some bugs with the new features that have released.
It is getting better but still, there are opportunity areas in some aspects, especially the Windows OS dependency.
For how long have I used the solution?
I have used this solution for 10 years and still counting.
Buyer's Guide
Microsoft Power BI
November 2024
Learn what your peers think about Microsoft Power BI. Get advice and tips from experienced pros sharing their opinions. Updated: November 2024.
823,875 professionals have used our research since 2012.
What do I think about the stability of the solution?
There were no stability issues.
How are customer service and support?
Technical support is very good.
Which solution did I use previously and why did I switch?
I was using Oracle before, we switched to Microsoft because Oracle is very expensive for the benefits that they offer.
How was the initial setup?
The setup was easy, actually, a single instance installation can be installed by clicking next and next. Maybe a cluster installation could be a little more complex, but it is still easy.
What's my experience with pricing, setup cost, and licensing?
This is one of the best out-of-the-box solutions on the market. Microsoft has to improve their Data Governance solution, but for a data platform and BI solution, it is very good.
Which other solutions did I evaluate?
We evaluated products such as Oracle, MySQL, and Postgres.
What other advice do I have?
It is very straightforward. Maybe you won't like the Windows OS dependency, but, in the 2017 version, you can install the engine on Linux.
Disclosure: My company has a business relationship with this vendor other than being a customer: My current company is a Microsoft Partner.
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
November 2024
Learn what your peers think about Microsoft Power BI. Get advice and tips from experienced pros sharing their opinions. Updated: November 2024.
823,875 professionals have used our research since 2012.
Strategy & Advisory - Solutions Architect at a financial services firm with 1,001-5,000 employees
Quality reporting and data migration with strong visibility, functional dashboards and more
Pros and Cons
- "I like having the ability to connect Excel files as data inputs."
- "I would like for the next release to have better desktop performance, especially for big databases. Additionally, I would like to have more integrations with programs like Salesforce in order to get more live data coming in."
What is our primary use case?
We use this solution for reporting around data migration.
How has it helped my organization?
BI provides us with strong computing power and calculations with quality visibility which helps with the whole pipeline.
What is most valuable?
I like having the ability to connect Excel files as data inputs.
BI also allows us to make functional dashboards, perform queries, and display data in various ways. And, there are always new features being released.
What needs improvement?
I would like for the next release to have better desktop performance, especially for big databases. Additionally, I would like to have more integrations with programs like Salesforce in order to get more live data coming in.
For how long have I used the solution?
I have been using BI on and off for the past two years.
What do I think about the stability of the solution?
Stability is very good.
What do I think about the scalability of the solution?
This solution is scalable.
How are customer service and support?
I have not needed to contact support.
Which solution did I use previously and why did I switch?
Originally, we were only using Excel, trying out different dashboards for the data. This was not powerful enough for us. It was not easy to use or streamline so we made the switch.
How was the initial setup?
The initial setup was straightforward and deployment took about a week plus another few weeks to do work within the BI.
What about the implementation team?
Our deployment was performed by our in-house team of one.
What other advice do I have?
There is a free version of the Power BI which may be worth looking into for small teams prior to purchasing a license. I would rate this solution a nine out of ten.
Which deployment model are you using for this solution?
On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
DGM IT at a manufacturing company with 5,001-10,000 employees
Easy to use solution
Pros and Cons
- "The data can be accessed from anywhere."
- "I would like to see a more user-friendly interface with Microsoft BI."
What is our primary use case?
Our company is a manufacturing firm. We have an ERP running in our company. I develop the reports for the business that include sales, stock and production related information. These dashboards are used for analytics purposes by management, enabling them to make decisions regarding the products and business improvement.
We use the BI text file and summarize the information on dashboards to help management make the right decisions for the business. The information includes production figures, running status, forecasts and actual positions.
We have 10 users of this solution.
What is most valuable?
The most valuable feature of Microsoft BI is the ease of use. The data can be accessed from anywhere. We control access through Office 365.
What needs improvement?
I would like to see a more user-friendly interface with Microsoft BI. Microsoft does regular updates, new features are added every month or so.
For how long have I used the solution?
I have been using Microsoft BI for one year.
What do I think about the stability of the solution?
Microsoft Power BI is stable with no issue.
What do I think about the scalability of the solution?
The solution is scalable.
How are customer service and support?
Overall, technical support is good.
Which solution did I use previously and why did I switch?
Prior to using Microsoft BI, we had been using OBIEE. Oracle is a complicated product with poor visuals. Comparing with Microsoft BI, we found Microsoft to have better handling, graphics, features, and easier development and coding.
How was the initial setup?
The initial deployment of Microsoft BI was relatively easy. We installed it to the machine and connected it to our Oracle database.
What about the implementation team?
We were able to install the solution ourselves internally.
What's my experience with pricing, setup cost, and licensing?
Microsoft BI requires licenses.
What other advice do I have?
Microsoft Power BI is an easy product. If you have some idea about the business intelligence solutions and some technical knowledge, it is a self-deployed solution.
I would rate the solution an 8 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.
Lead Business Analyst at a media company with 501-1,000 employees
Data visualization tool which has an extensive number of features including offering user defined charts
Pros and Cons
- "Power BI allows you to create user defined charts which is really useful."
- "The UI is the main improvement that could be made. Specifically, there is something called DAX, in Power BI, which is complicated compared to calculated fields used in Tableau."
What is our primary use case?
We use this data visualization tool for the business to understand data in a graphical manner. It is similar to Tableau, a tool also used for data visualization. A tool like this is used mostly by the leadership team to make decisions.
What is most valuable?
Power BI allows you to create user-defined charts which is really useful.
The Power Query button in the power tabs is a unique selling point and is very useful.
What needs improvement?
The UI is the main improvement that could be made. Specifically, there is something called DAX, in Power BI, which is complicated compared to calculated fields used in Tableau.
For how long have I used the solution?
I have been using this solution for six months.
What do I think about the stability of the solution?
This is a stable solution.
What do I think about the scalability of the solution?
This is a scalable solution. We have 500 users.
How was the initial setup?
The initial setup was easy.
What other advice do I have?
The main difference between Power BI and Tableau is the cost. Power BI is much cheaper. Tableau is the best BI tool that I've worked on and is easier for developers to work with. However, there are many things that can be done in Power BI which can't be done in Tableau.
If you're starting working with Power BI, then I would suggest first getting experience with the free version of Tableau to understand and learn about data visualization. From there, moving to Power BI will be much easier as the tools are so similar.
I would rate it a nine 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.
Operations Center Technician at a renewables & environment company with 501-1,000 employees
The visualization is convenient and easy to use.
Pros and Cons
- "I like that I can use Power BI to upload data. That is very important for me. The visualization is also convenient and easy to use."
- "I like that I can use Power BI to upload data. That is very important for me. The visualization is also convenient and easy to use."
- "The maps in Power BI could be improved. You deal with many maps over the years, like maps of America and Saudi Arabia. The maps aren't detailed enough, and there aren't enough visualization tools. Whenever I want to use a map, I struggle with choosing the right visualization."
What is our primary use case?
We use Power BI for dashboards and various reports. It's primarily a visualization tool. We don't use it for business intelligence— just visualization.
What is most valuable?
I like that I can use Power BI to upload data. That is very important for me. The visualization is also convenient and easy to use.
What needs improvement?
The maps in Power BI could be improved. You deal with many maps over the years, like maps of America and Saudi Arabia. The maps aren't detailed enough, and there aren't enough visualization tools. Whenever I want to use a map, I struggle with choosing the right visualization.
For how long have I used the solution?
We've been using Microsoft BI for about three years now.
What do I think about the scalability of the solution?
Microsoft BI is scalable. There are some limitations depending on the amount of data you need, but it's enough for me so far. We have about 50 users, and we'll likely increase our usage in the coming years as Microsoft adds more features and our people train themselves to do more with it.
How was the initial setup?
Setting up Microsoft BI is straightforward. It took about one week if you include training on how to send reports and other things. We were able to do it by ourselves with a team of about five people.
What's my experience with pricing, setup cost, and licensing?
The license is annual. If you need a fancy visualization, you have to pay a bit more, but a valid license covers everything else. I'm developing reports and rolling them out to some users who are not developers, so I need the visualization and have to pay for the license. In the case of Tableau, you don't need to pay, or maybe you spend a little less because you're not a developer.
What other advice do I have?
I rate Microsoft BI 10 out of 10.
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.
Data Science Intern at Clockworkx Gmbh
A business analytics solution that handles a large amount of data, but the types of plots you can use are limited
Pros and Cons
- "I liked that Microsoft Power BI handles a large amount of data. I can handle hundreds of rows from Postgres in a few minutes. I also like how it detects the relationship between the tables without explicitly saying that. It just detects the relationship automatically. That made it easier to work with the data."
- "It's not really complicated, but I didn't find the things I was looking for. The ones I used to work with within Dash are more open, and there are more choices. But with Power BI, there are only limited types of plots that I can use. For example, when I wanted to put the plots in Power BI, there was no extendable space. You have a limited page where you can place a maximum of three plots in that, and you can't do more than that on a single page. You have to create a new page, a different page for that. That made it a bit annoying, and the filtering part is limited, with basic functions. If you want to make custom filtering or custom functions, you can't do that."
What is our primary use case?
We have some monitoring data from turbines, and we want to plot the data to monitor the health state of turbines in different time stamps. I tried to download some data from the Postgres database and then do some plotting with that. I also tried to link different plots with each other to filter them and things like that.
What is most valuable?
I liked that Microsoft Power BI handles a large amount of data. I can handle hundreds of rows from Postgres in a few minutes. I also like how it detects the relationship between the tables without explicitly saying that. It just detects the relationship automatically. That made it easier to work with the data.
What needs improvement?
It's not really complicated, but I didn't find the things I was looking for. The ones I used to work with within Dash are more open, and there are more choices. But with Power BI, there are only limited types of plots that I can use.
For example, when I wanted to put the plots in Power BI, there was no extendable space. You have a limited page where you can place a maximum of three plots in that, and you can't do more than that on a single page. You have to create a new page, a different page for that. That made it a bit annoying, and the filtering part is limited, with basic functions. If you want to make custom filtering or custom functions, you can't do that.
Suppose you want to code a plot, Python available. You can code the plot you want, and you don't have to use a predefined one. But when you want to plot it and you want to import like five or ten packages in Python, there are limitations. It doesn't support all the libraries that Python has. Microsoft BI only supports a few, like three or four libraries at most. When I want to use my old code in Power BI, it doesn't handle it, and that was also annoying.
In the next release, it'll help if they added a coding area where you are more open to make custom things. Especially for a developer, it needs to be improved. For a Power BI person, it's fine, I think, because it doesn't require much technical knowledge, but a developer will need it. Maybe they should create a space for that.
For how long have I used the solution?
I have been using Microsoft BI for the last three months.
What do I think about the stability of the solution?
It's stable, but it's so slow. Sometimes it takes some time to respond, especially when you put two or three plots with big data. It becomes very slow.
How are customer service and technical support?
I didn't contact technical support as I used the support on the internet. I'm satisfied with the documentation, but I didn't find what I was looking for.
Which solution did I use previously and why did I switch?
I was using Dash Open Source, but when I discovered that it would take a lot of time, I wanted to define a platform for that. So, Power BI was the solution. Now I want to try Tableau, but I haven't had a chance to do that yet.
What's my experience with pricing, setup cost, and licensing?
I used a two months free trial to see if it had what I needed. I can pay later for a full license, but I don't think I will do that.
What other advice do I have?
On a scale from one to ten, I would give Microsoft BI a six.
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.
Director Research and Development at Projects Factory
A comprehensive source for visualizations and analytics
Pros and Cons
- "Because this solution is very easy, and very visual, you can have results in minutes."
- "I would like to see a feature that connects with a Machine Learning platform like a RapidMiner or Azure Machine Learning Studio. It would be great to have a Machine Learning application link to connect."
What is our primary use case?
I primarily use this for creating dashboards and reports for the oil and gas industry.
What is most valuable?
Power BI is always updating. I receive multi mail from Power BI with new visualizations, new analytics, new webinars and I'm going to Microsoft here locally in order to have a updated presentation about the new features of Power BI. For me it's very versatile. I can publish on my iPad. I have a Power BI application in order to manage the visualization of my report and my dashboard. Also I can speak to Power BI and ask about production and Q&A. But, I don't have compilation with other tools yet. For me, Power BI is the best.
What needs improvement?
I would like to see a feature that connects with a Machine Learning platform like a RapidMiner or Azure Machine Learning Studio. It would be great to have a Machine Learning application link to connect.
For how long have I used the solution?
One to three years.
How was the initial setup?
It was straightforward. We had no problems with implementation.
What's my experience with pricing, setup cost, and licensing?
The pricing is fine for our company. It is reasonably priced.
What other advice do I have?
Because this solution is very easy, and very visual, you can have results in minutes.
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: November 2024
Popular Comparisons
Amazon QuickSight
Teradata
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.