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 Details
Explore the comprehensive course modules
Setup, variables, data types, operators, strings, conditionals, loops, functions and error handling.
Lists, tuples, sets and dictionaries for storing and organising business data.
Arrays, indexing, reshaping, vectorised maths and array-level statistics.
DataFrames, importing and exporting files, filtering, cleaning, grouping and merging datasets.
Central tendency, dispersion, position measures and frequency summary tables in Python.
Line, bar, pie, histogram, box and scatter charts using Matplotlib and Seaborn.
Database connection, CRUD queries, aggregates, joins, subqueries and Pandas-SQL data transfer.
Covariance, correlation, simple and multiple regression, accuracy metrics and time-series forecasting.
Preprocessing, train-test split, classification models, decision trees, overfitting control and model evaluation.
K-Means, hierarchical linkage methods, Ward's method, dendrograms and cluster profiling.
Transaction data preparation, association rule mining and support, confidence and lift analysis.
Rule-based agents, neural network structure, activation functions and gradient descent training.
Constraint-based optimisation and what-if scenario analysis for decision making.
Plotly interactive charts and a Streamlit dashboard connected to the SQL database.
Learn from leading experts in stem cell research
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 — 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