Certificate in Data Analyst

courses details

Price

₹ 24000

Data Analyst

Duration: 6 Months

Syllabus:

🟢 Module 1: Introduction to Data Analytics 

  • What is Data Analytics?
  • Types:
    • Descriptive
    • Diagnostic
    • Predictive
    • Prescriptive
  • Role of a Data Analyst
  • Real-world use cases (business, marketing, finance)

🟢 Module 2: Microsoft Excel 

  • Basics: rows, columns, formatting
  • Functions: SUM, AVERAGE, IF, VLOOKUP, XLOOKUP
  • Data cleaning techniques
  • Pivot Tables & Pivot Charts
  • Dashboards in Excel

👉 Tools to learn: Microsoft Excel


🟢 Module 3: SQL (Database Basics) 

  • What is Database & DBMS
  • SQL Basics:
    • SELECT, WHERE, ORDER BY
    • GROUP BY, HAVING
  • Joins:
    • INNER JOIN
    • LEFT JOIN
  • Subqueries
  • Working with real datasets

👉 Tool: MySQL


🟢 Module 4: Python for Data Analysis 

  • Python basics (variables, loops, functions)
  • Libraries:
    • NumPy
    • Pandas
  • Data cleaning & manipulation
  • Reading CSV/Excel files
  • Basic data analysis

👉 Tools:

  • Python
  • Jupyter Notebook

🟢 Module 5: Data Visualization 

  • Importance of visualization
  • Charts:
    • Bar chart
    • Line chart
    • Pie chart
    • Histogram
  • Tools
    • Power BI

🟢 Module 7: Data Cleaning & Preparation 

  • Handling missing values
  • Removing duplicates
  • Data transformation
  • Data formatting

🟢 Module 8: Projects 

  • Sales data analysis project
  • Customer analysis project
  • Dashboard creation (Excel / Power BI )

🟢 Module 9: Interview Preparation

  • SQL interview questions
  • Excel case studies
  • Basic Python questions
  • Resume & portfolio building