Knowage vs Microsoft BI comparison

Cancel
You must select at least 2 products to compare!
Knowage Logo
2,687 views|1,991 comparisons
Microsoft Logo
48,850 views|38,957 comparisons
Comparison Buyer's Guide
Executive Summary

We performed a comparison between Knowage and Microsoft BI based on real PeerSpot user reviews.

Find out in this report how the two Reporting Tools solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI.
To learn more, read our detailed Knowage vs. Microsoft BI Report (Updated: November 2022).
657,397 professionals have used our research since 2012.
Featured Review
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"I can't name the features the way the Knowage community calls them because I still don't know the lingo. However, I can describe them. I like the ability to join more than one report, set all fields on one end, and replicate that on the other reports. I like that a lot. I think it's one of the features that got me using Knowage. They have tables, and I like that too. They took SQL scripts and many other scripts and enabled them to even correlate with Python. That's also one of the best things about Knowage. You could also decide to get information per user role, and this is also a feature that I like in Knowage.""The embedding feature is great.""We can easily do our own customizations."

More Knowage Pros →

"In my opinion, Microsoft BI is a low-cost solution, and it could be an interesting solution for a tourism company.""It's a powerful platform.""We have a lot of servers and applications from which we want reports, and it allows us to create reports from an SQL source or some other source.""The most interesting feature of Microsoft Power BI is that it's very user-friendly.""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.""I like data modeling. You can connect with your database, which is quite useful for me. It is a good tool if you have a large amount of data and you want to gather different data and interconnect it. The Power Query functionality is quite an interesting feature. If you have a query in Excel, you can also copy your query and run it in Power BI. Its dashboard is also very nice and not complicated. You don't need to be a developer to be able to use it. I am not an IT guy, and it is quite easy to use for somebody who is not an IT person.""Its ease of use is most valuable.""It is easy to use. It has got a desktop where people can develop their own dashboards. Basically, we have figured out how to connect finance contracts and all programs for the government agency. So, they can see everything in a dashboard. So, it is very easy to use from a technical standpoint of view."

More Microsoft BI Pros →

Cons
"The only challenge here is that it's a Java-based platform. It requires very high technical skills.""It would be better if more resources were available to help us learn how to use it. I wanted to use Knowage for a more extended period, but learning materials around the product were not really available and were not really straightforward. I've also seen inconsistencies between versions. For example, under the tools, especially in the cockpit, the way you create reports is now different. You will also find some configurations within a particular state, like a line chart, which differs from version to version. I think consistency is an essential feature in a product, especially for business intelligence products.""The dashboard components could be better."

More Knowage Cons →

"We have used other solutions and the reporting functionality should be user-friendly and have a drag and drop feature should be available, but Microsoft BI doesn't have these features. When you are creating reports and you can't change as a user. Every time you need one developer or one technical person to make the changes.""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.""My main complaint is that the error messages need to be made more clear. Currently, they are either too generic or outright misleading, and finding the real problem is like searching for a needle in a haystack.""More connections with other systems should be added, which would allow for other integrations.""Microsoft has got a very large repository of all change suggestions which have been raised by the BI community. They keep on adding features that are very widely sought after by the community. We don't focus on product features. We focus on business requirements. To use the solution, we find that existing features are good enough and offer us a very effective solution.""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.""Some kind of expression wizard, where the user can build a complex expression without any knowledge of DAX, can be a good addition to the product.""I would like to see better, undisturbed stability without any interruptions."

More Microsoft BI Cons →

