In affiliation with
Next batch soonDates announced shortly · pre-register free to get them firstPre-register

Level 2 • University Approved • Internationally Recognized

Internationally Certified Advanced Data Analyst with AI

60 Hours • 8 Advanced Projects • Evening Online Batch (2 sessions/week) • Flexible Timings

Lifetime Certificate Validity Excel Macros & VBA Machine Learning QR Authentication
NCS IDs: E19G73-0001536925957 • S19G76-1231027651047

Quick Facts

Next batch soon
60h Total Hours
8 Advanced Projects
9 weeks (3 months) Duration
Online Evening Batch
90 days Class Recordings
Level 2 After Data Analyst with AI
For learners who completed Internationally Certified Data Analyst with AI (Level 1), or who already use Excel, Power BI, SQL and Python or R at work. Open for FY/SY/TY/PG students of any stream + faculty + professionals.
Fees from₹3,499₹20,00083% off
Course Highlights

More Than a Course

Real Automation with VBABuild a one-click monthly report: import files, refresh, summarise, export PDFs and draft emails.
Your First ML ModelsRegression, classification and clustering in Python or R, with an ML capstone project.
vishwakarmaskillsai.com/learn1 / 9
Your course dashboard: VSA Learner Portal screen Live sessions: VSA Learner Portal screen Missed a class? Watch the recording: VSA Learner Portal screen Self-learning videos & notes: VSA Learner Portal screen Module quizzes: VSA Learner Portal screen Projects: VSA Learner Portal screen Badges: VSA Learner Portal screen AI resume builder: VSA Learner Portal screen Job application tracker: VSA Learner Portal screen
Your course dashboardProgress, your next live class and what to do this week, at a glance.
Live sessionsJoin your live classes in one click; email reminders before every class.
Missed a class? Watch the recordingThe recording of every live session is added after the class.
Self-learning videos & notesExtra video lessons, notes and the course handbook for every module.
Module quizzesInstant score with explanations; pass to earn the quiz badge.
ProjectsUpload your files, get trainer feedback and share the project on LinkedIn.
BadgesQuiz and module badges you can add to LinkedIn; anyone can verify them.
AI resume builderAn ATS-friendly resume with ready AI prompts and your course skills.
Job application trackerEvery application, its status and the next step, in one list.
Course Overview

Go Beyond Dashboards: Automate, Model and Predict

Level 2 of the VSA data analyst path. Automate Excel with macros and VBA, build advanced Power BI and Tableau models, write analytical SQL, test ideas with statistics and build your first machine learning models in Python or R, with AI as your co-pilot.

Live Sessions

2 live online sessions/week with your trainer. Missed a class? The recording is provided after every session.

Advanced Projects

8 projects (4 live, 4 self-paced): VBA automation, optimisation, Power BI app, Tableau story, SQL cohorts, A/B test, data pipeline and an ML capstone.

International Certificate

University-approved, lifetime validity with QR authentication.

Your Next Step After Level 1

Builds on Data Analyst with AI without repeating it. Comfortable with Excel, Power BI, SQL and Python or R? You can join directly.

Execution Strategy

  • Evening batches • 2 sessions per week • Online (Flexible Timings)
  • Exam holidays as per University timetable
  • Presented by KC College, HSNC University (EOC • Dept. of Economics • Dept. of CS)

What You Receive

  • Live online sessions with your trainer, 2 per week
  • Recording of every class, if you miss one
  • Self-learning video lessons, VSA notes (VBA, DAX, SQL window functions, statistics and ML cheat sheets), course handbook & syllabus PDF
  • Module quizzes, projects & badges; certificate with lifetime validity
  • QR code authentication on certificate
  • AI resume builder & job application tracker on the learner portal
Enrollment & Fees

Choose Your Path

Special pricing for HSNC University students and faculty. Your seat is confirmed on fee payment.

Pre-booking open

Upcoming Live Batch

The next live batch is being formed. Book today to lock in the current fee; we send you the dates and the batch WhatsApp group as soon as it is announced.

Recordings of every class Live, instructor-led Projects + certificate
Full-refund promise if we ever cancel a batch.
Best value

HSNC Students/Faculty

Students & faculty of all HSNC University colleges and schools

₹3,499 ₹20,000
You save ₹16,501 (83% off)
  • Level 2: Level 1 recommended, or equivalent skills
  • Access to all learning materials during course
  • Includes certificate fee, taxes, videos, handbook, evaluation & QR authentication
