snowflake Snowflake Blog ·

Snowflake's Snowplan: AI-powered financial planning platform

blogaisnowflakeengineerfinance
feature announcement

Snowflake has rebuilt its internal long-range financial planning model, Snowplan, on Snowflake with a Streamlit UI. This modernization addresses the limitations of large Excel models by providing a scalable, governed planning platform directly integrated with business data. The platform, now enhanced with Snowflake CoCo for conversational AI, allows finance teams to interact with forecasts and scenarios more fluidly, accelerating strategic alignment and analysis. It's designed for finance analysts, managers, and executives, allowing them to manage assumptions, generate scenarios, and understand forecast drivers through natural language queries.

  • Snowplan: Planning platform on Snowflake with Streamlit UI
  • Benefits of building the planning model within Snowflake
  • Snowflake CoCo enables conversational financial planning
  • Scenario planning for potential tax changes using CoCo
  • Snowflake's internal financial planning challenge
Features (4)
  • Snowplan: Planning platform on Snowflake with Streamlit UI

    Snowflake rebuilt its long-range planning model into Snowplan, a platform leveraging Snowflake for scale and governance and Streamlit for an intuitive UI. This allows analysts to update assumptions directly, with changes written back to Snowflake for immediate output surfacing, eliminating version control issues.

  • Benefits of building the planning model within Snowflake

    Building Snowplan on Snowflake provides advantages such as scalability for large datasets, enhanced governance through Snowflake's role-based permissions, and reusability of planning logic for various financial scenarios beyond the long-range plan.

  • Snowflake CoCo enables conversational financial planning

    The integration of Snowflake CoCo with Snowplan transforms the planning interaction model by allowing users to ask questions in plain English. This enables quick comparison of forecast versions, summarization of drivers, and compression of analysis from manual exercises into conversations.

  • Scenario planning for potential tax changes using CoCo

    Snowflake demonstrated scenario planning for a potential tax change using CoCo, allowing rapid creation of new forecast versions based on assumptions, such as passing costs to customers. The system can identify impacted sales, output financial impacts, and surface key metrics and potential risks.

Notes (1)
  • Snowflake's internal financial planning challenge

    Snowflake faced challenges scaling its 10-year long-range financial planning due to business complexity, leading to a large, difficult-to-maintain Excel model. This model became a valuable but unwieldy artifact that hindered governance and scaling.

Read the original announcement →

https://www.snowflake.com/content/snowflake-site/global/en/blog/fpa-ai-modernization-snowplan-v2