Dan Galavan, Cloud Data Architecture Consultant

Cloud Data Architecture Consultant | Conference Speaker | Lecturer

  • Blog
  • Speaking events
  • Services
  • About
  • Contact

There will be Snowflake(s) in Rotterdam today!

There will be Snowflake(s) in Rotterdam today!

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…

By Dan Galavan | October 27, 2020 | Analytics, Data Integration, Data Lake, Data Warehouse, Snowflake Cloud Data Platform | 2 Comments |
Read more

Optimizing the Data Vault architecture on Snowflake & free SQL!

Optimizing the Data Vault architecture on Snowflake & free SQL!

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.

By Dan Galavan | October 8, 2020 | Analytics, Business Intelligence, Data ingestion, Data Lake, Data Modeling, Data Vault, Data Warehouse, DataLakeHouse, Snowflake Cloud Data Platform | No Comments |
Read more

Snowflake Snowsight: 7 refreshing features

Snowflake Snowsight: 7 refreshing features

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. 

By Dan Galavan | July 16, 2020 | Analytics, Business Intelligence, Data Warehouse, Snowflake, Snowflake Cloud Data Platform, Snowsight | No Comments |
Read more

Power BI & Snowflake at the Microsoft Community Café

Power BI & Snowflake at the Microsoft Community Café

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 | May 20, 2020 | Analytics, Business Intelligence, Data Warehouse, PowerBI, Snowflake | No Comments |
Read more

“In honor of Kevin Bacon” The skinny on Graph Databases (interview)

“In honor of Kevin Bacon” The skinny on Graph Databases (interview)

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?…

By Dan Galavan | May 19, 2020 | Graph database, Interview | No Comments |
Read more

AWS AppFlow & the Snowflake Cloud Data Platform

AWS AppFlow & the Snowflake Cloud Data Platform

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…

By Dan Galavan | May 4, 2020 | Analytics, AWS, Data Flow Automation, Data ingestion, Data Integration, Data Warehouse, Snowflake | No Comments |
Read more

Three top takeaways from The Great Debate

Three top takeaways from The Great Debate

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,…

By Dan Galavan | April 23, 2020 | Analytics, Business Intelligence, Data Lake, Data Modeling, Data Vault, Data Warehouse | No Comments |
Read more

A Monday morning reflection

A Monday morning reflection

At the beginning of this year I became an Associate Faculty with the School of Computing at the National College of Ireland. The College augments it’s full time staff roster with experts from industry in a part time lecturing capacity.…

By Dan Galavan | March 23, 2020 | Uncategorized | No Comments |
Read more

Graph Database in Microsoft Azure Database and SQL ’17

Graph Database in Microsoft Azure Database and SQL ’17

Graph databases are made up of nodes, edges (relationships between nodes), and properties. Patterns are identified by searching or “traversing” the graph, and use cases include recommendation engines, social networks, and fraud detection. Microsoft have made Graph Database functionality available…

By Dan Galavan | March 3, 2018 | Microsoft SQL Server |
Read more

3 practical tips for Master Data Services 2016 permissions configuration

3 practical tips for Master Data Services 2016 permissions configuration

Microsoft SQL Server Master Data Services 2016 (MDS) provides comprehensive permissions configuration functionality, from the functional permissions level right down to column and row level. However there are a few gotchas that if you are aware of up front, will…

By Dan Galavan | May 17, 2016 | Business Intelligence, Microsoft SQL Server 2016, Microsoft SQL Server Master Data Services 2016 |
Read more
  • « Previous

Recent Posts

  • There will be Snowflake(s) in Rotterdam today!
  • Optimizing the Data Vault architecture on Snowflake & free SQL!
  • Snowflake Snowsight: 7 refreshing features
  • Power BI & Snowflake at the Microsoft Community Café
  • “In honor of Kevin Bacon” The skinny on Graph Databases (interview)
  • AWS AppFlow & the Snowflake Cloud Data Platform
  • Three top takeaways from The Great Debate

 

About

Disclaimer

Contact: info@galavan.com

Copyright ©2021 Dan Galavan, Cloud Data Architecture Consultant | Theme by: Theme Horse | Powered by: WordPress