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.

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.

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

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.

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.