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.
"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."
"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."
"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."
"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."
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:
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. ”
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.
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.