Welcome to SARASWATI VOCATIONAL AND EDUCATIONAL COLLEGE

SARASWATI VOCATIONAL & EDUCATIONAL COLLEGE          "Here Skills Meet Success."       "Craft Your Future with Confidence."

 
ADVANCE DIPLOMA IN DATA ANALYST ( M-04 )

BASIC INFORMATION

  • Course Fees : 0.00 0.00/-
  • Course Duration : 1 YEAR
  • Minimum Amount To Pay : Rs.0.00

Eligibility 

Minimum Educational Qualification

  • For Certificate/Diploma Courses:

    • 10+2 (any stream) with basic math and computer knowledge

      Age limit:
    • no age limit

 Syllabus 

Module 1: Introduction to Data Analytics

  • What is data analysis?

  • Data types and sources

  • Lifecycle of data analytics

Module 2: Statistics & Probability

  • Descriptive statistics (mean, median, mode, SD)

  • Probability distributions

  • Hypothesis testing

  • Correlation & regression

Module 3: Excel for Data Analysis

  • Data cleaning & sorting

  • Functions & formulas

  • Pivot tables & dashboards

  • Charts & visualization

Module 4: SQL (Structured Query Language)

  • Basics of databases

  • SELECT, JOIN, WHERE, GROUP BY, ORDER BY

  • Subqueries & data manipulation

Module 5: Python/R for Data Analysis

  • Data structures (lists, arrays, dictionaries)

  • Data cleaning and wrangling

  • Exploratory Data Analysis (EDA)

Module 6: Data Visualization

  • Principles of effective visualization

  • Tools: Tableau, Power BI, or Excel

  • Dashboards and storyboards

Module 7: Real-World Projects

  • Sales analysis

  • Customer segmentation

  • Market trend analysis

  • Performance dashboards