Key contributions
Conducted seamless data scraping of balance sheets and income statements using Python. Merged and streamlined the data with Python for cleaning and consolidation, optimised for comprehensive analysis, and engineered a robust MySQL database to house the refined financial data.
Analytical aspects
Delivered a 4-year financial health analysis, uncovering trends in margins, liquidity and profits across multiple dimensions — empowering decision-makers with nuanced insight for both individual companies and industry categories.
Outcome
Drove strategic decision-making by revealing critical financial trends, and made the shortlist in a data analytics competition built around this dataset.
Note: this project was built in December 2023, so it does not contain financial data for 2023 onward.