The Analytics Triad — Hands-On Python, SQL and ML

Course Description

The Analytics Triad — Hands-On Python, SQL and ML is a fully hands-on workshop that runs entirely at the keyboard — 56 in-class programs, two per one-hour session, with no lectures and no theory blocks. Participants move from Python fundamentals and data handling through SQL querying, statistical analysis and visualisation, and on to machine learning, clustering and association models. Every module works on the same set of real business datasets, so each new technique builds directly on the previous session's output. By the end of the workshop, participants can write Python programs that clean, transform and summarise business data using Pandas and NumPy, and query relational databases with SQL from within Python. They can produce publication-ready charts, run correlation, regression and forecasting models, and read the accuracy metrics that follow from them. They can also build and evaluate classification, clustering and association models, and present the results through an interactive dashboard connected to a live database.

Course Fee Seats Limited

₹1500.00

Course Details

Duration
Duration
30 HRS
Duration
Course Label
SkillDevelopment
Certificate
Certificate
Yes
Course Language
English
Duration
Course Mode
Online
Duration
Timings
7 PM - 8 PM
Days
Monday to Friday
Registration Till
31 Aug 2026
Duration
Tentative ClassStart Date
1st Week of September
Duration
Eligible Schools:
Certificate Criteria
Certificate Criteria
75% attendance, 50% score in all Exams/CA

Curriculum Snapshot

Explore the comprehensive course modules

1 Python Foundations

Setup, variables, data types, operators, strings, conditionals, loops, functions and error handling.

2 Python Data Structures

Lists, tuples, sets and dictionaries for storing and organising business data.

3 NumPy

Arrays, indexing, reshaping, vectorised maths and array-level statistics.

4 Pandas

DataFrames, importing and exporting files, filtering, cleaning, grouping and merging datasets.

5 Descriptive Statistics

Central tendency, dispersion, position measures and frequency summary tables in Python.

6 Data Visualisation

Line, bar, pie, histogram, box and scatter charts using Matplotlib and Seaborn.

7 SQL with Python

Database connection, CRUD queries, aggregates, joins, subqueries and Pandas-SQL data transfer.

8 Correlation, Regression and Forecasting

Covariance, correlation, simple and multiple regression, accuracy metrics and time-series forecasting.

9 Machine Learning Core

Preprocessing, train-test split, classification models, decision trees, overfitting control and model evaluation.

10 Clustering

K-Means, hierarchical linkage methods, Ward's method, dendrograms and cluster profiling.

11 Market Basket and Association

Transaction data preparation, association rule mining and support, confidence and lift analysis.

12 AI and Neural Network Basics

Rule-based agents, neural network structure, activation functions and gradient descent training.

13 Prescriptive Analytics

Constraint-based optimisation and what-if scenario analysis for decision making.

14 Interactive Dashboards

Plotly interactive charts and a Streamlit dashboard connected to the SQL database.

Instructor Spotlight

Learn from leading experts in stem cell research

Dr. Anup Sharma

Dr. Anup Sharma

Associate Professor

Dr. Anup Sharma is Associate Professor and Head — MBA Operations, IT & Analytics at Lovely Professional University, an IIM Ahmedabad alumnus (PGDM, 2015) with a Ph.D. in Management and 14+ years of academic and industry experience. He teaches Business Analytics in Python and R, machine learning, and data visualisation with Tableau and Power BI, and is certified in Python for Data Science and AI. He has conducted hands-on workshops on Python-Powered Business Analytics and Machine Learning with R, and serves as Subject Expert for MBA Operations and Business Analytics. His research includes ten Scopus and IEEE indexed papers on regression, decision trees and applied machine learning, along with four filed patents.

Dr. James Daniel Paul P

Dr. James Daniel Paul P

Professor

Dr. James Daniel Paul — Professor of Economics, Finance & Business Analytics, Mittal School of Business, Lovely Professional University PhD Economist turned data scientist: 30 years across 14 countries, including NIPFP, UNIDO, DP World Dubai, World Bank, and World Vision International Built a 44-million-transaction ML credit risk engine at DP World; managed a $237M UNIDO consulting portfolio Fluent across Python, SQL, R, Power BI, and Tableau — teaching production-grade analytics, not toy examples 20+ manuscripts in the pipeline at journals including Fiscal Studies and the Journal of Economic Surveys — research-grade rigor, classroom-ready delivery