Industry Discussions

Welcome to the industry discussions forum — a dedicated space to share resources, connect with like minded data workers, and discuss industry specific analytic challenges + solutions. Please read the Welcome post pinned below to familiarize yourself with how to engage in this new forum.
Right now, the power to solve new global challenges across industries, is at your fingertips, no matter where you're working from. Create a new topic or reply to an existing thread to share your perspective.

Internal Audit

Highlighted
Alteryx Partner

Interesting, I've used it in the past to analyze amounts distribution and not the invoice number (since they're generated automatically and usually don't correlate with BL).

I think that the main challenge is to identify relevant insights once there's a deviation.

 

Highlighted
Alteryx Partner

Using

  • last digit distribution and
  • last 2 digits distributions as separate variables

+ some other variables like time of transaction, IP, location etc.

 

you can actually score each transaction (with a random forest model) with a suspicion score...

Which transactions look shady most, prioritize your efforts…

Highlighted
9 - Comet

Hi Shawn,

 

I've built a series of workflows that performs compliance audit against our indirect booking policies. Our goal after the audits are completed is to use predictive analytics to minimize the amount of infractions identified. Context: the less infractions, the better, since it means travel agencies are complying with our booking policies.

 

You'd be surprised at how very little variety of tools are needed. Most will be found in the Preparation, Join, Parse, and Summarize categories.

 

Happy to connect in PM if you'd like to speak more.

 

Cheers.

 

William Chan | @WilliamChan | LinkedIn

Alteryx Transportation and Montreal User Group Co-Leader

Alteryx Core Certified

Business Analyst, Distribution and Payments | Air Canada

alteryx-sig.JPG

Highlighted
6 - Meteoroid

William: I, too, am looking for new ideas on workflows.  We, too, are beginning our Alteryx structures.  Can I discuss these options you mention also?

 

Jen 

Highlighted
6 - Meteoroid
Would it be possible to share some of those workflows with us?
Highlighted
7 - Meteor

Same here! It would be awesome to see or share some of these or even discuss how others are going about their process.

Highlighted
8 - Asteroid

Not sure why, but the messages would not let me add attachments. "maximum number of attachments allowed is: (0)"...

 

I've been doing internal audit analytics with Alteryx for the last 5 years (and are still fully in love with all it can do) in 2 companies (very different industries). Right now I have 2 risk-ranking tests, one for payroll (33 risk factors - i.e. "only paid by checks", "short tenure" etc.) and one for Procure to Pay (17 risk factors - geographic distance between vendors and employees, fuzzy on names, no phisical address, etc.). At my prior company I had some good tests on T&E, both for FCPA risk and for actual misappropriation by the employees. On predictive I had a decision tree set that would identify expense reports that were the approval was "rubberstamped". 

 

Since every industry and system is different, I guess I would hope to use this as a sound board for ideas on what to test, more than sharing any specific workflow that would be tied to the company and its production systems/tables/variables. I would also hope we can bring-up issues when we are somewhat stuck (i.e. how to "safelist" a keyword search, or how would you follow-up when the test trigger is more abstract "(i.e. "why did you pay this vendor significantly faster than any other?" 

Highlighted
6 - Meteoroid

@aristiguietapulgarf :  Thanks for the information.  Maybe each thread has an attachment limit?

  • For your predictive model, what are your indicators (in general)?
  • Are you using unsupervised or supervised data?  
  • For the risk ranking, are you using Likert-type scale (1-2-3,etc.)?

 

Thanks, 

Jen 

Highlighted
Alteryx Community Team
Alteryx Community Team

@JenP @aristiguietapulgarf , I think this is a bug on the community. I'm also seeing a similar error. 

 

@aristiguietapulgarf , do you mind submitting a ticket into community@alteryx.com? We can fix it. 

Highlighted
9 - Comet

Hi @JenP & @shawnbearsphelan,

 

I would love to be able to share my work, but unfortunately it is proprietary and contains information that cannot be distributed. I'm working on a version that can eventually be shared since I would like to publish this as a use case.

 

I would be happy to engage in a further discussion since as I mentioned, the tools used are in the Data Prep categories. For our purposes, it was all about the logic and business rules that needed to be put into place.

 

Cheers.

William