Intro of Key Features of SoftCAAT Ent SQL Software

Ad

Ad

Ad

Ad

Ad

Ad

Ad

Ad

Ad

Ad

Ad

Ad

Intro of Key Features of SoftCAAT
Ent SQL Version
Perform Powerful Data Analytics on Large Volume of Data in SQL
Using Com...

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
ProvideValue
Addition through...

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

Home

All-purpose
standalone/indepen
dent application
SW. Makes Data
Analytics Simple,
Effective,
Affordable and
Powerful.
Desig...

SoftCAAT Ent SQL: Data Analytics
Simplified & Amplified with Power of SQL
Import large volume of data into SQL to perform ...

Comparison of SoftCAAT Ent SQL
Ent & Pro Versions

Comparison of SoftCAAT Ent SQL
Ent & Pro Versions

Intro

Challenges of Digital Data of Digital Age
Do you know how to navigate the information superhighway to increase your produc...

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

With manual approach,
performing audit tasks on
Digital Data is Tedious &
Cumber-some!
Manual approach
to Auditing
Digital...

What is the
KEY to
access
Digital Data?

How to audit
digital data?

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

All-purpose
standalone/indepen
dent application
SW. Makes Data
Analytics Simple,
Effective,
Affordable and
Powerful.
Desig...

Who can use SoftCAAT Ent SQL?
• Auditors: Financial, Compliance or IT,CXOs, Fraud/Forensics
investigator….
Those who are w...

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

What are CAATs?
Computer Assisted Audit
Techniques (CAATs)
Computer Assisted Audit
Tools andTechniques
(CAATTs)
Facilitate...

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

When can you do with Data Analytics?

What can you do with Data Analytics?

33
Applying Thought To Technology
What is Data Analytics/BI?

Why

Why Use SoftCAAT?

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

Automatic AuditTrail of analysis performed to facilitate peer review and context of the
findings and to rerun functions as...

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

CAATTs help you to Access & Analyse Data
as per Scope & Objectives of Audit

How

3 USEFUL SETS OF PROFESSIONALS
Mindset SkillSet Toolset

How to use CAATs in Audit?

Systematic approach for using CAATTs
Document the findings and report.
Perform the tests using the DA software and analyse...

How can Analytics be Applied in Audit?

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

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

Systematic Approach to Using SoftCAAT Ent SQL
Set Objectives
Set Test
Objectives
Obtain Relevant
Data
Identify Tools &
Tec...

Sample Process Flow of Sales Order: Evaluate & Confirm
Controls in the Data Elements of Each Stage as Applicable
SalesOrde...

Key Features

Key Features

Panels Brief Description of Panels in SoftCAAT Ent SQL
File
Home
Provides options to create an auditee, audit, file and pa...

File & Home
• File
• Auditee
• Audit
• File
• Password
• Home
• Import Data
• Copy, Navigate
• Columns
• Tree, Find In
• F...

Curate
• Remove Characters
• Remove Spaces
• Remove 'X' Characters
• Delete
• Convert
• Format Case
Curate refers to
trans...

Analysis
• Identify Duplicates
• IdentifyGaps
• Outliers By
• Identify
• Change Seq.
• Fuzzy Match
• Sort
• Filter
• Split...

Explore
•Classifier
•Stratum
•Analysis
Explore refers to
examining the data in
detail to discover
essential features by
br...

Investigate & Trendline
• Investigate
• Query
• Statistics
• Templates
• 3D Reports
• Trendline
• Stratify
• Classified
• ...

Utilities & Tools
• Utilities
• Columns
• Extract
• Files
• Analytical
• Rerun
• Tools
• AuditTable, Audit Log
• Comments,...

Functions

Use Cases

Generic Use Case of SoftCAAT Ent SQL:
What can you do with it?
• SoftCAAT Ent SQL is an all-purpose Standalone/Independent...

Generic Use Case of SoftCAAT Ent SQL: Walk-through of Functions
• SoftCAAT Ent SQL is an
Independent Data Analytics/BI
Sof...

