Data Science

Master Data Analytics in SQL & Excel

Course Description

Data analytics requires you to effectively transform data into actionable information. This course will walk you through the statistical and EDA concepts through excel. You will use SQL to extract business information from relational databases and use that data to define business dimensions, store transactions about customers, produce results, and more. You will also learn about Data Wrangling, Statistics using Excel, Linear regression, and RDBMS.

Verified Certificate

Self Paced Projects

14.5 hrs content from Top instructors

5+ Assignments & Quizzes

Discussion Support

Course Fee
₹ 8,000

₹ 3,999 incl. GST

Learning Hours

14.5 Hrs


  • Basic statistics
  • Excel (basics)
  • Regression line

Your Faculty

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


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.

Great Learning - Machine Learning Certificate


Module 1

Data Wrangling

Great Learning - Data Analytics using Excel Cerificate 3 hrs

  • Cell Referencing
  • Tables and borders
  • Basic functions
  • Sorting
  • Filtering
  • Date and time
  • Basic statistical functions
  • Show more

Module 2


Great Learning - Data Analytics using Excel Cerificate 3 hrs

  • Pivot tables
  • Data visualizations
  • Charts
  • Case study - in brief
  • Show more

Module 3

Statistics using Excel

Great Learning - Data Analytics using Excel Cerificate 2 hrs

  • Measures of central tendency
  • Measures of dispersion
  • Measures of symmetry
  • Normal distribution

Module 4

Linear Regression

Great Learning - Data Analytics using Excel Cerificate 1.8 hrs

  • Covariance
  • Correlation
  • Simple linear regression
  • Multiple linear regression

Module 5

Introduction to RDBMS and SQL

Great Learning - Data Analytics using Excel Cerificate 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


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.