Reporting with Snowflake

Scott Andersen
5 min readAug 13, 2023

Advanced SQL | Stored Procedures | BI Tools

If you work with data, you’ve probably heard someone mention Snowflake. The Snowflake Data Cloud stores data for thousands of organizations, across every industry of business today. Their platform is an excellent option for all kinds of work loads, from AI and Machine Learning to Data Engineering and Cybersecurity. But what you don’t hear as often is how to leverage Snowflake to build analytics projects, how to automate business intelligence reporting with tools like Tableau, Streamlit, or even Power BI.

Agenda:

  1. Playing with Transactional data
  2. Stored Procedures (SQL)
  3. Building a Report

PLAYING WITH TRANSACTIONS

Dim and Fact tables are key concepts used in the context of data warehousing and relational database design, particularly in the realm of business intelligence and analytics. They are components of the Snowflake schema, which are approaches to organizing data for efficient querying and reporting. Transactional databases are commonly used in applications where data accuracy and integrity are critical, such as…

--

--