Interim Manager Supply Chain / IT at a consultancy with 501-1,000 employees
Real User
It is connected to every database: Whatever and wherever it is
Pros and Cons
  • "It is easy to work with and very chic."
  • "Its connection to every database: Whatever and wherever it is."
  • "The look is simple, and could be a little more professional."

What is our primary use case?

Its primary use case is for CIPs from the purchasing department. It performs perfectly. It is very quick and easy to use.

How has it helped my organization?

We approve it for use with SAP BI, so it has been more effective for our users and much cheaper. So, the costs are small and the benefits are high.

What is most valuable?

Its connection to every database: Whatever and wherever it is. 

It is easy to work with and very chic.

What needs improvement?

The look is simple, and could be a little more professional.

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

For how long have I used the solution?

One to three years.

What do I think about the stability of the solution?

The stability is very good. We have no problems.

We receive an update every month with new functions, so we are not missing anything.

What do I think about the scalability of the solution?

The scalability is good. It works for a large community just fine.

How are customer service and support?

We have not needed to use technical support. We are able to do everything by ourselves. That is one of the main reasons that we like the product.

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

We have SAP BI working. It has cost us more than a million Euro, and it does not work. This was one of the reasons to change.

Power BI is very easy to use and much sleeker. 

How was the initial setup?

The initial setup was straightforward. 30 minutes, and it runs perfectly.

What other advice do I have?

I would recommend Power BI as the best working solution.

Most important criteria when selecting a vendor: Usability of the solution.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
IT Director at VIC Dept of Health and Human Services
User
Provides data feeds for enterprise KPI reporting
Pros and Cons
  • "Provides data feeds for enterprise KPI reporting."
  • "There is continual improvement year-over-year."
  • "The data source definition is all over the place."
  • "It needs a wizard that covers all its options."
  • "It needs an AI which can choose the appropriate connection strings and provide options for connections."

What is our primary use case?

  • Enterprise reporting
  • Enterprise BI
  • Project reporting and BI
  • Data integration
  • Data collection
  • Information management

How has it helped my organization?

    • We are running over 500,000 report annually.
    • It provides data feeds for enterprise KPI reporting.
    • It provides data feeds for AI.

    What is most valuable?

    • Integration of DB and reporting
    • Standardised SQL language
    • Plenty of support
    • Cloud options
    • Continual improvement year-over-year

    What needs improvement?

    • The data source definition is all over the place. 
    • It needs a wizard that covers all its options. 
    • It needs an AI which can choose the appropriate connection strings and provide options for connections.

    For how long have I used the solution?

    More than five years.
    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    PeerSpot user
    Buyer's Guide
    Microsoft Power BI
    April 2024
    Learn what your peers think about Microsoft Power BI. Get advice and tips from experienced pros sharing their opinions. Updated: April 2024.
    768,857 professionals have used our research since 2012.
    PeerSpot user
    Presales Architect at a tech services company with 10,001+ employees
    Real User
    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?

    With the out-of-the-box Data Platform and Business Intelligence ecosystem, you get the entire platform with a single license.

    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.

    What do I think about the stability of the solution?

    There were no stability issues.

    How are customer service and technical 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.
    PeerSpot user
    it_user6819 - PeerSpot reviewer
    BI Expert with 1,001-5,000 employees
    Vendor
    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.
    PeerSpot user
    it_user1068 - PeerSpot reviewer
    it_user1068Tech Support Staff at a tech company with 51-200 employees
    Vendor

    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.

    See all 2 comments
    DGM IT at a manufacturing company with 5,001-10,000 employees
    Real User
    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.
    PeerSpot user
    Lead Business Analyst at a media company with 501-1,000 employees
    Real User
    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.
    PeerSpot user
    Operations Center Technician at a renewables & environment company with 501-1,000 employees
    Real User
    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.
    PeerSpot user
    Technology Solutions Professional at OrchidaSoft
    Real User
    Has good implementation features
    Pros and Cons
    • "The solution is easy to set up and implement."
    • "I would like to see a change in the premium capacity."

    What is most valuable?

    Defining the most valuable features would take a long time. While I cannot point to a specific feature, I feel the solution provides a full range of implementation capabilities. This allows for integration and modeling, for carrying out good transformations within the same platform, as well as visualization. There are not many products included inside and one can start from scratch. 

    In respect of the customer, one can quickly implement phases. A person can start out with creating his data set on a miniscule amount of the client's work and, working solely with a sales team, make it agile, only involving three or four dashboards. At this point, completion is possible and progress may be made to the next one very quickly. We like the solution's ease of use, functionality range and ability to be quickly implemented. 

    What needs improvement?

    I would like to see a change in the premium capacity. It is very costly, particularly for the Egyptian market, amounting to $5,000 per month. Perhaps in the Gulf this would work well. The data flow should be enhanced from OnPrem-Gateways, which we find to be somewhat complicated and which does not always work. Regional pricing is the main issue. 

    The stability is okay, although there can sometimes be an issue with the connection when it comes to data OnPrem and the need to manage gateway communication and do troubleshooting. In brief, there are certain issues with OnPrem stability. 

    'Although we feel the solution to be a dream, it would be great to see everything on Power BI services, obviating the need for Power BI desktop. I hope to see such Power BI implementation. 

    I feel like we don't have a very powerful ELT or ETL tool when it comes to power and data cleansing. The solution compares unfavorably with such products as Informatica in this regard.

    For how long have I used the solution?

    I have been using Microsoft BI for two years.

    What do I think about the stability of the solution?

    The stability is okay, although there are occasional connectivity problems when it comes to managed gateway communication of data OnPrem and troubleshooting. The OnPrem stability should be addressed. 

    What do I think about the scalability of the solution?

    While the stability is okay, there is an occasional need to add extra products, such as those involving Azure data analysis and Azure Analytics Services. 

    Big data would require the involvement of different products, Microsoft sign ups, for example. While we did not go for this, our technical teams are trying to get up to speed to have big data rediness. 

    I feel like the solution has a comparatively inferior ELT or ETL tool when it comes to power and data cleansing and compares unfavorably with Informatica. There is occasionally a need to involve other solutions, such as Informatica and Alteryx. 

    How are customer service and support?

    While we have not made much use of Microsoft support, I did previously work with Microsoft's premier support and found it to be very good, overall. 

    How was the initial setup?

    The solution is easy to set up and implement. 

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

    The premium capacity is very costly in respect of the market in Egypt, amounting to $5,000 monthly. The regional pricing should be addressed. 

    Which other solutions did I evaluate?

    The solution has an edge over others in its quick implementation. It is also very helpful to consider Microsoft data platform on Azure. Doing a combination with Microsoft data plaform will give one a great edge over, say, Tableau. 

    The combining of Power BI with Microsoft data platform on Azure provides one increased familiarity. We are talking about a great ecosystem. 

    The solution is comparatively inferior to those offered by other companies in respect of the ETL and ELT as these relate to power and data cleansing. It is not the best. 

    What other advice do I have?

    My advice to someone looking to implement Power BI for his own organization would be to take things step by step. He should initially refrain from taking on big projects, instead focusing on agility, starting with the most requisite dashboards, working on them and garnering experience. The person will improve from one time to the next. One should familiarize himself with the details and how to move data and big data. He should not remain stuck waiting for the implementation of a big project. 

    I rate Microsoft BI as an eight out of ten. 

    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    PeerSpot user
    Buyer's Guide
    Download our free Microsoft Power BI Report and get advice and tips from experienced pros sharing their opinions.
    Updated: April 2024
    Buyer's Guide
    Download our free Microsoft Power BI Report and get advice and tips from experienced pros sharing their opinions.