Join us for a FREE hands-on Meetup webinar on Automate Workflows with Agentic AI – No Coding Needed! | Thursday, April 24th, 2025 · 7:00 PM IST/ 09:30 AM EDT Join us for a FREE hands-on Meetup webinar on Automate Workflows with Agentic AI – No Coding Needed! | Thursday, April 24th, 2025 · 7:00 PM IST/ 09:30 AM EDT

Snowflake Advanced Analytics

Leveraging Snowflake’s Advanced Analytical Capabilities for Predictive Insights and Trend Analysis

Duration

2 Days

Level

Advanced Level

Design and Tailor this course

Official Course

Edit Content

This two-day, role-specific course introduces participants to the advanced analytic capabilities provided by the
Snowflake AI Data Cloud. Participants learn to employ these analytical capabilities to derive deeper insights,
discover patterns, and pinpoint trends. This course will provide participants with the skills to begin accessing
information that supports a more predictive approach to identifying what could happen instead of only looking
at what has happened. The course consists of lectures, labs, demonstrations, and discussions.

ACQUIRED SKILLS
• Use the advanced analytic capabilities provided in Snowflake to improve decision-making.
• Show quick insights into trends, correlations, and predictions using linear regression.
• Exploit windowing functions to provide eicient query processing and support comparative analysis.
• Manipulate semi-structured data in its raw format to expand analysis capabilities.
• Explain how geospatial data can enhance operational eiciencies, support location-based analysis, and
augment visualizations.
• Perform analysis using algorithms designed for “big data” to facilitate predictive analytics.
• Employ complex query syntax in Snowflake.
• Utilize Streamlit in Snowflake apps for analysis.
• Summarize Snowflake’s LLM and ML capabilities.
• Use a Snowflake Notebook to perform analysis and visualizations using SQL and select Python packages.

Edit Content

• Data Analysts
• Citizen Data Scientists
• Anyone interested in advanced analytics

Edit Content

• Loading Data
• Running Queries
• Visualizations

• Descriptive Statistics
• Time Travel-based Analytics
• Times Series Analytics
• Linear Regression

• Over Clause Review
• Rank and Dense Rank
• Row Number
• Lead and Lag
• Other Functions

• Unnesting Data Using Flatten
• Using Other Semi-structured Functions
• Extracting and Checking Data Types
• Creating Semi-structured Elements From Structured Data
• Unloading Semi-structured Data
• Loading Semi-structured Data
• Schema Detection
• Benefits of Structured vs Non-structured Tables

Geospatial
• Geospatial Overview
• Geometry Data
• Geography Data
• Using Geospatial Functions
Big Data
• Processing Big Data
• Comparing Data Sets
• Top- K Frequency
• Counting Distinct Elements
• Percentile Distributions
Streamlit
• Streamlit Overview
• Streamlit in Snowflake
Snowflake ML Functions
• Snowflake ML Functions – Overview
• Snowflake ML Functions – Generalized Workflow
• Snowflake ML Functions – Specifications
• Snowflake ML Functions – Cost Considerations
Cortex LLM Functions
• Generative AI
• Cortex LLM Functions – Overview
• Cortex LLM Functions – Specialized Functions
• Cortex LLM Functions – COMPLETE
• Cortex LLM – Cost Monitoring
Snowflake Notebooks
• Introducing Snowflake Notebooks
• Using Notebook Cells
• Integrating Snowflake ML and Cortex LLM

Edit Content

• Completion of “Snowflake Data Analyst” two-day course or equivalent Snowflake knowledge.
• Knowledge of SQL is required.
• Familiarity with statistical analysis and its terminology is recommended.
• Previous Python programming experience is beneficial.

Connect

we'd love to have your feedback on your experience so far