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 deduction”. We can…
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 accessibility, and…
The team at SqlDBM have invited me to share my Snowflake Data Cloud and data modeling expertise, reflect on current industry trends, and discuss the role that data modeling plays in the context of the Snowflake Data Cloud. During the…
Today I will pack my virtual suitcase and take a virtual flight to deliver a virtual lecture at the Rotterdam University of Applied Sciences. OK, so there won’t be actual snow in Rotterdam today. In fact the weather forecast is…
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 recording, the SQL scripts are now available.
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.
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.
Recently I gave an interview on Graph databases to Great Data Minds’s Mike Lampa and Kalia Garrido. Areas covered included an introduction to Graph databases, use cases, anti-patterns, the hype, and what have they got to do with Kevin Bacon?…
Introduction AWS Appflow is a new data integration service which as the tagline states, securely integrates apps and automates data flows at any scale, without code. It offers a variety of features such as: Point and click user interface Native…
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 DataVault Scot Reagin: CEO, Sensible Data Integrations – defending Traditional Tyler Allbritton: Managing Director,…