Subscribe to my posts
-
Recent Posts
Archives
- November 2018 (1)
- October 2018 (1)
- August 2018 (1)
- July 2018 (1)
- May 2018 (2)
- 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
- Bug
- Connector
- Dashboards
- data blending
- data lake
- Data Prep
- data processing
- Documentation
- excel
- GA
- Google Analytics
- Headcount
- How To
- HR
- INDB
- JSON
- Marketo
- MongoDB
- Operations
- performance
- Planning
- R
- Redshift
- RegEx
- Search
- 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
TC18 Tableau Conference Highlights
I skipped the Tableau conference last year as it was taking place in Vegas, and that is usually not a good experience, even without crowd shooters. I was happy to partake again this year to TC18, which took place in … Continue reading
Faster field name edits in Alteryx
From a distance, editing field names might not seem such a big issue, worth dedicating a blog post. Yet, I realize how much experience I gained over time, dealing with such minor issues, which end up affecting my productivity significantly … Continue reading
Weird query results on Snowflake
If, when you use Tableau or Alteryx to query a Snowflake Database, you are getting weird $ amounts, not matching what is the database, you are experiencing a known bug in the recent versions of the Snowflake ODBC driver: https://support.snowflake.net/s/article/Regression-in-ODBC-v2-16-4-v-2 … Continue reading
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