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 seasoned data aficionado who thrives at the crossroads of technology, specializing in the Microsoft data ecosystem. His mastery extends beyond SQL Server, encompassing airflow-driven ETL processes, Python development, and the orchestration of cloud architecture across AWS and Azure. Ian's proficiency also spans Salesforce integrations, harmonizing SQL, and championing technical communication. With a passion for bridging data silos and enabling data-driven decision-making, Ian brings a ... more