27th Oct. 2020 – Guest Lecturer at Rotterdam University, the Netherlands
Topic: Cloud Data Warehousing using Snowflake as a reference architecture
22nd Sept. 2020 – Data Modelling Meetup – Munich
Data Vault is a modern, agile approach to building an enterprise data warehouse and analytics repository. It provides auditable, historical data which can be loaded at speed. Kent Graziano a.k.a. “The Data Warrior” published a series of blog posts detailing how to optimize Data Vault architecture on the Snowflake Cloud Data Platform. This talk will follow in those footsteps using worked examples and demos covering parallel data loading & separation of workloads, key management, and managing big data to support schema-on-read.
26th May 2020 – Snowflake and Power BI
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?
Will deliver a hands-on crash course on how the only data warehouse built for the cloud offers instant elasticity, secure data sharing, per-second pricing and many other features to enable the data-driven enterprise on behalf of Sonra.
Delivered two lectures to Computer Science Masters students on behalf of Sonra giving an introduction to cloud data warehousing using Snowflake DWaaS as a reference platform on behalf of Sonra.
17th October 2019 – Webinar: a 360° view of the patient primary care journey on Snowflake DWaaS
A recording of the Webinar is available here.
A 360° view of the patient primary care journey on Snowflake DWaaS on behalf of Sonra
Azure Data Factory & Data Vault datawarehousing
Deploying a Data Vault on a Snowflake elastic cloud data warehouse.
Azure Data Factory orchestration of a Data Vault data warehouse
Snowflake cloud datawarehouse case study on behalf of Sonra
Using Azure Data Factory for data integration with a Data Vault data warehouse
Including DataVault, Snowflake Elastic Cloud Data Warehouse, Fivetran Data Pipeline, and Knowledge Graphs
9th-Jun-2018 – SQL Saturday Cork – Enterprise Data Warehousing – the Data Architectural perspective
24th-Feb-2018 – SQL Bits 2018, London, UK – Lightning Talk – Graph Database in Azure DB and SQL Server 2017
5th- Dec-2017 –Dublin SQL Server User Group – Christmas 2017 Lightning Talks – Graph Database in Azure DB and SQL Server 2017
6th-Dec-2016 – Dublin SQL Server User Group – Christmas Lightning Talks Extravaganza – SQL Server and Data Lineage
06-Sept-2016 – Dublin SQL Server User Group – MS SQL Server Master Data services 2016
18-Jun-2016 – SQL Saturday 501 Dublin – MS SQL Server Master Data services 2016 – how far can it take your business?
- Of 142 session submissions 25 were selected including this one
- SQL Saturday 501 – venue – the National College of Ireland, Mayor Street, IFSC, Dublin 1.
- Click here to watch the talk on Microsoft’s channel 9
07-May-2016 – SQL Bits 2016, Liverpool – Master Data Services Lightning Talk
08-Dec-2015 – Dublin SQL Server User Group – MS SQL Server Master Data Services 2016 – Entity Synchronization
18-Sep-2015 – Dublin SQL Server User Group – MS SQL Server Master Data Services – How far can it take your business?
21-May-2015 – Belfast SQL Server User Group – MS SQL Server Master Data Services – How far can it take your business?
09-Dec-2014 – Dublin SQL Ireland User Group – Master Data Services Whistle-stop Tour
25-Sep-2014 – Irish Computer Society/IASA – Mining Bitcoins or Business Automation – Which is More Profitable?