Subscribe to my posts
-
Recent Posts
Archives
- 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
- 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
Author Archives: Frederic
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
Access and Process Leads Activity History with Marketo Bulk Extract APIs
Marketo’s core expertise is Marketing Automation, a software category it pioneered along with Eloqua, Pardot, Hubspot, Adobe and now 208 additional vendors and counting. Marketo still holds a solid market share, especially on the West Coast, especially in Tech companies. … Continue reading
Word clouds with Alteryx and R
In a previous post, I explained how to build word clouds easily with a combination of Alteryx and Tableau. But what happens without Tableau? It turns out that Alteryx can leverage the power of existing R libraries to easily generate … Continue reading
Navigating Alteryx Maze of Tools
Alteryx is objectively an amazing tool to manipulate data and models, without coding (much). As I mentioned in earlier posts, that simplicity involves trade offs. One of those is the initial difficulty to apprehend the potential and capabilities of the … Continue reading
Posted in Alteryx
Leave a comment