SnowPro Advanced Data Analyst: Data Transformation and Modeling
Snowflake offers a unique and powerful data storage platform that has many efficiencies for storing and querying your data. This course will teach you to effectively load, query, model, and optimize your Snowflake data for data analytic use cases.
What you'll learn
This course covers the full data lifecycle of loading, cleaning, and optimizing for the use case of performant data analytic solutions connected to Snowflake.
In this course, SnowPro Advanced Data Analyst: Data Transformation and Modeling, you’ll gain the ability to effectively load, query, and optimize data for business intelligence in Snowflake.
First, you’ll explore Snowflake data loading.
Next, you’ll discover data cleansing, querying, and modeling.
Finally, you’ll learn how to optimize and debug SQL performance in Snowflake.
When you’re finished with this course, you’ll have the skills and knowledge of Snowflake needed to be an effective data analyst.
Table of contents
- Modeling Data and Optimizing Performance 1m
- Aggregate and Analytical Functions 4m
- Data Classification and Enrichment 3m
- Optimization Techniques and Query Performance 3m
- Data Modeling Techniques 5m
- Demo: Using and Understanding Time Travel 4m
- Demo: Querying and Manipulating JSON Data 6m
- Demo: Performance and Optimization 9m
About the author
Ian is a cloud data engineer focusing on data management and cloud solutions. He has a passion for database technologies, particularly Snowflake, and enjoys building efficient data pipelines. Skilled in SQL, Python, and ETL tools like Apache Airflow, Ian is experienced in creating scalable databases and optimizing data processes. He also contributes to tech blogs and designs practical learning content.