Data Analytics - 1 Day Masterclass
Experience the essence of our acclaimed 6-week Data Analytics course delivered for the CIIA (Data Analytics for Auditors), condensed into a single-day masterclass.
This intensive workshop zeroes in on the critical elements of Data Analytics within an audit context, making it the perfect launchpad for auditors embarking on their Data Analytics journey or those aiming to solidify their existing skill set.
I wanted to thank you for the excellent Data Analytics Masterclass yesterday.
You really brought data analytics to life and the real ways it can be integrated into Audit to enhance the work. You gave us lots of ideas to take forward and the Team will absolutely benefit from this. Not only have you given us practical tips on the use of excel, but shown us how to efficiently go about getting data and utilising it, as well as how to use DA to build upon testing going forward.
This course will enhance not only my practical use of DA but the way in which we integrate it into our work across the Team. I certainly recommend the course to anyone who wants to know more about how data analytics can enhance their work.
Andrea I
Choose from three distinct versions of the course, tailored to match your areas of interest and your proficiency in MS Excel.
Option 1 - Deploying Audit Analytics:
9 July 2024
3 December 2024
10 June 2025
Option 2 - Excel Refresher (Let's get hands-on!):
16 July 2024
5 December 2024
18 February 2025
15 May 2025
Option 3 - Introduction to PowerBI:
12 September 2024
8 April 2025
Cost
£275 + VAT per learner
"In-House" Team training also available - please enquire for costs
" From my perspective, the training was great and struck the right balance between theory and practical application – and the direct linkage to Internal Audit was really helpful.
I’ve also had positive feedback / comments from my team – one of them only thought she’d be able to attend the morning, but was enjoying it that much she moved some things around in their diary to come back after lunch!"
A plethora of data analytics courses are available, yet they often fall into two categories: broad, overarching analytics courses or those fixated on particular software tools. Neither of these approaches deliver a practical "how-to" of Data Analytics, meaning that many of these options are of limited benefit to auditors embarking on their initial Data Analytics journey, especially when their primary tool is MS Excel.
Enter our 1-day Data Analytics Masterclass, a distilled essence of our acclaimed Data Analytics for Auditors program, which has enlightened over 250 auditors to date! Crafted by auditors, for auditors, this course required no previous experience or knowledge in data, making it an unparalleled and very relevant program, whatever the size of your team.
Split across four areas of learning - Audit Process / content; Data Theory; Data Analytics Techniques and Technical Skills, participants can tailor their learning experience by selecting between two distinct tracks: "Deploying Audit Analytics" or having an Excel refresher course (in addition to loads of useful core information to help you in your analytics). A quick look at the table below will let you know which course is right for you, and you will also see the content delivered as part of our Data Analytics for Auditors course - so you can be confident that you are selecting the right course for you!
| Data Analytics Masterclass - Excel Refresher |
Data Analytics Masterclass - Introduction to PowerBI | Data Analytics Masterclass – Deploying Data Analytics |
Data Analytics for Auditors |
|
| The Case for Data Analytics | ||||
| What is Data Analysis and why it is important? | Y | Y |
Y | Y |
| The case for Data Analytics in Internal Audit | Y | Y |
Y | Y |
| Barriers for Data Analytics in Internal Audit | Y | Y | ||
| Data Theory / Terminology | ||||
| What is data? / Where is it from? | Y | |||
| Sources of data for Internal Audit | Y | Y |
Y | Y |
| Data Tables / Data structures / Key terminology | Y | Y |
Y | Y |
| Different data file types and why it matters | Y | Y |
Y | Y |
| An overview of the Data Analytics lifecycle | Y | Y |
Y | Y |
| o Planning process tips | Y | Y | ||
| o Testing process tips | Y | |||
| o Reporting Process tips | Y | |||
| An Introduction to AI | Y | |||
| An Introduction to Data Governance | Y | |||
| An Introduction to Continuous Assurance | Y | |||
| Data Verification and Cleaning | ||||
| Confirming and understanding data | Y | Y |
Y | Y |
| Exploratory Data Analysis | Y | Y |
Y | Y |
| Data Outliers (introduction) | Y | Y |
Y | Y |
| Alternative Sources of Data | Y | Y |
Y | Y |
| Deploying DA into the IA Team | ||||
| The Three Pillars of Successful Audit Analytics · Stakeholders · Software Tools · People |
Software Tools overview only | Y | ||
| Typical deployment models for Data Analytics / Alternative Team Structures | Y | Y | ||
| Relevant Policies and Procedures | Y | Y | ||
| Current Audit Planning Process / Audit planning in a Data enabled Internal Audit Function | Y | |||
| Current Audit Testing Process / Audit Testing in a Data enabled Internal Audit Function | Y | |||
| Current Audit Reporting process / Audit Reporting in a Data enabled Internal Audit Function | Y | |||
| Documentation of Data Analytics | ||||
| Documentation of data analysis tests | Y | |||
| Documenting Data Tables | Y | |||
| Data Analytics Reporting | ||||
| Use of visualisations | Y | |||
| Use of colour | Y | |||
| Getting started | ||||
| Advice and guidance on practical steps to get started started | Y | Y |
Y | Y |
| MS Excel | ||||
| Order of operations | Y | Y | ||
| Quick Analysis Tool | Y | Y | ||
| Data Verification | ||||
| Record count | Y | |||
| Key field parameters | Y | |||
| Confirm data format of individual data fields | Y | |||
| Data cleaning | ||||
| Splitting fields | Y | Y (Overview) | Y | |
| Removing characters | Y | Y (Overview) | Y | |
| Normalising data format | Y |
Y | ||
| Identifying duplicates | Y | |||
| Applying data transformation - practical exercise | Y | Y | ||
| Data Joins | ||||
| Blending Data | Y | Y (Overview) | Y | |
| If / Nested If | Y | Y | ||
| Pivot Tables and using to find outliers | Y | Y | ||
| PowerBI |
||||
| What is PowerBI |
Y |
|||
| The PowerBi process flow |
Y |
|||
| Creating and opening a project |
Y |
|||
| Getting to know the PowerBI interface |
Y |
|||
| Connecting Data Sources - Text/CSV; Excel; Data Folders; Websites |
Y |
|||
| Types of Visualisation |
Y |
|||
| Creating Dashboards |
Y |
|||
| Transforming Data |
Y |
|||
| Inserting Custom Columns |
Y |
|||
| Removing Rows / Splitting Columns |
Y |
|||
During the course, you will learn to:
Speak the "language of data"
- Learn data teminology and principles
- Be able to have credible conversations about data
Introduce analytics into the audit team
- Understand how the audit process is impacted by Data Analytics
- Understand how to introduce analytics effectively into your organisation
Learn to "do" Data Analysis
- Understand the sources of data and how to find/request data for analysis
- Learn how to document your analytics
Includes:
- Insightful guidance from experienced audit experts
- Expert advice from professionals who have successfully integrated Data Analytics and Continuous Assurance into Audit teams