thinQmaster Virtual testing partner Adaptive practice exams that find your weak spots and drill them. Every answer explained. From $59
Enroll

thinQmaster

Find your exam

Five questions free, before you decide.

Step 1 · choose a vendor

In one of our camps? Your practice exams come with the tuition — they are on your study page already.

Using Army CA, Air Force, Space Force or SpouseWorks? Get the itemized quote your program asks for in one minute.
Get my military quote
Courses  /  Snowflake  /  Snowflake SnowPro Advanced: Data Analyst (DAA-C01)
Exam DAA-C01SnowPro Advanced: Data Analyst Snowflake

Snowflake SnowPro Advanced: Data Analyst (DAA-C01)

Three days of advanced analysis in Snowflake: preparing data, advanced SQL, functions and UDFs, forecasting and presenting results. Prepares you for SnowPro Advanced: Data Analyst.

Three days, instructor-led In class or live online Class Hub + 90 days Military funding accepted

Course overview

Core firstSnowPro Core requiredSnowflake requires an active SnowPro Core certification for this exam
Hands-onWork in SnowflakeLab guide for a Snowflake trial account you keep using after class
3 days+ 90 days of Class HubLive class, then recordings, labs and practice exams for 90 days after

thinQtank® Learning is offering a unique three-day training camp comprised of three days of instructor-led learning that gives students the knowledge and skills needed to work with data analysis on Snowflake: preparing and loading data, transforming it for analysis, building and troubleshooting advanced SQL, built-in functions and UDFs, descriptive, diagnostic and predictive analysis, and presenting data to meet business needs.

The camp follows the abilities Snowflake publishes for this certification, with hands-on work in Snowflake throughout. SnowPro Core is Snowflake's foundation certification and the gateway to the Advanced and Specialty exams.

Snowflake and SnowPro are trademarks of Snowflake Inc.

This course prepares students to take the SnowPro Advanced: Data Analyst (DAA-C01) exam.

Your certification path

Where this course sits: what to have first, and where it leads.

Course objectives

What you will be able to do by the end of the class.

Prepare dataLoad and stage data for analysis and check its quality.
TransformUse joins, pivots, window functions and semi-structured data for analysis.
Advanced SQLDesign and troubleshoot complex queries with the query profile.
Functions and UDFsUse aggregate, analytic and geospatial functions and write SQL and Python UDFs.
AnalyzeRun descriptive, diagnostic and predictive analysis, including forecasting and ML functions.
PresentBuild Snowsight dashboards and connect BI tools.

Who it is for

Who gets the most from this class, and what to know before you start.

Who should attend

  • Data and business analysts working in Snowflake
  • BI developers and report builders
  • Analytics engineers
  • Service members, veterans and military spouses using AF COOL, Army Credentialing Assistance, MyCAA or VET TEC 2.0

Prerequisites

  • An active SnowPro Core certification (required by Snowflake before this exam)
  • Snowflake recommends 1 or more years of hands-on experience as a data analyst on Snowflake
  • Fluency in advanced SQL; another language is helpful

Course outline

6 modules. Open any one to see what it covers.

01Preparing and loading data
  • Loading and staging
  • Data quality checks
  • Profiling
02Transformations for analysis
  • Joins and pivots
  • Window functions
  • Semi-structured data
03Advanced SQL
  • Query design
  • Troubleshooting
  • Query profile
04Built-in functions and UDFs
  • Aggregate and analytic functions
  • Geospatial functions
  • SQL and Python UDFs
05Descriptive, diagnostic and predictive analysis
  • Statistical functions
  • Forecasting
  • ML functions
06Presenting data
  • Snowsight dashboards
  • BI tool connections
  • Communicating results

The full lesson-by-lesson outline is in the course datasheet (PDF).

Course features

How the class is taught, and why it works.

Live, instructor-ledEvery session is taught live by a certified instructor, in the classroom and online at the same time.
Hands-on labsLabs are built into the modules so you practise what you learn.
Exam preparation built inPractice questions and focused review aligned to exam DAA-C01.
Class Hub for 90 daysRecordings, materials and practice stay open for the class plus 90 days after it ends.
Attend your waySterling, VA, Atlanta, GA, Burbank, CA, or live online from anywhere.
Funding friendlyMilitary flat rate, thinQflex monthly payments, or a formal quote for your employer.

What you get

Everything below is included in the course price.

Class Hub access for the length of the class plus 90 days
thinQtank® Learning Accelerated Custom Exam Study Guide for the DAA-C01 exam
Hands-on lab guide for a Snowflake trial account
Custom and focused exam preparation software and materials
Course specific thinQtank® Learning publications to promote a fun and exciting learning
Membership to the thinQtank® Learning University Online
WE DO NOT "TEACH THE TEST" - Students will receive valuable examples and discussion
All courses taught by experienced Snowflake practitioners
Additional hours of remote lab access
Custom video recordings with even more in-depth learning of course topics
Customized practice exam software
Digital courseware
Retake any or all portions of the course as many times as you like in person or live on-line for 24 months
Six months mentoring access to our engineers after completing the course

Format: Three days, Monday to Wednesday, instructor-led · About 60% lecture and 40% hands-on work in Snowflake and practice exams · Instructor-Led Training, Immersive Live-Online Training, On-Site and Custom Delivery

Study plan

How the three days run, plus what to do before and after class.

Before class
  • Check the prerequisites above and fill any gaps
  • We send joining details and course materials before day one
Day 1
  • Preparing and loading data
  • Transformations for analysis
Day 2
  • Advanced SQL
  • Built-in functions and UDFs
