Certification Course on Data Analytics

         Learn How to Become Awesome in Analytics and Excel beyond MS Excel.

Introduction to Online Course on eCAAT

• For professionals, the most important assets are knowledge, skills, and time.
• Technology empowers professionals to be more productive and effective.
• In a dynamic digital world, learn how to use relevant technology, tools and techniques to access, analyse and audit the maze of diverse digital data.
• Learn Data Analytics which enables you to transition from ticks to clicks, save time and add value.
• Shift focus from time-consuming manual procedures and instead focus on performing intelligent insightful analysis of data
• Provide Better Assurance with Greater Assurance and become more relevant and valuable.

What is eCAAT Software?

India’s first Data Analytics software developed by CAs for use by CAs/CXOs to analyse any Digital Data for Assurance, Compliance or Consulting.

1. Developed with the effort of more than 30 man-years & based on practical experience.
2. Add-in to MS Excel which fits into MS Excel and applied to analyse data in any Excel file.
3. Powerful functions which simplify Data Analytics and enable users to be Data Analysts.
4. Right Blend of simplicity, learnability & usability providing powerful analytics in few clicks.
5. Used by hundreds of practising CAs and enterprises across more than 40 cities in India.

Course Overview

The Course include the following modules

• Module 1: Overview of 7 Sutras of Data Analytics
• Module 2: Overview of 51 Techniques of Data Analytics and eCAAT
• Module 3: Hands-on Training on Curating data
• Module 4: Hands-on training on Profiling Techniques of Data Analytics
• Module 5: Hands-on training on Analysis Techniques of Data Analytics
• Module 6: Hands-on training on Sampling Techniques
• Module 7: Hands-on training on Investigate Techniques of Data Analytics
• Module 8: Hands-on training on Relate/Docs/Utilities and Summary of Techniques

Details of Modules

Module 1: Overview of 7 Sutras of Data Analytics and eCAAT

1.1 Introduction and overview of Data Analytics
1.2 Learn Seven Sutras of Analytics (7Ps)
1.3 Systematic approach for using Data Analytics
1.4 Walk-through of eCAAT Menus and Functions

Module 2: Curating Data

1.1 Overview of Digital Audit Techniques
1.2 Translating audit objectives to specific audit tests
1.3 Selecting relevant audit techniques for specific tests
1.4 Overview of Curate DA functions with examples
1.5 Learn Curate Functions.

Module 3: Profiling Techniques of Data Analytics

1.1 Recap of Curate functions
1.2 Overview of Profiling Techniques with examples
1.3 Demo of Profiling Techniques/Participants to perform
1.4 Work on practical application through case studies
1.5 Summary of Module & Q & A

Module 4: Analysis Techniques of Data Analytics

1.1 Overview of Analysis Techniques – Concepts with examples
1.2 Demo of Analysis Techniques/Participants to perform
1.3 Discussion on practical application of Analysis Techniques
1.4 Work on practical application through case studies

Module 5: Sampling Techniques

1.1 How to integrate Data analytics techniques into audit process?
1.2 Overview of Sampling Techniques – Concepts with examples
1.3 Demo of Sampling Techniques/Participants to perform
1.4 Discussion on practical application of Sampling Techniques
1.5 Work on practical application through case studies

Module 6: Investigate Techniques of Data Analytics

1.1 Overview of Investigate Techniques – Concepts with examples
1.2 Demo of Investigate Techniques/Participants to perform
1.3 Discussion on practical application of Investigate Techniques
1.4 Work on practical application through case studies
1.5 Summary of the Module & Q & A

Module 7: Relate Multiple Files for Analytics

1.1 Overview of Techniques of Relate, Docs/Utilities – Concepts with examples
1.2 Demo of Techniques of Relate, Docs/Utilities/Participants to perform
1.3 Discussion on practical application of Relate, Docs/Utilities Techniques
1.4 Work on practical application through case studies
1.5 Summary of the Module & Q & A

Module 8: Case Studies of Practical Application of Techniques of Data Analytics

1.1 Recap of Data Analytics Techniques and how to integrate it in your work
1.2 Case study of using Data analytics techniques for Internal Audit
1.3 Case study of using Data analytics techniques for GST Review
1.4 Case study of using Data analytics techniques for Tax Audit
1.5 Summary of Techniques with Practical Tips & Q & A

Why should you Join this Course?

1. Apply New Digital Methodologies of Analysing Digital Data and be a Thought Leader.
2. Apply New Perspectives to New Digital Platforms & Business Models.
3. Get Practical Actionable Insights and Inferences from Digital Data
4. Acquire New Skillsets to move to new orbits in Professional Career.
5. Update your Knowledge and Skills Repository and Do More in Less Time.
6. Learn how to provide Better Assurance to Clients with Greater Self-Assurance
7. Add Value to your Clients in Assurance/Compliance/Consulting assignments.

How is the Course Designed?

The Course is designed to explain, illustrate, demonstrate, and confirm learning by participants so that they can start using DA techniques in their work-area immediately.

1. Dynamic approach of “learning by doing” with practical case studies/examples.
2. Learn to perform various types of tests using relevant functions with sample data.
3. Systematic approach for using Data Analytics applicable for all types of assignments.
4. Learn 51 practical techniques of Data Analytics with scenarios and sample data.
5. Organised into practical learnable modules of 20 minutes each which can be learnt as per your convenience.
6. Apply the techniques in your practical area of work immediately to harness benefits.
7. Obtain certificate which demonstrates and show-cases your expertise.

Who should join this Course?

Every professional who is interested in upgrading their tech skill-sets to harness power of technology to enhance career and add value. This course is specifically suitable for:

• Students
• Executives
• Managers
• Practitioners
• Chartered Accountants
• Entrepreneurs/Businessmen
• Anyone who wants to use the tool to master organisational skills at work

Who is the Course Leader?

The Course is designed and conducted by CA. Abdul Rafeq, Managing Director of WINCER Infotech Limited with experience of over 35 years in IT Assurance & Data Analytics. Brief Highlights of his career:

• Fellow member of ICAI. He passed his CA Final exam in 1985 and CISA in June 1995 and DISA of ICAI in 2008.
• Passed various global certification exams such as:
üCertified Information Systems Auditor
üCertified in Governance of Enterprise IT,
üCertified Fraud Examiner,
üCertified Internal Auditor and many more

• Experience in varied roles such as CFO, CIO, IT implementer, IT consultant, IT Auditor, Data Analyst and Trainer.
• Presented and spoke on: “COBIT, IT Audit and CAATTs” at various global conferences, seminars, and workshop of ISACA and its chapter in 14 countries.
• Conducted training programs on “Using Data Analytics and BI” for Assurance and Fraud investigations” for various professional institutions in India and abroad.
• Chief architect and instrumental in designing and developing various types of Data Analytics Software such as SoftCAAT, eCAAT, T-CAAT, ProCAAT and E2Tally-Soft.

Course Fees

• The specific fees applicable for each course will be added shortly.You can register your interest in joining the course by submitting details here so that we can notify you as soon as the course is available.

FAQ

1. What are the pre-requisites for installing software?
   The pre-requisites for installing the software are Windows 7 or higher/MS office 2010 or higher.
2. Will participants be issued a certificate on completion of the course?
   All the participants who attend the Course and pass the online assessment test will be issued certificates.