Intro of Key Features of S-CAAT

Ad

Ad

Ad

Ad

Ad

Ad

Ad

Ad

Ad

Ad

Ad

Ad

Intro of Key Features of S-CAAT
Powerful Data Analytics Performed from Excel
on Large Volume of Data in SQL
https://www.wi...

Global Leading Solution Provider in Data Analytics
for Empowering Professionals to realise potential
by Applying Thought t...

With Innovative Software Solutions,
We Empower CAs & CXOs to Harness:
Power of
Technology to
Provide Value
Addition throug...

Higher use of Technology.
Greater Value Addition and
Serve your Clients in Shorter Time with
Deploying Systems and Solutio...

Home

Add in to MS
Excel. Blends
simplicity of MS
Excel with the
power of SQL
Database!
Perform Powerful
Analytics on
large volu...

S-CAAT: Add-in to MS Excel
Connect to SQL Data to Perform Analytics
Enables users to perform tests with the click of a but...

Features of S-CAAT Version

Features of Auto S-CAAT Version

Intro

Can you Re-Imagine the Future of Auditing
with IT & Play a Key Role in Creating it with IT?
Internet and Information Techn...

How to be a NextGen Digital Accountant?

The Future will be exponentially Digital.
Chartered Accountants can
Future-proof their career
with Knowledge and skills of...

We have Invested time and resources to Creating Suite of Solutions
with required Knowledge-base.
We empower you with Onlin...

What

Data Analytics Skills: a “Want” or a “Necessity”
•Data is the lifeblood of a
modern enterprise.
•Data analytics is a must-...

Using Data Analytics is an Art and a Science
Data Analytics is an art requires
understanding of business
process and appli...

What are CAATs?
Computer Assisted Audit
Techniques (CAATs)
Computer Assisted Audit
Tools and Techniques
(CAATTs)
Facilitat...

Functional Capabilities of CAATs
• Enables the reading of different record formats
and file structures
File access:
• Enab...

Functional Capabilities of CAATs
What
Specific
objective
s that
should be
addressed
by the
analysis
When
Define the
period...

CAATTs/Analytics: Key features
• Review large population and
determine true areas of risk to Isolate
“red flags” and drill...

What is S-CAAT?
Use eCAAT to Connect to SQL from Excel to perform Analysis
• Developed by Auditors for Auditors to
Audit a...

What can you do
with it?
27
Connect to SQL
FROM Excel to
perform
Data Analysis
for Compliance,
Assurance,
BI or FI OR MIS

Add-in to MS Excel
Software
Easy to use and
Simple to Learn
Look & Feel of MS
Excel but with
Power of Database
Powerful
Au...

Who can use S-CAAT?
• Auditors: Financial, Compliance or IT, CXOs, Fraud/Forensics
investigator….
Those who are working as...

Why

Automatic Audit Trail of analysis performed to facilitate peer review and context of
the findings and to rerun functions a...

Why Use CAATs in Audit?
Analyse entire data population as per scope and Objective of Assignment.
Importing data is easy an...

Need for Data Analytics in age of Digital Disruption
Technology is
driving rapid
transformation in
diverse and
dynamic way...

How

3 USEFUL SETS OF PROFESSIONALS
Mindset SkillSet Toolset

When to use CAATs/Data Analytics/BI?
Mathematics is exact but
Statistics is approximate
Data is dumb but
information is in...

How to use CAATs in Audit?

Assurance – Key Factors to Consider
Business
Processes
Regulatory requirements
Organization
Structure
Technology
Deployed
...

Systematic Approach to Using CAATs
Set Objectives
Set Test
Objectives
Obtain Relevant
Data
Identify Tools &
Techniques
Per...

Seven Steps for Performing Data Analytics
1. Identify Objectives & Deliverable
2. Identify Data & Platform
3. Understand P...

Approach to using Analytics
Problems to
Analyse
Get/Process
Data
Analyse
Results
Measure
Insights
Apply
Learnings

