Data Mapping

Patrick Cuba
9 min readAug 17, 2021

An oldie but goodie…

How great is excel? You can add comments below this article to express your love for it! I am a fan too but what often happens is that Excel gets abused; used way beyond its limitations, way beyond it was designed to handle; think VBA + Excel + 2m+ records! and Excel starts getting used as a database! I do like Excel and I use it for data mapping because chances are that the business understands Excel and we can easily talk about the elements in excel without getting lost in translation.

--

--

Patrick Cuba

A Data Vault 2.0 Expert, Snowflake Solution Architect