Brainforge x CTA: Weekly!
Date: March 20, 2026 Source: Granola Meeting ID: 18c77022-f294-47f6-8454-55124d5a63f7 URL: https://notes.granola.ai/t/18c77022-f294-47f6-8454-55124d5a63f7
Participants:
- Uttam Kumaran (note creator) from Brainforge uttam@brainforge.ai
- Kyle Wandel from Consumer Technology Association kwandel@cta.tech
- Ashwini Sharma from Brainforge ashwini.sharma@brainforge.ai
- Katherine Bayless kbayless@cta.tech
- Chi Quinn from Consumer Technology Association cquinn@cta.tech
Technical Updates & Development Progress
- Ashwini completed dimensional modeling for Expo Cat data
- PR ready for internal review and merge
- 90% match rate achieved between exhibitor records and member organizations
- Kyle finished Fortune 500 data integration (1988-2025)
- Added top retailers and electronic retailers datasets
- Data stored in raw archive with S3 integration
- Streamlit dashboard development planned
- Kyle to provide Power BI report inventory and requirements
- Focus on CES data with basic attendee participation metrics
- 30-minute requirements session scheduled for Monday
Identity Stitching Implementation Deep Dive
- Multi-stage matching waterfall approach deployed:
- Direct organization name matching
- Organization alias lookup
- Website normalization and matching
- Email domain matching
- Phone number matching
- Fuzzy matching between organization names
- Match rate breakdown by method:
- Name matches: highest volume
- Alias matches: second tier
- Phone matches: lowest volume
- Recommendation to remove email and phone matching
- Risk of false positives from individual-based matches
- Aggregator issue: one person managing multiple exhibit booths
- AI-enhanced matching exploration planned
- Snowflake Cortex AI functions (AI_EXTRACT, AI_COMPLETE)
- Non-deterministic matching as final waterfall step
Data Integration & Canonical ID Strategy
- Canonical company ID system needed across datasets
- Current approach works for exhibitor-linked data only
- Innovation Awards and other datasets require different identifiers
- Power Automate integration for reverse ETL to Remembers
- Test staging environment available
- Alternative: manual data import tool via admin interface
- Social login implementation suggested by Okta
- Sign in with Google, Apple, LinkedIn options
- Reduces authentication friction for users
Next Steps & Action Items
- Monday demo session planned
- Cortex changes and role updates
- Streamlit observability dashboard
- VS Code/Cursor integration for Snowflake development
- Kyle: Send Power BI report examples and requirements to Brainforge chat today
- Test Power Automate key for Remembers integration
- April planning discussion scheduled for Monday
- Snowflake rollout plan review pending leadership anxiety resolution
- Meeting with Christina scheduled for data access concerns
- Cautiously optimistic for planned timeline