Audit Analytics Using Tableau – Fundamentals

Registrations

Date/Time
Date(s) - 22/11/2022 - 23/11/2022
9:00 am - 4:00 pm

Location
Business Square


In collaboration with BEINEX

Course Overview

This course guides the learners on how to use BI in different audit phases for a quick, insightful analysis of data. Our curriculum-based approach uses hands-on labs and individualized coaching to help you to locate, combine and analyze data to create compelling dashboards for audit requirements.

Course Objective

Attending the training will enable the learners to:

  • Use Tableau for Audit Analytics
  • Apply Tableau at different audit phases
  • Implement Tableau for audit analytics and Continuous Monitoring
  • Visualize data to gather deeper insights

Target Audience

This course benefits Accountants, IT Auditors, Internal Auditors, Audit  Analysts

Summary

Course Type  : Fundamentals

Course Duration:  : 2 days/ 14 Hours (9am to 4pm)

Pre-requisites  : Systems with Tableau Desktop license pre-installed.

Includes  : Classroom training with hands-on activities

Location  :  Virtual Room/Onsite

Course Expectation

By the end of the training, you will be able to:

  • Use data analytics in different audit phases.
    • Planning
    • Execution
    • Reporting
  • Implement Tableau for Continuous Monitoring
  • Perform data quality checks for large volumes of data
  • Use sampling techniques to pick the best samples
  • Identify outliers and perform exploratory analysis
  • Validate correlation between variables
  • Formulate Hypothesis tests and validate it using Tableau
  • Visualize data to gather deeper insights
  • Convey results using strong visualizations
  • Set up Tableau system for Audit Management
  • Understand the use of data analytics in:
    • Use case 1: HR Audit
    • Use case 2: Procurement Audit
    • Use case 3: Finance Audit
  • Sharing & collaboration in Tableau

Course Outcome

By the end of the training, you will be able to:

  • Use data analytics in different audit phases.
    • Planning
    • Execution
    • Reporting
  • Implement Tableau for Continuous Monitoring
  • Perform data quality checks for large volumes of data
  • Identify outliers and perform exploratory analysis
  • Validate correlation between variables
  • Connect to various data sources – Excel/CSV, SQL, Oracle and other databases
  • Perform code-free data processing and cleaning activities
  • Create calculations and derived fields to sharpen analysis
  • Visualize data to gather deeper insights on Internal Audit activities
  • Understand the use of data analytics in
    • Use case 1: HR Audit
    • Use case 2: Procurement Audit
    • Use case 3: Finance Audit
  • Publishing Sharing & access control in Tableau

Bookings

Bookings are closed for this event.