snowflake analysis