Venture Community Portal
CEMS Entrepreneurs ran a network of 320+ startups, 30+ business schools and 80+ corporate partners on 15+ scattered spreadsheets and bases. I merged them into one Airtable base and built an all-in-one portal to manage people, ventures, partners and programmes, with AI and automation keeping operations agile.
By Jin Longyu·Published ·Updated
The context
CEMS Entrepreneurs supports 200+ ventures from 30+ top business schools and 80+ corporate partners. However, it lacks a centralized portal to manage and scale its network.
Scattered data
data about the ecosystem players and events are scattered in 15+ data sources (airtable, google sheet), resulting in duplications and difficulties in data reusing
Repetitive manual efforts
Scattered data made it challenging to retrieve past info. Therefore, the team had to build a new dataset from scratch for each new initiative, creating more data silos.
Missed scaling opportunities
Since there was no single truth of information, the team found it challenging to scale their initiatives, like data insights overview, venture support match-making, etc.
How I built it
I joined the team to lead their Tech and automation and built CEMS Entrepreneurs' first venture management portal.
Centralized data
in days, I collected, combined, and cleaned 15+ data sources into one Airtable base.
All-in-one management portal
The team can now manage the entire network (people, venture, partners) and initiatives (acceleration, events, challenges) in one interface
Scalable automation
We implemented AI and automation to keep the operation agile, from new member registration and event management to data intelligence