Broadly, there are problems that require two distinct way of solutioning. Either the solution is scrapping the current system in its entirety, or just breaking the problem into many little manageable problems and solving one by one. The current situation was unique in that it required a combination of both.
Amick Brown performed an exhaustive analysis of the Organizational Reporting Framework: people, process and technology. The current reporting framework was not designed with a strategic vision. Instead, it grew organically, to solve little problems as they arose. Each unique solution was implemented with no regard to the rest of the system. It was obvious that there were various moving parts, each moving independently. The ultimate solution required a holistic approach in designing and deploying a Reporting and Analytics Platform.
A Single Reporting Framework
Since the company already had licenses, SAP-BW was determined to be the Enterprise Data Warehouse (EDW) Platform. Although, the scope of the project pertained only to HR data, the EDW was designed to scale for other functional domains as well.
All the data that the varied Analysts used for their reports was sourced into the SAP-BW systems. Doing this, eliminated several duplicate data extractions performed by different Analysts. It also ensured a single and accurate set of business rules applied to the data sourced from various data islands.
A fully automated ETL process ensured the timeliness of the reports. Amick Brown worked with the Enterprise IT team to ensure that the automated ETL process was executed and monitored on a regular basis. Amick Brown also helped set up service level agreements (SLAs).
There were a total of 81 reports in the scope of this project. In the earlier system, all 81 reports were manually assembled and distributed by the HR Analysts. Amick Brown converted all 81 reports into canned reports on the new HR-BW system. They were provisioned by means of a reports catalog on the Enterprise Portal. This enabled self-service.
Ad hoc Reporting and Shared Services Team
Once all the relevant data was housed in the EDW, and because SAP-BW provides for ad-hoc reporting, it became the facility for responding to unique or one time information requirements. Amick Brown worked with the client to set up an HR-Reporting Shared Services Team to support the organization and its ad hoc reporting needs. The Shared Services Team was trained on the data dictionary as well as the ad-hoc reporting capabilities of the EDW system. The Shared Services team also provisioned reports to users from other departments.