How can Analytics be Applied in Audit?

Planning
Scope the
Audit
Build Audit
Plan
Request
Information
Fieldwork
Analyze
Data
Document
Results
Organize
Supporting
...

Key Features

Panels Brief Description of Panels in S-CAAT
Curate Transform data in a standard structure to be usable for data analysis ...

Curate Data
•Convert
•Format
•Remove
Curate refers to
transforming data in
a standard structure
to be usable for data
anal...

Analyse Data
• Identify
• Duplicates, Gaps, Outliers
• Sampling
• By Selection, By Criteria, By
Criteria-Analysis, By Prof...

Investigate Data
• Analysis
• Classifier, Stratum, Comparitive,
3D-Reports
• Trendline
• Stratify, Classifier,
Classificat...

Document
• Index
• File Info
• Index Tables
• Index Databases
• Log:
• Database History
• Audit Log, Enterprise Info
• Sys...

Utilities
•Tables
•Columns
•Hide / Unhide
•Print Setup
•Charts
Provides unique
functions which
complement and
enhance the ...

Connect to Database
• GetData
• Tables
• Current Table
• Import to Excel
• Import to SQL
• Close Conn.
Provides option to
...

Functions

Use Cases

Generic Use Case of S-CAAT: What can you do with it?
• S-CAAT is an add-in software to MS Excel which can be performed fro...

Generic Use Case of S-CAAT: Walk-through of Functions
• User has a quick walk-through of the Tabs which include:
• Connect...

Generic Use Case of S-CAAT: Understand Relevant Functions
• The user selects the relevant functions in the Connect to Data...

Generic Use Case of S-CAAT: Understand Relevant Functions
• The user selects the relevant functions in Analyse panel to ex...

Generic Use Case of S-CAAT: User has walk-through of
the various powerful functions available in menus of:
• Remove
• Form...

Specific Use Case:
Auditing Journal Entries Using S-CAAT
ACAfirmisconductingFinancialAuditofaListedcompanywhich
hasmaintai...

Specific Use Case of S-CAAT: List the Steps
The CA firm documented the steps in auditing JE included the following:
• Step...

Specific Use Case of S-CAAT:
Identify Possible Fraudulent Journal Entries
The CA firm Performed Risk Assessment and identi...

Specific Use Cases of S-CAAT: Testing Procedure
The CA firm decided to adopt following Test Procedures:
Identify anomalies...

Specific Use Case:
Sample CAAT Queries Performed using S-CAAT
1. Find journal entries (JE) that do
not balance
2. Find gap...

Specific Use Case of S-CAAT: Key Benefits
• The team of the CA firm was able to perform audit test procedures and CAAT
Que...

Add in to MS
Excel. Blends
simplicity of MS
Excel with the
power of SQL
Database!
Perform Powerful
Analytics on
large volu...

Thank you!
Email: sales@wincaat.com

Intro of Key Features of S-CAAT

Intro of Key Features of S-CAAT

Intro of Key Features of S-CAAT

Intro of Key Features of S-CAAT

Intro of Key Features of S-CAAT

Intro of Key Features of S-CAAT

Intro of Key Features of S-CAAT

Intro of Key Features of S-CAAT

Intro of Key Features of S-CAAT

You are reading a preview.

Activate your 30 day free trial to continue reading.

Share SlideShare

Facebook
Twitter
LinkedIn

Embed

Size (px)

Show related SlideShares at end

WordPress Shortcode

Link

Share
Email

Good Stuff Happens in 1:1 Meetings:... by Saba Software 17064 views
Introduction to C Programming Language by Simplilearn 4941 views
The Pixar Way: 37 Quotes on Develop... by Palo Alto Software 86272 views
9 Tips for a Work-free Vacation by Weekdone.com 5419 views
I Rock Therefore I Am. 20 Legendary... by Empowered Present... 140824 views
How to Map Your Future by SlideShop.com 271593 views

Top clipped slide

1 of 72 Ad

1 of 72 Ad