Course Curriculum
Data AnalyticsComplete Syllabus & Module Breakdown
Full Curriculum
Data Analytics — Complete Syllabus
7 modules · all topics listed · last updated 2026
Module 1 — Introduction to Data Analytics
- Overview of Data Analytics — definition and importance
- Applications in various industries (finance, healthcare, e-commerce, logistics)
- Career opportunities — Data Analyst, Business Analyst, MIS Analyst
- Data Analytics Process — collection, cleaning, analysis, visualisation, interpretation
Module 2 — Statistics and Probability
- Descriptive Statistics — mean, median, mode, range, variance, standard deviation
- Distribution types — normal, binomial, Poisson
- Inferential Statistics — hypothesis testing, confidence intervals, p-values
- Probability distributions and Bayes' theorem
- Sampling methods
Module 3 — Data Collection and Data Cleaning
- Data Collection Methods — surveys, APIs, web scraping
- Handling missing values and dealing with outliers
- Data transformation
- Data normalisation and standardisation
Module 4 — Data Analysis and Exploration
- Exploratory Data Analysis (EDA)
- Data profiling
- Univariate and bivariate analysis
- Data visualisation techniques — histograms, box plots, scatter plots
- Tools: Excel, SQL, R, Python (Pandas, NumPy)
Module 5 — Data Visualisation
- Principles of Data Visualisation
- Choosing the right chart types
- Design best practices
- Tableau — dashboards and reports
- Power BI — data modelling and interactive dashboards
- Matplotlib and Seaborn in Python
Module 6 — Introduction to Excel
- Excel interface, workbook and worksheet management
- Basic functions — SUM, AVERAGE, MIN, MAX
- Cell referencing — relative, absolute, mixed
- Data Import/Export (CSV, databases, web)
- VLOOKUP, HLOOKUP, INDEX, MATCH
- Logical functions — IF, AND, OR, NOT, nested IF
- Date and Time functions — TODAY, NOW, DATEDIF, NETWORKDAYS
- PivotTables, Pivot Charts and Data Analysis Toolpak
- Conditional Formatting and Sparklines
- What-If Analysis — Scenario Manager, Goal Seek, Data Tables, Solver
- Introduction to Macros and VBA Programming
- Power Query — importing, transforming, merging data
- Integrating Excel with Power BI and Python
Module 7 — Introduction to SQL
- Overview of SQL — MySQL, PostgreSQL, SQL Server
- SELECT, INSERT, UPDATE, DELETE
- WHERE clause, logical and comparison operators, LIKE
- ORDER BY, GROUP BY, HAVING
- Aggregate functions — COUNT, SUM, AVG, MIN, MAX
- String, Numeric, and Date/Time functions
- INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN, Self joins, Cross joins
- Subqueries — in SELECT, FROM, WHERE clauses
- Common Table Expressions (CTEs)
- Data Manipulation and Transactions — BEGIN, COMMIT, ROLLBACK
- Indexing and Query Optimisation
- Stored Procedures, Triggers, and Views
Frequently Asked Questions
What is the difference between data analytics and data science?
Data analytics focuses on understanding existing data — trends, dashboards, Excel, SQL reports, and business insights. Data science goes deeper into predictive modelling and machine learning. Analytics is a faster path to a first job (4-month course vs 5–6 months). Most analytics professionals eventually advance into data science roles.
Is data analytics in demand in India in 2026?
Yes. Every company — banks, e-commerce, logistics, healthcare, FMCG — needs analysts who can turn raw data into decisions. Entry-level analytics roles are among the most accessible IT careers for freshers and career-switchers, with strong hiring across Pune, Mumbai, and Ahmedabad.
What is the salary of a data analyst in Pune?
Fresh data analysts in Pune earn ₹3.5–5.5 LPA at IT services and consulting companies. Analysts with Tableau + SQL + Python skills command ₹5–8 LPA. Senior analysts and BI leads at tech companies earn ₹10–16 LPA.
What is the salary of a data analyst in Mumbai?
Mumbai pays a premium for analytics talent. Fresh analysts at banking and financial firms (HDFC, ICICI analytics teams, EXL, WNS) earn ₹4.5–7 LPA. With 2–3 years of experience, salaries reach ₹8–14 LPA. Financial analytics specialists earn ₹15–25 LPA.
What is the data analyst course fee at Felix ITs?
The Data Analytics course fee starts at ₹45,000 with a 0% EMI option of ₹7,500/month over 6 months. Book a free demo to confirm the latest batch schedule and fee structure.
Data Analytics
Tools You'll Master
Career Outcomes
- ✓Data Analyst
- ✓Business Analyst
- ✓MIS Analyst
- ✓Reporting Analyst
- ✓BI Developer
Who Should Attend
- Graduates who want to work with data and business insights
- Professionals in finance, operations, or HR wanting data skills
- Anyone who wants to switch to analytics without a CS degree
- Students who are strong in logic and problem-solving