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