Data Analyst

Data Analyst
(Data Analyst)

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