Customer experience analytics is crucial for businesses to understand their customers and improve their services. Through comprehensive data analysis and AI-powered insights, businesses can uncover patterns in customer feedback, identify pain points, and generate actionable recommendations.

In this Quickstart, we will build a comprehensive fan experience analytics platform for a basketball team called "Snow Bear". This demonstrates how to use Snowflake Cortex AI functions to analyze fan survey data, extract sentiment insights, generate business recommendations, and create advanced analytics dashboards.

This Quickstart showcases the complete Snow Bear analytics platform with:

In this step, you'll create the Snowflake database objects and upload all necessary files for the Snow Bear analytics platform.

To use Workspaces:

1. In Snowsight, click Projects, then Workspaces in the left navigation
2. Click + Add new to create a new Workspace
3. Click SQL File to create a new SQL file
4. Copy the setup script from setup.sql and paste it into your SQL file, then run it

To use Worksheets:

1. In Snowsight, click Projects, then Worksheets in the left navigation
2. Click + in the top-right corner to open a new Worksheet
3. Copy the setup script from setup.sql and paste it into your worksheet, then run it

The setup script creates:

Download these 5 files from the GitHub repository:

1. In Snowsight, change your role to SNOW_BEAR_DATA_SCIENTIST

2. Navigate to Catalog → Database Explorer → SNOW_BEAR_DB

Upload files to two stages in different schemas:

3. Upload to ANALYTICS → Stages → SNOW_BEAR_STAGE:

   • Navigate to ANALYTICS → Stages
   • Click on SNOW_BEAR_STAGE
   • Click Enable Directory Table
   • Upload these files:
     • basketball_fan_survey_data.csv.gz
     • snow_bear.py
     • environment.yml

4. Upload to GOLD_LAYER → Stages → SEMANTIC_MODELS:

   • Navigate to GOLD_LAYER → Stages
   • Click on SEMANTIC_MODELS
   • Click Enable Directory Table
   • Upload this file:
     • snow_bear_fan_360.yaml

1. Import into Snowflake:

   • Navigate to Projects → Notebooks in Snowsight
   • Click the down arrow next to + Notebook and select Import .ipynb file
   • Choose snow_bear_complete_setup.ipynb from your downloads

2. Configure the notebook settings:

   • Role: Select SNOW_BEAR_DATA_SCIENTIST
   • Database: Select SNOW_BEAR_DB
   • Schema: Select ANALYTICS
   • Query Warehouse: Select SNOW_BEAR_WH
   • Notebook Warehouse: Select SNOW_BEAR_WH

3. Click Create to import the notebook

The notebook contains all the SQL scripts and processing logic needed for the complete analytics platform.

1. Go to Projects → Notebooks in Snowsight
2. Click on SNOW_BEAR_COMPLETE_SETUP Notebook to open it
3. Click Run all to execute all cells in the notebook at once

1. Navigate to Projects → Streamlit in Snowsight
2. Find and click on Snow Bear Fan Analytics
3. Explore your 7-module analytics dashboard

Your platform includes executive dashboards, sentiment analysis, theme analysis, fan segmentation, AI recommendations, interactive search, and AI assistant capabilities.

When you're ready to remove all the resources created during this quickstart:

1. Open the setup.sql script
2. Scroll to the bottom to find the "TEARDOWN SCRIPT" section
3. Uncomment the teardown statements
4. Run the freshly uncommented script to remove all databases, warehouses, roles, and objects

Congratulations! You've successfully built the complete Snow Bear Fan Experience Analytics platform using Snowflake Cortex AI!