Knowage Reviews

The advantage of the solution is we don't need to have any third-party tools to connect to the different databases. It has in-built features such as data mass and data warehousing. The big data concept is also included. It's very easy to implement graphical reports. We don't need to have a data warehouse for maintaining the historical data and things like that. We can achieve most of the goals without using third-party tools.

It's very easy to get the historical reports you need based on the business requirements and this helps our executives for taking decisions.

It is cross-platform. We can use it on desktops and on mobile versions and we don't need to have a separate mobile version for this.

We can easily do our own customizations. 

If you have a great technical team, it's a great option.

The solution can scale.

The product is stable. 

We primarily use the solution to embed reports. We are using it as a server to share our embedded reports.

In terms of reporting, it gives us a central place to store all our reports. We can also do version control. Instead of just relying on emails to disperse our reports, having a central server to do this for us has helped our organization and has pushed us into a better place. It's simplified our reporting.

We can test. There's room for testing reports before you deploy to other users and so forth. Just that functionality as well as their dashboards and the statistics you can collect on the usage of Knowage also helps our organization function effectively.

I created some tunnel processes and tunnel scripts in an Oracle database that helped me collect all aspects of profitability. We have around 14 million customers, and they generate a lot of records—for example, many activities like millions of records per day. I created a script that condensed that information and then aggregated that further to an activity level. I do it to determine if the company was profitable each month and understand if we have a positive or negative margin or a zero margin.

From there, I drill down to those customers that sort of caused that negative margin and try to analyze what caused that negative margin. For example, I look at what products or activities caused that negative margin. That's the analysis I do, and it gives me that access to tools. I could join two to three reports that help me analyze and drill down and export that information in whatever form I need.

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 health data warehouse is a centralized repository for data that allows organizations to store, integrate, recall, and analyze information.  Healthcare organizations may wish to use their warehouses perform clinical analytics using patient data stored in the EHR, or they may try to improve their financial forecasting by diving into business intelligence and revenue cycle analytics using claims and billing codes.

Making better decision using KPI, Peforming predictive analytics about each department/functional units

Building reports and user cockpits/dashboards from data and a MySQL database. Later, it will implement the ad hoc reporting tools to improve the user experience.

It allows the implementation of an effective reporting system using internal skills at a limited upfront cost.

The Mobile Edition, which now they have stopped in the Community Edition.

It improves sales and products, which motivates employees.

• Our customers really appreciate the self-service BI functionalities. For us, this is the most valuable feature. It allows them to work more autonomously without the need to engage us.
• For example, loading a spreadsheet and being able to make analysis inputs along with the data stored in a DWH without any external support in an easy and guided way.

SpagoBI helped us to move a lot of analysis activities from our company to the customer side. Moreover, we avoided extending other products we used in order to add BI functionalities.

Because it is an open source product, we were also able to adopt it in our project from the early stages for very simple tasks.

• SpagoBI Server offers the core and analytical functionalities. It provides the Analytical Model (reports, ETL, OLAP analysis, real-time dashboards, KPI, cockpits, GIS information, etc.), administration tools and cross-platform services.
• SpagoBI Studio has high productivity in the development phase; it easily permits the developer to design analytical documents such as reports, charts, geo, cockpits.
• SpagoBI SDK for integration and to use SpagoBI with external applications.

In other words, the main goal of my project was to create detailed reporting and a dashboard for managing various local departments (ASL) of the ministry to analyze the various performance and geographical distribution (through the use of maps and geo-referenced data) of expenditures, with the purpose of providing support to strategic choices of the senior management. One of the features that attracted us with the choice of SpagoBI was that it offers a simplified query functionality for business users, requiring no technical knowledge.