Data Analytics Course Syllabus — Complete Module-by-Module Guide (2026)
The same curriculum taught at every Uncodemy location — reviewed by Senior Trainer Mr. Irshad Khan and technically verified by Mr. Upendra Kumar Tiwari (Senior Data Science Trainer, 15+ years' experience).
Quick answer
Uncodemy's Data Analytics course syllabus is organised into 9 modules across 120+ hours and 75+ live instructor-led sessions, covering Excel, SQL, Python, Statistics, Data Cleaning/EDA, Power BI, Tableau, Generative AI, and a final Capstone. The syllabus follows the natural workflow of a working analyst: get the data, clean it, analyse it, interpret it, visualise it, and communicate it. It is delivered identically Live Online and at Uncodemy's own classroom centres in Noida (Sector 1) and Delhi (Laxmi Nagar, Shakarpur Extension).
At a Glance
Syllabus at a Glance
#
Module
Hours
Tools
1
Excel for Data Analytics
12
Excel, Power Query
2
SQL & Database Management
18
MySQL
3
Python for Data Analytics
20
Python, Pandas, NumPy
4
Statistics & Business Mathematics
12
Excel, Python
5
Data Cleaning & Exploratory Data Analysis
12
Python, Pandas
6
Power BI
18
Power BI Desktop
7
Tableau
10
Tableau Public
8
AI & Gen AI for Data Analysts
8
ChatGPT, Copilot
9
Capstone Projects & Career Preparation
10
All tools
Total
120 Hours
10+ Tools
Module by Module
Full 9-Module Breakdown
Module 1: Excel for Data Analytics — 12 Hours
Advanced formulas: VLOOKUP, XLOOKUP, INDEX-MATCH, SUMIFS, COUNTIFS, nested IF. Data cleaning: text functions, Find & Replace, Flash Fill, removing duplicates. Pivot Tables, PivotCharts, Slicers and Timelines. Power Query for importing and transforming data. Data validation, conditional formatting and dashboard design. Charts: histogram, Pareto, combo, waterfall.
Module 2: SQL & Database Management — 18 Hours
Relational database concepts, ER diagrams, normalisation. SELECT, WHERE, ORDER BY, GROUP BY, HAVING. All join types: inner, left, right, full outer, self, cross. Subqueries and Common Table Expressions. Window functions: ROW_NUMBER, RANK, LEAD, LAG. Connecting SQL databases to Python.
Module 4: Statistics & Business Mathematics — 12 Hours
Descriptive statistics: mean, median, variance, standard deviation. Probability fundamentals and data distributions. Sampling methods and the Central Limit Theorem. Hypothesis testing: p-values, confidence intervals, t-tests, chi-square, ANOVA. Correlation and regression basics. A/B testing in a business context.
Module 5: Data Cleaning & Exploratory Data Analysis — 12 Hours
Data quality assessment and profiling. Handling missing values: deletion, imputation, flagging. Outlier detection and treatment. Feature creation and binning. Univariate, bivariate and multivariate analysis. Correlation heatmaps and structuring an EDA report.
Module 6: Power BI — 18 Hours
Connecting to Excel, SQL, CSV and web sources. Power Query Editor, data modelling and relationships. DAX: calculated columns, measures, time intelligence. Visual types, filters, slicers, bookmarks and drill-through. Publishing to Power BI Service and scheduling refresh. Row-level security basics.
Module 7: Tableau — 10 Hours
Tableau architecture, data connection and blending. Dimensions, measures and calculated fields. Filters, groups, sets and hierarchies. Parameters and dynamic controls. Reference lines, trend lines and forecasting. Dashboards, actions and stories.
Module 8: AI & Gen AI for Data Analysts — 8 Hours
Prompt engineering for data tasks. Generating and debugging SQL and Python with AI assistance. Copilot in Excel and Power BI. AI-assisted insight summaries and report drafting. Verifying AI output: hallucinations, wrong aggregations, false confidence. Data privacy and what should never be pasted into a public AI tool.
Module 9: Capstone Projects & Career Preparation — 10 Hours
End-to-end capstone project on a real business dataset. Building a GitHub portfolio and dashboard showcase. Analyst resume writing and LinkedIn optimisation. SQL and case-study interview practice. Mock interviews with feedback.
Download the Complete Curriculum
Get the complete course curriculum with detailed modules, topics, learning outcomes, project details, and career-focused training information. Download the curriculum to explore the complete learning journey.
Audience
Who This Syllabus Is Designed For
Fresh Graduates
From any stream — B.Com, BBA, B.Sc, B.Tech, BA, BCA — entering analytics for the first time.
Working Professionals
In operations, sales, finance, HR or marketing formalising an existing data skillset.
Career Changers
Moving from a non-technical role into a data role.
MIS & Reporting Executives
Moving up from Excel into SQL, Python and BI tools.
Eligibility
A graduate degree in any discipline. No prior programming experience is required — Python and SQL are taught from the first line of code. Comfort with basic mathematics helps but is not essential, since the statistics module builds this from the ground up. A laptop with 8GB RAM and a stable internet connection is recommended for practical sessions.
Verified & Reviewed
Curriculum Ownership and Review
The curriculum is designed by industry professional Mr. Irshad Khan (Data Analytics & AI Trainer, 8+ years across consulting and public-sector analytics) and technically reviewed by Mr. Upendra Kumar Tiwari (Senior Data Science Trainer, 15+ years' experience).
Uncodemy separates the trainer who teaches a batch from the domain reviewer who verifies the curriculum is technically accurate and current — the person teaching a course is not the only person checking whether its content is correct. Every trainer and domain reviewer is published by name, with their background, so learners can look them up before enrolling.
Delivery
Where This Syllabus Is Taught
This exact 9-module, 120+ hour syllabus is delivered:
Live Online
Available to learners anywhere in India.
Classroom — Noida
Uncodemy's Noida centre — B 14-15, Udhoyg Marg, Sector 1, Noida.
Classroom — Delhi
Uncodemy's Delhi centre — Shakarpur Extension, Laxmi Nagar, Delhi.
Hybrid
A mix of classroom and online sessions, subject to batch availability.
The syllabus, trainers, projects and total fee are identical regardless of format or city — only the attendance mode changes.
Fee, Duration & Certification
Fee, Duration and Certification Snapshot
Attribute
Detail
Duration
6–7 months
Total Learning
120+ hours across 75+ live sessions
Total Fee
₹20,650 (₹17,500 + 18% GST)
EMI
Starting from ₹4,032/month
Projects
5 guided + 1 capstone
Certificate
Uncodemy Data Analytics Program Certificate (online-verifiable)
Offline Reference
Download the Full Curriculum
A downloadable PDF version of this syllabus — with module hours, tools and project details laid out for offline reference — is available on the Data Analytics Course Curriculum PDF page.
Have Questions?
Frequently Asked Questions
How many modules does the Data Analytics syllabus have?▾
9 modules across 120+ hours and 75+ live sessions, covering Excel, SQL, Python, Statistics, Data Cleaning/EDA, Power BI, Tableau, Gen AI and a Capstone.
Is the syllabus the same online and in classroom batches?▾
Yes. The syllabus, trainers and projects are identical across Live Online, Classroom (Delhi and Noida centres) and Hybrid formats.
Do I need coding experience before starting?▾
No. Python and SQL are taught from scratch — the first two months focus on Excel and SQL, which need no traditional coding background.
Does the syllabus include a Generative AI module?▾
Yes. Module 8 is a dedicated 8-hour module on AI for data analysts — prompt engineering, AI-assisted SQL/Python, Copilot in Excel and Power BI, and verifying AI output for errors.
How many hands-on projects are included?▾
5 guided projects across retail, banking, HR, e-commerce and healthcare domains, plus 1 capstone project of the learner's choosing.
Who reviews and verifies this syllabus?▾
The curriculum is designed by Mr. Irshad Khan and independently technically reviewed by Mr. Upendra Kumar Tiwari, Uncodemy's Senior Data Science Trainer.
Where can I take this course in person?▾
Uncodemy runs classroom batches for this exact syllabus at its Noida centre (Sector 1) and its Delhi centre (Laxmi Nagar, Shakarpur Extension), alongside live online batches available across India.
Can I download this syllabus as a PDF?▾
Yes — see the downloadable curriculum PDF page for an offline copy with the same module breakdown.
Last reviewed: September 2026. Curriculum verified by: Mr. Irshad Khan. Technical review: Mr. Upendra Kumar Tiwari. Data sourced directly from: uncodemy.com/course/data-analytics-training-course-in-delhi and uncodemy.com/course/data-analytics-training-course-in-noida.
Start the Syllabus in the Next Batch
Talk to a counsellor about batch timings, EMI plans & the 2-class trial.
