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...
by Dan Galavan | May 20, 2020 | Analytics, Blog, Business Intelligence, Data Warehouse, PowerBI, Snowflake
Do come join me on the 25th May at the Microsoft Community Café to walk through the architectural principles of the Snowflake cloud data warehouse, the enhanced PowerBI Snowflake connector, and see both PowerBI and Snowflake in action....
by Dan Galavan | Apr 23, 2020 | Analytics, Blog, Business Intelligence, Data Lake, Data Modeling, Data Vault, Data Warehouse
Yesterday I attended the Great Data Minds debate on the pros and cons of different data architectures. The panel: Hans Hultgren: CEO, Genesee Academy – defending DataVaultScot Reagin: CEO, Sensible Data Integrations – defending TraditionalTyler...