Cash Flow Analysis

[AlecB]

Hi All!

Curious if anybody has a cash flow analysis workflow that they can share? 

[CatherineM]

Excellent question! @AlecB 

@fosterking @rsomani005 @alyon - Have we had any past presenters share in regards to Cash Flow analysis? Thanks! 

-- Cat Martinez 

[rsomani005 · Accepted solution]

Hi,

I was working with daily cash flow payments data for the past 19 months. I used Alteryx to summarize the data into weekly payments and then used the distribution analysis to tool to check the distribution of the data. Once I was able to confirm that my data was normally distributed, I used Z-score to identify those weeks with an abnormal level of payments (i.e. more than 2 standard deviations)

Hope this helps.

[AlecB]

@rsomani005 Thank you very much!!

[Lvasu · Accepted solution]

Hi! We hosted a webinar last week with a live demo of cash flow analysis using Alteryx. You can check it out here, https://pages.alteryx.com/webinar-simplifying-analytics-in-finance-on-demand.html

[CatherineM]

Awesome content @Lvasu  @rsomani005 , thank you so much for sharing! 🙂

-- Cat Martinez

[alyon]

This is great! @AlecB - did you watch the recording? @rsomani005 @fosterking , do you think this is something we should be taking a second look at after @Lvasu 's recording? 

[rsomani005]

Yes, I think it will make sense to pin this recording in some place its more visible in this group.