All projects Project 04

Data Automation & Presentation in Investment Research

Built a customizable data dashboard using automation tools that enabled tailored financial analysis, reduced repetitive tasks and increased research coverage.

90%
Automation rate
95%
Error reduction
3x
Scalability in research
4 weeks
Time to completion

01 Context

An investment management firm relied on manual data collection from Bloomberg for financial analysis. Data downloaded was hard-coded, making the process slow and inefficient, especially when analyzing multiple companies and industries.

02 Problem

  • Manual data collection was time-consuming and repetitive, and took 2 days to prepare the data for analysis.
  • Data was static and required re-downloading for updates.
  • No ability to create custom variables or dynamic analyses.
  • Limited capacity to analyze multiple companies or perform complex data exercises efficiently.

03 Objective

  • Automate data collection and presentation, make data analysis dynamic and customizable.
  • Increase the speed and scale of financial research by enabling cross-sectional and time-series analysis across industries and companies.

04 Solutions

Industry Databases in BQL

Developed industry-specific databases using Bloomberg Query Language (BQL) in Excel.

Dynamic Excel Templates

Created dynamic customisable Excel templates for company financials, industry and global peers, and valuation metrics.

Tearsheets & Watchlists

Built tearsheets, watchlists, and worksheets for quick reference and to track/monitor the portfolio.

05 Outcomes

  • Faster data processing, cutting time taken from 15 hours to 3 hours.
  • 3x more companies analyzed weekly, increasing our research coverage.
  • Higher customisation using industry-specific variables.

06 Reflection

Automation unlocks capacity for scalability of research, not just efficiency. Integration of powerful tools like Python for visualisation would have enabled faster data processing and better visualisation flexibility for data analysis.

07 Skills Acquired

Data Automation & VisualizationWorkflow Optimisation