Expand your data analysis toolkit

May 16, 2023

Screenshot of the webinar recording: Expand your data analysis toolkit

Expand your data analysis toolkit with Arbutus SmartApps

Arbutus Analyzer menu expanded with 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.

We set the scene for this webinar, covering house rules and the topics for today.
The main topics are:

Of course, we cannot do without a one-minute personal introduction and introduction of the company and GRC software tools.

Screenshot of the webinar recording: Expand your data analysis toolkit (About me and Sepia Solutions).

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.

Screenshot of the webinar recording: Expand your data analysis toolkit (What is Arbutus Analytics?).

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.

Screenshot of the webinar recording: Expand your data analysis toolkit (How to standardise your analysis? ).

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“.

Screenshot of the webinar recording: Expand your data analysis toolkit (What are Arbutus SmartApps?).

Back to the core of this webinar: we summarise the 3 ways you can expand your data analysis toolkit:

  1. Acquire Arbutus Analytics
  2. Explore the predefined SmartApps
  3. Build your own Apps and start your library of tests
Screenshot of the webinar recording: Expand your data analysis toolkit (Expand your data analysis toolkit).

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.

Screenshot of the webinar recording: Expand your data analysis toolkit (Some practical examples).

Starting from scratch, we take you through the steps to…

  1. Set up a Team Share
  2. Create new procedures
    – Open Internet pages
    – Open Explorer in the project folder
  3. Clean up the Project Overview by hiding the Team Share
Screenshot of the webinar recording: Expand your data analysis toolkit (How to build and share your own apps?).

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.

Screenshot of the webinar recording: Expand your data analysis toolkit (Next steps).

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?

Screenshot of the webinar recording: Expand your data analysis toolkit (Q&A and closing).

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

    Let us be your guide !

    Data analysis is a journey, not a product. So, let us be your guide and help you in this exciting endeavour. Take your first step right now and get in touch with us so that we can discuss your organisation, your data environment and data sources, and especially your data analysis objectives!

    Let us help you on your way.

    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.