Western India Regional Council of
The Institute of Chartered Accountants of India

(Set up by an Act of Parliament)

Welcome, Guest

Virtual Workshop on Data Analytics and Database Management - Member

Fees: Member & Student ₹10620/-                                    Non Member ₹11800/-             

Please Pay your Attention here: Separate Link will be sent for each day for Joining Webinar. Each day new Link will be shared on the email id submitted while carrying out registration. 

To ensure timely receipt of link, kindly: 1. White list email from wircweblink@icai.in /customercare goto webinar.com. 2. Check Spam Box. 3. Incase of non-receipt of link & technical difficulty write email with payment details on wircevents@icai.in 

Event Details

Event Date 04-06-2021
Event End Date 18-07-2021

About the course:

ICAI – WIRC in association with School of Data Science and Business Intelligence (SDBI) presents 60hrs online training in Data Analytics and Database Management

This course presents a gentle introduction into the concepts of data analysis, the role of a Data Analyst, and the tools that are used to perform daily functions. This to help students and members upskill themselves and embrace new age opportunities.

Highlights of the program

1. Get hands on training in Python, Microsoft Power BI, SQL, RPA tools and understand practical use cases of these new-age tools in the accounting and finance world.

2. Understand how professional data analytics techniques can be combined with traditional audit approaches enabling new ways for auditors to interrogate, understand, and gain assurance over client data.

3. Test entire data sets rather than extrapolating samples. This will increase efficiency and streamline processes, ultimately improving the quality of audits.

4. Introduce new areas of advisory of using data to drive business strategy and performance.

5. Predictive accounting to become competitive and add value to their clients as they continue with their professional development education over the lifetime of their professional activities.

Topics
What You Will Learn

Data Analysis using Python Programming

a. The crisp framework of data analytics
b. Types of Analytics
c. Introduction to Python
d. Introduction to data analysis
e. Statistical Data Analysis
f. Data Visualization and Graphics with Python
g. Probability and bayes theorem
h. Exploring two-dimensional data
i. Credit risk and operational application
 
Database Management using SQL

a. Introduction to DBMS
b. Structured Query Language
c. Data Retrievals and Joins
d. Advance Queries and Database Objects
e. Security Privileges, Set Operators & Data Time Functions
f. Advanced Subqueries

Project Work/Case Study

 

 Program Delivery Details:

  • Course shall be conducted per the following time table
    • Friday ---- 6 pm to 8pm (2 hours)
    • Saturday---- 10 am to 2 pm (4 hours)
    • Sunday ----- 10 am to 2 pm (4 hours)
  • Program shall be conducted online, and each participant shall be given access to SDBI’s Learning Management System (LMS).
  • Post the completion of each Part, participants will receive a Certificate of Participation from ICAI-WIRC.
  • On completion of this program you will receive SDBI digital badge to share with your online professional network, which is available as a downloadable PDF certificate suitable for printing and framing.

LIMITED SEAT 30 PARTICIPANTS FIRST CUM FIRST BASIS 

 

Note: For Students Registration click on below link:

https://wirc-icai.org/student/students-events-registration/536-virtual-workshop-on-data-analytics-and-database-management-student

 

For all queries related to program email us on wircevents@icai.in

 

Members