Case Study: a US solar panel and inverter manufacturer cuts ad hoc data requests by 80% with Bacancy Technology’s Snowflake BI Assistant

A Bacancy Technology Case Study

Built a Natural Language BI Assistant on Snowflake for a US Solar Equipment Manufacturer

The client, a US manufacturer of solar panels and inverters, faced significant delays in its plant operations. Plant managers and analysts had no way to answer questions outside of fixed dashboards, leading to a backlog of ad hoc data requests for the IT team that took days to fulfill, forcing decisions to be made on incomplete information.

Bacancy Technology built a natural language BI assistant on Snowflake using Cortex Analyst and a Streamlit interface. This solution allowed users to type plain English questions and instantly receive charts and tables, eliminating the need for SQL. The project cut ad hoc data requests to the data team by 80% and provided governed access to data across six manufacturing plants.


View this case study…

Bacancy Technology

32 Case Studies