Data retrieval and analysis tools in financial reporting and controllership: SQL vs Excel

Ing. Muhammad Siddique

Diplomová práce

Abstract:

This study evaluated the impact of SQL reporting techniques on financial reporting and controllership processes in the corporate organization (Microsoft Corporation). Excel became insufficient as financial data increased in bulk and sophistication. MySQL's sophisticated data management and analytical tools helped the organization digest massive volumes of data and automate heavy reporting. This research focuses on SQL reporting about Excel's strengths and limitations to determine how Microsoft's finance business might be improved.SQL reporting strategies gained various advantages in the analysis. This revealed scalability, which lets SQL databases manage millions of rows of data in seconds, unlike Excel. Oracle technology in SQL reduced human data entry, minimizing report mistakes and improved accuracy. Integration with new technologies like artificial intelligence and machine learning increased Microsoft's predictive analysis and real-time report generating, boosting decision-making.The investigation also identified SQL reporting difficulties. Newcomers had trouble utilizing the program, which required technical expertise. Because the client's systems required to be merged, merging with other systems generated compatibility issues that took time to resolve. Software, training, and new system implementation expenses were another drawback. Security became a concern owing to vulnerability and potential threats from setup or security faults.The research offered several practical methods to address these concerns, as listed below. The organizations suggested strengthening financial team training to reduce skill gaps and guarantee SQL tool use. Middleware solutions were recommended to avoid time and expense delays caused by obsolete system integration. In order to avoid data leakage and meet standards, high levels of security, AES-256 encryption, and service audits were regularly emphasized. Given that SQL solutions are fine, a hybrid reporting strategy using SQL and Power BI was suggested.The study concluded that SQL reporting methodologies might revolutionize financial reporting and controllership. Microsoft's financial operations could benefit by millions in accuracy, scalability, and efficiency if it implemented efficient SQL solutions uniformly across its departments using algebra and proper software tools. This research highlights the uses and hazards of modern technologies that improve financial reporting systems for firms considering to implement them.

Keywords

Data, Excel, MySql, Financial records, Data analysis, Technology, Software.

Jazyk práce: angličtina

Datum vytvoření / odevzdání či podání práce: 6. 1. 2025

Obhajoba závěrečné práce

• Obhajoba proběhla 29. 1. 2025
• Vedoucí: Ing. Oleksandra Lemeshko
• Oponent: Ing. Veronika Kajurová, Ph.D.

Masarykova univerzita

Ekonomicko-správní fakulta

Magisterský studijní program / obor:
Finance / Finance