# Analyzing the Corporate Business Intelligence Impact: A Case Study in the Financial Sector
## 2 Proposed Research Framework, Methodology, and Case Study
### Manual Preparation of Reports and Definition of the Problem  
In the sales coordination department of XY Financial Institution, customer-based cheque statuses, the number of open cheques, cheque amounts, and the status of payments based on these are reported every week to be presented to management by querying 12 months before the current day. The report is prepared by a different employee in the unit every week. The preparation of the report takes until noon on Mondays every week, but sometimes extends to end of the day, depending on the abundance of data. In addition, a control period is also activated after the report is prepared. The time study for the Manual Report is provided in Figure 2. While determining the report preparation time at XY Financial Institution, the report preparation process was measured with a stopwatch over 10 working days. The periods for the 10 days are shown by drawing a time study graph. According to the results obtained from the graphic trend, the average duration of the manually prepared report was determined to be 4 h. \begin{table}
\begin{tabular}{p{113.8 pt} p{113.8 pt} p{113.8 pt} p{113.8 pt}} \hline \hline
**Table Names** & **Primary Key** & \begin{tabular}{} \end{tabular} & \
\begin{tabular}{} \end{tabular} &
\begin{tabular}{} \end{tabular} \\ \hline CEKSOR & ID & 25 & 19,868,459 \\ \hline CEKICMAL & QUESTIONNO & 26 & 738,159 \\ \hline CEKBANKA & QUESTIONNO & 32 & 1,863,189 \\ \hline CEKOZET & QUESTIONNO & 45 & 14,868,459 \\ \hline CEKKESIDECI & QUESTIONNO & 15 & 2,963,256 \\ \hline CEKUMHABIR & QUESTIONNO & 36 & 3,125,912 \\ \hline CEKSORSONUC & QUESTIONNO & 25 & 7,074,994 \\ \hline CEKKESIDECITUTARI & QUESTIONNO & 25 & 3,034,269 \\ \hline \hline \end{tabular}
\end{table} 
Table 1: Number of columns and total number of records in cheque tables. Figure 2: Time study for manual report. The current situation was analyzed, and a workflow diagram was created and presented in Figure 3. The following problems were encountered during the manual preparation of cheque reports:  
1. Inefficiency and time loss of the manual process: Cheque reports are prepared manually on a weekly basis, and it takes an average of 4 h to prepare a report. In this process, operations such as manually combining and editing data cause a great loss of time. In addition, manual processes create personnel dependency, and the continuity and accuracy of the prepared reports are affected in case of personnel change. 2. High error rates and lack of accuracy: Data entry errors made during manual reporting negatively affect the accuracy of reports. This situation is seen as a significant problem, especially in strategically important reports such as credit risk analyses. High errors slow down decision-making processes and damage corporate reliability. 3. Impact on strategic decision-making processes: The fact that reports used by senior management are not based on detailed analysis causes deficiencies in strategic decision-making processes. In particular, the failure to report critical information such as cheque payment status, delays, and customer payment habits quickly and accurately negatively affects corporate performance. 4. Operational risks coming with increasing data load: The increase in data over time makes it difficult to maintain manual processes. Working on large data sets takes more time and increases the risk of manual errors. This may lead to further growth in operational risks in the future. As a result, it was found that the manual reporting process was a significant problem that negatively affected the efficiency of the operational processes at XY Financial Institution. Therefore, it is anticipated that the report should be prepared within a systematic framework rather than manually. In this context, it is aimed to combine data from multiple sources into a single data set by pulling the CRB Cheque Report on a customer basis querying  
Figure 3: General work steps for manual report.