Home / Current Issue / Paper 1713872
Optimizing Finance Operations Through Data Analysis
Subject area: Management and Commerce · Area of research: Data-Driven Financial Management
DOI: https://doi.org/10.64388/IREV9I7-1713872
Abstract
This report presents an overview of the summer internship in the finance domain, focusing on financial reporting, data analysis, and automation. The internship aimed to support the finance team in improving operational efficiency, data accuracy, and decision-making through structured reporting and analytical tools. Key contributions included the automation of investor reports using Power BI, support in a state sales tax study, and analysis of revenue and publisher cost concentration at both overall and business unit levels. The work also involved average collection and payment period analysis and evaluation of revenue receipt trends to derive insights into working capital management and financial planning. Throughout the internship, accurate documentation was maintained, collaboration with cross-functional teams was ensured, and reporting standards and timelines were strictly followed. This experience strengthened financial analysis capabilities, enhanced proficiency in Excel and Power BI, and provided practical exposure to corporate finance and data-driven decision-making.
References
[1] Bragg, S. (2022). Financial analysis: A business decision guide (pp. 1–412). Accounting Tools, Inc.https://www.accountingtools.com/articles/financial-analysis.html
[2] Wild, J. J., Subramanyam, K. R., & Halsey, R. F. (2020). Financial statement analysis (12th ed., pp. 1–720). McGraw-Hill Education.https://www.mheducation.com
[3] Gallo, A. (2017, April). A refresher on return on assets and return on equity. Harvard Business Review.https://hbr.org/2017/04/a-refresher-on-return-on-assets-and-return-on-equity
[4] Damodaran, A. (2012). Investment valuation: Tools and techniques for determining the value of any asset (3rd ed., pp. 1–992). Wiley Finance.https://pages.stern.nyu.edu/~adamodar/
[5] IBM. (n.d.). Power BI vs. Excel: Choosing the right analytics tool.https://www.ibm.com
[6] CFA Institute. (2023). Corporate finance and financial reporting standards.https://www.cfainstitute.org
[7] PwC. (2022). Finance function of the future: Digital transformation in finance.https://www.pwc.com/gx/en/services/consulting/finance-transformation.html
[8] EY. (2021). Reimagining finance for the future.https://www.ey.com/en_gl/consulting/reimagining-finance
[9] Deloitte Insights. (2023). The future of finance: How CFOs are reinventing reporting.https://www2.deloitte.com
[10] McKinsey & Company. (2020). Finance 2030: The future of finance in a digital world.https://www.mckinsey.com
[11] KPMG. (2022). Improving financial reporting through automation.https://home.kpmg/xx/en/home/insights.html
[12] BDO. (2021). Financial automation and the CFO’s digital role.https://www.bdo.com
[13] Bain & Company. (2023). Strategic cost management in corporates.https://www.bain.com
[14] Gartner. (2022). Trends in financial planning and analysis (FP&A).https://www.gartner.com
How to cite this paper
@article{1713872,
author = {Sujoy Das, Pushkar Parulekar },
title = {Optimizing Finance Operations Through Data Analysis},
journal = {Iconic Research And Engineering Journals},
year = {2026},
volume = {9},
number = {7},
pages = {2009-2016},
issn = {2456-8880},
url = {https://www.irejournals.com/formatedpaper/1713872.pdf},
abstract = {This report presents an overview of the summer internship in the finance domain, focusing on financial reporting, data analysis, and automation. The internship aimed to support the finance team in improving operational efficiency, data accuracy, and decision-making through structured reporting and analytical tools.
Key contributions included the automation of investor reports using Power BI, support in a state sales tax study, and analysis of revenue and publisher cost concentration at both overall and business unit levels. The work also involved average collection and payment period analysis and evaluation of revenue receipt trends to derive insights into working capital management and financial planning.
Throughout the internship, accurate documentation was maintained, collaboration with cross-functional teams was ensured, and reporting standards and timelines were strictly followed. This experience strengthened financial analysis capabilities, enhanced proficiency in Excel and Power BI, and provided practical exposure to corporate finance and data-driven decision-making.},
month = {January},
doi = {https://doi.org/10.64388/IREV9I7-1713872}
}