Valid for all 17 HSNC colleges & schools
Colleges:K.C. CollegeH.R. College of Commerce and EconomicsBombay Teachers' Training College (B.T.T.C.)R.D. & S.H. National College and S.W.A. Science CollegeK.C. Law CollegeM.M.K. College of Commerce and EconomicsK.M. Kundnani College of PharmacyThadomal Shahani Engineering CollegeSchools:Niranjan Hiranandani School of Management and Real EstateD.M. Harish School of LawSchool of Interdisciplinary StudiesChellaram School of Yoga and WellnessSchool of Applied SciencesSchool of Performing ArtsSchool of Engineering and TechnologySchool of Humanities and Social SciencesSchool of Nuclear Science and Technology
Pre-book my seat 2 minutes · secure payment · instant confirmation

Other University / Not Working / Corporate Employee

Level 1 recommended, or equivalent skills

₹4,999 ₹20,000
You save ₹15,001 (75% off)
  • Access to all learning materials during course
  • Class recordings for 90 days
  • Includes certificate fee, taxes, videos, handbook, evaluation & QR authentication
Pre-book my seat 2 minutes · secure payment · instant confirmation

Have a coupon code? You can apply it during registration.

Non-Refund Policy: Fees are non-refundable and non-transferable because the program is subsidized and academic resources are allocated at registration.

Curriculum Details

Syllabus & Learning Path

9-week (3-month) journey: Orientation, Advanced Excel & VBA, Advanced Power BI & Tableau, Advanced SQL, Statistics, Advanced Python or R and Introduction to Machine Learning, with 8 advanced projects and a bonus career module. Syllabus may be revised per industry needs.

Module 0

Orientation & Advanced Toolkit

Programme Orientation & Advanced Analytics Toolkit

Live Session 1 | 2 live hours | Compulsory programme readiness module (included within the 30 live training hours)

  • Level 2 Roadmap & Analytics Maturity
  • Advanced Toolkit Setup
  • Working Like a Professional Analyst
  • AI as a Co-pilot
Detailed syllabus · 5 part(s)
Level 2 Roadmap & Analytics MaturityFrom descriptive and diagnostic to predictive and prescriptive analytics; what changes from Level 1; how automation, statistics and machine learning fit into analyst roles; the 8 Level 2 projects and how badges are earned.
Advanced Toolkit SetupExcel Developer tab, macro security, Trust Center and .xlsm files; Power BI Desktop with DAX Studio; Tableau Public; MySQL 8 Server and Workbench; Python (Jupyter/Colab with pandas, scipy, statsmodels, scikit-learn) or R (RStudio with tidyverse and tidymodels); practice datasets and folder structure.
Working Like a Professional AnalystProject folders and naming, version control basics with Git/GitHub, documenting assumptions, reproducible work, data privacy and confidentiality.
AI as a Co-pilotUsing AI assistants for VBA, DAX, SQL and Python/R: writing precise prompts, asking for explanations, testing on copies and verifying every result.
QuizModule 0 quiz (10 questions, 1 mark each): Level 2 tools, analytics maturity and responsible AI use.
Live sessions · 1
  • S1 · Level 2 Orientation, Advanced Analytics Roadmap & Toolkit Setup
Module 1

Advanced Excel & VBA

Advanced Excel, Automation with Macros & VBA

Live Sessions 2–4 | 6 live hours | 4 self-paced learning hours | 1 live project + 1 self-paced project (4 hours)

  • Formula Engineering with Dynamic Arrays
  • Power Query M & Automated Data Pipelines
  • Data Model, DAX & CUBE Reporting in Excel
  • Optimisation & Simulation
  • Macros
  • VBA Programming
  • VBA Automation Projects
  • Debugging, Error Handling & Governance
  • AI-Assisted Excel
