Snowflake SnowPro Advanced Data Analyst Certification

• Handson: Create a Snowflake account

• Organization, Accounts and Editions
• NumPy In Python
• PandasDataFrame and Series
• Data Manipulation with Pandas and NumPy
• Reading Data from Various Data Source Using Pandas
• Data Visualization with Matplotlib
• Data Visualization with Seaborn

• Introduction to Statistics
• Types of Statistics
• Population and Sample Data
• Types of Sampling Techniques
• Types of Data
• Scales of Measurement of Data

• Data Ingestion Overview
• Measure Of Central Tendency (Mean, Median and Mode)
• Measures Of Dispersion (Range, Variance, Standard Deviation)
• Why Sample Variance is divided by n1
• Random Variables
• Percentiles And Quartiles
• Number Summary
• Histogram And Skewness
• Covariance And Correlation

• Pdf, PMF, CDF
• Types OF Probability Distribution
• Bernoulli Distribution
• Binomial Distribution
• Poisson Distribution
• Normal or Gaussian Distribution
• Standard Normal Distribution
• Uniform Distribution
• Log Normal Distribution
• 10Power Law Distribution
• 11Pareto Distribution
• Central Limit Theorem
• Estimates

• Hypothesis Testing and Mechanism
• P value And Hypothesis Testing
• Z test Hypothesis Testing
• Student t Distribution
• T stats With T Test and Hypothesis Testing
• Z test vs T test
• Type1 And Type 2 Error
• Baye's Theorem
• Confidence Interval and Margin of Error
• What is Chi Square Test
• Chi Square Goodness of Fitness
• What is Anova
• Assumptions Of Anova
• Types Of Annova
• Partioning OF Annova

• Introduction for Loading Data to Snowflake.
• Feature EngineeringHandling Missing Data
• Feature EngineeringHandling Imbalanced Dataset
• Feature EngineeringSMOTE
• Handling Outliers with Python
• Data EncodingNominal/One Hot Encoding
• Label And Ordinal Encoding
• Target Guided Ordinal Encoding

• Red Wine Dataset EDA
• EDA Flight Price Dataset
• Part 1Data Cleaning Google Playstore Dataset
• Part 2EDA Google Play Store Dataset

• SQL Select Statement
• SQL Select Distinct
• SQL Temporary Tables
• SQL Where Clause
• SQL Order by Clause
• SQL AND & OR Operator
• SQL NOT, BETWEEN & IN Operators
• SQL Insert Into
• SQL Null Operator
• SQL Update Statement
• Delete, Drop & Truncate
• SQL Comments & TOP N
• SQL MAX & Group BY
• SQL MIN Function & Group BY
• SUM, AVG, COUNT & Group BY
• Group BY Concept
• Group BY Example SQL Server
• SQL Having Clause
• SQL Where & Having Clause Difference
• Inner Join Concept
• Inner Join Example
• Left Join Concept
• Left Join Example
• Right Join Concept
• Right Join Example
• Left & Right Anti Join
• Left & Right Anti Join Example
• Full Outer Join
• SelfJoin
• Union & Union All
• SQL Like Operator
• SQL Case in Select statement & Order BY Clause
• Nested CASE statement
• SQL Data Types
• SQL Create Table
• Inserting Records into All Columns of the Table
• Inserting Records into Certain Columns in a Table
• Copying Data from One Table to Another
• Sub Queries
• Not Null Constraint
• Unique Constraint
• Check Constraint
• Default Constraint
• Primary & Foreign Key Concept
• Primary Key Constraint
• Foreign Key Constraint
• SQL Order of Execution

• Rank, Dense Rank & Row Number Window Functions 1
• Rank, Dense Rank & Row Number Window Functions 2
• Window Functions Lead Function
• Window Functions Lag Function
• ISNULL & Coalesce Functions
• First_Value() Window Function
• Last_Value() Window Function

• Common Table Expressions 1
• Common Table Expressions 2
• Recursive Common Table Expressions
• Stored Procedure in MS SQL Server
• Views in MS SQL Server
• Indexes in MS SQL Server
• Clustered Index
• NonClustered Index

