by Dan Galavan | Jan 27, 2026 | AI, Business Intelligence, Data Governance, Data Integration, Data Modeling, Snowflake
Introduction: Semantic Layers are not new. I first used them back in the noughties. I’ve designed, configured, and led their delivery in a variety of analytical solution initiatives, not least Enterprise Data Warehousing. I’ve worked with numerous Semantic Layer...
by Dan Galavan | Jan 22, 2024 | Business Intelligence, Data Governance, Data Integration, Data Lake, Data Modeling, Data Vault, Snowflake Data Cloud
Data modeling is a key component of any analytical or operational data processing initiative. It’s critical to how data is both processed and governed in areas such as gaining data insights, data quality management, and data literacy. The most succinct description of...
by Dan Galavan | May 20, 2021 | Analytics, Blog, Business Intelligence, Data Warehouse, Snowflake Data Cloud, Snowflake Data SuperHero, Snowsight
Sherlock Holmes, the fictional private detective, uses a combination of observation, deduction, forensic science, and logical reasoning to investigate cases. He applies these facets to great effect in solving those cases. This process is known as “Holmesian...
by Dan Galavan | Apr 14, 2021 | Analytics, Blog, Business Intelligence, Data Flow Automation, Data Integration, Data Lake, Data Modeling, Data Vault, Data Warehouse, Snowflake Data Cloud
A data model is a communication tool Data models are core components of a successful data pipeline, whether formally or informally. They influence how Data Engineers develop the desired data transformation logic. Data models support data governance, data...
by Dan Galavan | Oct 8, 2020 | Analytics, Blog, Business Intelligence, Data ingestion, Data Lake, Data Modeling, Data Vault, Data Warehouse, DataLakeHouse, Snowflake Cloud Data Platform
Data Vault physical Data Model designed for the Snowflake Cloud Data Platform using SQLDBM Following on from my recent presentation at the virtual Munich Data Modeling Meetup on how to optimize the Data Vault architecture on Snowflake, along with the session...
by Dan Galavan | Jul 16, 2020 | Analytics, Blog, Business Intelligence, Data Warehouse, Snowflake, Snowflake Cloud Data Platform, Snowsight
With the acquisition of Numeracy in March 2019, Snowflake took a step towards enhancing the Snowflake Cloud Data Platform web user experience. This is in the form of a new offering called Snowflake Snowsight. Not only does Snowsight provide features such as...
