Over the period of 10 years, a leading healthcare solution provider had been through merger and acquisition cycles integrating the offerings of the companies acquired into their line of business. Although, this garnered their business value offerings to the customers and broadened their market reach, it internally led to a disparate array of backend data sources ranging across: MS-Access, Oracle, SQL Server, etc. Similarly for the front end reporting needs, client uses multiple tools i.e. Power Builder, MS – Assess, Cognos and SAS.
The key business challenges were:
• The current Data warehouse solution needs to be evaluated and re-architected, considering past and future business requirements.
• Currently, there are several resources that are focused in generating reports for various customers of client. Due to the current data warehouse design, disparate data sources and other unknown technical dependencies, time taken by these analysts is significant to generate the reports, thereby increasing the cost of conducting business.
• The usage of current BI/ DWH tools need to be evaluated and if required to be consolidated. The objective is to utilize those tools that are more pertinent to the business need, thereby reducing maintenance costs.
• Help to identify and automate overall ETL, OLAP and reporting process is a key element as this will help reduce manual dependencies, cause less human error and will be a good scalable option for similar or repetitive reporting needs from customers.
• Other challenge of providing timely delivery of reports to customers, due to complex internal environment set-up and dependencies on internal and external data feeds can be eliminated or minimized.
A Business Needs assessment includes an analysis of the underlying business drivers and objectives and overall context of business need that has been established for the client’s Data Warehouse. When business needs have been defined, the assessment process examines the approach to capturing business requirements, their completeness, the priorities of the requirements, and alignment of the data warehouse release strategy and deliverables to the needs.
The team conducted a high level assessment as follows:
• Interview with various Stakeholder i.e. Leadership team, Business subject matter experts, Technical subject matter experts, Infrastructure and IT, Business end users.
• Assessment of current technical architecture.
• Assessment of organizational and infrastructure readiness to support value transparency initiatives including key gaps.
• Assessment of cost/value improvement opportunities.
• Recommendation of high-level architecture and strategy to support defined information needs.
• Specific recommendations for short and long term improvements.
• Cost benefits analysis and ROI.
An Organizational Assessment includes an examination of the existing organizational structure and identification of the roles and responsibilities of both IT and the business community that need to be addressed. Organizational readiness for warehousing is examined, including readiness to assume responsibility for ongoing technical and business support, business requirements definition, and front end applications enhancement.