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.
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.
They conducted an advanced assessment the following:
• Interview with assorted Stakeholder i.e. Leadership team, Business subject material experts, Technical subject material experts, Infrastructure also it, Business finish users.
• Assessment of current technical architecture.
• Assessment of business and infrastructure readiness to aid value transparency initiatives including key gaps.
• Assessment of cost/value improvement possibilities.
• Recommendation of high-level architecture and technique to support defined information needs.
• Specific strategies for short and lengthy term enhancements.
• Cost benefits analysis and Return on investment.
An Business Assessment includes a test from the existing business structure and identification from the roles and required both IT and also the world of business that should be addressed. Business readiness for warehousing is examined, including readiness to visualize responsibility for ongoing technical and business support, business needs definition, and front finish applications enhancement.
Small Business Assessment
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 data warehouse. When small business happen to be defined, the assessment process examines the method of recording business needs, their completeness and organization, the priorities from the needs, and alignment from the data warehouse release strategy and deliverables towards the needs.
Information Architecture Assessment
Information Architecture Assessment includes an analysis of logical data structures, their practicality, completeness, documentation, and fit to business needs. Information architecture assessment includes analysis of information sourcing and transformation, the techniques and assumptions applied, and validation of mappings to business needs.
Technical Architecture Assessment
A Technical Architecture Assessment examines current hardware, software and network infrastructure, and examines physical database designs. Technical architecture assessment seeks to recognize any technical risks or constraints regarding performance, maintenance, scalability, data distribution, disaster recovery, and sizing.
An advanced technical approach that’s been recommended is applying SAS 9.2 to automate ETL, OLAP, Reporting, Dashboard and knowledge mining for client.
Deploying SAS Business Intelligence will let the client to place reporting tools into the hands of their finish users, making certain consistent use of information for much better making decisions. Key advantages of the answer include:
• Reduced daily presentation time – Presentations for that monthly executive meeting are instantly generated, eliminating the specialist time to allow them to take more time on greater-level tasks.
• Reduced report creation time – Business users have access to the reports they require making changes and updates when needed, reducing how long spent developing reports and requesting data.
• Automation of processes – Suggested ETL and Reporting automation using SAS Data integrator and Reporting studio
• Enhanced visibility – Because standard reports are updated monthly inside a dashboard, they are able to rapidly identify trends or problems.
• Improved data precision – Because users have access to the information directly and instantly update key reports, they are able to ensure they always have the most up-to-date and accurate data.
• Enhanced human sources – Because users can be cultivated and personalize their very own reports, client has had the ability to considerably grow its reporting abilities without adding reporting programmers: because the deployment more new reports happen to be produced without them intervention.