HUMAN INTELLIGENCE LABS / Offline training | Lucknow
Data Analytics & Gen AI Program in Lucknow
Learn Excel, SQL, Python, statistics, Power BI and Generative AI in this 3-month, in-person program in Lucknow. Turn real datasets into business insights, complete a capstone project and prepare for data analyst interviews.
Founded by alumni of IISc Bangalore and IE Business School, Spain
HI / LEARNING IN PRACTICE↗
COURSE PROJECT MOCKUP
HUMAN INTELLIGENCE LABSData Analytics & Gen AI Program
Complete Career Track Curriculum & Real-World Case Study Blueprint↗
◷
3 monthsProgram duration
Offline training | Lucknow
✧
Human Intelligence Labs Private Limited
About Human Intelligence Labs
Human Intelligence Labs is an AI-focused software engineering company built to make students job-ready. We focus on practical coding, AI tools, real-world projects, and corporate work culture – pairing personalized mentorship with international exposure and complete placement support including resume building, LinkedIn optimization, mock interviews, and interview preparation.
The Human Intelligence Labs approach
Learning that goes beyond the classroom.
01⌘
Curriculum by Global Alumni
Curriculum designed by graduates of IISc Bangalore and IE Business School, Spain
02↗
Elite Mentorship
Guidance from experienced mentors with backgrounds at IITs, NVIDIA, Accenture, and leading companies
03✧
Global Exposure
Direct access to product teams and companies across India, Spain, and Saudi Arabia
04↔
Project-Based Learning
Learn by working on live projects, with weekly reviews, feedback, and deadlines. This builds accountability, a key requirement in the industry
05◷
End-to-End Placement Support
Our Industry Readiness Classes cover resume building, LinkedIn optimization, mock interviews, job prep, and hiring assistance, so you can face interviews with confidence
06→
Extra-Curricular Activities
Hackathons, LeetCode Problem-Solving Batches, and other practical coding activities
What you will learn
Data Analytics & Generative AI
Complete Career Track Curriculum & Real-World Case Study Blueprint
08
curriculum modules
01
Foundations, Excel & SQL
Data Analytics Foundations & Advanced Excel
+
Start here, no coding needed
Analytics lifecycle: ask, clean, analyse, present
Types of data, data sources and data quality
Formulas: logical, text and lookup functions
VLOOKUP, XLOOKUP and INDEX-MATCH
PivotTables, slicers and PivotCharts
Data cleaning, validation, Power Query basics
Interactive Excel dashboards
Business reporting and storytelling
Case studies / projects
Retail Sales Report
E-Com Orders
02
Foundations, Excel & SQL
Analytics with SQL
+
MySQL Workbench
Databases, RDBMS and ER modelling
SELECT, WHERE, ORDER BY, GROUP BY, HAVING
Joins: inner, left, right, self, cross
Aggregates, CASE, date and string functions
Subqueries and CTEs
Window functions: RANK, LAG/LEAD
Views, indexes, constraints, optimisation
Data retrieval for dashboards and KPIs
Case studies / projects
E-Com Business
Retail Store
03
Python, Statistics & EDA
Python for Data Analytics
+
Jupyter, Google Colab
Python basics: variables, data types, operators
Conditionals, loops, functions, error handling
Lists, tuples, dictionaries and sets
NumPy: arrays, indexing, vectorisation
Pandas: Series, DataFrames, filtering, sorting
Cleaning: missing values, duplicates, outliers
GroupBy, merge, join, pivot and reshape
Reading CSV, Excel, JSON and SQL data
Case studies / projects
UPI Transactions
Covid-19 Trends
04
Python, Statistics & EDA
Statistics & Exploratory Data Analysis
+
Python, SciPy, Statsmodels
Descriptive statistics and dispersion
Probability, distributions, Central Limit Theorem
Sampling techniques and confidence intervals
Hypothesis testing: t-test, chi-square, ANOVA
Correlation, covariance, bivariate analysis
Univariate and multivariate EDA workflow
Outlier detection and feature selection basics
Case studies / projects
Loan Default
Air Quality
05
Data Visualization & BI
Data Visualization & BI with Power BI
+
Power BI Desktop and Service
Principles of effective visual storytelling
Power Query: connect, transform, model data
Star-schema modelling and relationships
DAX measures, columns, time intelligence
Charts, maps, KPI cards, drill-through
Publishing, sharing and scheduled refresh
Row-level security and KPI governance
Python charts: Matplotlib and Seaborn
Case studies / projects
Sales Dashboard
People Analytics
06
Generative AI for Analytics
Generative AI for Data Analytics
+
Live lectures
How LLMs work: concepts, capabilities, limits
Prompt engineering for analysis and code
AI in Excel and Power BI (Copilot, DAX help)
AI-assisted SQL: write, debug, optimise
AI-assisted Python: pandas code, automation
AI-driven EDA: insights, anomaly spotting
Executive-ready narratives from findings
“Chat with your data” assistant via LLM API
Responsible AI: privacy, bias, verification
Case studies / projects
Customer Feedback Mining
Credit Risk Insights
07
Capstone & Career Launch
Capstone & Live Industry Projects
+
Portfolio on GitHub
Problem framing with a stakeholder brief
End-to-end: SQL → Python → Power BI → GenAI
Version control and GitHub portfolio
Demo day: present insights, mentor feedback
Case-study write-ups for recruiters
Case studies / projects
Capstone Project
Live Industry Project
08
Capstone & Career Launch
Career Readiness & Placement Prep
+
Runs alongside the program
Resume and LinkedIn for analyst roles
SQL, Python and case-based interview practice
Mock technical and HR interviews
Communication and stakeholder skills
Salary negotiation and offer basics
Case studies / projects
Mock Interviews
Job Support
Every module is taught the same way
01Concept
02Hands-on lab
03Real case study
04AI-assisted practice
05Mentor review
Your roadmap
Complete the Roadmap. Build the Skills. Become Industry Ready.
After completing this roadmap, you’ll be equipped with the skills and practical experience to confidently pursue data analyst interview opportunities.
Tools & technologies covered
Hands-on from day one
Spreadsheets & BI
ExcelPower QueryPower BI DesktopPower BI Service
Databases & SQL
SQLMySQLMySQL Workbench
Programming, Notebooks & Version Control
PythonNumPypandasJupyterGoogle ColabGitHub
Statistics & Visualization
SciPyStatsmodelsMatplotlibSeaborn
Generative AI & Large Language Models
ChatGPTClaudeGeminiMicrosoft CopilotLLM APIs
One end-to-end workflow
From raw data to AI-powered insight.
01SQL: extract & prepare
02Python: clean & analyse
03Power BI: visualise & share
04GenAI: summarise & narrate
Practical · Job-ready
Skills you will learn
01
Data Cleaning & Preparation
Turn messy data into analysis-ready data
Fix missing values, duplicates, outliers and wrong data types in Excel and pandas
Merge, reshape and pivot data from files and SQL
02
Exploratory Data Analysis
Find the story hidden in the numbers
Run univariate, bivariate and multivariate EDA
Spot outliers, correlations and patterns early
03
SQL & Database Querying, MySQL
Get exactly the data you need, fast
Write joins, subqueries, CTEs and window functions
Pull KPIs for dashboards and speed up queries with views and indexes
04
Data Visualization & Dashboards
Make insights impossible to miss
Build interactive dashboards in Excel and Power BI with DAX measures
Create clear charts with Matplotlib and Seaborn; publish with row-level security
05
Statistics & Business Insights
Back every decision with evidence
Apply probability, sampling, confidence intervals and hypothesis tests
Measure relationships with correlation and turn results into business recommendations
06
Generative AI & Prompt Engineering
Use AI with confidence, and verify it
Understand how LLMs work, where they fall short and how to use them responsibly
Write prompts that get reliable answers for analysis, reporting and code
07
AI-Assisted Workflows & Apps
Do in minutes what took hours
Speed up SQL, Python, Excel and Power BI work with AI and Copilot help
Build a “chat with your data” LLM assistant
08
Real-World Projects & Careers
Show proof of work to employers
Deliver an end-to-end capstone from SQL to Python to Power BI to a GenAI summary
Build a GitHub portfolio, plus resume, LinkedIn and mock-interview skills
Your outcome
From raw data to business decisions. Powered by AI.
Take a raw dataset from messy to meaningful and explain it to the business.
Human Intelligence Labs
Your mentors
10+ yearsexperience01
YOUR MENTOR
Mr. Ansari TK
Co-founder, Human Intelligence Labs
↗
Ex-NVIDIA, IISc Bangalore alumnus
5+ yearsexperience02
YOUR MENTOR
Mr. Harshit Dixit
Project Manager, Cars24
↗
Ex-Morgan Stanley
8+ yearsexperience03
YOUR MENTOR
Ms. Dishanshi
Team Lead, Accenture
↗
Ex-TCS
8+ yearsexperience04
YOUR MENTOR
Ms. Sangeeta Mishra
Senior Software Developer
↗
Engineering mentorship
8+ yearsexperience05
YOUR MENTOR
Ms. Nidhi Shukla
Senior Software Developer
↗
Engineering mentorship
4+ yearsexperience06
YOUR MENTOR
Mr. Shivam Rai
Software Engineer
↗
Human Intelligence Labs
3+ yearsexperience07
YOUR MENTOR
Mr. Bharat Joshi
Software Trainer
↗
Human Intelligence Labs
4+ yearsexperience08
YOUR MENTOR
Mr. Vimal Tiwari
Front-End Developer
↗
Human Intelligence Labs
Your mentor support
Complete one-on-one support throughout your journey to your first job
Every student gets one-on-one support from 5 to 6 mentors.
Mentor 1
Trainer
Fundamentals & Theory
He will work on your fundamentals, strengthen your theoretical knowledge, and teach you how to apply what you learn in practical work.
Mentor 2
Software Engineer
Live Projects & Technical Guidance
He will guide you through the live projects you work on, conduct weekly reviews, provide feedback, and support you throughout your project journey.
Mentor 3
HR
Interview & Career Preparation
She will guide you on interview preparation, mock interviews, resume building and soft skills development.
Mentor 4
Industry Experts
Mock Interviews & Industry Exposure
Industry experts will conduct mock interviews and help you prepare for job interviews, referrals and real-world hiring processes.
Mentor 5
Placement Officer
Job Opportunities & Placement Support
His role will be to provide interview opportunities with companies and bring relevant company vacancies to the placement portal.
The program moves through Excel and data foundations, SQL, Python, statistics, Power BI and Generative AI, followed by capstone work and placement preparation. The curriculum contains eight modules in five phases.
How long is the program?+
The program lasts three months, with classes five days a week for four to five hours a day.
What are the fees?+
The brochure lists ₹35,000 + GST, with a booking amount of ₹5,000 + GST. No Cost EMI options are available.
Where are classes held?+
This is an offline program in Lucknow. The brochure lists ten available seats.
Your next step
Make your next move count.
Founded by alumni of IISc Bangalore and IE Business School, Spain
An offline, 3-month program in Lucknow that takes learners from Excel and SQL through Python, statistics and Power BI to Generative AI, then a capstone and placement preparation.
The Data Analytics & Gen AI Program is a 3-month, in-person course in Lucknow covering Excel, SQL, Python, statistics, Power BI and Generative AI, followed by capstone work and placement preparation.