Day 3
  • Descriptive, diagnostic and predictive analysis
  • Presenting data
  • Final review and exam strategy
After class
  • Class Hub stays open 90 days: recordings, labs and practice
  • Book your exam while the material is fresh

The order of topics can shift with the class; your instructor confirms the schedule on day one.

The certification exam

SnowPro Advanced: Data Analyst · exam DAA-C01

Exam codeDAA-C01
Questions65
Time115 minutes
Passing score750 / 1000
Format
Multiple choice and multiple select
Voucher
Exam voucher available — ask us to add it to your registration

DoD 8140 and college credit

What this certification counts for with the Department of Defense, and toward a degree.

DoD 8140 / 8570 This certification is not on the DoD 8570 baseline list. Under DoD 8140, a degree or qualifying training can also meet the requirement. See which certifications qualify in the DoD Workforce Navigator.
College credit None of the 9 universities in our College Credit Navigator publishes credit for this certification yet. Ask us for a free credit review and we will check your options.

Where it can take you

Roles this certification is commonly asked for.

Data AnalystAnswer business questions directly in Snowflake.
Business AnalystBuild trusted metrics and reports.
BI DeveloperFeed dashboards from well-built Snowflake queries.
Analytics EngineerModel and transform data for analysts.

Upcoming dates

Every class runs in the classroom and live online at the same time. Pick the dates; choose how you attend when you register.

DatesLocationFormat
Nov 30 – Dec 2, 2026 Sterling, VA Classroom + live online Reserve
Dec 14 – 16, 2026 Atlanta, GA Classroom + live online Reserve
Jan 4 – 6, 2027 Burbank, CA Classroom + live online Reserve
Jan 25 – 27, 2027 Sterling, VA Classroom + live online Reserve
Feb 8 – 10, 2027 Atlanta, GA Classroom + live online Reserve
Mar 1 – 3, 2027 Burbank, CA Classroom + live online Reserve
Mar 22 – 24, 2027 Sterling, VA Classroom + live online Reserve
Apr 5 – 7, 2027 Atlanta, GA Classroom + live online Reserve
Apr 26 – 28, 2027 Burbank, CA Classroom + live online Reserve
May 17 – 19, 2027 Sterling, VA Classroom + live online Reserve
Jun 7 – 9, 2027 Atlanta, GA Classroom + live online Reserve
Jun 21 – 23, 2027 Burbank, CA Classroom + live online Reserve

9 more dates through December 2027. Ask about a later date.

Paying for it

The price above is our standard rate. These options can bring it down or spread it out.

Military & veterans
$1,500

Flat rate per class when you use Air Force COOL, Army Credentialing Assistance, MyCAA or VET TEC 2.0. Your program confirms eligibility.

Funding details
thinQflex™
Name your price

Paying yourself? Tell us what you can pay and over how many months, up to twelve. We say yes, or come back with terms.

Make an offer
Employer or agency
Formal quote

A formal quote with the course and exam voucher as separate lines, valid 30 days. Group and government pricing available.

Request a quote

How to enroll

Four steps from here to certified.

  1. Pick your datesChoose a class from the dates above, in a classroom or live online.
  2. Reserve or get a quoteReserve your seat, ask for a quote for your employer, or make a thinQflex offer.
  3. Get readyWe confirm your seat and send joining details and materials before day one.
  4. Attend and certifyTake the class, then sit exam DAA-C01, with Class Hub open for 90 days after.

Frequently asked questions

Do I need SnowPro Core first?
Yes. Snowflake requires an active SnowPro Core certification before you can sit this exam.
How much SQL do I need?
Fluency in advanced SQL. Snowflake recommends a year or more as a data analyst on Snowflake; another language such as Python helps.
What does it cost?
The standard price is $2,550; exam voucher available — ask us to add it to your registration. Military students using AF COOL, Army CA, MyCAA or VET TEC 2.0 pay $1,500, and thinQflex lets you name your own price and monthly payment.
How long is the class?
Three days of live, instructor-led training.
Can I attend live online?
Yes. Every class runs live online at the same time as the classroom, with the same instructor and labs.
How long do I keep access to the materials?
Your Class Hub stays open for the length of the class plus 90 days.
Is the exam included?
The exam voucher is priced separately; we can add it to your registration or quote.
Can I use military funding?
Yes. With Air Force COOL, Army CA, MyCAA or VET TEC 2.0 you pay a flat $1,500 per class.
Can my employer pay?
Yes. Request a quote and we will send a formal one, valid for 30 days.
What if I cannot pay all at once?
Use thinQflex to name your price and spread payments over up to twelve months.
Where are the classrooms?
Sterling, Virginia; Atlanta, Georgia; and Burbank, California. Every class also runs live online, so you can join from anywhere.
What do I need to attend online?
A computer with a reliable internet connection, a headset or speakers, and a microphone. A webcam is recommended.
Will I get a certificate of completion?
Yes. You receive a thinQtank Learning certificate of completion when you finish the class.
Which course should I take next?
Most students go on to Snowflake SnowPro Core Certification (COF-C03), Snowflake SnowPro Advanced: Data Engineer (DEA-C02), Microsoft Power BI Data Analyst (PL-300). Tell us your goal and we will map the path with you.
Do you run private classes for teams?
Yes. We deliver private classes on-site or online for teams and agencies, on your dates. Ask for a quote.
Can you help me choose the right course?
Yes. Call 855-868-4467 or email sasmith@thinqtanklearning.com and we will recommend the right starting point.

Ready to earn your Snowflake SnowPro Advanced: Data Analyst (DAA-C01)?

Next class Feb 8 – 10, 2027 · Atlanta, GA and live online.