The Skillians
THESKILLIANS
Book Call
Skillians×IBM
Full Syllabus · Lecture by Lecture

Data Analytics Job Bootcamp
Curriculum · Lecture-wise

Every single lecture across all 7 modules — 81 sessions, real tools, real datasets and 15+ portfolio projects. Built with IBM's industry framework.

7
Modules
81
Lectures
15+
Projects
20+
Tools
Back to Bootcamp
IBM
In Collaboration With
IBM · Skillians Advanced Gen AI Program
Co-issued certificate · Blockchain-verified
At a glance

The complete roadmap

Foundational to advanced — click any module to jump straight to its lecture list.

01

Introduction to Data Analytics & Excel

12 lectures→
02

Data Visualization with Power BI

11 lectures→
03

Analytics with SQL

15 lectures→
04

Python Programming

19 lectures→
05

Statistics & EDA with Python

10 lectures→
06

Generative AI

6 lectures→
07

Machine Learning with Python

8 lectures→
Module 01Foundations

Introduction to Data Analytics & Excel

12 lectures
MS ExcelPower Query
  1. 01Introduction to Data Analytics
  2. 02Life Cycle of Data Analysis
  3. 03Operations, Functions and Formatting in MS Excel
  4. 04Introduction to a Business Problem
  5. 05LOOKUPs in Excel
  6. 06AI Tools in MS Excel
  7. 07Data Cleaning in Excel
  8. 08Charts in Data Analytics
  9. 09Data Analysis – Univariate and Bivariate
  10. 10Power Query
  11. 11Data Transformation in Power Query
  12. 12Introduction to Power BI and Business Intelligence

Hands-on Projects

National Air QualityUS Healthcare DatasetIndia CPI Inflation
Module 02Visual Storytelling

Data Visualization with Power BI

11 lectures
Microsoft Power BI
  1. 01Basic Functionality of Power BI and Data Transformations
  2. 02Data Cleaning with Power BI
  3. 03AI Tools in Power BI
  4. 04Advanced Power Query and Data Modelling
  5. 05DAX Functions
  6. 06Advanced DAX Functions
  7. 07Hierarchy and Visualization in Power BI
  8. 08Creating Compelling Reports in Power BI
  9. 09Data Analysis and Data Storytelling using Power BI
  10. 10Features in Power BI Service with AI Insights
  11. 11Row Level Security and KPIs

Hands-on Projects

E-com Orders
Module 03Data Wrangling

Analytics with SQL

15 lectures
MySQLMySQL Workbench
  1. 01Introduction to SQL and Different Types of Databases
  2. 02Fundamentals of SQL and Data Management in MySQL Workbench
  3. 03Advanced SQL Query Techniques for Data Retrieval and Documentation
  4. 04CRUD Operations and Data Integrity
  5. 05Database Schema Management
  6. 06Operations (INSERT, CREATE, SHOW, DROP, USE)
  7. 07String Operations
  8. 08Aggregate Functions
  9. 09Joins, Constraints and ER Modelling
  10. 10Advanced Query Writing using Joins and Aggregate Functions
  11. 11Case Statements for Conditional Logic and Aggregation
  12. 12Common Table Expressions (CTEs) and Subqueries
  13. 13Date Manipulation – Data Types and Functions
  14. 14Fundamentals of Window Functions and its Applications
  15. 15Views, Indexes and Data Partitioning

Hands-on Projects

Retail StoreE-Com Business
Module 04Programming

Python Programming

19 lectures
PythonNumPyPandasMatplotlibSeabornJupyter
  1. 01Introduction to Python
  2. 02Fundamentals of Python: Syntax, Variables, and Data Types
  3. 03Types and Order of Operators
  4. 04Strings: Operations and Methods
  5. 05Data Structures – List, Tuple, Set, Dictionary
  6. 06Conditional Statements
  7. 07Looping Statements
  8. 08Control Transfer Statements – Break, Continue and Pass
  9. 09Functions
  10. 10Exception Handling
  11. 11Modules
  12. 12File Handling, Overview of Library
  13. 13NumPy – Libraries for Array Management
  14. 14Attributes, Operations, and Statistical Analysis using NumPy
  15. 15Data Structures and Series Management using Pandas
  16. 16Data Manipulation and Analysis in Pandas
  17. 17Data Visualization using Matplotlib and Seaborn
  18. 18Concepts and Application of OOPS
  19. 19Database Connectivity using Libraries for Data Management

Hands-on Projects

Covid-19PhonePe Digital Payments
Module 05Analytical Thinking

Statistics & EDA with Python

10 lectures
PythonSciPyScikit-learnStatsModelsPandasSeabornMatplotlib
  1. 01Introduction to Statistics
  2. 02Types of Data and Data Collection
  3. 03Sampling Techniques & Measures of Central Tendency
  4. 04Descriptive Statistics: Measures of Dispersion
  5. 05Introduction to Probability in Statistics
  6. 06Probability Distributions
  7. 07Central Limit Theorem and Sampling Distributions
  8. 08Hypothesis Testing
  9. 09Confidence Intervals
  10. 10Statistical Tests and Uses for Bivariate Analysis

Hands-on Projects

Loan DefaultPro Kabaddi LeagueSuperstore Sales
Module 06AI-Powered Analyst

Generative AI

6 lectures
ChatGPTClaudeGeminiCopilotLLaMA 3
  1. 01Introduction to Generative AI: Concepts, Tools, and Applications
  2. 02Prompt Engineering Techniques
  3. 03Generative AI in Excel
  4. 04Python Development with Generative AI
  5. 05Generative AI for SQL Coding
  6. 06Generative AI for Data Analysis and Visualization

Hands-on Projects

Credit Risk Modelling
Bonus · Pre-recorded
Module 07Bonus · Pre-recorded

Machine Learning with Python

8 lectures
PythonNumPyPandasScikit-learnNLTKTensorFlowKeras
  1. 01Introduction to Machine Learning
  2. 02Python Basics & Programming
  3. 03Data Types & Manipulation
  4. 04Linear & Logistic Regression
  5. 05Decision Trees & Random Forests
  6. 06Naive Bayes, KNN & SVM
  7. 07Principal Component Analysis
  8. 08Natural Language Processing

Hands-on Projects

Gradient DescentDecision Tree ImplementationText ClassificationCIFAR-10 ClassificationTwitter Sentiment AnalysisFacial Emotion RecognitionText GenerationNeural Machine Translation
Where our learners work

180+ hiring partners

From high-growth startups to Fortune 500s — Skillians alumni are analyzing data at companies you already know.

1,437+
Placements
₹12.4L
Highest CTC
₹6.2L
Average CTC
94%
Placement Rate
See all placements
Career Assistance

Your unfair advantage after graduation

Beyond the syllabus — every Skillians learner gets our full AI-powered career stack: mock interviews, resume tools, a job tracker and LinkedIn optimisation, built with hiring managers.

Next Cohort · Limited seats

Ready to become a Data Analyst?

Get IBM-certified and job-ready. Join the Skillians × IBM Data Analytics Job Bootcamp.