Subscribe to my posts
-
Recent Posts
Archives
- May 2020 (1)
- June 2019 (1)
- April 2019 (3)
- 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
- hierarchy
- 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
Category Archives: SQL
How to Import SFDC Recursive Hierarchies to Tableau
If you have dealt with hierarchies from Salesforce (SFDC), or from most normalized transactional systems, you have faced some challenges to use those hierarchies in Tableau. Those systems treat hierarchies as a recursive model, storing Parent to Child relationships in … Continue reading
Posted in Alteryx, Automation, Marketing, Sales, SFDC, SQL, Tableau, Uncategorized
Tagged hierarchy, SFDC
Leave a comment
Snowflake Summit 2019 Debrief
I was very excited at the thought of attending the first edition of the Snowflake customer event In San Francisco last week, and the event did deliver…
Posted in Alteryx, Automation, Performance, Snowflake, SQL, Tableau, Uncategorized
Leave a comment
Alteryx INDB Traps and Limitations Series: Filtering Nulls
I get to spend a lot of quality time with INDB tools, which represent 90% of my workflows. I love them, I can generate code almost at the speed of thoughts. They are fast to put together but also very … Continue reading
Posted in Alteryx, Redshift, Snowflake, SQL
Leave a comment
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