Boost logo
Language
course | Internal Audit Analytics: Data and Visualization

We turn your development needs and aspirations into powerful digital solutions that drive growth

ARG-460 | Internal Audit Analytics: Data and Visualization

Course Sector : Audit, Risk and Governance

Duration
Date from
Date to Course Venue Course fees Book a course
5 Days2025-05-042025-05-08Riyadh$4,250 Book now
5 Days2025-08-182025-08-22Dubai$4,250 Book now
5 Days2025-11-172025-11-21Amsterdam$4,950 Book now

Course Introduction

DATA VISUALIZATION

This training program is designed to equip professionals with the essential and relevant knowledge, concepts, and techniques in handling data and incorporating data visualization in audit analytics.

 This program will enable participants to utilize Excel and its features in creating visuals and spreadsheets for audits. 


Course objective

  •         Enhance knowledge and upscale internal auditing skills.
  •        Recognize the common causes of error in spreadsheets.
  •        Manage and utilize data to create persuasive results during the fieldwork phase of an audit.
  •        Use Excel in handling data for audit including Excel statistics, data matching, sortation, filtering.
  •        Identify Excel features to enhance and create data visuals for audit reports.
  •        List the various external data sources and create dashboards using free free–standing products such as power bi and tableau.

Course Outline | 01 DAY ONE

Introduction to Internal Audit Analytics

 

  •      What is the difference between data analytics and audit analytics?
  •      Benefits of data analytics for internal audit
  •      Who uses audit analytics?
  •      When can audit analytics be used?
  •      Data analytics literature.
  •      Internal audit literature.
  •      Theories and Models in Visual Representation Literature
  •      Data analytics strategies for internal auditors.

Course Outline | 02 DAY TWO

Data Analytics and Handling (Using Excel)

 

  •      Introduction to Excel importance for Internal Audit analytics.
  •      Checking the Integrity of spreadsheets.
  •      Common error sources.
  •      Identify Invalid data and formulae precedents.
  •      Recording macros.
  •      Re‐performance and virtual calculations.
  •      How to use Excel statistics?
  •      Filtering and stratification.
  •      How Pivot tables, pivot charts and slicers help internal audit analytics?
  •      Creating an audit workpaper within excel
  •      Simple and complex sortation.
  •      What is Fuzzy data matching and how it works?
  •      Replicating what other paid–for software can do by substituting excel
  •      How Formulae work?  

Course Outline | 03 DAY THREE

External Data Sources:

 

  •      Why to connect with external data?
  •      Your Guide to import Data into excel.
  •      How to create and edit queries?  
  •      Transforming data and creating transformation rules.
  •      Interacting with data sources to refresh data.
  •      Creating dashboards using free free–standing products such as Power BI and tableau.

 

 

Course Outline | 04 DAY FOUR

External Data Sources:

 

  •      Why to connect with external data?
  •      Your Guide to import Data into excel.
  •      How to create and edit queries?  
  •      Transforming data and creating transformation rules.
  •      Interacting with data sources to refresh data.
  •      Creating dashboards using free free–standing products such as Power BI and tableau.

Course Outline | 05 DAY FIVE

Practical Workshop. 

Course Certificates
BOOST Logo

BOOST’s Professional Attendance Certificate “BPAC”

BPAC is always given to the delegates after completing the training course,and depends on their attendance of the program at a rate of no less than 80%,besides their active participation and engagement during the program sessions.

Request a Quote
Sectors

Upcoming Courses In This Sector

Follow us
facebook iconinstagram iconlinkedIn icontwitter icon
BOOST Logo

Since 2001, we have been pioneering the training field in the Middle East, helping individuals, teams, and organizations reach their full potential with integrated solutions.

left

🔗 Quick Links

Boost Abroad logoSparks logo

Sister Companies to Boost Consulting and Training

Training Image 1Training Image 2Training Image 3Training Image 4Training Image 5Training Image 6

We believe in progress for everyone.

We helped more than 10,000 clients over 20 countries on 4 continents in boosting their knowledge, skills, and careers.

Copy rights

Boost Training And Consulting All Copyrights Reserved 2025