How to perform Powerful Analytics in Few Clicks using eCAAT -Case study of Bank Branch Audit, Part-
This webinar provides an overview of key features of data analytics, 7 steps for performing data analytics using eCAAT and it covers various examples of audit tests for bank branch audit using eCAAT Functions. You can register for the Part-2 of the webinar on 10th April 2021 at:
https://www.wincaat.com/Training/Webinars.aspx
You can watch specific section of the presentation by clicking on timing below:
00:58 Welcome and intro of topics, speaker and company
03:40 Four Learning Objectives
04:17 Why use Data Analytics Software
06:00 Seven Steps for using Data Analytics
08:18 What is eCAAT version and comparison, panels
10:50 Key benefits of using eCAAT for data analytics & seven steps for using eCAAT
15:00 Distinction between MS Excel and eCAAT
17:13 Walk-through of key functions of eCAAT Pro & eCAAT Ent
23:30 Sample Audit Tests using eCAAT for bank branch audit and results of analytics
27:08 Demo of Classify function on specifi column with brief walk-through of results
30:20 Extract specific details from classify results
32:25 Demo of Classify with group by on a different column
34:35 Demo of Identify duplicates of account id and then by customer name, duplicates with summary with drill down on specific row
37:50 Demo of Remove duplicates
38:52 Demo of Group by function
40:03 Demo of Stratify function based on different strata and extract selected details of strata
42:08 Walkthrough of 51 audit tests of using eCAAT with brief explanation of purpose/results
46:50 Demo of Top Last X with input of Top 10, based on borrower name and group by sector
51:10 Demo of Quick Summarise based on limit giving results of each unique value of limit and dynamic analysis on results displayed in result form of eCAAT
55:00 Demo of Pareto analysis (80:20) and sampling using pareto analysis and extract sample
57:05 Demo of sampling based on results of classify
58:45 Demo of ABC Analysis (60:30:10)
01:00:00 Demo of Column Statistics of Numeric columns
01:01:00 Walk-through of results of analytics performed
01:02:50 Questions & Answers
01:05:00 Invite to webainar of SoftCAAT on 7th Apr. 2021
Видео How to perform Powerful Analytics in Few Clicks using eCAAT -Case study of Bank Branch Audit, Part- автора Famous Faces Revealed
Видео How to perform Powerful Analytics in Few Clicks using eCAAT -Case study of Bank Branch Audit, Part- автора Famous Faces Revealed
Информация
14 июля 2024 г. 5:41:32
01:06:12
Похожие видео