Cost Benefits Through Business Technology Assessment

Within the duration of ten years, a number one healthcare solution provider have been through merger and acquisition cycles integrating the choices from the companies acquired to their profession. Although, this received their business value choices towards the customers and broadened their market achieve, it internally brought to some disparate variety of backend data sources varying across: MS-Access, Oracle, SQL Server, etc. Similarly for that front finish reporting needs, client uses multiple tools i.e. Power Builder, MS – Assess, Cognos and SAS.

Business Need

The important thing business challenges were:

• The present Data warehouse solution must be evaluated and re-architected, thinking about past and future business needs.

• Presently, there are many sources which are focused in generating reports for a number of customers of client. Because of the current data warehouse design, disparate data sources along with other unknown technical dependencies, time taken by these analysts is important to create the reports, therefore growing the price of performing business.

• Using current BI/ DWH tools have to be evaluated and when needed to become consolidated. The aim would be to utilize individuals tools which are more pertinent towards the business need, therefore reducing maintenance costs.

• Assistance to identify and automate overall ETL, OLAP and reporting process is really a key factor as this helps reduce manual dependencies, cause less human error and will also be a great scalable choice for similar or repetitive reporting needs from customers.

• Other challenge of supplying timely delivery of reports to customers, because of complex internal atmosphere set-up and dependencies on internal and exterior data feeds could be eliminated or minimized.


A Company Needs assessment includes an research into the underlying business motorists and objectives and overall context of economic need that’s been established for that client’s Data Warehouse. When small business happen to be defined, the assessment process examines the method of recording business needs, their completeness, the priorities from the needs, and alignment from the data warehouse release strategy and deliverables towards the needs.

Comments are Closed