Margin Assurance Analyst at a comms service provider with 1,001-5,000 employees
Real User
Oct 14, 2021
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.
General Manager Information Technology & Enterprise Applications Manager at OXFORD HOLDING
Real User
Top 20
Sep 14, 2021
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.
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.
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...
We primarily use the solution to embed reports. We are using it as a server to share our embedded reports.
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.
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.
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.