Start Learning Now!
Verified Certificate
Self Paced Projects
5+ Assignments & Quizzes
Discussion Support
1000+ Courses for Free
ESC
Data Science
Master Data Analytics in SQL & Excel
Course Description
Course Fee
₹ 15,000 incl. GST
Prerequisite
- Basic statistics
- Excel (basics)
- Regression line
Your Faculty
Dr. Abhinanda Sarkar
PhD (Stanford University)
Academic Director, Great Learning
Dr. Abhinanda Sarkar has a degree in B.Stat. and M.Stat. from the Indian Statistical Institute (ISI) and a Ph.D. in Statistics from Stanford University. After working in the research teams at MIT and IBM, he spent a decade at General Electric in Bangalore. Currently, he is an Associate Dean at the MYRA School of Business and a certified Master Black Belt in Lean Six Sigma and Design for Six Sigma. He has been currently adjunct or visiting faculty at Stanford, ISI Delhi, the IIM-B and IISC.
Dr. P.K.Viswanathan
PhD (Madras University)
Professor, Analytics, Great Lakes Institute of Management
He has been ranked consecutively for three years as one of 10 Most Prominent Analytics Academicians in India-2017, one of 20 Most Prominent Analytics & Data Science Academicians in India 2018, and done of 10 Most Prominent Data Science Academicians In India: 2019. Dr. P.K.Viswanathan teaches MBA students, Business Statistics, Business Analytics, Predictive Analytics, Machine Learning Analytics, and Spreadsheet Modeling, He is the Principal Faculty in Analytics for the Management Development Programs conducted by Great Lakes.
Mr. Aniruddha Kalbande
Entrepreneur
His areas of specialization are Machine Learning, Data Science, Research and Strategic Planning. He took various workshops and seminars on Data Science, Soft Skills, Hack for Interviews and How to Excel in Engineering.
Mr. Vinit Thakur
Certified Psychometric Analyst
He has held several notable positions with various International Organizations and Universities such as US Technology Resources LLC( as Global Head of Learning and Competency Development), International Institute of Information Technology (as Associate Professor of IT), Professional Management Centre, Dubai (as Trainer) and Indo German Chamber of Commerce ( as a functional CIO, and Centre Head, Mumbai).
Target Job Roles
- The course helps you in gearing yourselves for the below-mentioned job roles which are in high demand and pay a good salary
- Business Analyst
- Data Analyst
- Decision Analyst
Projects
This is an industry relevant real-world case study through which you will be implementing the core concepts studied in this course.
Terro's Real Estate Agency
Certificate
Earn a Verified Certificate from Great Learning Academy, which is highly regarded and valued by corporates. Make your CV & LinkedIn profile stand out from the rest.
Curriculum
Module 1
Data Wrangling
3 hrs
- Cell Referencing
- Tables and borders
- Basic functions
- Sorting
- Filtering
- Date and time
- Basic statistical functions
- Show more
Module 3
Statistics using Excel
2 hrs
- Measures of central tendency
- Measures of dispersion
- Measures of symmetry
- Normal distribution
Module 4
Linear Regression
1.8 hrs
- Covariance
- Correlation
- Simple linear regression
- Multiple linear regression
Module 5
Introduction to RDBMS and SQL
2.8 hrs
- Introduction to database
- Types of data models
- Advantages of DBMS
- Introduction to RDBMS
- Hands-on exercise with DB browser for SQlite
- SQL - hands on in python
- Show more
FAQs
For how long can I access these courses?
You can access all these courses for 1 year.
Is it 100% online learning and self-paced?
It is a 100% online learning course that you can learn at your own pace through our website and mobile app.
On what basis are the certificates rolled out?
The certificates are rolled out as and when you complete the mandatory course content and submit the project with a satisfactory grade.
Will I gain access to any sort of Forum support?
Yes. You will gain complete access to our Discussion forum support in your course to connect with our SMEs to resolve your course content related queries within 48 hrs.
Is there a refund in case I want to discontinue from the course?
Fees once paid is not refundable. Kindly make an informed decision before enrolling into the course.