Pricing and Cost Advice
  • "Knowage is open-source, and an enterprise edition is also available."
  • More Knowage Pricing and Cost Advice →

  • "For my primary use case, i.e. teaching students, the free version of Power BI is adequate."
  • "The premium licensing is approximately $5,000 per month which is pretty expensive."
  • "We pay on a monthly basis which is approximately $10 per user on the Microsoft Power BI Pro license. At the moment we are still down at 400 users, but once we reach 500 users, we will move to the premium edition. The premium is $5,000 for unlimited users. Currently, with the 40 users, the cost is roughly $500."
  • "It is based on the usage. If you're using it, you pay for it, and if you're not using it, you stop paying for it."
  • "The cost of licensing depends on the number of people that are going to be using the reports, and we are satisfied with it at $10 per user."
  • "I am satisfied with its price. Its price is very less as compared to Tableau and QlikView."
  • "Their price is good."
  • "As far as I am aware you do not need a license for the solution."
  • More Microsoft BI Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Reporting Tools solutions are best for your needs.
    657,397 professionals have used our research since 2012.
    Questions from the Community
    Top Answer:It's an open-source product; we use the open-source edition for Knowage.
    Top Answer:The integration could be better. We've been struggling a bit with embedding it without the need to log on. The dashboard components could be better. They could do a lot more. If you compare it with… more »
    Top Answer:We primarily use the solution to embed reports. We are using it as a server to share our embedded reports.
    Top Answer:There are many...It would rather depend what System BI architecture or Enterprise legacy you have at your end...I would recommend as follows:  1) If you have legacies of SAP, Oracle  - look for SAP… more »
    Top Answer:Power BI is an advanced visualization tool oriented to big data with a very complete set of widgets to visualize information, control users accessing information, the configuration of governance… more »
    Top Answer:Oracle OBIEE is great in allowing design and creativity per the individual needs of the organization. Dashboards are fully customizable and very user-friendly. This solution is very stable. Oracle… more »
    Ranking
    10th
    out of 49 in Reporting Tools
    Views
    2,687
    Comparisons
    1,991
    Reviews
    3
    Average Words per Review
    820
    Rating
    7.3
    1st
    out of 49 in Reporting Tools
    Views
    48,850
    Comparisons
    38,957
    Reviews
    172
    Average Words per Review
    529
    Rating
    8.1
    Comparisons
    Also Known As
    SpagoBI
    SSRS, SSAS, MSBI, MS Reporting Services, Power BI, Microsoft BI Tools, Microsoft Big Data, Power BI Pro, MS BI
    Learn More
    Overview

    Knowage (formerly SpagoBI) has a 14-years history. The actual release is the 6.3.

    Knowage offers FULL ANALYTICAL CAPABILITIES, with a special focus on big data analytics and comprehensive support to rich and multi-source data analysis. Knowage provides different modules, each one focused on a specific domain but mutually combinable (Big Data, Smart Intelligence, Enterprise Reporting, Location Intelligence, Performance Management, Predictive Analysis). Moreover, Knowage is an OPEN SOURCE solution: the source code is freely accessible, everyone is allowed to join the community and build the own business solution to ensure strategic decision-making and improved productivity.

    Knowage suite is supported by Engineering Group, the leading Italian software and services company, with about 10,000 people and more than 50 offices worldwide. Maintenance and support services (such as trainings, migration support, proof-of-concepts, etc) are provided by Engineering Group (KNOWAGE Labs) under subscription.

    Microsoft BI is a business intelligence solution that connects to all your data sources and turns your data into insightful and useful business information that is relevant to all levels of the business, ensuring data accuracy, consistency, and security.

    Microsoft BI combines familiar Microsoft tools - Office, SharePoint, and SQL server - with extra features for end-users, such as Power View and Power Pivot. This powerful product gives businesses a competitive advantage by allowing end users to better analyze their data, collaborate, and better present their data.

    The BI platform empowers members of your organization to make data-driven decisions that drive strategic actions quickly by allowing them to work together easily on the same data, share insights, and collaborate on reports using other Microsoft Office applications.

    Microsoft BI Benefits

    Some of the benefits of using Microsoft BI include: 

    • Scalability: Easily scale the Microsoft BI platform to help reduce costs and minimize the security risks and complexities that arise as a result of maintaining multiple systems.
    • Secure analytics: Protect your data with sophisticated data security features, including sensitivity labeling, end-to-end encryption, and real-time access monitoring. View and share meaningful AI-based insights enriched by data visualizations.
    • Regular user-driven innovative updates: Get weekly and monthly updates that improve the capabilities of Power BI based on thousands of ideas submitted each year from a community of over 500,000 members worldwide.
    • Seamless integration with Microsoft products: Microsoft BI connects with Microsoft 365, allowing you to create Excel queries, data models, and reports for the Power BI dashboards. These integrations make it easy to collect, analyze, publish, and share Excel business data.
    • Access Microsoft BI from any location: BI can be accessed at any time from anywhere using its mobile app, allowing ease of access to distributed teams or businesses across many locations. The business intelligence platform also enables teams to work on any file at the same time.
    • User-friendly dashboard: View and manage your data in a user-friendly and intuitive customized dashboard. The Microsoft BI platform enables teams to work independently while exchanging analytics between different departments and users. With Microsoft BI, you can easily create personalized dashboards that combine on-premises and cloud data into a single view, allowing you to monitor enterprise data from multiple business applications.
    • Easy installation: Install the platform in minutes just by creating an API key and inputting it into the software.

    Reviews from Real Users

    Microsoft BI stands out among its competitors for a number of reasons. Two major ones are its integration options and its data analytics capabilities.

    Tariq R., an operations & BI analyst at American Hospital Dubai, writes, “Power BI is a complete ecosystem. It has an integrated ETL tool and good connectivity with applications such as Office 365 and SQL. Power BI supports the DAX and Power Query M languages. These languages are making Power BI very strong in data analytics, and you can do many types of analysis. ”

    Offer
    Learn more about Knowage
    Learn more about Microsoft BI
    Sample Customers
    FIAT Group, Italian air navigation service provider, Ministry of Education and Science of the Russian Federation, Telecom Italia, ASL Genovese, San Giovanni Battista University Hospital
    Konica Minolta, Klout, Mahindra Satyam, The Weather Channel, Argus, Credit Suisse, NCR, and Sysmex.
    Top Industries
    REVIEWERS
    Comms Service Provider29%
    Computer Software Company29%
    Healthcare Company14%
    Non Tech Company14%
    VISITORS READING REVIEWS
    Computer Software Company23%
    Comms Service Provider18%
    Government7%
    Educational Organization5%
    REVIEWERS
    Financial Services Firm14%
    Manufacturing Company14%
    Computer Software Company11%
    Government9%
    VISITORS READING REVIEWS
    Computer Software Company16%
    Comms Service Provider11%
    Financial Services Firm10%
    Government7%
    Company Size
    REVIEWERS
    Small Business39%
    Midsize Enterprise33%
    Large Enterprise28%
    VISITORS READING REVIEWS
    Small Business28%
    Midsize Enterprise16%
    Large Enterprise56%
    REVIEWERS
    Small Business39%
    Midsize Enterprise17%
    Large Enterprise45%
    VISITORS READING REVIEWS
    Small Business18%
    Midsize Enterprise14%
    Large Enterprise68%
    Buyer's Guide
    Knowage vs. Microsoft BI
    November 2022
    Find out what your peers are saying about Knowage vs. Microsoft BI and other solutions. Updated: November 2022.
    657,397 professionals have used our research since 2012.

    Knowage is ranked 10th in Reporting Tools with 3 reviews while Microsoft BI is ranked 1st in Reporting Tools with 176 reviews. Knowage is rated 7.4, while Microsoft BI is rated 8.0. The top reviewer of Knowage writes "Open-source with great embedding capabilities but the dashboards could be better". On the other hand, the top reviewer of Microsoft BI writes "A complete ecosystem with an builtin ETL tool, good integrations with python and R, and support of DAX and Power Query (M languages)". Knowage is most compared with Pentaho Business Analytics, Tableau, TIBCO Jaspersoft, QlikView and SQL Server, whereas Microsoft BI is most compared with Amazon QuickSight, Tableau, Oracle OBIEE, SAP BusinessObjects Business Intelligence Platform and IBM Cognos. See our Knowage vs. Microsoft BI report.

    See our list of best Reporting Tools vendors and best BI (Business Intelligence) Tools vendors.

    We monitor all Reporting Tools reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.