Generic Use Case of SoftCAAT Ent SQL: User has walk-
through of the various powerful functions available in
Panels of:
• I...

Generic Use Case of SoftCAAT Ent SQL: Understand Relevant
Functions
• The user selects the relevant functions in the File ...

Generic Use Case of SoftCAAT Ent SQL: Understand Relevant
Functions
• The user selects the relevant functions in the Explo...

Generic Use case of SoftCAAT Ent SQL: Key Benefits
• The user gets practical exposure of how Software provides independent...

Specific Use case of
Inventory Audit

Control Objectives: Inventory
• i.Whether the company maintains proper records showing full
particulars including details ...

Illustrative Control Objectives to Test using Data Analytics Financial Assertions
• Adjustments to inventory prices or qua...

Illustrative Control Objectives Financial Assertions
• Shipments are recorded accurately. • Valuation
• Shipments are reco...

Sample Areas for Review in Inventory
Inventory Listing
Negative Inventory Quantities
Inventory With A Zero Cost Price
Inve...

Area: Inventory Listing
• The inventory listing itemises all inventory on
hand, including description, quantity and value....

Area: Negative Inventory Quantities
• Inventory should not have a negative quantity, i.e. more sold
than available.
• All ...

Area: Inventory With A Zero Cost Price
• Inventory with a zero cost price could be as a result of
incorrect capturing or o...

Area: Inventory With A Zero Sale Price
• Inventory sales value is not expected to be zero. If this occurs it
could be beca...

Area: Inventory Received And Issued By The Same User
• There should be segregation of duties in place between the
person r...

Area: Net Realizable Value
• The inventory sales value is not expected to be less than the cost
price. If this occurs it c...

Area: Analysis Of Inventory Sales By Quantity
• Identify and investigate unexpected movements in
inventory.
• Investigate ...

Area: Analysis Of Inventory Sales By Amount
• Useful management information to identify
unexpected increase/decrease turno...

Area: General Journal Adjustments To Inventory Accounts
• The use of journals (JEs) should be minimised and any identified...

Area: Analysis Inventory Ordering And Usage
• This information is used to track inventory movement, identify
unexpected mo...

Specific Use Case: Inventory
Sample CAAT Queries Performed
1. Analyze usage and ordering to improve
turnover
2. Analyze hi...

All-purpose
standalone/indepen
dent application
SW. Makes Data
Analytics Simple,
Effective,
Affordable and
Powerful.
Desig...

Thank you! Questions?
sales@wincaat.com
rafeq@wincaat.com

Intro of Key Features of SoftCAAT Ent SQL Software

Intro of Key Features of SoftCAAT Ent SQL Software

Intro of Key Features of SoftCAAT Ent SQL Software

Intro of Key Features of SoftCAAT Ent SQL Software

Intro of Key Features of SoftCAAT Ent SQL Software

Intro of Key Features of SoftCAAT Ent SQL Software

Intro of Key Features of SoftCAAT Ent SQL Software

Intro of Key Features of SoftCAAT Ent SQL Software

Intro of Key Features of SoftCAAT Ent SQL Software

Intro of Key Features of SoftCAAT Ent SQL Software

Intro of Key Features of SoftCAAT Ent SQL Software

Intro of Key Features of SoftCAAT Ent SQL Software

Intro of Key Features of SoftCAAT Ent SQL Software

Intro of Key Features of SoftCAAT Ent SQL Software

Intro of Key Features of SoftCAAT Ent SQL Software

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 15132 views
Introduction to C Programming Language by Simplilearn 4401 views
The Pixar Way: 37 Quotes on Develop... by Palo Alto Software 85932 views
9 Tips for a Work-free Vacation by Weekdone.com 4891 views
I Rock Therefore I Am. 20 Legendary... by Empowered Present... 140466 views
How to Map Your Future by SlideShop.com 270813 views

Top clipped slide

1 of 93 Ad

1 of 93 Ad