Pantheon

• 

  dashboard page

• 

  dashboard with purposefully left out database

• 

  integration visualization page

• 

  data validation showing purposefully left out database

• 

  tool stack page

• 

  settings page

Inspiration

Problem: Analytics and CRM exports are scattered, messy, and time-consuming to prepare. Goal: Make data ingestion, validation, and dashboarding effortless for small teams.

What It Does

Ingests: Accepts raw GA4 and HubSpot exports (CSV). Cleans & Validates: Detects schema issues, normalizes fields, and fills or flags missing data via DataValidation. Visualizes: Delivers interactive charts and tables (BarGraph, FilterableTable) and API endpoints for integrations. Exports: Produces clean datasets ready for reporting and BI tools.

How We Built It

Frontend: Next.js app with component-driven UI and API routes for data flows. Backend: Flask service handling parsing, validation, and storage; utilities in utils/dbManager.py. Architecture: Modular IntegrationNode components and lightweight REST endpoints for extensibility.

Challenges We Ran Into

Data Drift: Inconsistent schemas and column names across exports. Quality Issues: Missing timestamps, inconsistent encodings, and timezone mismatches.

Built With

• flask
• html
• next.js
• python
• react
• sqlite
• typescript