Data Visualization with Snowflake
How can a business intelligence group transition from relational database T-SQL to Snowflake SQL and functions? This course will teach you the ins and outs of writing Snowflake SQL statements to visualize data in analytical reporting tools.
What you'll learn
In order for visualizations to display correct analytics, Snowflake SQL and aggregation functions need to be in place to summarize and pinpoint data for KPIs. This code will need to take advantage of Snowflake-specific syntax that is sometimes different from relational database syntax.
In this course, Data Visualization with Snowflake, you will gain the skills to aggregate data using SQL in Snowflake. First, you will start with the syntax of Snowflake SQL for retrieving data. Next, you will see how to add SQL functions to SQL statements to enhance the aggregated data while visualizing in a Snowflake workspace. Finally, you will discover how the SQL created is used to import data in visualization tools, and how visuals are used for storytelling to enhance the visuals initially used in a Snowflake workspace. When you're finished with this course, you'll have the skills and knowledge of Snowflake needed to create successful data visualizations.
Table of contents
About the author
Thomas LeBlanc (Microsoft Data Platform MVP) is a Data Enthusiast in Baton Rouge, La. He started his IT career as a COBOL programmer in 1989 while at LSU. Since then he has spent years as a developer, DBA and Data Warehousing/Business Intelligence Architect. Community involve includes the local SQL Server and Analytics User Groups as well as SQLSaturday. Speaking engagements have been a blessing at SQL Pass Summit, Live 360, VSLive and IT Dev Connections.