niit logo
  • logo
  • programs PROGRAMS

Data Analytics Foundation Program

Gain expertise in Data Analysis using excel, SQL & Python
Mode Of Delivery

Online Mentor led

/-

( Excluding GST @18% )
Batch Starting From

/-

( Excluding GST @ 18% )
Batch Starting From
Strong Programming Foundation
6 weeks program
1:1 doubt clearing sessions
6 weeks

Strong Programming Foundation

6 weeks program

1:1 doubt clearing sessions

6 weeks

.

HIGHLIGHTS

Ahead of your peers

Prepare learners to perform better on programming and database related college courses

Top skills you will learn

Data Analysis; Data Visualization; RDBMS; SQL; Python

Career Catalyst

Improve critical thinking & problem solving skills. Practice with Real business scenarios.

Who is this program for

Anyone interested can apply for this program

PROGRAMME OVERVIEW

PROGRAMME OVERVIEW

This program will help you build foundational skills in data analysis, data visualization, programming, and Relational Database Management Systems (RDBMS).

Learners will learn how to apply basic statistical methods for data analysis using Excel. Including how to visualize data using graphs. Learners will also be introduced to RDBMSs and learn how to use SQL to retrieve or manipulate data. Then, they will learn to program using Python. Python has become a preferred programming language in the world of analytics.

This program will help learners as they progress through their academic journey. It will lay the foundation for an important programming and data analysis skill that will be of immense value in their academic and professional lives.

 

CURRICULUM

The Program focuses on competency development. It is practice based i.e. learners learn by doing things rather than by watching videos or by attending traditional lectures. Curriculum will cover the following

  • Learn to analyze numerical and categorized data using MS Excel as a tool. Use Descriptive Statistical techniques to analyze the data. Visually present the analysis using graphs & charts in MS Excel
  • Learn to represent data in the form of tables in a Relational Database. Create, update, and retrieve data stored in a MySQL (RDBMS) database. Use Structured Query Language (SQL) to perform various operations on the database.
  • Learn to apply problem-solving techniques to decompose a problem into computational steps. Then translate the steps into a program using the Python language.
  • Use the NumPy and Pandas libraries in Python to perform data analysis.
  • Introduction to Exploratory Data Analysis

FAQs

  • Anyone interested can join.
  • This program will help you build foundational skills in data analysis, data visualization, programming, and Relational Database Management Systems (RDBMS).
  • Learners will learn how to apply basic statistical methods for data analysis using Excel. Including how to visualize data using graphs. Learners will also be introduced to RDBMSs and learn how to use SQL to retrieve or manipulate data. Then, they will learn to program using Python. Python has become a preferred programming language in the world of analytics.
  • This program will help learners as they progress through their academic journey. It will lay the foundation for an important programming and data analysis skill that will be of immense value in their academic and professional lives.
  • Data Analytics Using Excel
  • Analytics using SQL
  • Introduction to Programming using Python
  • Python for Data Science (Using NumPy and Pandas libraries)
  • Exploratory Data Analysis (EDA)

Learners will acquire knowledge and skills to analyse data using Excel, SQL and Python. On successful completion of all the challenges, each learner will be able to:

  • Analyse and Visualize data using Microsoft Excel
  • Build basic programs using basic Python
  • Perform basic data analysis using Python
  • Analyze and visualize data
  • You can read the complete set of Terms and Conditions for this program on the Application page.

Top