AI & Analytics · BigQuery
Wisenbaker
A BigQuery-powered NLP analytics platform that transformed how a national construction firm understands its data.
30%
reduction in sales cycle time
The Challenge
Wisenbaker, a national construction and building products company, had data spread across multiple systems — ERP, CRM, project management — with no unified way to access or analyze it. Sales teams were spending hours manually pulling reports, and leadership lacked real-time visibility into business performance.
Our Approach
We built a unified data warehouse on BigQuery that consolidated data from all source systems, then layered a natural language query interface on top that let stakeholders ask questions in plain English. No SQL knowledge required — just type a question and get an answer.
Data Warehouse
Consolidated ERP, CRM, and project data into a single BigQuery data warehouse with automated ingestion pipelines.
NLP Interface
Built a natural language query layer that translates plain English questions into optimized BigQuery SQL.
Real-Time Dashboards
Looker dashboards providing real-time visibility into sales pipeline, project performance, and financial metrics.
Self-Service Analytics
Enabled non-technical stakeholders to access and analyze data without depending on IT or data teams.
Results
- 30% reduction in sales cycle time
- Eliminated manual report generation
- Real-time visibility across all business units
- Self-service analytics adopted by 40+ users
“Finally, data we can actually use.”
Technologies Used
BigQuery
Looker
Vertex AI
Dataflow
Cloud Functions
NLP