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