• Business Requirements
• Loading Data to PBI Desktop
• Data Profiling & Data Transformations Part 1
• Data Transformations Part 2
• Primary & Foreign Key
• Cardinality
• Star Schema
• Data Model Overview
• Different Types of Filters in Filters Pane
• Top Bottom 5 Products by Sales, Quantity and Profit
• Sales Trends Over Time
• Other Requirements
• Requirement 4 DAX
• Requirement 4 Edit Interactions
• Other Remaining Requirements
• Changing Filter Behaviour for Dimension Table Slicers

• Downloading & Installing MSSQL Server
• Importing Data to MSSQL Server
• Loading Data to Power BI Desktop
• Table View & Data Profiling
• Adding Slicers & Text
• Adding New Card Visuals
• Adding a Multi Row Card & a Ribbon Chart
• Adding a Bar & a Line Chart
• Adding a Donut Chart & Matrix Visual
• Publishing the Report to Power BI Service
• Scheduling Refresh
• Drill Through Filter
• Testing Scheduled Refresh & Publishing the updated report
• Creating & Testing Roles in PBI Desktop
• Testing & Implementing RLS in Power BI Service
• Power BI Reports & Dashboards
• Sentiment Analysis Power Query
• Sentiment Analysis Adding Visuals to the Report

• Loading Data into Power BI Desktop
• Data Profiling
• Size & Position of slicers
• Formatting the Slicers
• Adding a Page & Age Group Column
• Adding a Line Chart
• Adding a Matrix Visual
• Syncing Slicers & Applying Conditional Formatting
• Adding Bookmarks for Transactions
• Adding Bookmarks for Remaining Balance
• Publishing the Report to Power BI Service

• Creating Snowflake Free Trial Account
• Creating a SQL Worksheet
• Snowflake Architecture
• Setting up a Warehouse in Snowflake
• Signing up for an AWS Account
• Creating S3 Bucket
• Uploading Data to Amazon S3 Bucket
• Creating Roles using IAM
• Creating Integration Object
• Loading Data
• Creating Free Azure Account
• Creating Storage Account in Azure
• Creating Containers in Azure & Loading Data in Containers
• Creating Integration Object to Connect to Azure
• Creating the stage area & loading data in table in snowflake

• Connecting Snowflake to Power BI
• Connecting Snowflake to Tableau

• Creating Amazon S3 Bucket & Loading Data into it
• Creating the Role
• Creating the Integration Object & Updating the Trust Policy
• Loading Data into Snowflake
• Understanding the Data
• Data Transformation using Snowflake SQL
• Adding Rainfall Groups Column
• Importing Data into Power BI from Snowflake
• Adding Rainfall Analysis page in the Power BI report
• Adding Other Pages to the Power BI report
• Publishing the report to Power BI Service

• Creating & Loading Data to S3 Bucket
• Creating the Role
• Creating the Integration Object & updating the trust policy
• Loading Data into Snowflake
• Data Understanding
• Data Transformation using Snowflake SQL
• Connecting Snowflake to Tableau
• Creating Charts for Monthly Usage Consumption
• Creating Charts for Cost Savings
• Creating the Dashboard
• Publishing the workbook to Tableau Cloud

No prior statistics degree is required. The course builds statistical knowledge from first principles — descriptive stats, probability distributions, and hypothesis testing — with practical Python examples before applying them in a Snowflake analytics context.

Both Power BI Desktop (free) and Tableau Public (free) are used throughout. Labs also cover connecting to Power BI Service and Tableau Cloud using trial accounts, so you can complete all exercises without purchasing paid licenses.

Basic Python familiarity — variables, loops, functions — is helpful but not mandatory. The course covers NumPy, Pandas, Matplotlib, and Seaborn from an applied data analysis perspective with step-by-step lab guides for each library.

Yes. The curriculum maps to the SnowPro Advanced Data Analyst exam domains including Snowflake connectivity, advanced SQL analytics, semi-structured data handling, statistical analysis, and BI tool integration.

Projects use real-world style datasets covering retail sales, UPI payment transactions, insurance claims, and Google Play Store app data — giving you broad domain exposure and portfolio-ready work across the full analytics curriculum.

Yes. The course includes dedicated labs for both AWS S3 and Azure Blob Storage integration with Snowflake, including IAM and Azure role configuration, so you can complete hands-on work with whichever cloud provider you have access to.