-
Recent Posts
Archives
- September 2022 (1)
- January 2022 (1)
- April 2021 (1)
- March 2021 (1)
- November 2020 (1)
- October 2020 (1)
- September 2020 (1)
- August 2020 (1)
- July 2020 (1)
- 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
- CTE
- Dashboards
- data blending
- data lake
- Data Prep
- excel
- Fivetran
- fuzzy logic
- GA
- Google Analytics
- Headcount
- hierarchy
- HR
- INDB
- JSON
- Marketo
- MongoDB
- Operations
- performance
- Planning
- R
- Redshift
- RegEx
- Search
- SFDC
- Snowflake
- SQL
- SQL Alteryx
- Tableau
- User Experience
- User Interface
- VLOOKUP
- Window functions
- word cloud
- YoY
- YTD
Blog Roll
Category Archives: Performance
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, Window functions
2 Comments
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
YoY YTD dashboard made easy in Tableau
When using a set of dated transactions which gets updated, how do you provide a report which will track visually a monthly YoY (Year over Year) YTD (Year to Date) comparison? This needs to work at the day level, to … Continue reading
10 Tricks to adopt Redshift In-DB
If you are still manipulating data in Excel, why should you care about In-DB and Redshift? Whether you are accessing your Redshift data through Alteryx or through Tableau, knowing how to prepare your data within Redshift, with In-DB tool in … Continue reading
Pathways to Analytics Automated Operations Nirvana
I already wrote a couple of posts on the topic of Automation of Operations using Alteryx, but I felt an update was in order, as the possibilities evolve so fast lately. I gauged some interest on the topic as well … Continue reading
Posted in Alteryx, Automation, Performance, Power BI, Qlik, Redshift, Tableau
Tagged Alteryx, Automation, Redshift
Comments Off on Pathways to Analytics Automated Operations Nirvana