Beginner to Job-Ready

Data Analytics with Agentic AI

Excel to AI Agent — Zero to Analyst in 3 Months

A 3-month, 96-hour weekend program that takes you from Excel and statistics to SQL, Tableau, Python and agentic AI. 8 real-world capstone projects, mock interviews and placement prep across 5 phases.

  • 3 Months · 12 Weeks · 96 Hours
  • Live weekend cohort (Sat & Sun) + recordings
  • Live instructor-led on Zoom
  • 1-year placement support
ISO Certified
Enrol online
₹19,999₹39,999

or ₹950/month with EMI

Secure checkout via Razorpay — UPI, cards, netbanking and wallets. Instant access in your dashboard.

Next cohort starts in

--Days
--Hours
--Minutes
--Seconds

Batch begins 26 September 2026

Talk to a mentor

Get the detailed syllabus, batch dates and fee options.

We only use your details to contact you about Skillancy programs.

Overview

What this program covers

Excel to AI Agent — Zero to Analyst in 3 Months. 72 hours of core training plus a 24-hour case study and interview track, delivered live on Saturdays and Sundays. Built for students, non-tech backgrounds, working professionals and career-break returners — no prior coding needed.

This program is for you if:

  • You're from a non-tech background wanting to break into analytics
  • You're a working professional looking to upskill
  • You're returning to work after a career break
  • You want structured, mentor-led learning over self-paced videos

Outcomes

What you will be able to do

  • Analyse business data confidently in Excel with pivot tables, lookups and statistics

  • Write advanced SQL with CTEs, window functions and analytical joins

  • Build interactive KPI dashboards and data stories in Tableau

  • Automate analysis with Python, NumPy, Pandas, Matplotlib and Seaborn

  • Build your own no-code AI agent with Make.com and API integrations

  • Ship 8 real-world capstone projects and clear mock interviews with feedback

Meet your instructors

Learn directly from working data professionals

Rishav Kumar, Principal Data Analyst at Walmart

Rishav Kumar

Principal Data Analyst

Walmart logoWalmart
Sutapa Banerjee, Data Analyst at Google

Sutapa Banerjee

Data Analyst

Google logoGoogle
Sowmya Krishna, Senior Data Analyst at Walmart

Sowmya Krishna

Senior Data Analyst

Walmart logoWalmart

Student success stories

Real career transformations from Skillancy alumni

One of the most impactful learning experiences of my analytics journey — especially SQL and Python. Real-world scenarios and case studies strengthened my analytical thinking.

Sanghamitra Phukan — Oracle

Sanghamitra Phukan

Oracle

Skillancy's mentorship went beyond interview prep — teaching me how to think critically and solve real-world problems, with end-to-end support throughout.

Jayant Khanna — PayPal

Jayant Khanna

PayPal

Structured, industry-aligned training helped me secure a role at ZoomInfo. Hands-on, real-world problem-solving strengthened my technical skills and confidence.

Mohammad Ammar — ZoomInfo

Mohammad Ammar

ZoomInfo

Key to transitioning into analytics without prior experience. Structured mentorship and rigorous SQL training built strong technical confidence, plus valuable career planning.

Umashankar Pati — RSystems

Umashankar Pati

RSystems

Crucial in helping me transition into data analytics from a non-technical background. Patient mentorship and guidance in resume building and interview prep were instrumental.

Ankita Singh — EXL Services

Ankita Singh

EXL Services

Hiring partners

Where our alumni work

Target
and more

Weekly schedule

Week-by-week curriculum

Five phases, twelve weeks, one continuous build from spreadsheets to a placement-ready portfolio.

Phase 1

Phase 2

Phase 3

Phase 4

Phase 5

  • Saturday 10:00 AM – 12:00 PM — Core Session 1
  • Saturday 1:30 PM – 3:30 PM — Core Session 2
  • Sunday 10:00 AM – 12:00 PM — Core Session 3
  • Sunday 1:30 PM – 3:30 PM — Case Study & Interview Practice
1

Phase 1Excel, Statistics & SQL Foundations

Weeks 1–5

Core content (6 hrs) · Week 1

  • Excel basics & formatting, sorting/filtering
  • Aggregations (SUM/AVERAGE)
  • IF/AND logical functions
  • VLOOKUP & INDEX-MATCH

Sunday case / interview track (2 hrs)

  • Excel interview Q&A — formulas, lookups, common trick questions

Core content (6 hrs) · Week 2

  • Pivot tables & basic charts
  • Central tendency: Mean, Median, Mode
  • Spread, percentiles/IQR
  • Skew & kurtosis, correlation, normal distribution
  • Z-score outliers, sampling

Sunday case / interview track (2 hrs)

  • Statistics & analytics interview questions
Capstone project

DMart logoRetail Sales & Inventory Performance Analysis — DMart (Excel)

Core content (6 hrs) · Week 3

  • Database concepts
  • SELECT / WHERE / ORDER BY
  • GROUP BY / HAVING
  • All join types, UNION/UNION ALL

