Scribd
Upload
905 views2 pages

Data Analyst Syllabus 2025-26

The document outlines the complete syllabus for a Data Analyst course for the 2025-26 academic year, covering fundamental topics such as data analysis concepts, Excel, statistics, SQL, and data visualization tools. It includes optional modules on Python for data analysis and real-world projects, emphasizing both technical skills and soft skills necessary for a data analyst. Additionally, it features bonus topics like machine learning and cloud platforms, along with certification options.

Uploaded by

harshd7310
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
905 views2 pages

Data Analyst Syllabus 2025-26

The document outlines the complete syllabus for a Data Analyst course for the 2025-26 academic year, covering fundamental topics such as data analysis concepts, Excel, statistics, SQL, and data visualization tools. It includes optional modules on Python for data analysis and real-world projects, emphasizing both technical skills and soft skills necessary for a data analyst. Additionally, it features bonus topics like machine learning and cloud platforms, along with certification options.

Uploaded by

harshd7310
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 2

Data Analyst Complete Syllabus (2025–

26)
Module 1: Fundamentals of Data Analysis
 - What is Data Analysis?
 - Roles and responsibilities of a Data Analyst
 - Types of data: Structured vs Unstructured
 - Data types: Numerical, Categorical, Ordinal, Time-series
 - Workflow of a Data Analytics project (Data → Insights → Action)

Module 2: Excel for Data Analytics


 - Excel basics: Rows, Columns, Cell formatting
 - Functions: VLOOKUP, HLOOKUP, IF, SUMIF, COUNTIF
 - Pivot tables & Pivot charts
 - Data validation, conditional formatting
 - Dashboards using Excel
 - Case Study: Sales Dashboard using Excel

Module 3: Statistics & Probability for Data Analysis


 - Descriptive statistics: Mean, Median, Mode, Variance, Standard Deviation
 - Data distribution: Normal, Skewness, Kurtosis
 - Inferential statistics: Hypothesis testing, Confidence interval
 - Correlation and Regression
 - Probability basics and Bayes Theorem
 - Chi-square, T-tests, ANOVA

Module 4: SQL for Data Retrieval


 - Relational database basics (RDBMS)
 - SQL Syntax & Queries
 - SELECT, FROM, WHERE, GROUP BY, ORDER BY
 - JOINS (INNER, LEFT, RIGHT, FULL)
 - Subqueries and nested queries
 - Data aggregation using SQL
 - Real-life Practice: Analyzing customer and sales data from SQL database

Module 5: Data Visualization Tools


 - Power BI: Data import, Dashboards, DAX basics
 - Tableau: Filters, Parameters, Calculated Fields, Dashboards
 - Optional tools: Google Data Studio, Looker Studio
Module 6: Python for Data Analysis (Optional)
 - Introduction to Python, Jupyter Notebook
 - Libraries: Pandas, NumPy, Matplotlib, Seaborn
 - Data cleaning, manipulation, and visualization
 - Exploratory Data Analysis (EDA)
 - Real-life datasets: COVID-19, Netflix, IPL, Banking

Module 7: Real-World Projects & Soft Skills


 - Projects: E-commerce dashboard, Sales performance, Customer churn, Forecasting
 - Soft Skills: Report writing, Storytelling, Resume building, Interview preparation

Bonus Topics (Optional)


 - Intro to Machine Learning
 - Big Data Concepts (Hadoop/Spark overview)
 - Cloud platforms (AWS/GCP/Azure basics for Data)
 - Freelancing as Data Analyst
 - Certifications: Google, Microsoft Excel, Power BI, Tableau

You might also like