Overview

This two-day, role-specific course introduces data analysts to how the Snowflake AI Data Cloud enables them to deliver actionable insights and reports to their organization to drive business value. The course is structured around a data analysis lifecycle placing each capability Snowflake provides in the data analyst’s context. The course begins with how to connect to the Snowflake Data Cloud. It then covers how to analyze, ingest, enrich, report, and diagnose data insights with Snowflake. The course consists of lectures, labs, demonstrations, and discussions.

Skills Covered

  • Outline the unique and differentiated architecture of the Snowflake AI Data Cloud.
  • Exploit the options provided to connect and interact with the Snowflake AI Data Cloud.
  • Describe how to use BI tools for data analysis in Snowflake.
  • Summarize query constructs, Data Definition Language (DDL), Data Manipulation Language (DML), and Data Query Language (DQL) operations.
  • Use Snowflake’s extensive SQL capabilities and the built-in table, scalar, window, and estimation functions to support data analysis.
  • Apply Snowflake best practices when working with semi-structured data.
  • Load and transform data.
  • Visualize data outside of Snowflake.
  • Employ Snowflake features in the reporting process and activities performed by the data analyst to create analytic visualizations.
  • Explain Snowflake’s unique approach to caching and the benefits to query performance.
  • Perform query evaluation, pre- and post-execution, using Snowflake’s Explain, Query History, and Query Profile.

Prerequisites

  • Recommended completion of the “Snowflake Multi-Factor Authentication (MFA) Essentials” free on-demand course.
  • Basic knowledge of SQL is required.

Target Audience

  • Data Analysts
  • Business Intelligence users

Course Curriculum

Module 1: Data Analysis with Snowflake
Snowflake Overview

  • Why Snowflake?
  • Snowflake Functional Architecture
  • Platform Features
  • GettingStarted with Snowflake

Snowflake Architecture

  • Snowflake Architecture Layers
  • Snowflake Structure

Account Usage and More

  • Information Schema and Account Usage
  • Using Parameters to Control Snowflake
  • Query Tags
  • Sample Data Sets

Client Interfaces

  • Client Interface Overview
  • Authentication
  • Snowsight
  • SnowSQL
  • Connecting Tools to Snowflake

SQL Support in Snowflake

  • Data Definition Language (DDL)
  • Data Manipulation Language (DML)
  • Data Query Language (DQL)
  • Set Operations and Joins
  • Subqueries and Common Table Expressions
  • Dynamic Pivot Queries
  • Constructing Efficient Queries
  • Copilot

Functions in Snowflake

  • Function Overview
  • Estimation Functions
  • User-defined Functions
  • Stored Procedures
  • Snowflake Scripting

Other Snowflake Features

  • Collation
  • Sampling
  • Snowflake Tasks
  • Alerts

Creating More Complex Queries

  • Window Functions, Syntax, and Usage
  • Group By and Grouping Sets
  • Recursive With and Connect By

Semi-structured Data

  • Semi-structured Data Overview
  • Query Semi-structured Data

Continuous Data Protection

  • Time Travel
  • Cloning

Module 2: Collaboration
Data Loading

  • Data Loading Concepts
  • Examples of Data Loading

Module 3: Snowflake Data Lake Support
Reporting Using Snowflake

  • Explore Data
  • Prepare Data
  • Analyze Data
  • Visualize Data
  • Integrate BI Tools

Caching and Query Pruning

  • Metadata and Caching Overview
  • Metadata
  • Query Result Cache
  • Data Cache
  • Query Pruning

Visualizing Query Execution with Query Profile

  • Using Explain
  • Using Query Profile

Performance Tips and Troubleshooting

  • SQL Performance Tips
  • Performance Bottlenecks

Dates & Locations

Let’s make it work for you

Can’t find a date that fits? Need to train your whole team? Looking for a discount?
Speak to one of our learning experts today.

x Clear all selections
Trainocate exam and cert

Exam & Certification

SnowPro® Advanced: Data Analyst Certification Exam DAA-C01

SNOWPRO ADVANCED: DATA ANALYST OVERVIEW

This certification will test the ability to:

  • •Prepare and load data
  • •Perform simple data transformations for data analysis
  • •Build and troubleshoot advanced SQL queries in Snowflake
  • •Use Snowflake built-in functions and create User-Defined Functions (UDFs)
  • •Perform descriptive and diagnostic data analyses
  • •Perform predictive data analysis
  • •Prepare and present data to meet business requirements

Training & Certification Guide

Exam Version: DAA-C01
Total Number of Questions: 65
Question Types: Multiple Select, Multiple Choice, Interactive
Time Limit: 115 minutes
Language: English
Registration fee: $375 USD
India Registration fee: $300 USD
Passing Score: 750 + Scaled Scoring from 0 – 1000
Unscored Content: Exams may include unscored items to gather statistical information for future use. These items are not identified on the form and do not impact your score, and additional time is factored into account for this content.
Prerequisites: SnowPro Core Certified
Delivery Options:

  1. 1: Online Proctoring
  2. 2: Onsite Testing Centers

EXAM DOMAIN BREAKDOWN

The table below lists the main content domains and their weightings.

Domain Domain Weightings
1.0 Data Ingestion and Data Preparation 17%
2.0 Data Transformation and Data Modeling 23%
3.0 Data Analysis 32%
4.0 Data Presentation and Data Visualization 28%

RECOMMENDED TRAINING

As preparation for this exam, we recommend a combination of hands-on experience, instructor-led training and the utilization of self-study assets.

Instructor-Led Course recommended for this exam:

Snowflake Data Analyst Training

Register for the Snowflake Practice Exam now:

SnowPro Practice Exam: Data Analyst

Frequently Asked Questions

Speak to a Training Consultant

All courses are HRD Claimable.
Get in touch with our team via the form or WhatsApp us on +6011-5119 6631

Preferred mode of training
Checkboxes