10/12/2026
How VIRA Insight turned scattered data into trusted, conversational insight with Snowflake
VIRA Insight designs, engineers, manufactures and installs retail environments, fixtures and displays. Its business ran on Salesforce, Epicor, SharePoint, SQL Server and custom APIs, each holding part of the picture. Building a single view meant spreadsheet exports, manual reconciliation, and departments working from conflicting versions of the same metrics.
NorthBay built VIRA a governed enterprise data foundation on Snowflake:
🔹 Automated ingestion with Snowflake OpenFlow
🔹 dbt transformations across Bronze, Silver and Gold layers
🔹 A Cortex Analyst semantic layer that aligns KPI definitions across teams
🔹 Power BI dashboards for executive and self-service reporting
🔹 Five AI agents built with Snowflake Agent Studio, including an Opportunities Agent for natural-language questions in Snowflake Intelligence
The results:
✅ Q2 scope delivered 100% on time and on budget
✅ 4 production reports: Opportunities, Accounts Receivable, Monthly Shipping and Backlog
✅ Reporting cycles reduced from days to minutes
✅ Salesforce, Epicor and SharePoint data unified in one governed lakehouse
The work continues in Q3 with more Epicor tables, customer and vendor master data, and expanded governance.
Read the full case study 👉 https://hubs.li/Q04zWYgT0