b. course contents 2016-17...i & ii audit report –language structure and complying style guide...
Post on 02-Aug-2020
1 Views
Preview:
TRANSCRIPT
B. COURSE CONTENTS
2016-17
I. General Courses
Special Course on Statistics and Sampling in Audit
5 Working Days) Course contents
DAY SESSION TOPIC
Day 1
I Fundamentals of Ethics and Code of Ethics for IA& AD
II Introduction to Statistical methods and Descriptive Statistics
III & IV Elementary probabilities theory and Classification and concept of
Probability.
Day 2
I & II Advantage of Statistical Sampling. Sampling error and not – Sampling
error, Bias in Sampling
III & IV Random Sampling and Random Numbers, sample frame and Sampling
distribution.
Day 3
I & II Simple random Sampling, simple random Statistical random Sampling and
cluster sampling.
III & IV Probability proportional to size Sampling and Multistage Statistical
Sampling.
Day 4
I & II Need for Statistical Sampling in Audit, Attribute Sampling Plan for Audit.
III & IV Monetary unit Sampling and application of sampling in audit using IDEA
package.
Day 5
I & II Group Discussion and Case studies on Statistical Sampling in Audit.
III End Course Assessment Test
IV Evaluation and Valediction.
Special Course on Audit Evidence
3 Working Days)
Course contents
DAY SESSION TOPIC
Day 1
I Fundamentals of Ethics and Code of Ethics for IA& AD
II Concept of Audit Evidence
III & IV Techniques of Evidence gathering
Day 2 I & II Audit Evidence in Financial Audit with a case study
III & IV Audit Evidence in Performance Audit with a case study
Day 3
I & II Audit Evidence in Compliance Audit with a case study
III End Course Asessment Test
IV Evaluation and Valediction
Special Course on Audit Reporting
3 Working Days)
Course contents
DAY SESSION TOPIC
Day 1
I Fundamentals of Ethics and Code of Ethics for IA& AD
II Introduction to Audit Reporting and components of an audit
paragraph
III & IV Audit objectives, findings and recommendations
Day 2 I & II Characteristics of Audit Evidence, Balance and objectivity
III & IV Compliance of Audit Reporting as envisaged in ISSAI 4100
Day 3 I & II Audit Report – Language structure and complying style guide
III End Course Assessment Test
IV Evaluation and Valediction
Intensive Training Course on Civil Accounts
5 Working Days)
Course contents
DAY SESSION TOPIC
Day 1
I Fundamentals of Ethics and Code of Ethics for IA& AD
II Introduction to Government Accounts – Division, Classification,
Accounts in Treasuries, Public Works and Forest Divisions
III & IV
Exhibition of Government Accounts from Treasury to Monthly Civil
Accounts. Checks to be exercised by Treasury Inspection Party
Day 2
I & II
.Maintenance of Broad Sheets of Loans and Deposits, GPF and
Suspense Heads, clearance and adjustment procedure with practical
exercise
III & IV Maintenance of Broad Sheets of Remittance Heads and procedure for
reconciliation and clearance and their depiction in Finance Accounts
with practical exercises.
Day 3
I & II Accounting of Debt, Deposits and Clearance of various suspense
balances under VLC environment.
III & IV Inter-Government adjustments, Inward and Outward Accounts ,
Monthly Closing Balance statement from RBI CAS Advice
Adjustments
Day 4
I & II Preparation of Budget, Exchequer Control, issue of sanctions and
monitoring of expenditure and related matters
III & IV Improper operation of Personal Deposit Account and Central Plan
Scheme Monitoring System (CPSMS)
Day 5
I & II Government Accounts – Accrual system of Accounting and Transaction
of Government Accounts towards Accrual system of Accounting
III End Course Assessment Test
IV Evaluation and Valediction.
Railway Financial Accounting System and Works Accounts –
Contract Bills
3 Working Days)
Course contents
DAY SESSION TOPIC
Day 1
I Revenue & Works expenditure- an overview
II Initial accounts of Revenue and works expenditure
III Revenue expenditure, Revenue allocation Register
IV
Monthly financial Reviews, reappropriation , review of
expenditure, review of works expenditure, watch over
progress of expenditure
Day 2
I Expenditure against the capital suspense grants, monthly
reviews of suspense grants
II Excheque control, expenditure and accounting on staff, fuel,
works and store
III Civil grants and allocation of expenditure amongst various
heads of account
IV Tender System- Invitation of tender to contract agreement
and Execution of contract, Condition of contract, Variation
in contract conditions and settlement of disputes
Day 3
I Contracts- Type of Contracts, Preparation of contractors
bills- Running on account bill and final bill
II Commissioning and completion of Railway projects
III Evaluation and assessment test
IV Evaluation and valediction
Seminar on Social Sector Audit
3 Working Days) Course contents
DAY SESSION TOPIC
Day 1
I & II Overview of Social Sector and new challenges in Social Sector
III & IV Strategic Planning and Planning Individual Social Sector Audit
Day 2
I & II Implementing Social Sector Audit Plan and Role of Criteria in
Social Sector Audit
III & IV Social Sector Audit in EDP Environment – Evidence Gathering
and Audit Techniques
Day 3
I & II Reporting and follow up process for Social Sector Audit
III & IV Group Discussion and Valediction
Special Course on Important Provisions of New Companies Act, 2013
(including Important Accounting Standards)
5 Working Days)
Course contents
DAY SESSION TOPIC
Day 1
I Fundamentals of Ethics and Code of Ethics for IA & AD
II Overview of Companies Act 2013 vis-à-vis Act 1956-Changes
in the Companies Act and new provisions
III & IV Cash Flow statement-Process of preparing Cash flow statement,
Accounting policies, utility and limitation of CFS
Day 2
I & II New concept of interest for Audit-Related Party transactions for
PSUs , Corporate Social Responsibility and Sustainability
III & IV Statutory authorities this Act- National Financial Reporting
Authority( NFRA), National Company Law Tribunal (NCLT) and
SF10
Day 3
I & II Salient features of ICAI Accounting Standards- Applicability,
Interpretation, Scope and Compliance
III & IV Framework and objectives of IFRS and underlying assumptions
Day 4
I & II Consolidated Financial Statement-ICAI’s guidance note on CFS,
Provisions of Act/Rules vis-à-vis AS-23/27 on consolidation
associates/first ventures
III & IV Board and Directors responsibility-Independent Directors, Mandatory
Committees, Key Managerial Personnel
Day 5
I & II Major changes in auditing-Statutory Auditor’s appointment,
eligibility, disqualification, increased responsibilities and penalties,
Supplementary Audit by CAG
III End Course Evaluation Test
IV Evaluation Assessment
Special Course on Performance Audit
5 Working Days)
Course contents
DAY SESSION TOPIC
Day 1
I & II Fundamentals of Ethics and Code of Ethics for IA& AD
III & IV Distinguished features of New Performance Audit Guidelines 2014
Day 2
I & II Audit Mandate and General principles of Performance Audit
III & IV Strategic audit planning and selection of audit topics
Day 3
I & II Planning individual Performance audit
III & IV Implementing the Performance audit
Day 4
I & II Evidence and Documentation in Performance audit
III & IV Developing Audit Conclusions from audit findings with a case
study
Day 5
I & II Reporting process and follow up of Performance audits
III End Course Assessment Test
IV Evaluation and Valediction
Special Course on Auditing of Public Private Partnership (PPP) Projects
5 Working Days)
Course contents
DAY SESSION TOPIC
Day 1
I Fundamentals of Ethics and Code of Ethics for IA& AD
II
An overview of Public Private Partnership (PPP). Public Private
Partnership and Privatisation. Role of private sector partners in
PPP Projects
III & IV Procedure for Formulation and Appraisal of PPP Projects in
Infrastructure and Model Concession Agreements (MCA)
Day 2
I & II Identifying and sharing risks, Management and treatment of
various risks in infrastructure projects
III & IV Selection of PPP Project for audit and preparation of Audit Plan
with a case study. Audit methodology. Audit of Project
Formulation and Approvals.
Day 3
I & II Scope and objectives of various PPP Audit. Types of various PPP.
PPP Audit in different infrastructure sectors.
III & IV INTOSAI guidelines for the audit of PPP Projects. Documents to
be audited in a PPP Audit.
Day 4
I & II Reporting of Audit findings in PPP Audit of Infrastructure
Projects and recommendations.
III & IV Introduction to International Standards of Supreme Audit
Institutions.
Day 5
I & II Time Management : utilizing time in a useful manner and making
time a follower and not a teacher
III End Course Assessment Test
IV Evaluation and Valediction
Special Course on Common Administrative issues and writing of APARs
5 Working Days)
Course contents
DAY SESSION TOPIC
Day 1
I Fundamentals of Ethics and Code of Ethics for IA& AD
II
Overview of DP’s Rules – CCS (Conduct) Rules 1964, CCS
(CCA) Rules 1965, Provisions under Constitution of India and
Principles of Natural Justice
III & IV Minor and Major Penalties under CCS (CCA (Rules)) Provisions,
procedure & decision relating to suspension
Day 2 I & II
Preliminary inquiry – identification of appropriate disciplinary
authority, authenticity of the complaint and necessary for
preliminary inquiry
III & IV Case studies relating to components, drafting & issuing charge sheet
Day 3
I & II Inquiry – Preliminary hearing, regular hearing, bringing the
documents on record, right of charged officer.
III & IV Cases where criminal prosecutions also on double jeopardy
panelled departmental action
Day 4
I & II Brief Explanation about roster system and DPC meetings about
recruitment and promotions
III & IV Nature of penalties & drafting / issue of penalty order and
processing an appeal & drafting an order on appeal
Day 5
I & II Annual Performance Appraisal Reports – writing, importance and
evaluation of such reports.
III End Course Assessment Test
IV Evaluation and valediction
Special Course on Risk Based Audit Approach (RBAA)
3 Working Days)
Course contents
DAY SESSION TOPIC
Day 1
I Fundamentals of Ethics and Code of Ethics for IA& AD
II Risk Based Audit Approach – Identification and Assessment of
Risk and Risk Model
III & IV Determining Materiality and its importance in Risk Based Audit
Approach
Day 2
I & II Internal Control, Risk Analysis and Risk Based Sampling in Audit
III & IV Relevance of Statistical Sampling in Audit and Multistage
Statistical Sampling in Audit
Day 3
I & II Case Study on Audit Risk in EDP Environment Group Discussion
on High Risk Areas in Audit
III End Course Assessment Test
IV Evaluation and valediction
Seminar on Performance Audit
3 Working Days) Course contents
DAY SESSION TOPIC
Day 1
I & II Distinguished features of Performance Audit Guidelines and
New Challenges in Performance Audit.
III & IV Strategic planning and planning individual Performance Audit
Day 2
I & II Implementing Performance Audit Plan and Role of Criteria in
Performance Audit
III & IV Performance Audit in EDP environment – Evidence gathering
and audit techniques
Day 3
I & II Reporting process and follow-up of Performance Audit
III & IV Group Discussion and Valediction
Special Course on Accrual Accounting
3 Working Days)
Course contents
DAY SESSION TOPIC
Day 1
I Fundamentals of Ethics and Code of Ethics for IA& AD
II Introduction to Accrual basis Accounting System
III & IV Review of present system of accounting
Day 2
I & II Role of GASAB on development of Accrual Accounting
Standards
III & IV Nature of reporting in Accrual Accounting and positive factors in
Accrual Accounting
Day 3
I & II Public Sector Financial Reporting Frame Work.
III End Course Assessment Test
IV Evaluation and Valediction
Special Course on Environment Audit
(03 Working Days)
Course contents
DAY SESSION TOPIC
Day 1
I Fundamentals of Public Sector Ethics and Code of Ethics for
IA& AD
II Introduction to Environment - Environment policies,
programmes, legislation and management
III & IV Impact of Global warming and climate change in environment
Day 2
I & II Clean Development Mechanism (CDM) for environmental
improvement
III & IV Audit process in Environment Audit including importance and
selection of Audit Criteria
Day 3
I & II Sustainable development and elated Environmental issues
III End course assessment test
IV Evaluation and valediction.
Special Course on Audit of Social Sector Audit
5 Working Days)
Course contents
DAY SESSION TOPIC
Day 1
I Fundamentals of Ethics and Code of Ethics for IA& AD
II Institutional Framework of Social Audit and Role of CAG in Social
Audit
III & IV Scope and objectives of Social Audit. Different Stages of Social
Audit
Day 2 I & II
Integration of social audit in NREGA. Social Audit in gram Sabha.
Post Social Audit Action.
III & IV Social Obligations of PSUs and problems faced by Social Audit.
Day3 I & II
Audit of Central/State Schemes implemented through Zila Parishads
and Panchayat Samities.
III & IV Audit of Zila Parishads and Panchayat Samiti Fund Audit.
Day 4 I & II
Audit of Works Accounts and Stores and Stock Accounts of Zila
Parishad and Panchayat Samities
III & IV Social Audit and Environment Management
Day 5
I & II Case Study and discussion, presentation by participants
III End Course Assessment Test
IV Evaluation and valediction
Special Course on International Standards of Supreme Audit Institutions
(ISSAI)
3 Working Days)
Course contents
DAY SESSION TOPIC
Day 1
I Fundamentals of Ethics and Code of Ethics for IA& AD
II Introduction to ISSAI- Objectives and founding principles
III & IV Level II ISSAIs- pre-conditions for functioning of SAIs
Day 2 I & II ISSAI guidelines on Financial Audit
III & IV ISSAI guidelines on Performance Audit-
Day 3
I & II ISSAI guidelines on Compliance Audit-
III INTOSAI GOVIN Guidelines for good governance
IV End Course Assessment Test
5.00 PM Evaluation and Valediction
Special Course on Audit of VAT (5 Working days)
Course contents
DAY SESSION TOPIC
Day 1
I & II Fundamentals of Ethics and Code of Ethics for IA& AD
III & IV Measures to regulate transport of goods, seizure of goods and penalty
provisions
Day 2
I & II International experience of VAT and VAT structure in Rajasthan
III & IV Important Definitions under VAT Act, Liability, Registration and
Schedules.
Day 3
I & II Net Tax Payable & maintenance of VAT Accounts, Input Tax, Input &
Output Tax
III & IV Tax structure in India – Indirect
Tax and need for rationalization
Day 4
I & II Scrutiny and verification of returns, Assessment,
Recovery and Refunds under VAT
III & IV Provision relating to Audit of VAT, Conduct and Reporting results of
audit
Day 5
I & II Different types of VAT Fraud and its impact with a case study
III End Course Evaluation Test
III & IV Evaluation and Valediction
Special Course on Audit of CERA, GST and ACES (5 Working days)
Course contents
DAY SESSION TOPIC
Day 1
I Inauguration of the Course and Introductory talk on CERA and
GST
II Fundamentals of Public Sector Ethics and Code of Ethics for IA&
AD
III & IV Implementation and utilisation of ACES, Impact of ACES on
working of various wings of the Central Excise and Service Tax
Department.
Day 2
I & II Valuation Principals with case laws, Adjudication, Appeal, Levy
of penalties, interest, refunds.
III & IV Latest changes in Service Tax with case studies
Day 3
I & II Audit methodology, Determination of periodicity, sample
selection under Risk analysis, follow up of LARs/Processing of
DPs/ATNs, recovery at the instance of audit
III & IV Basic Concepts of GST
Day 4
I & II Implementation process and prospective of GST
III & IV CENVAT Schemes with latest studies of Case Laws.
Day 5
I & II End course assessment test and discussion
III & IV Evaluation and Valediction of the Course
Special Course on Financial Attest Audit
5 Working Days)
Course contents
DAY SESSION TOPIC
Day 1
I Fundamentals of Ethics and Code of Ethics for IA& AD
II Concept and overview of Financial Attest Audit Manual (FAAM).
Broad principals of Accountancy and Basics of Financial
Management
III & IV Accounting Standards as issued by the Institute of Chartered
Accountants of India and Disclosure requirement
Day 2
I & II Audit Planning and Field Audit Programmes, Audit Objectives and
approach for Financial Statement audit
III & IV Importance of materiality in audit of Financial Statements during
Financial Attest Audit
Day 3
I & II Identification and assessment and analysis of Risk in Financial Attest
Audit
III & IV Need for statistical sampling , Random Sampling, Random Number
Sampling Distribution and Analytical Review
Day 4
I & II Monetary Unit Sampling and application of sampling in Financial
Attest Audit using IDEA package
III & IV Principals of Reporting and drafting of reviews relating to Financial
Attest Audit
Day 5
I & II Case study on Railway specific Financial Attest Audit and Group
Discussion.
III End course assessment test
IV Evaluation and valediction.
Special Course on CCO Based Audit (Department Centric Audit)
3 Working Days)
Course contents
DAY SESSION TOPIC
Day 1
I Fundamentals of Ethics and Code of Ethics for IA& AD
II Concept and objectives of Department Centric Audit
III & IV Risk evaluation and selection of CCO/DDO units
Day 2 I & II Planning and methodology of CCO Based Audit
III & IV Broad parameters for executing CCO based audit
Day 3
I & II Reporting of Department Centric Audit
III End Course Assessment Test
IV Evaluation and Valediction.
Financial Attest Audit in Railways
5 Working Days)
Course contents
DAY SESSION TOPIC
Day 1
I Fundamentals of Ethics and Code of Ethics for IA& AD
II
Concept and overview of Financial Attest Audit Manual (FAAM).
Broad principals of Accountancy and Basics of Financial
Management
III & IV Accounting Standards as issued by the Institute of Chartered
Accountants of India and Disclosure requirement
Day 2
I & II Audit Planning and Field Audit Programmes in Railway Audit
III & IV Importance of materiality in Financial Statements of Railway
Accounts
Day 3
I & II Identification and assessment and analysis of Risk in Railway
specific audit.
III & IV Need for statistical sampling, Random Sampling, Random Number
and Sampling Distribution.
Day 4
I & II Principals of Reporting and drafting of reviews relating to Financial
Attest Audit
III & IV Monetary Unit Sampling and application of sampling in Railway
Audit using IDEA package.
Day 5
I & II Case study on Railway specific Financial Attest Audit and group
discussion.
III End Course Assessment Test
IV Evaluation and valediction.
Special Course on General Management
5 Working Days)
Course contents
DAY SESSION TOPIC
Day 1
I & II Fundamentals of Ethics and Code of Ethics for IA&AD
III & IV Organisation of IA&AD, Functions of Administration and
Office Procedure
Day 2
I & II Organisational Behaviour and Human Resource Development
III & IV Disciplinary proceedings as a tool for improvement in
management
Day 3
I & II Transparency and accountability for Good Governance i
III & IV Motivation and leadership for Government employees to
improve efficiency
Day 4
I & II Budgetary control and propriety in public expenditure –
understanding of Financial Statements
III & IV Time management and stress management for better
performance
Day 5
I & II Gender Sensitisation for improved work culture
III End Course Assessment Test
III & IV Evaluation and Valediction of Course
Special Course on Audit of Direct Taxes (5 working days)
Course contents
DAY SESSION TOPIC
Day 1
I & II Fundamentals of Public Sector Ethics and Code of Ethics for IA&
AD
III Audit Mandate- Audit of Receipts under Section 16 of CAG’s
DPC Act. Legal approach to audit of Assessments
IV Briefs on accountal of tax collection and remittances.
Day 2
I & II Audit methodology, Determination of periodicity, sample selection
under Risk analysis, follow up of LARs/Processing of DPs/ATNs
recovery at the instance of audit
III & IV General lay out of Direct Tax Law, Distinction of legal terms in
Direct Tax Laws e.g. Income, Business Expenditure, Definition
of important terms and evaluation of their meaning – case laws
Day 3
I & II MAT Provisions, Clubbing of Income, set off of losses. Income
from capital gains/ capital losses, exemptions and deductions available
there-under;
III & IV How to read a Balance Sheet? Income not forming part of total
income. Exemptions under Chapter III, Provisions of Section 14A
Day 4
I & II Chapter VIA deductions and tax rebates with case studies
III Corporate Taxation: Theory – Definition in Corporate Taxation,
Section 115 O 115Q, 115R : Venture Capital companions,
liquidation of companies under Section 178, 179,
IV Income from business or profession including section 44, 44A,
44AA, 44AB, 44AD/AE/AF and presumptive income on non
residents – 44B, 44C
Day 5
I & II End course assessment test and discussion
III & IV Evaluation and Valediction
Special Course on Audit Quality Management Framework
3 Working Days)
Course contents
DAY SESSION TOPIC
Day 1
I Fundamentals of Sector Ethics and Code of Ethics for IA&
AD
II Introduction to Audit Quality Management Framework and its
broad parameters
III & IV Audit Management and relationship with clients – Audit
Planning and Execution, Reporting and Follow up
Day 2
I & II Human Resource Development - leadership and Direction
III & IV Capacity Building – Staffing and training of Audit Personnel
as per Auditing Standards
Day 3
I & II Continuous Improvement through Internal Audit, Internal
Quality Assurance and Peer Review
III End Course Assessment Test
IV Evaluation and Valediction
COURSE CONTENTS
Computer Course on Level 2 Group 1
Database concepts, system concepts and introduction to MS Access
(05 Working Days) DATE & DAY TOPIC
Day 1
Inauguration
Fundamentals of Public Sector Ethics for IA& AD
Introduction to RDBMS Concepts
Creating a Database -Designing the Database
-Using the Database Wizard
-Looking at Database Properties
Day 2
Creating and Modifying Tables -Creating a New Table Structure with the Table Wizard
-Creating a New Table from Scratch
-Modifying the Table Design
-Ensuring Data Validity
-Creating a New Table in Datasheet View
-Copying an Existing Table Structure
-Setting Table Properties
Relating Tables -Defining a Relationship
-Viewing and Editing Relationships
-Printing the Relationships
Day 3
Entering and Editing Data -Entering New Data
-Customizing Data Entry
-Changing the Datasheet Appearance
-Changing Table Definition in Datasheet View
-Editing Record Data
-Printing Table Data
Extracting Information with Queries -How Do Queries Work?
-Creating Select Queries
-Adding Selection Criteria
-Setting Query Properties
-Modifying a Query- Performing Calculations in a Query
Day 4
Creating Advanced Queries -Creating Special Purpose Queries -Find Duplicate query
Creating Advanced Queries
Day 5
Using the Form Wizard -Creating a New Form Design
-Modifying the Form Design
-Using the Form
-Printing the Form
Using the Report Wizard -Creating a New Report Design
-Previewing the Report
-Printing the Report
-Modifying the Report Design
-Saving the Report Design
-Using Report Snapshots End-of-Course Assessment and Evaluation & Valediction
Computer Course on SQL (05 Working Days)
DATE & DAY TOPIC
Day 1
Inauguration
Fundamentals of Public Sector Ethics for IA& AD
Introduction to RDBMS Concepts
Writing Basic SQL Statements
Day 2
Restricting and Sorting Data (Where clause, Character Strings and Dates and
Comparison Operators)
Selecting Data from Oracle Other Comparison Operators Using the (BETWEEN,IN,LIKE, IS NULL)Operator, Logical
Operators, Using the (AND,OR,NOT) Operator, Rules of Precedence,
ORDER BY Clause, Sorting in Descending Order, Sorting by Column
Alias, Sorting by Multiple Columns
Day 3
Single-Row Functions SQL Functions, Two Types of SQL Functions, Single-Row Functions,
Character Functions, Case Conversion Functions, Character
Manipulation Functions, Number Functions (ROUND, TRUNC,
MOD), Working with Dates, Arithmetic with Dates, Using Arithmetic
Operators with Dates, Date Functions, Conversion Functions
(TO_CHAR, TO_NUMBER, TO_DATE), Date Format, Special
Functions (NVL, DECODE), -Nesting Functions
Displaying Data from Multiple Tables -EQUIJOIN, NON-EQUIJOIN, OUTERJOIN, SELFJOIN Aggregating Data Using Group Functions -AVG, SUM, MIN, MAX, COUNT
-GROUP BY and HAVING Clauses
Day 4
Subqueries
Creating and Managing Tables CREATE TABLE, ALTER TABLE, DROP TABLE
Manipulating Data INSERT, UPDATE, DELETE, COMMIT, ROLLBACK
Day 5
Including Constraints
End-of-Course Assessment
Evaluation & Valediction
‘Audit in IT Environment’ (06 Working days)
P R O G R A M M E Date & Day Session Topics
Day 1 I Ice Breaking Session
Entry Knowledge Test (EKT)
II Understanding IT environment- Challenges and opportunities
III Importance of controls with specific reference to Application Controls
IV Introduction to CAATs – IDEA and Excel
Day 2 I Excel as data analytic tool- Features of Excel
(we intend to cover the aspects relating to following underlining the purpose for which these are used as Audit Tool)
Conditional formatting
Filter including Advanced filter
Pivot Table
II Hands on session
III Excel functions – User defined functions
Numeric
Text
Conditional
Date and time
Financial
Aggregation
IV Hands on Session
Day 3 I Creating Projects – Managed and External, Import of data from diverse formats –Excel, Access, csv, text ; understanding data using the field statistics, Checking validity of data through Control totals, creating current documentation of tasks performed using the history property, Project Overview
II Hands on Session
III Importing of PDF/PRN Data, Importing data using ODBC, Indexing of Data – Quick Index, Composite Index, Sorting Data
IV Hands On Session
Day 4 I Field Manipulation in IDEA – Append, Remove, Modify columns – Data types –
Virtual, Non Virtual, Editable, Enabling/Disabling deletion of non-virtual fields
Analysis Basic data analysis in IDEA – Duplicate Key Detection/Exclusion, Gap Detection, Summarization
II Hands on Session
III Data Extraction – Direct Extraction, Key value extraction, Top/Bottom Records extraction, Indexed Extraction
Working with multiple databases – Join, Visual Connector, Append, Compare
IV Hands on Session
Day 5 I Commonly used @ Functions in IDEA, introduction to #functions
II Stratification of Data, Aging analysis, Sampling
III & IV Exporting Data from IDEA to other formats, Creating and Printing Reports in IDEA
Revision & Queries
Hands on Session
Case Study – Selection of vouchers
Day 6 I , II & III Way Forward – Overview of Qlikview
IV Way Forward -Overview of Tableau
top related