
Expand your data analysis toolkit with Arbutus SmartApps

The Arbutus SmartApps are a collection of about 70 predefined audit analytics for areas such as accounts payable, accounts receivable, inventory, compliance, etc. So why would you want to build your own Arbutus SmartApps?
Flexible and versatile as the data analysis tool “Arbutus Analyzer” is, there are still things it doesn’t do that you might wish were included.
Well, adding your own SmartApps is not that hard and may really save time for you and your colleagues. So, become the expert and create added value for your team!
In this webinar, we illustrate all the steps of creating a SmartApp from scratch and sharing it with your colleagues so that it appears a seamless new feature in Analyzer.
You can follow this analysis along, or try this out yourself later as we will post the procedure for the SmartApp (i.e. executable script) on this website.
If you don’t already have the software, you can request an Arbutus Analyzer evaluation license to try it out.
Watch the full recording …
… or dive straight into the section of your choice …
Click on the links below to watch the video on the Sepia Solutions Youtube channel starting at that specific section.
Expand your data analysis toolkit – Shortcuts
Introduction and agenda for this webinar
We set the scene for this webinar, covering house rules and the topics for today.
The main topics are:
About me and Sepia Solutions
Of course, we cannot do without a one-minute personal introduction and introduction of the company and GRC software tools.

What is Arbutus Analytics?
We start by explaining what Arbutus Analytics is. How the Analyzer desktop software fits into the overall Arbutus Analytics platform and how it may fit within the organisation.
We shortly explore the look-and-feel of Analyzer and explore some of the features such as filters, the command log, grouping data, interactive graphs, duplicates testing and more.

How to standardise your analysis?
Let’s consider the data analysis objective: how many invoices were created on a weekend day?
We illustrate how this simple test could be standardised across the team, or over time by building an extremely simple Pro cedure.

What are Arbutus SmartApps?
SmartApps are pre-built analytics that you can use to get some quick wins easily. Arbutus Analyzer comes with about 90 of such SmartApps, covering areas such as Accounts payable, Accounts receivable, General ledger, Inventory, Payroll, Fraud & Compliance, and Fixed assest.
We illustrate one of our favourite SmartApps in the Fraud & Compliance section: “Suspicious key word matching“.
We analyse invoice details (line items) looking for words we wouldn’t normally expect such as “ball“, “massage” “adult“, “chocolate“, “flowers“, and “gift“.
Spoiler alert: We get some hits!

Expand your data analysis toolkit
Back to the core of this webinar: we summarise the 3 ways you can expand your data analysis toolkit:
- Acquire Arbutus Analytics
- Explore the predefined SmartApps
- Build your own Apps and start your library of tests

Some practical examples
We showsome very simple yet practical examples such as shortcuts (URL) to certain internet pages (help, online training, LinkedIn, IPPF, etc.).
Next, we illustrate an App that creates a data table based on the Windows environment variables. We then demonstrate a self-built App that simplifies getting a directory listing from the operating system. Finally, we show a convenient App that splits a text field into as many parts as required based on a text delimiter.

How to build and share your own apps?
Starting from scratch, we take you through the steps to…
- Set up a Team Share
- Create new procedures
– Open Internet pages
– Open Explorer in the project folder - Clean up the Project Overview by hiding the Team Share

Next steps?
How can we help you, achieve your own data analysis objectives?
Well, reach out and we’ll schedule a first meeting, possibly followed-up with a practical workshop.
If we find there is a good match, we can proceed with a full and personalised implementation. of Arbutus Analytics platform.

Q&A and closing
A short recap of this session.
Also a repeat of our question to you: Which topics would you like to see addressed in one of our next webinars?

Missed the webinar, or does the timing not work for you?
First of all, make sure to follow Sepia Solutions on LinkedIn where new events are announced, or check our upcoming events regularly.
In addition, we typically either document the use case and/or make the recorded webinar available at a later date. Check out our list of use cases and recorded webinars.
Reach out to us right now
You might be interested in other planned events:
Sorry, no more events are currently planned (or we haven’t updated our website).
Feel free to reach out to us, or check again later.