Business Intelligence (Using Power BI & Tableau)
3-Course
Data Analytics using R
Series MS Excel Essentials
Online Self-Paced Course
DATA ANALYSIS & VISUALIZATION
THEMED TRACK
Duration of 63 Hours
access anytime and anywhere
Price
1-Year of Access Rs 12,750/-
Get LMS access for one year +GST
Completion Certificate
Jointly issued by NSE Academy &
Grant Thornton Bharat
Enroll Now!
Business Intelligence
Course Content
(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
Data
Course
Analytics
Content
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
MSCourse
Excel Essentials
Content
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
ADVANCED
E-LEARNING COURSES
CO-CERTIFIED BY
GRANT THORNTON & NSE ACADEMY
Get ready with specialized skills sets in advance analytics
and technologies.
Courses designed by professionals at Grant Thornton
In-course exercises files to help apply knowledge in
real-world situations.
Joint certificate will be awarded by Grant Thornton & NSE Academy
upon completion.
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.
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.
Contact Details
Prashant: +91 8591297096 | Kritika: +91 9372500961
bmahadik@[Link]
Price: Rs. 12,750/-
+ GST
(Rs. 15,045/- inclusive of GST)
REGISTER & PAY NOW
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.