Business Intelligence Solution

Abstract

A leading construction company which plays a major role in soil load capability improvement and management had a problem in monthly financial reporting, especially after their recent acquisition & merger. It took more than two weeks to generate the reports every month and when more details were requested, it took another couple of weeks. This strongly impacted the decision making. By the time the decisions were made they were almost in the mid of the next month, and it was too late for corrective actions. It was critical to solve this problem as they were not able to make timely corrective actions resulting in financial loss. A deep study was made to find the root cause of the problem. The entire landscape was analyzed, and the reporting requirements were refined. Based on these findings, a new solution is proposed. The scope of this thesis is limited to the analysis of the existing issues and IT landscape. As a result of the analysis, a dedicated Business Intelligence Solution is suggested for reporting needs.