Subscribe to my posts
-
Recent Posts
Archives
- May 2018 (1)
- January 2018 (1)
- October 2017 (1)
- July 2017 (2)
- June 2017 (2)
- May 2017 (1)
- April 2017 (1)
- December 2016 (1)
- November 2016 (1)
- October 2016 (1)
- September 2016 (1)
- August 2016 (1)
- June 2016 (1)
- April 2016 (1)
- March 2016 (1)
- February 2016 (2)
- January 2016 (2)
- December 2015 (2)
- November 2015 (1)
- October 2015 (2)
- September 2015 (1)
- August 2015 (2)
- July 2015 (4)
- June 2015 (6)
Tags
- Alteryx
- Analysis
- API
- Audit Trail
- Automation
- BSON
- Connector
- Dashboards
- data blending
- data lake
- data processing
- Documentation
- excel
- GA
- Google Analytics
- Headcount
- How To
- HR
- INDB
- JSON
- Marketo
- MongoDB
- Operations
- performance
- Planning
- R
- Redshift
- RegEx
- SFDC
- Snowflake
- SQL
- Tableau
- User Experience
- User Interface
- VLOOKUP
- word cloud
- YoY
- YTD
Blog Roll
- Adam Riley – Chaos Reigns Within
- Andy Kriebel – VizWiz
- Chris Love – Sciolistic Ramblings
- Information Lab Blog
- John Mathis – Tableau Blog
- Jonathan Drummey – Drawing with Numbers
- Ken Black – 3danim8's Blog
- Sculpting Data by Daniel Kresina
- The Last Data Bender – Alan Eldridge
- Wicked Cool Alteryx Workflows
Category Archives: Snowflake
How to filter transactions by a calculated category using SQL Window Functions
Have you ever found yourself in a situation where you need to filter a set of transactions based on categories which need to be calculated from that same set? Let’s say you have a data set containing all the customer … Continue reading
Posted in Alteryx, Marketing, Performance, Redshift, Snowflake, SQL
Tagged INDB, SQL
Leave a comment
How to Load Data in Bulk to Snowflake with Alteryx
Why a post about Snowflake? What does Alteryx and Tableau have to do with Snowflake? Here is some context: as I was planning to launch my Data Lake consulting business, which is now launched, I was looking for a place … Continue reading