Data Analysis &
Visualization THEMED TRACK
Business Intelligence using Power BI and Tableau
3-Course
Data Analytics using R
Series MS Excel Essentials
Inaugural Price
Duration of 63 Hours 12,750/- Plus Taxes
access anytime and anywhere
Organizations value data as an asset. When
Online Self-Paced managed effectively, data can help define long-
Learn at your convenience term business strategies, improve systems and
streamline processes, mitigate risks, and gain a
competitive edge. This program will teach
1-Year of Access learners how to transform data into actionable
Get LMS access for one year
insights, maximize the value of data for an
organization, analyze large datasets quickly,
Completion Certificate and develop reporting dashboards that make
Jointly issued by NAL & GT Bharat data more accessible.
Business intelligence is a strategic tool that
helps organizations track trends, identify
Online Query Support actions, and understand their overall
Through LMS, by SME within 48-Hrs
operations. It can improve processes,
efficiency, and decision-making.
[email protected] +91 86556 47391 Program Website Enroll Now!
Business Intelligence (Power BI & Tableau)
Module 1: Introduction
Module 2: Power BI
Module 3: Tableau
Module 4: Software Support
a. Support Material
b. Final Assessment
c. Power BI and Tableau Instructions
d. oftware Download Instructions
[email protected] +91 86556 47391 Program Website Enroll Now!
Data Analytics using R
Module 1: Introduction and Programming
1. Introduction to Data Analytics
2. Introduction to R
a. R programming
b. R programming - Case Study
c. Customer Churn
Module 2: Statistics and Visualization
1. Data Visualization: Various graphs, charts
2. Data Visualization: Advance
3. Descriptive Statistics: Basic statistical techniques including data properties: Hypothesis
testing DPLYR package.
4. Linear Regression Model
5. Multinomial Linear Regression - Case Study
6. Logistic Regression
7. Multinomial Logistic Regression
a. Multinomial Logistic Regression - Case Study
Module 3: Advance Methods
1. Introduction to Artificial intelligence, ML and Deep learning
2. Neural Networks
3. Support Vector Machines (SVM)
4. Support Vector Machines (SVM) - Case Study
5. Decision Tree
6. Random Forest
7. K-nearest Neighbors
8. K-nearest Neighbors - Case Study
9. Clustering (K Means)
10. Principle Component Analysis
11. Principle Component Analysis - Case Study
[email protected] +91 86556 47391 Program Website Enroll Now!
MS Excel Essentials
Module 1: Excel Functions 1 Module 4: Excel Functions 4
1. Introduction to Excel 24. Query Editor
2. Fundamentals of Excel 25. Power Query 2
3. Cell Freezing and Referencing 26. Power Query 3
4. Paste Special 27. Power Query 4
5. Conditional Formatting 28. Index and Constitutional Columns
6. Sorting, Filter, SUM and SUMIF 29. Grouping and Aggregating Data
7. COUNT, COUNTIF and COUNTIFS 30. Power Query 5
8. Average, Max, Min, Median and CAGR
Module 1: Excel Functions 5
Module 2: Excel Functions 2
31. Introduction to Data Models
9. Rounding Function – ROUNDUP and 32. Primary Key, Foreign Key, Data table and Lookup
ROUNDDOWN 33. Creating Relationships
10. Text Functions 34. Hierarchies
11. Advance 35. Power Pivot
12. Charts 36. Dashboards
13. Group and Ungroup
14. Subtotal
15. Sum Product
Module 3: Excel Functions 3
16. Large and Small
17. Text to Column
18. What if analysis – Data Table
19. IRR and NPV
20. PPS – Choose Function
21. Transpose
22. Pivot Table
23. Analytics
[email protected] +91 86556 47391 Program Website Enroll Now!
ADVANCED
E-LEARNING COURSES
CO-CERTIFIED BY
GRANT THORNTON & NSE ACADEMY
Grant Thornton & NSE Academy,
Get ready with specialized skills
sets in advance analytics and self-paced courses are designed
technologies.
to impart practical knowledge and
skills to the learners. The
Courses designed by
professionals at Grant Thornton programs are helpful to those
individuals who aim to build or
In-course exercises files to help
advance careers in specialized
apply knowledge in real-world
situations. domains like Finance & advanced
technologies like Blockchain,
Joint certificate will be awarded
by Grant Thornton & NSE Analytics, Cyber Security, and
Academy upon completion.
Taxation.
About Grant Thornton Bharat LLP
Grant Thornton Bharat (GT) is truly a global organization with 62,000+ people in more than 130
countries. No matter, how big the organization or the international challenges you face, GT has
the resources to match and provide solutions. The organization has member firms in over 130
countries worldwide. It is ranked one of the top six firms in 88 markets around the world and
established in all major business centres and emerging markets.
The organization serves India region with 13 offices in all major cities with more than 15,000
people.
About NSE Academy
NSE Academy Limited is a wholly owned subsidiary of the National Stock Exchange of India
Limited (NSE). NSE Academy Limited enables the next generation of BFSI and FinTech
professionals with industry aligned skills – through capacity building programs and certification
courses, powered by an online examination and certification system. The courses are well-
researched and carefully crafted with input from the industry professionals. NSE Academy
Limited works closely with reputed universities and institutions across India in building a
competent workforce for the future of BFSI and FinTech. NSE Academy Limited also promotes
financial literacy as an essential life skill among youngsters – a contribution towards financial
inclusion and wellbeing. For more information visit: https://www.nseindia.com/
Disclaimer
It is clarified that NSE Academy does not, in any manner whatsoever, assure, warrant, guarantee, or promise any job/placement/advancement to any
Participant. Under no circumstances, NSE Academy shall be held responsible/liable for failure on the part of the Participants to pass / successfully
clear the interview process or the requirements to successfully secure a job.
The information here can be used only by NSE Academy Ltd. It may not be reproduced in whole, or in part, nor may any of the information contained
therein be disclosed without the prior consent of the authorized representatives of "NSE Academy Ltd." except within the organization.
Any form of reproduction, dissemination, copying, disclosure, modification, distribution, and or publication of this material is strictly prohibited.
All the courses are administered by the NSE Academy Ltd and Grant Thornton Bharat LLP. The participants need to complete certificate criteria
independently to be eligible for the respective certificates.
The Course Content/Outline mentioned herein is indicative and may be modified by NSE Academy in the best interest of the participants.
The fee paid is non-transferable and non-refundable.
