CSE498, Collaborative Design, Fall 2024
Computer Science and Engineering
Michigan State University

WK Kellogg Co, home to some of the world’s most iconic cereal brands, is one of the largest food manufacturing companies in the nation. Headquartered in Battle Creek, Michigan, WK Kellogg has grown into a major player in the food industry, thanks to its global reach and ability to adapt to shifting consumer demands.

WK Kellogg currently operates in the competitive global food market in over 180 countries. Operating at such a large scale, it is important for the company to stay up to date on current business and market trends.

Our Cereal Industry Analysis Tool Using Generative AI automates data analysis through a web application. The website enables analysts and financial professionals to extract valuable insights regarding WK Kellogg and their competitors. This information can then be used by the company to assist in making business decisions and developing strategies to enhance the WK Kellogg brand.

WK Kellogg employees navigate to the web application and select a large language model to perform analysis on the large amount of stored data. Users then pose questions to our intelligent chatbot to gain valuable insights into business performance. Users can ask questions about industry shifts, market trends, business strategies, and more. The chatbot provides detailed responses throughout the conversation, empowering users to make informed business decisions.

The platform uses public datasets stored in Snowflake, which serves as the primary data warehouse. SQL commands interact with the Snowflake database and extract information from stored files. Streamlit, a Python framework, powers the front end of the web application. The application enables user interaction via a chatbot, which leverages large language models for generating detailed responses.