HDI

₹25,000 ₹31,000

Course Includes

Duration6 Months
Enrolled0
Lectures90
Videos0
Notes0
CertificateYes

What you'll learn

The Certificate in Data Analytics is a career-focused program designed to develop essential data analysis skills using industry-standard tools. This course starts with computer fundamentals and gradually builds expertise in Excel, SQL, Python, Power BI, and Tableau for data handling, analysis, and visualization.

Students will learn how to collect, clean, analyze, and present data effectively to support business decision-making. With a strong focus on practical learning and real-world use cases, this course prepares learners for roles such as Data Analyst, MIS Executive, Business Analyst, and Reporting Analyst.

Course Syllabus

Module 1: Fundamentals of Computer

Introduction to Computer & IT
Operating System Basics
File & Folder Management
Internet, Email & Cyber Safety

Module 2: Excel for Data Analysis

Excel Basics & Advanced Functions
Data Cleaning & Formatting
Logical, Text & Date Functions
Lookup Functions (VLOOKUP, HLOOKUP, XLOOKUP)
Pivot Tables & Pivot Charts
Conditional Formatting & Dashboards

Module 3: SQL for Data Analytics

Database Concepts
SQL Commands (DDL, DML, DCL)
SELECT, WHERE, GROUP BY, HAVING
Joins & Subqueries
Data Analysis using SQL

Module 4: Python for Data Analytics

Python Basics & Syntax
Variables, Data Types & Control Flow
Functions & Modules
NumPy for Numerical Analysis
Pandas for Data Handling
Data Cleaning & Transformation

Module 5: R Language for Data Analytics

Introduction to R & RStudio
Data Types & Data Structures in R
Data Import & Export
Data Manipulation using dplyr
Data Visualization using ggplot2
Basic Statistical Analysis

Module 6: Power BI

Power BI Interface
Data Import & Transformation
Data Modeling
DAX Fundamentals
Interactive Reports & Dashboards

Module 7: Tableau

Tableau Basics
Connecting Data Sources
Charts, Filters & Calculations
Dashboard & Story Creation
Data Storytelling & Insights

Module 8: Mini Project & Practical Training

Real-world Dataset Analysis
Excel / SQL / Python / R based Analysis
Power BI & Tableau Dashboards
Final Project Presentation

Course Fees

₹31000/-

Discounted Fees

₹ 25000/-

Course Duration

6 Months

Review

0.0

Course Rating (0 reviews)

Featured review

No reviews yet. Be the first to review this course!

Diploma In DATA ANALYTICS(M-DA-3988)