Digitization of analytics and reporting capabilties for industry specific alternative data
Objective
A European Union investment bank wanted to analyze restaurant industry data from food delivery websites to analyse trends and growth potential of restaurants.
Challenges
- Sourcing and extracting alternative data for sector analysis.
- Standardizing data due to inconsistencies between data sources.
Approach
- Created a scheduled job to run a Python script to identify and download new data releases from food delivery websites.
- Visualized outputs with Tableau-based location maps to highlight unique coverage areas.
Impact
- Leveraged alternative data to estimate revenue potential through expansion in restaurant chain coverage
- Digitised framework enabled quick scale-up to cover other geographies as well
Questions