-
Course
- Data
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
About the author
Ian is a database enthusiast with particular expertise in the Microsoft data stack. Other technologies that Ian has expert level experience with include ETL, Python development, cloud architecture and systems automation. Ian holds the Microsoft Certified Solutions Expert (MCSE) for data management and analytics as well as the AWS Solution Architect associate certifications. Ian also writes for multiple technical blogs including SuperFunSQL.com which he founded in 2019.
More Courses by Ian