Margin Assurance Analyst at a comms service provider with 1,001-5,000 employees
Real User
2021-10-14T16:27:59Z
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
2021-09-14T13:53:42Z
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.
Business intelligence (BI) successfully combines business history and software to interpret data to analyze a business’s footprint and create action plans for success in the future. Business intelligence will look at the effects of various business decisions and summarize those effects in easy-to-understand reports, graphs, charts, and summaries.
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.