Detailed syllabus · 10 part(s)
Formula Engineering with Dynamic ArraysBeyond Level 1: LAMBDA helper functions (BYROW, BYCOL, MAP, SCAN, REDUCE, MAKEARRAY); named LAMBDA functions; GROUPBY and PIVOTBY formula reports; CHOOSECOLS, WRAPROWS, TOCOL; REGEXTEST, REGEXEXTRACT and REGEXREPLACE for text cleaning; spill references (#) and dynamic dependent drop-downs.
Power Query M & Automated Data PipelinesAdvanced Editor and M language basics; custom functions and invoking them for many files; parameters; fuzzy matching; try … otherwise error handling; unpivot/pivot patterns; query dependencies and refresh order.
Data Model, DAX & CUBE Reporting in ExcelPower Pivot measures with CALCULATE and time intelligence; KPIs; CUBEVALUE and CUBEMEMBER formula reports and dashboards built directly on the Data Model.
Optimisation & SimulationSolver models: objective, changing cells, constraints, integer and binary decisions, Simplex LP vs GRG Nonlinear, sensitivity report; Monte Carlo simulation with RAND, NORM.INV and Data Tables; scenario comparison and risk ranges.
MacrosRecording to Reusable Automation: Macro recorder with absolute and relative references; the Visual Basic Editor, modules and the Project Explorer; macro security and trusted locations; .xlsm, .xlsb, Personal Macro Workbook and .xlam add-ins; buttons and shapes to run macros.
VBA ProgrammingExcel object model (Application, Workbook, Worksheet, Range, Cells, Offset); variables, data types and Option Explicit; If, Select Case; For, For Each, Do While/Until loops; With blocks; MsgBox and InputBox; Sub vs Function and user-defined functions; arrays for speed.
VBA Automation ProjectsEvents (Workbook_Open, Worksheet_Change); UserForms for data entry; looping through files in a folder to consolidate; refreshing queries and PivotTables; splitting data by category; exporting PDFs; drafting Outlook emails; status messages and logs.
Debugging, Error Handling & GovernanceBreakpoints, F8 stepping, Immediate and Locals windows; On Error GoTo handlers and clean exits; turning off ScreenUpdating for speed; documenting and protecting code; Office Scripts and Power Automate as the cloud alternative.
AI-Assisted ExcelCopilot in Excel and Python in Excel; using AI to write, explain and debug formulas and VBA, with testing on copies and human verification.
QuizModule 1 quiz (20 questions, 1 mark each): LAMBDA helpers, Power Query M, CUBE functions, Solver/Monte Carlo and Macros & VBA.
Live sessions · 3
  • S2 · Advanced Formulas, Power Query M & CUBE Reporting
  • S3 · Macros & VBA Foundations
  • S4 · VBA Automation, Debugging & AI-Assisted Macros
Module 2

Advanced Power BI & Tableau

Advanced Power BI & Tableau — Modelling, DAX, Security & Visual Analytics

Live Sessions 5–7 | 6 live hours | 3 self-paced learning hours | 1 live project + 1 self-paced project (4 hours)

  • Advanced Data Modelling
  • Advanced DAX
  • Advanced Reports & AI Visuals
  • Security, Performance & Power BI Service
  • Tableau for Analysts
Detailed syllabus · 6 part(s)
Advanced Data ModellingStar schema design and grain; role-playing dates and inactive relationships; bidirectional filters and when to avoid them; calculation tables; a marked date table with fiscal periods.
Advanced DAXRow vs filter context and context transition; CALCULATE modifiers (ALL, ALLEXCEPT, REMOVEFILTERS, KEEPFILTERS, USERELATIONSHIP); iterators (SUMX, AVERAGEX); variables; RANKX and TOPN; time intelligence (YTD, same period last year, rolling 3/12 months, YoY %); calculation groups and field parameters.
Advanced Reports & AI VisualsBookmarks and buttons, drill-through and tooltip pages, dynamic titles and conditional formatting; what-if parameters; Key influencers, Decomposition tree, Q&A, smart narratives and Copilot for Power BI.
Security, Performance & Power BI ServiceRow-level security with roles and USERPRINCIPALNAME(); Performance Analyzer, DAX Studio and VertiPaq Analyzer; workspaces and apps; gateways and scheduled refresh; incremental refresh and deployment pipelines (concepts).
Tableau for AnalystsTableau Public interface; data sources, relationships vs joins; calculated fields; table calculations; LOD expressions (FIXED, INCLUDE, EXCLUDE); parameters; sets and actions; dashboards, stories and publishing to Tableau Public; Power BI vs Tableau.
QuizModule 2 quiz (20 questions, 1 mark each): data modelling, advanced DAX, report features, security/performance and Tableau.
Live sessions · 3
  • S5 · Advanced Data Modelling & DAX
  • S6 · Advanced Reports, AI Visuals, Security & Performance
  • S7 · Tableau for Analysts: Calculations, LOD & Interactive Dashboards
Module 3

Advanced SQL

Advanced SQL — Analytical Queries, Window Functions & Database Objects

Live Sessions 8–9 | 4 live hours | 2 self-paced learning hours | 1 live project

  • Subqueries, CTEs & Set Operations
  • Window Functions
  • Dates, Text & Data Cleaning in SQL
  • Views, Stored Procedures & Performance
  • Business Analytics with SQL
Detailed syllabus · 6 part(s)
Subqueries, CTEs & Set OperationsScalar, table and correlated subqueries; EXISTS; common table expressions and recursive CTEs (hierarchies, date series); self joins; UNION, INTERSECT and EXCEPT; CASE for business rules.
Window FunctionsOVER with PARTITION BY and ORDER BY; ROW_NUMBER, RANK, DENSE_RANK, NTILE; LAG and LEAD; running totals and moving averages with frames (ROWS BETWEEN); FIRST_VALUE and LAST_VALUE; top-N per group.
Dates, Text & Data Cleaning in SQLDate functions (DATE_FORMAT, DATEDIFF, DATE_ADD, TIMESTAMPDIFF); string functions and pattern matching; finding and removing duplicates; standardising values; NULL handling with COALESCE.
Views, Stored Procedures & PerformanceViews for reporting layers; stored procedures with parameters; triggers (overview); indexes and EXPLAIN; writing efficient queries; transactions with COMMIT and ROLLBACK.
Business Analytics with SQLCohort retention, RFM segmentation, funnel and conversion analysis, month-on-month growth and contribution analysis; feeding SQL views to Power BI and Python/R.
QuizModule 3 quiz (20 questions, 1 mark each): subqueries, CTEs, window functions, views, procedures, indexes and SQL analytics.
Live sessions · 2
  • S8 · Subqueries, CTEs & Window Functions
  • S9 · Views, Procedures, Performance & SQL Business Analytics
Module 4

Statistics for Analytics

Statistics for Data Analytics — Probability, Inference & Regression

Live Sessions 10–11 | 4 live hours | 2 self-paced learning hours | 1 self-paced project (3 hours)

  • Descriptive Statistics & Distributions
  • Sampling & Estimation
  • Hypothesis Testing
  • Experiments & A/B Testing
  • Correlation & Regression
Detailed syllabus · 6 part(s)
Descriptive Statistics & DistributionsCentre, spread and shape revisited; skewness and outliers; probability basics; binomial, Poisson and normal distributions; z-scores.
Sampling & EstimationPopulations and samples, sampling methods and bias; sampling distributions and the central limit theorem; standard error; confidence intervals for means and proportions.
Hypothesis TestingNull and alternative hypotheses, p-values, significance, Type I/II errors and power; one- and two-sample and paired t-tests; chi-square tests; one-way ANOVA; non-parametric alternatives; effect size.
Experiments & A/B TestingDesigning an experiment: metric, randomisation, sample size and duration; avoiding peeking; analysing conversion and revenue differences; communicating results.
Correlation & RegressionCorrelation vs causation; simple and multiple linear regression; interpreting coefficients, R² and adjusted R²; residual checks, multicollinearity; dummy variables; regression in Excel and Python/R.
QuizModule 4 quiz (20 questions, 1 mark each): distributions, sampling, confidence intervals, hypothesis tests, A/B testing and regression.
Live sessions · 2
  • S10 · Probability, Distributions, Sampling & Confidence Intervals
  • S11 · Hypothesis Testing, A/B Tests & Regression
Module 5

Advanced Python or R

Advanced Python or R — Data Wrangling, Automation & Statistical Analysis

Live Sessions 12–13 | 4 live hours | 2 self-paced learning hours | 1 self-paced project (3 hours). The programme covers either Python or R, not both.

  • Advanced Data Wrangling
  • Time Series & Dates
  • Data from Databases, Files & APIs
  • Statistical Analysis in Code
  • Visualisation & Reproducible Reports
  • AI-Assisted Coding
Detailed syllabus · 7 part(s)
Advanced Data WranglingPython: groupby with named aggregation, merge types, pivot_table and melt, MultiIndex, method chaining, apply and vectorisation, categorical data. R: dplyr with across(), joins, tidyr pivot_longer/pivot_wider, stringr, purrr map functions.
Time Series & DatesPython: DatetimeIndex, resample, rolling windows, shift and percentage change. R: lubridate parsing, floor_date, rolling and lag calculations.
Data from Databases, Files & APIsReading many files at once; SQL queries into DataFrames/tibbles; calling web APIs and flattening JSON; saving clean outputs to Excel/CSV/SQL.
Statistical Analysis in CodePython: scipy.stats and statsmodels (t-tests, chi-square, ANOVA, OLS). R: t.test, chisq.test, aov, lm and broom for tidy results.
Visualisation & Reproducible ReportsPython: seaborn and Plotly interactive charts. R: ggplot2 facets, themes and annotations. Notebooks exported to HTML, Quarto/R Markdown reports; reusable functions and project structure.
AI-Assisted CodingUsing AI to draft, explain and debug pandas or tidyverse code, with checks on row counts and totals.
QuizModule 5 quiz (20 questions, 1 mark each): advanced pandas or tidyverse, data sources, statistics in code, visualisation and reports.
Live sessions · 2
  • S12 · Advanced Data Wrangling & Time Series in Python or R
  • S13 · Statistics in Code, APIs, Visualisation & Reproducible Reports
Module 6

Introduction to Machine Learning

Introduction to Machine Learning — Regression, Classification & Clustering

Live Sessions 14–15 | 4 live hours | 3 self-paced learning hours | 1 live capstone project

  • Machine Learning Foundations
  • Feature Engineering
  • Regression Models
  • Classification Models
  • Clustering
  • Responsible & Explainable ML
Detailed syllabus · 7 part(s)
Machine Learning FoundationsWhat machine learning is; supervised vs unsupervised learning; features and target; train/test split and cross-validation; bias–variance, overfitting and underfitting; data leakage.
Feature EngineeringHandling missing values, encoding categories (one-hot), scaling, date features and simple feature selection; pipelines in scikit-learn or recipes in tidymodels.
Regression ModelsLinear and polynomial regression for prediction; evaluation with MAE, RMSE and R²; interpreting coefficients.
Classification ModelsLogistic regression, decision trees and random forests; confusion matrix, accuracy, precision, recall, F1, ROC curve and AUC; class imbalance and choosing a threshold.
Clusteringk-means clustering for customer segmentation; scaling, choosing k with the elbow method and profiling clusters.
Responsible & Explainable MLFeature importance, explaining predictions to managers, bias and fairness checks, privacy, and when not to use ML; AI-assisted modelling (AutoML and copilots) with human review.
QuizModule 6 quiz (20 questions, 1 mark each): ML foundations, feature engineering, regression, classification metrics, clustering and responsible AI.
Live sessions · 2
  • S14 · Machine Learning Foundations & Regression Models
  • S15 · Classification, Clustering & Responsible ML
Module 7 · Bonus

Career Accelerator

Career Accelerator (Bonus)

Two additional bonus sessions | 4 hours beyond the 60-hour core programme | No separate technical project required

  • Portfolio for Advanced Roles
  • Resume & LinkedIn for Advanced Roles
  • Technical Interview & Case Practice
Detailed syllabus · 5 part(s)
Portfolio for Advanced RolesChoosing 3 Level 2 projects; GitHub repository structure and README; Tableau Public and Power BI showcase; project write-ups with business impact.
Resume & LinkedIn for Advanced RolesUpdating the resume with automation, BI, SQL, statistics and ML achievements; LinkedIn headline, featured projects and skills; using the learner portal resume builder.
Technical Interview & Case PracticeSQL and Excel/VBA tests, DAX and dashboard questions, statistics and ML concept questions; a business case walk-through; STAR answers; mock interview and feedback.
QuizModule 7 quiz (10 questions, 1 mark each): portfolio, resume, LinkedIn and interview preparation.
Module assessmentbadge on attending both bonus sessions, passing the quiz and submitting your portfolio link + updated resume.
Live sessions · 2
  • Bonus · Portfolio & Personal Brand for Advanced Roles
  • Bonus · Technical Interview & Case Practice
Skills Covered

Skills You Will Build

The key skills employers list in Data Analyst job posts, and the tools you will use.

36 technical skills 16 professional skills 24 tools

Technical Skills

Advanced AnalyticsAnalytics Maturity AssessmentExcel VBAMacro AutomationAdvanced Excel FormulasPower Query MOptimisationMonte Carlo SimulationAdvanced DAXData ModelingRow-Level SecurityPerformance TuningTableau Visual AnalyticsAdvanced SQLWindow FunctionsCTEsStored ProceduresQuery OptimisationCohort AnalysisInferential StatisticsHypothesis TestingA/B TestingRegression AnalysisAdvanced PandasTidyverseTime Series AnalysisAPI Data ExtractionReproducible ReportingMachine LearningPredictive ModelingClassificationClusteringFeature EngineeringModel EvaluationPortfolio DevelopmentTechnical Interview Skills

Non-Technical Skills

Problem SolvingProfessional EthicsProcess ImprovementAttention to DetailData StorytellingStakeholder CommunicationAnalytical ThinkingCritical ThinkingDecision MakingAutomation MindsetResponsible AIBusiness CommunicationCommunicationPersonal BrandingProfessional NetworkingInterview Preparation

Tools

Excel Developer TabDAX StudioTableau PublicMySQL 8Git/GitHubExcel VBAPower QueryPower PivotSolverMicrosoft CopilotPower BITableauExcel Analysis ToolPakPandasSciPyStatsmodelsPlotlydplyrggplot2Quartoscikit-learntidymodelsGitHubLinkedIn
Skills by module
ModuleTechnicalNon-technicalTools
Module 0 · Orientation & Advanced ToolkitAdvanced Analytics, Analytics Maturity AssessmentProblem Solving, Professional EthicsExcel Developer Tab, DAX Studio, Tableau Public, MySQL 8, Git/GitHub
Module 1 · Advanced Excel & VBAExcel VBA, Macro Automation, Advanced Excel Formulas, Power Query M, Optimisation, Monte Carlo SimulationProcess Improvement, Attention to DetailExcel VBA, Power Query, Power Pivot, Solver, Microsoft Copilot
Module 2 · Advanced Power BI & TableauAdvanced DAX, Data Modeling, Row-Level Security, Performance Tuning, Tableau Visual AnalyticsData Storytelling, Stakeholder CommunicationPower BI, DAX Studio, Tableau
Module 3 · Advanced SQLAdvanced SQL, Window Functions, CTEs, Stored Procedures, Query Optimisation, Cohort AnalysisAnalytical ThinkingMySQL 8
Module 4 · Statistics for AnalyticsInferential Statistics, Hypothesis Testing, A/B Testing, Regression AnalysisCritical Thinking, Decision MakingExcel Analysis ToolPak
Module 5 · Advanced Python or RAdvanced Pandas, Tidyverse, Time Series Analysis, API Data Extraction, Reproducible ReportingAutomation MindsetPandas, SciPy, Statsmodels, Plotly, dplyr, ggplot2, Quarto
Module 6 · Introduction to Machine LearningMachine Learning, Predictive Modeling, Classification, Clustering, Feature Engineering, Model EvaluationResponsible AI, Business Communicationscikit-learn, tidymodels
Module 7 · Bonus · Career AcceleratorPortfolio Development, Technical Interview SkillsCommunication, Personal Branding, Professional Networking, Interview PreparationGitHub, LinkedIn
Assessment

How You Are Assessed

Learn, practise, prove it: every module ends with a quiz and a project, and each one earns a badge.

  1. 1LearnLive classes, class recordings and video lessons
  2. 28 module quizzes20 MCQs each, pass 60%, with explanations
  3. 38 industry projects4 live with your trainer · 4 self-paced
  4. 4Quiz & module badgesShare each one on LinkedIn, verifiable by link
  5. 5CertificateLifetime validity with QR authentication
Bonus Module

Career Accelerator: 2 Bonus Sessions

4 extra live hours beyond the 60-hour core programme, with its own badge: attend both sessions, pass the short quiz and submit your portfolio link + updated resume.

01 Session 1 · live

Portfolio & Personal Brand

A public portfolio (GitHub / Tableau Public / Power BI) with 3 Level 2 projects, strong project write-ups and a LinkedIn profile for advanced roles.

02 Session 2 · live

Technical Interview & Case Practice

SQL, Excel/VBA, Power BI, statistics and ML interview questions, a business case walk-through and a mock interview.

Attend both sessions+ Pass the 10-question quiz+ Submit your resume + LinkedIn = Career badge
Certification Information

International Certificate with Lifetime Validity

QR authentication, university affiliation, and structured assessment ensure credibility.

Assessment & Eligibility

  • Module quizzes (1 mark per question), assignments and 8 advanced projects, including a machine learning capstone.
  • Certificate issued upon successful completion of all course requirements.
  • Academic integrity and professional conduct are mandatory.

Access & Delivery

  • Mode: Online • Evening batch • 2 sessions/week
  • Class recordings available for 90 days; videos and study materials on the learner portal.
  • Exam breaks aligned to university schedule.

Affiliation & IDs

  • KC College, HSNC University, Mumbai
  • Presented by Equal Opportunity Centre, Dept. of Economics & Dept. of CS
  • NCS IDs: E19G73-0001536925957, S19G76-1231027651047
Register
Career path

Where this course takes you

Each step gives you its own verifiable certificate. Start here, then go further when you are ready.

Certificate 1

Internationally Certified Data Analyst with AI

60 Hours • 8 Industry Projects • Evening Online Batch (2 sessions/week) • Flexible Timings

Sample certificate: Internationally Certified Data Analyst with AI
Certificate 2 · this course

Internationally Certified Advanced Data Analyst with AI

60 Hours • 8 Advanced Projects • Evening Online Batch (2 sessions/week) • Flexible Timings

Sample certificate: Internationally Certified Advanced Data Analyst with AI
Potential Career Outcomes

Roles You Can Target After Level 2

Advanced analytics, BI development, automation and entry-level data science roles across BFSI, e-commerce, consulting, healthcare, manufacturing and more.

Advanced Analytics & AI Skills Are in High Demand

11.7%

of job postings in India mentioned AI in September 2025, second highest among Indeed markets

Source: Indeed (via YourStory)
39%

of data & analytics job postings in India mention AI

Source: Indeed (via YourStory)
51%

demand–supply gap for AI talent in India (2025)

Source: Quess Corp (via CIOL)
86%

of employers expect AI and information processing to transform their business by 2030

Source: World Economic Forum, Future of Jobs Report 2025
Job roles

Roles You Can Apply For

Where this course can take you, by area.

Advanced Analytics

Senior Data / Business AnalystProduct & Marketing AnalystAnalytics Engineer (SQL)Decision / Strategy Analyst

BI & Automation

Power BI DeveloperTableau DeveloperMIS & Reporting Automation (VBA)BI Analyst

Data Science Track

Junior Data ScientistMachine Learning AnalystStatistician / Research AnalystAI-Assisted Analytics Specialist

Domain Roles

Risk / Credit AnalystPricing AnalystSupply ChainDemand PlanningHealthcareHR People Analytics
Learn from the best

Learn from an industry practitioner

Technology and people development, taught by someone who has done both for 15+ years.

Prof. Ajit Vishwakarma
5 lakh+Learners trained
150+Organisations
300+Certifications
15+Years in training
Your mentor

Prof. Ajit Vishwakarma

Chief Data Scientist & Industrial Psychologist
Chief Data ScientistIndustrial PsychologistVJTI Alumnus, Mumbai99.4 %ile · State Rank 27 (Maharashtra CET)300+ Certifications
Some people build technology. Others develop people. Very few spend a lifetime mastering both.

Professor Ajit belongs to that rare intersection where technology meets human potential. He combines deep expertise in psychology, technology, leadership, and organizational development to create measurable business impact. His ability to bridge human behavior with emerging technologies such as Artificial Intelligence and Data Science enables organizations to build future-ready workforces, strengthen leadership pipelines, and accelerate performance excellence across industries.

  • Government of India (NSDC) Master Trainer and Lead Assessor
  • Trained 5 lakh+ professionals, officials and students across 150+ organisations
  • Former Indian Army instructor
  • Board Member for syllabus development, HSNC University
  • 15+ years in corporate training, consulting, coaching and talent development
LinkedIn

Honours, awards & distinctions

  • Maharashtra CET State Rank 27 with 99.4 Percentile
  • Alumnus of VJTI (Veermata Jijabai Technological Institute), Mumbai (Tier 1 Engineering Institute)
  • Recognized Expert Trainer and Subject Matter Expert
  • National Level Rifle Shooter
  • Internationally Acclaimed Organizational Growth Strategist

Qualifications

  • Doctoral-Level Specialization in Industrial Psychology
  • Doctoral-Level Specialization in Data Science & Artificial Intelligence
  • Postgraduate Degree in Computer Science
  • Diploma in Management, Entrepreneurship & Professional Skills
  • Certified Project Management Professional
  • Six Sigma Consultant
  • Power BI and Tableau Certified Professional

Publications & achievements

  • Recognized researcher and practitioner in Industrial Psychology, Data Science, and Artificial Intelligence
  • Mentor and motivational speaker impacting lakhs of youth across India
  • Contributor to curriculum design and skill development initiatives through academic and government collaborations
  • Successfully led large-scale learning interventions for corporate, government, and educational ecosystems
300+Professional certificationsacross 14 domains · open a domain to see the credentials
Artificial Intelligence, Generative AI & Agentic AI 2
  • Claude Certified Architect – Professional Anthropic
  • Microsoft Certified: Agentic AI Business Solutions Architect Expert Microsoft
Data Science, Business Analytics & Advanced Excel 2
  • Microsoft Office Specialist: Excel Expert (Microsoft 365 Apps) Microsoft
  • Certification in Business Data Analytics (CBDA) IIBA
Certified expert in Information Security, Cybersecurity & Enterprise Governance
Human Resource Management & People Analytics 3
  • SHRM Senior Certified Professional (SHRM-SCP) SHRM
  • People Analytics Specialty Credential SHRM
  • Certified Compensation Professional (CCP) WorldatWork
Learning & Development, Performance Evaluation & Assessment 3
  • Certified Professional in Talent Development (CPTD) ATD
  • Certified Performance Technologist (CPT) ISPI
  • Hogan Assessments Certification Hogan Assessments
Industrial Psychology, Leadership & Executive Coaching 3
  • Master Certified Coach (MCC) International Coaching Federation
  • Neuro-Linguistic Programming (NLP) Practitioner
  • Change Management Practitioner
Project Management, Agile & Scrum 2
  • Professional Scrum Master III (PSM III) Scrum.org
  • PMI Agile Certified Practitioner (PMI-ACP) PMI
Lean Management, Quality & Operational Excellence 2
  • Lean Gold Certification (LGC) SME / Lean Certification Alliance
  • Certified Manager of Quality/Organizational Excellence (CMQ/OE) ASQ
Procurement, Supply Chain & Enterprise Operations 3
  • SAP Certified Associate – SAP S/4HANA Sourcing and Procurement SAP
  • Certified Professional in Supply Management (CPSM) ISM
  • Certified Supply Chain Professional (CSCP) ASCM
Finance, Financial Planning & Business Performance 2
  • Certified Management Accountant (CMA) IMA
  • Certified Corporate Financial Planning & Analysis Professional (FPAC) AFP
Sales, Business Development & CRM 2
  • Certified Sales Executive (CSE) SMEI
  • Salesforce Certified Agentforce Sales Consultant Salesforce
Marketing, Digital Strategy & Brand Management 2
  • Certified Marketing Executive (CME) SMEI
  • Professional Certified Marketer (PCM) – Digital Marketing Expert American Marketing Association
Additional Course Certificates & Advanced Specializations 2
  • Prompt Engineering Specialization (Course Certificate) Vanderbilt University / Coursera
  • Data Storytelling & Executive Analytics Advanced Specialization
Institutional Training Credentials & Designations 2
  • Master Trainer & Lead Assessor NSDC / MEPSC
  • State Trainer Heartfulness Education Trust
Corporate clients

Trained by the team that trains India's leading companies

Our trainers run programmes for banks, insurers, manufacturers, IT firms and government teams.

150+ Companies50+ Government establishments200+ Universities & institutes

BFSI 26BFSI — Banking, Financial Services, Insurance, Payments & FinTech

  • Axis Mutual Fund
  • Asset Vantage
  • State Bank of India
  • Reserve Bank of India
  • CRED
  • Future Generali India Insurance
  • Kotak Mahindra Bank
  • Tata AIG General Insurance
  • Axis Max Life Insurance
  • IDFC FIRST Bank
  • Prudent Corporate Advisory Services
  • Kotak Securities
  • HDFC Bank
  • J.P. Morgan
  • SBI Mutual Fund
  • Magma HDI General Insurance
  • NPCI
  • HDFC Life
  • Jio Allianz
  • Kotak Life Insurance
  • Morgan Stanley
  • Axis Bank
  • ICICI Prudential AMC
  • ManipalCigna Health Insurance
  • Swift
  • Barclays

Industrial 18Industrial, Engineering, Manufacturing, Chemicals & Automotive

  • Welspun
  • Epsilon Carbon
  • Asian Paints
  • Godrej
  • GHCL (Gujarat Heavy Chemicals)
  • HTL Aircon
  • Larsen & Toubro
  • MG Motor
  • Modison Metals
  • Mexim Adhesive Tapes
  • Liebherr
  • Bureau Veritas
  • Nuvoco Vistas
  • SGS
  • Thermax
  • Volkswagen
  • Kataria
  • Laxmi Organic Industries

Technology & IT 17Technology, IT Services, Consulting & Knowledge Services

  • Deloitte
  • Accenture
  • EY
  • Azentio
  • Infosys
  • Inspira Enterprise
  • IBM
  • Hexaware
  • Tata Consultancy Services
  • Rakuten
  • Wipro
  • L&T Infotech
  • Microsoft
  • Cactus Communications
  • NTT
  • Merit
  • Tech Mahindra

FMCG & Retail 10FMCG, Retail, Consumer & Telecom

  • Jubilant FoodWorks (Domino's)
  • Hindustan Coca-Cola Beverages
  • Emami Group
  • bigbasket
  • Reliance Retail
  • Hindustan Unilever
  • Airtel
  • Kellanova
  • Moët Hennessy
  • Walmart

Healthcare & Pharma 7Healthcare, Pharmaceuticals & Medical Technology

  • Sun Pharma
  • Zydus
  • Medserve
  • Bayer
  • Clove Dental
  • IOL Chemicals and Pharmaceuticals
  • Themis Medicare

Government & Defence 8Government, Defence & Public Sector

  • Ministry of Commerce & Industry
  • Ministry of Electronics & Information Technology
  • Indian Army
  • Maharashtra Police
  • Power Sector Skill Council
  • MSDE & NSDC (Skill Development)
  • C-DAC
  • Skill India

Media & Hospitality 4Media, Entertainment, Hospitality & Marketing

  • Taj Hotels
  • Wondrlab
  • IHCL (The Indian Hotels Company)
  • Sony LIV

Energy, Oil & Gas 2Energy, Oil & Gas

  • Indian Oil
  • Hindustan Petroleum (HPCL)

Logistics 2Logistics & Transportation

  • FedEx
  • CJ Darcl Logistics
FAQs

Frequently Asked Questions

Key answers about eligibility, access and operations.

Level 1 (Internationally Certified Data Analyst with AI) is recommended. If you already use Excel (PivotTables, XLOOKUP), Power BI, basic SQL (joins, GROUP BY) and Python or R, you can join Level 2 directly.

9 weeks (3 months) • 60 hours + 4 bonus hours • 2 online sessions per week • Evening batch. Class recordings are available for 90 days.

Excel macros & VBA automation, LAMBDA helpers, Power Query M and CUBE functions, Solver and Monte Carlo; advanced DAX, RLS and Tableau; CTEs, window functions, views and procedures; statistics and hypothesis testing; advanced pandas or tidyverse; and machine learning.

You choose one pathway for Modules 5 and 6. Both cover the same concepts: advanced data wrangling, statistics, reports and machine learning (scikit-learn or tidymodels).

A Windows laptop with Microsoft Excel (desktop, for VBA), Power BI Desktop, Tableau Public, MySQL 8 and Python or R is enough. Google Colab can be used for Python.

Yes. University-approved certificate with lifetime validity and QR authentication.

Batch change requests are not allowed. Batches are planned in advance.
Advanced Data Analyst with AI Registration open
Fees from ₹3,499 ₹20,000 83% off
Next live batchBeing formed nowBook today to lock in the current fee
Register now