1. Introduction to Data Analytics
- What is Data Analytics?
- Lifecycle of Data Analysis
- Roles & Responsibilities of a Data Analyst
- Career paths and industry use cases
2. Excel for Data Analysis
- Basic to Advanced Excel Functions (VLOOKUP, INDEX/MATCH, etc.)
- Pivot Tables and Charts
- Data Cleaning and Validation
- Excel Dashboards
3. Statistics & Probability
- Descriptive Statistics: Mean, Median, Mode, Std. Dev.
- Probability concepts
- Distributions (Normal, Binomial, etc.)
- Hypothesis Testing & Confidence Intervals
4. SQL for Data Analysis
- Relational Databases Concepts
- SELECT, WHERE, JOIN, GROUP BY, HAVING
- Subqueries, CTEs, and Window Functions
- Data Cleaning with SQL
5. Data Visualization Basics
- Principles of effective data visualization
- Introduction to tools: Tableau / Power BI
- Creating bar charts, line charts, scatter plots, and maps
Data Analyst Course Level 2 Syllabus: Intermediate (Tooling + Applied Skills)
6. Python for Data Analysis
- Python basics (data types, loops, functions)
- Pandas for data manipulation
- NumPy for numerical computation
- Data Cleaning and Preprocessing
- Exploratory Data Analysis (EDA) with Matplotlib and Seaborn
7. Data Wrangling & Transformation
- Handling missing data and outliers
- Feature engineering
- Date and time manipulation
- String manipulation
8. Databases & Big Data Introduction
- Data warehousing concepts (OLAP vs OLTP)
- Introduction to BigQuery, Snowflake, or Redshift
- Basics of NoSQL (MongoDB)
9. Tableau / Power BI Advanced
- Interactive dashboards
- Calculated fields and Parameters
- Data blending and joins
- Dashboard optimization and storytelling
10. Capstone Project 1
- Real-world dataset
- End-to-end analysis using Excel, SQL, Python
- Dashboard presentation
11. What are the prerequisites for Data Analysis course?
- Basic understanding of mathematics and statistics.
- Familiarity with Excel or spreadsheets is helpful.
- No prior programming experience is required (unless specified).
12. What topics are covered in the course?
- Introduction to Data Analysis
- Data Cleaning and Preprocessing
- Exploratory Data Analysis (EDA)
- Statistical Analysis
- Data Visualization
- SQL for Data Analysis
- Python/R for Data Analysis
- Excel and Spreadsheets
- Dashboarding (e.g., Power BI/Tableau)
- Capstone Project
13. Which tools and software will I learn?
- Excel/Google Sheets
- SQL (MySQL, PostgreSQL, or similar)
- Python (Pandas, NumPy, Matplotlib, Seaborn)
- Power BI or Tableau
- Jupyter Notebooks
- Git/GitHub (optional)
14. How is the course structured?
- Weekly modules with video lessons, readings, and quizzes.
- Hands-on labs and mini-projects.
- Final capstone project to apply all skills learned.
15. Is this course beginner-friendly?
- Yes. It is designed for learners with little to no background in data analysis, though familiarity with basic computer operations is expected.
16. Will I get a certificate after completion?
- Yes, a certificate of completion will be awarded if you successfully complete all course requirements and projects.
17. How much time do I need to commit per week?
- On average, 5–8 hours per week, depending on your pace and familiarity with the material.
💼 Prerequisites for this Course:
Able to come to the offline classes (or) Access to Smart Phone / Computer
Dedication and confidence to clear any exam or Interview
Good Internet Speed (Wifi/3G/4G)
Good Quality Earphones / Speakers
Basic Understanding of English & Tamil