Course 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.
What are the 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.
Who should attend this course
- Data Analysts
- Business Intelligence users
Course Curriculum
Course Modules
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