Sunday case / interview track (2 hrs)

  • SQL interview Q&A — SELECT, WHERE, GROUP BY

Core content (6 hrs) · Week 4

  • Subqueries (basic & correlated)
  • CASE statements
  • Advanced join scenarios

Sunday case / interview track (2 hrs)

  • SQL interview Q&A — subqueries & joins

Core content (6 hrs) · Week 5

  • CTEs & recursive CTEs
  • Window functions: RANK, ROW_NUMBER, LEAD/LAG
  • Running aggregations
  • PERCENTILE_CONT

Sunday case / interview track (2 hrs)

  • Business case — solving a real query problem using window functions
Capstone project

Flipkart logoE-commerce Order & Customer Segmentation Analysis — Flipkart (SQL)

2

Phase 2Tableau

Weeks 6–7

Core content (6 hrs) · Week 6

  • Tableau introduction, connecting to Excel/CSV/SQL
  • Interface basics, dimensions vs measures
  • Foundational chart types & filters
  • Calculated fields & table calculations
  • Parameters, Level of Detail (LOD) basics

Sunday case / interview track (2 hrs)

  • Tableau / BI interview Q&A

Core content (6 hrs) · Week 7

  • Dashboards & dashboard actions
  • Data storytelling
  • KPI dashboards

Sunday case / interview track (2 hrs)

  • Case study — leadership dashboard design review
Capstone project

Ola logoSales & Marketing Performance Dashboard — Ola (Tableau)

3

Phase 3Python for Analytics

Weeks 8–10

Core content (6 hrs) · Week 8

  • Variables & data types
  • Lists & dictionaries
  • Conditional statements
  • Loops (for/while)
  • Functions & built-ins

Sunday case / interview track (2 hrs)

  • Python interview Q&A

Core content (6 hrs) · Week 9

  • NumPy arrays & operations
  • Indexing & broadcasting
  • Practice problems

Sunday case / interview track (2 hrs)

  • Python/NumPy interview Q&A

Core content (6 hrs) · Week 10

  • Pandas DataFrames & filtering
  • Data cleaning & transformation, merging datasets
  • Exploratory Data Analysis & outlier handling
  • Data validation
  • Visualization with Matplotlib & Seaborn

Sunday case / interview track (2 hrs)

  • Case study — cleaning a messy real-world dataset
Capstone project

Zomato logoCustomer Churn Prediction & Behavior Analysis — Zomato (Python)

4

Phase 4Agentic AI

Week 11

Core content (6 hrs) · Week 11

  • Make.com workflow creation
  • API integrations
  • Build your own no-code AI agent
  • Final capstone presentation

Sunday case / interview track (2 hrs)

  • Mock interviews + placement prep
5

Phase 5Resume Creation & Mock Interviews

Week 12

Core content (6 hrs) · Week 12

  • Resume & LinkedIn profile building for data roles
  • Portfolio & GitHub presentation
  • Common HR & behavioral interview questions
  • Salary negotiation basics

Sunday case / interview track (2 hrs)

  • Live mock interviews (technical + HR rounds) with feedback

Capstone projects

Real-world projects delivered across the program

DMart logo

Excel · DMart

Retail Sales & Inventory Performance Analysis

Pivot tables, lookups & stats applied to a multi-store retail dataset

Flipkart logo

SQL · Flipkart

E-commerce Order & Customer Segmentation Analysis

CTEs & window functions used to segment customers by order behavior

Zomato logo

Python · Zomato

Customer Churn Prediction & Behavior Analysis

Pandas-based cleaning & feature analysis on delivery data

Ola logo

Tableau · Ola

Sales & Marketing Performance Dashboard

An interactive KPI dashboard built for a leadership review

BigBasket logo

Excel · BigBasket

Grocery Delivery Performance & Discount Analysis

Pivot tables & lookups measuring discount impact and delivery SLAs across dark stores

Myntra logo

SQL · Myntra

Fashion Returns & Customer Lifetime Value Analysis

CTEs & window functions analyzing return rates and CLV across fashion categories

Paytm logo

Python · Paytm

Transaction Pattern & Spend Behavior Analysis

Pandas-based cleaning & EDA on digital payment transaction data

MakeMyTrip logo

Tableau · MakeMyTrip

Travel Booking Trends & Revenue Dashboard

Interactive dashboard tracking booking trends, seasonality & revenue by route

Toolkit

Tools and platforms you will use

  • Excel logoExcel
  • PostgreSQL logoPostgreSQL
  • Tableau logoTableau
  • Python logoPython
  • NumPy logoNumPy
  • Pandas logoPandas
  • Matplotlib logoMatplotlib
  • Seaborn logoSeaborn
  • Make.com logoMake.com

Get certified

Certificate of Completion

Every learner who completes the program receives a Certificate of Completion from Skillancy.

Skillancy Certificate of Completion for Data Analytics with Agentic AI

FAQ

Frequently asked questions

Ready to start learning?

Create your account, request enrolment and start with the free preview sessions.