Data Science

Business Analytics with SQL & Excel

Business analysis requires you to effectively transform data into actionable information. In this course, you use SQL and Excel to extract business information from relational databases and use that data to define business dimensions, store transactions about customers, produce results, and more. In this course, you will learn about Data Wrangling, statistics using Excel, Linear regression, EDA and lastly on RDBS and SQL.

Verified Certificate

Guided Projects

12 hrs content from Top instructors

5+ Assignments & Quizzes

Discussion Support

Course Fee
₹ 8,000

₹ 3,999 incl. GST

Course Duration

12 Hrs

Prerequisite

  • 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 Scientist
  • Machine Learning Expert
  • Data Engineer

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.

Great Learning - Machine Learning Certificate

Curriculum

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

EDA

Great Learning - Data Analytics using Excel Cerificate 3 hrs

  • Pivot tables
  • Data visualizations
  • charts part 1
  • charts part 2
  • 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

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.