Try our new research platform with insights from 80,000+ expert users
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.
    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.
    815,854 professionals have used our research since 2012.

    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
    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
    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.
    815,854 professionals have used our research since 2012.
    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
    reviewer1785144 - PeerSpot reviewer
    Strategy & Advisory - Solutions Architect at a financial services firm with 1,001-5,000 employees
    Real User
    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.
    PeerSpot user
    reviewer1247253 - PeerSpot reviewer
    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
    reviewer1722714 - PeerSpot reviewer
    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: November 2024
    Buyer's Guide
    Download our free Microsoft Power BI Report and get advice and tips from experienced pros sharing their opinions.