Challenge

General Catalyst’s data flow was in an Excel spreadsheet and reports required 100+ hours of man work.

Solution

Custom GCP-based data platform:

• ETL and Data Quality
• BI and Reporting

Data quality tooling:

• Aumni (data automation to parse and transfer data to Salesforce)
• Airbyte (transfer data from different sources to the central warehouse)
• GCP big query (warehouse)
• Power BI (reporting + data visualization)
• Streamlit (data manipulation).

Result

Custom reporting, which previously took 100 hours to manually create, now only takes 1 hour. Plus, no lagging data.