Snowflake Training –

Data Modeling – 

Introduction

  • Duration: 1 day
  • Prerequisites: Foundational understanding of SQL
Data Modeling training on Snowflake Data Cloud using SqlDBM

Training overview

  • This training module is designed for Data Professionals who wish to learn about data modeling – what it is, how to model data, along with best practices & tips
  • Through a blend of theoretical and hands-on content, participants will build an end-to-end understanding of data modeling using SqlDBM Data Modeling tool & the Snowflake Platform
    • As a reference architecture, it will also cover Snowflake’s distinct features, workloads, and the role that data modeling plays in this context
  • This training ensures that participants will develop technical expertise regarding data model delivery, quality and cost-effectiveness
  • Attendees will be equipped with the expertise required to navigate the data modeling challenges of modern data environments

Your team will learn

  • Core concepts of Data Modeling
  • The Data Modeling lifecycle in the context of the Snowflake Platform
  • The Entity Relationship Diagram (ERD) & Snowflake
  • Metadata management
  • Data Modeling roles
  • How to collaborate for successful data model delivery
  • Data Modeling end-to-end in the context of solution delivery
  • Using Data Modeling for Data Governance
  • Data Warehousing, Data Lakes, Data Lakehouse, and Data Mesh in the context of Data Modeling
  • Data model maintenance

Geared towards

  • Data Analysts
  • Data Architects
  • Database Administrators
  • Data Engineers
  • Data Integration Architects
  • Solution Architects
  • Data Governance Architects and Engineers
  • Anyone who has the requirement of combining structured and unstructured data for analytics on the Snowflake Data Cloud

 

 

© Dan Galavan 2025

About the instructor

Uniquely, Dan Galavan possesses a wide berth of Snowflake, educational, and data industry expertise, having advised clients and led the delivery of data solutions in both the private and public sector for 27 years.

Data Architecture Industry expertise

Over the course of his data solution design and delivery career across a variety of industries, Dan has worked on over 200 projects.  This spans areas such as Data Modeling, Master Data Management, Data Warehousing, Data Migration, Data Interoperability, and Data Strategy.

Snowflake training expertise

Dan has delivered and led the delivery of Snowflake Data Cloud solutions in a variety of industries such as Healthcare and Financial Services. He has been awarded the Snowflake Data Superhero Program credential for community contributions for the last 5 years. Dan is a regular speaker on the Snowflake Data Cloud circuit, having delivered presentations and hands-on labs at a variety of conferences and events, such as the official Snowflake Ireland launch, the World Wide Data Vault Consortium, The Knowledge Gap, the 2023 Snowflake World Summit, and the 2024 Data Innovation Summit.

He was also the first person in Europe to delivery the “Zero to Snowflake in 90 Minutes” Hands-on lab. 

Academic expertise

In addition to consultancy, Dan has also worked as an Associate Faculty Lecturer in Data Management at the National College of Ireland. He has also delivered Snowflake Data Cloud lectures at third level educational institutions such as the Technical University Dublin, Ireland, and Rotterdam University, The Netherlands. 

“We organized a two-week technology summit for a US-based government agency. We needed the top speakers from each discipline and therefore chose Dan Galavan as our speaker on Snowflake. He impressed the agency with his in-depth knowledge of Snowflake and broader knowledge of databases in general. His clear and precise way of explaining concepts was very much appreciated by the group.”
Steve Hoberman

Director, Technics Publications, Arizona, U.S.A.

“Dan Galavan’s training session on the latest updates in Snowflake Data Cloud technology was a resounding success. As an IT academy, we deeply appreciate Dan’s flexible approach, always prioritizing customer satisfaction. His willingness to adapt to the unique needs of our clientele ensures that every training session is tailored to maximize learning outcomes. Dan’s commitment to excellence and customer-centric approach makes him a standout trainer in the field. We eagerly anticipate future collaborations with him to continue delivering exceptional educational experiences.”
Bart Marciniak

Head Of Sales, infoShare Academy sp. z o.o.

“Dan demonstrated a seamless delivery of a consolidated training agenda covering SQL, data modeling, and data warehousing on the Snowflake Data Cloud. Dan delivered the training to a diverse group of microfinance professionals from different markets in the MENA region in which the Vitas microfinance group operates. The trainees showed commitment, enthusiasm and engagement throughout the 5 day training and took away extensive hands-on experience with the Snowflake Data Cloud, thanks to Dan’s smooth, clear and structured delivery and most of all to his in depth knowledge and passion for the material topped with a calm, professional and positive attitude.”
Rola El Amine

Digital Business Manager, Vitas Group.