Monthly Archives: October 2020

Cross Tab and Transpose INDB with Snowflake using Pivot and Unpivot

Data for analytics can be structured in two different ways: Wide or Long. Here is an illustration of the two types of format for the same data set: When would you use one vs. the other? In general, wide models … Continue reading

Posted in Alteryx, Snowflake, SQL | Tagged , , | Leave a comment